PLACEMENT_FACT¶
This fact table stores information about placements.
Relationships¶
The following diagram illustrates the relationships between this table and other related tables.
Columns¶
| Column | Data type | Description |
|---|---|---|
ACTDATE |
DATE | The activity date that is tied to the placement record. |
ACTDATETIME |
TIMESTAMP_NTZ | The activity date and time that is tied to the placement 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. |
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. |
CANDIDATESOURCE |
VARCHAR | The source from which the talent applied via the Job Board or selected manually in the Talent Source tag section in BOLD UI. For a visual reference of this data element in the source system, see Appendix B: CANDIDATESOURCE. |
COMPANYID |
NUMBER | The identifier for the company. For a visual reference of this data element in the source system, see Appendix B: COMPANYID. |
COUNTACTIVITY |
NUMBER | The count of recorded activities. This column is set to 1. |
CUSTOMERKEY |
NUMBER | A foreign key referencing the customer record in the DIMCUSTOMER table. |
NOMINATIONSOURCE |
VARCHAR | Not used. |
OFFICEID |
NUMBER | A foreign key referencing the office in the DIMOFFICE table. |
PLACEMENTACTIVITYKEY |
NUMBER | The primary key referencing a placement activity. |
REQHIREDID |
NUMBER | A foreign key referencing a placement in the DIMHIRED table. |
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. |
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. |
USERID |
NUMBER | A foreign key referencing a user in the DIMUSER table. |
USERSALESID |
NUMBER | A foreign key referencing a sales user in the DIMUSER table. |