TALENT_FACT¶
This fact table stores information about talent.
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 (Job/Applicant/Web/Contact). For a visual reference of this data element in the source system, see Appendix B: ACTDATE. |
ACTDATETIME |
TIMESTAMP_NTZ | The date and time of the activity (Job/Applicant/Web/Contact). For a visual reference of this data element in the source system, see Appendix B: ACTDATETIME. |
ACTIVITYTYPEID |
NUMBER | An ID representing the Activity Type. This field is not the foreign key to the DIMACTIVITYTYPE table – ACTIVITYTYPEKEY should be used to join ACTIVITY_FACT to DIMACTIVITYTYPE. |
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. |
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. |
COMPOSITESTAGEKEY |
VARCHAR | A composite key for various activities, combining the Applicant and Job keys. |
COUNTACTIVITY |
NUMBER | The count of recorded activities. This column is set to 1. |
CREDITUSERID |
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 in the DIMHIRINGMANAGER table. |
OFFICEID |
NUMBER | A foreign key referencing the office in the DIMOFFICE table. |
REQCREATEDDATE |
DATE | The date the job requirement was created. |
REQID |
NUMBER | A foreign key referencing a job requirement in the DIMRPTREQ table. |
REQTIERID |
NUMBER | A foreign key referencing a job requirement tier/status in the DIMREQTIER table. |
RPTREQKEY |
NUMBER | A foreign key referencing a report in the DIMRPTREQ table. |
SALESUSERID |
NUMBER | A foreign key referencing a sales user (USERID) in the DIMUSER table. |
SOURCETAG |
VARCHAR | The most recent source from which the talent applied, either through the Job Board, selected manually under the Talent Source tag section, or Nominated section. For a visual reference of this data element in the source system, see Appendix B: SOURCETAG. |
TALENTKEY |
NUMBER | The primary key referencing a talent. |
WEBAPPID |
NUMBER | A foreign key referencing a web applicant in the DIMWEBAPPLY table. |