DIMOPPORTUNITY

This dimension table stores information about opportunities.

Columns

Column	Data type	Description
BUILDID	NUMBER	Avionté’s unique identifier for each of its customers’ instances or builds. The value in this field is the same for all rows.
COMPANYID	NUMBER	The identifier for the company. For a visual reference of this data element in the source system, see Appendix B: COMPANYID.
COMPANYKEY	NUMBER	The identifier for the company.
CUSTOMERKEY	NUMBER	A foreign key referencing the customer record in the DIMCUSTOMER table.
HIRINGMANAGERID	NUMBER	A foreign key referencing a contact/hiring manager in the DIMHIRINGMANAGER table.
HIRINGMANAGERKEY	NUMBER	A foreign key referencing a contact/hiring manager in the DIMHIRINGMANAGER table.
OPPAMT	NUMBER	The dollar amount of the total earning potential of the opportunity. For a visual reference of this data element in the source system, see Appendix B: OPPAMT.
OPPARCHIVE	NUMBER	An indication of whether the opportunity record is archived or not.
OPPCLOSEDATE	TIMESTAMP_NTZ	The date and time when the opportunity was closed. For a visual reference of this data element in the source system, see Appendix B: OPPCLOSEDATE.
OPPCOMMIT	NUMBER	The dollar amount the company has committed to so far. For a visual reference of this data element in the source system, see Appendix B: OPPCOMMIT.
OPPCREATEUSERID	NUMBER	A foreign key referencing the DIMUSER table who created an opportunity record.
OPPCREATEUSERKEY	NUMBER	A foreign key referencing the DIMUSER table who created an opportunity record.
OPPCREATEUSERNAME	VARCHAR	The username of the user who created an opportunity.
OPPDATE	TIMESTAMP_NTZ	The date and time the opportunity was added.
OPPID	NUMBER	The identifier for the opportunity.
OPPKEY	NUMBER	The identifier for the opportunity.
OPPNAME	VARCHAR	The name of the opportunity. For a visual reference of this data element in the source system, see Appendix B: OPPNAME.
OPPNEXTSTEP	VARCHAR	An indication of what needs to happen next to progress the opportunity to the next stage. For a visual reference of this data element in the source system, see Appendix B: OPPNEXTSTEP.
OPPPERCENT	FLOAT	An indication of the percentage of the opportunity completed across different stages until it is closed. For example, if the client has 5 stages, this indicates the currently completed stage. For a visual reference of this data element in the source system, see Appendix B: OPPPERCENT.
OPPSTAGE	VARCHAR	The current stage of the opportunity. For a visual reference of this data element in the source system, see Appendix B: OPPSTAGE.
OPPTYPE	VARCHAR	The type of the opportunity. For a visual reference of this data element in the source system, see Appendix B: OPPTYPE.