CONTACT_JOB_TALENT_FACT¶
This fact table stores data for contact, job, and talent activities. This table is used in the User Stats Author dashboard. Note: This table contains a subset of the records contained in the ACTIVITY_FACT table. Avionté intends to deprecate this table in future releases.
Relationships¶
The following diagram illustrates the relationships between this table and other related tables.
Columns¶
| Column | Data type | Description |
|---|---|---|
ACTDATE |
DATE | The date of the activity. For a visual reference of this data element in the source system, see Appendix B: ACTDATE. |
ACTIVITYDATEKEY |
NUMBER | A foreign key referencing the date of the activity in the DIMDATE table. |
ACTIVITYTYPEKEY |
NUMBER | A foreign key referencing an activity type in the DIMACTIVITYTYPE table. |
APPLICANTID |
NUMBER | A foreign key referencing an applicant record in the DIMAPPLICANT table. |
APPLICANTKEY |
NUMBER | A foreign key referencing an applicant record in the DIMAPPLICANT table. |
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. |
COMPOSITESTAGEKEY |
VARCHAR | A composite key for various activities, in the format of ApplicantKey | ActivityTypeKey | ReqKey for job activity, ApplicantKey | ActivitySubType | CustomerKey for applicant activity. |
CONTACTJOBTALENTKEY |
NUMBER | The primary key referencing a contact, job, or talent record activity. |
COUNTACTIVITY |
NUMBER | The count of recorded activities. The value is set to 1. |
CREDITUSERID |
NUMBER | A foreign key referencing a credit user and a recruiter user in the DIMUSER table. |
CREDITUSERKEY |
NUMBER | A foreign key referencing a credit user and a recruiter user in the DIMUSER table. |
HIRINGMANAGERID |
NUMBER | A foreign key referencing a contact/hiring manager responsible for the activity in the DIMHIRINGMANAGER table. |
HIRINGMANAGERKEY |
NUMBER | A foreign key referencing a contact/hiring manager responsible for the activity in the DIMHIRINGMANAGER table. |
OFFICEID |
NUMBER | A foreign key referencing the office in the DIMOFFICE table. |
OFFICEKEY |
NUMBER | A foreign key referencing the office in the DIMOFFICE table. |
REQCREATEDATE |
DATE | The date a requirement was created. |
REQCREATEDDATEKEY |
NUMBER | A foreign key referencing the date the requirement was created in the DIMDATE table. |
REQID |
NUMBER | A foreign key referencing the job requirement in the DIMRPTREQ table. |
REQKEY |
NUMBER | A foreign key referencing the job requirement in the DIMRPTREQ table. |
REQTIERID |
NUMBER | A foreign key referencing the requirement tier/status in the DIMREQTIER table. |
REQTIERKEY |
NUMBER | A foreign key referencing the requirement tier/status in the DIMREQTIER table. |
SALESUSERID |
NUMBER | A foreign key referencing a sales user in the DIMUSER table. |
SALESUSERKEY |
NUMBER | A foreign key referencing a sales user in the DIMUSER table. |
USERAUTHID |
NUMBER | A foreign key referencing the user who created a contact, job, or talent activity in the DIMUSER table. |
USERAUTHKEY |
NUMBER | A key referencing the user who created a contact, job, or talent activity in the DIMUSER table. |
WEBAPPID |
NUMBER | A foreign key referencing a web applicant in the DIMWEBAPPLY table. |
WEBAPPKEY |
NUMBER | A foreign key referencing a web applicant in the DIMWEBAPPLY table. |