OPPORTUNITY_TRACKING_FACT¶

This fact table stores information about opportunities.

Relationships¶

The following diagram illustrates the relationships between this table and other related tables.

OPPORTUNITY_TRACKING_FACT relationship diagram

Columns¶

Column	Data type	Description
`ACTDATE`	DATE	The contact activity date that is tied to the opportunity record.
`ACTIVITYTYPEID`	NUMBER	Activity Type Identifier. This is not the foreign key to the DIMACTIVITYTYPE table – ACTIVITYTYPEKEY should be used for that relationship.
`ACTIVITYTYPEKEY`	NUMBER	A foreign key referencing an activity type in the DIMACTIVITYTYPE table.
`AMOUNT`	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: AMOUNT.
`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.
`COMMITMENT`	NUMBER	The dollar amount the company has committed so far. For a visual reference of this data element in the source system, see Appendix B: COMMITMENT.
`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.
`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.
`NEXTSTEP`	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: NEXTSTEP.
`NEXTSTEPDATE`	DATE	The date and time by which the next step should be completed. For a visual reference of this data element in the source system, see Appendix B: NEXTSTEPDATE.
`OFFICEID`	NUMBER	A foreign key referencing the office in the DIMOFFICE table.
`OFFICEKEY`	NUMBER	A foreign key referencing the office in the DIMOFFICE table.
`OPPORTUNITYCLOSEDDATE`	DATE	The date and time when the opportunity was closed. For a visual reference of this data element in the source system, see Appendix B: OPPORTUNITYCLOSEDDATE.
`OPPORTUNITYCREATEDATE`	DATE	The date and time when the opportunity was created. For a visual reference of this data element in the source system, see Appendix B: OPPORTUNITYCREATEDATE.
`OPPORTUNITYNAME`	VARCHAR	The name of the opportunity. For a visual reference of this data element in the source system, see Appendix B: OPPORTUNITYNAME.
`OPPORTUNITYOWNER`	VARCHAR	The owner of the opportunity. For a visual reference of this data element in the source system, see Appendix B: OPPORTUNITYOWNER.
`OPPORTUNITYTRACKINGKEY`	NUMBER	The primary key referencing an opportunity.
`OPPARCHIVE`	VARCHAR	An indication of whether the opportunity is archived or not.
`OPPID`	NUMBER	The identifier for the opportunity.
`OPPPARTNER`	VARCHAR	Not used.
`OPPTYPE`	VARCHAR	The type of opportunity.
`PERCENTAGE`	NUMBER	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: PERCENTAGE.
`PIPELINESTAGE`	VARCHAR	The current stage of the opportunity. For example, if the client has 5 stages and the opportunity is in the 3rd stage (e.g., Proposal Presented), this value is stored as PIPELINESTAGE.
`USERID`	NUMBER	A foreign key referencing the user in the DIMUSER table.
`USERKEY`	NUMBER	A foreign key referencing the user in the DIMUSER table.