ACTIVITY_FACT¶

This fact table stores information about applicant, job, and contact activities.

Relationships¶

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

ACTIVITY_FACT relationship diagram

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.
`ACTID`	NUMBER	The ID holding the primary key value for Applicants, Hiring Manager/Contact, Req/Job and ReqHired/Placement based on the activity that falls under those entities.
`ACTIVITYKEY`	NUMBER	The primary key referencing an activity.
`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`	VARCHAR	A foreign key referencing an activity type in the DIMACTIVITYTYPE table.
`ACTUTCDATETIME`	TIMESTAMP_NTZ	The date and time of the Applicant activity in UTC or Coordinated Universal Time.
`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.
`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.
`COMPOSITESTAGEKEY`	VARCHAR	A composite key for various activities, combining the Applicant and Job keys.
`CONTACTID`	NUMBER	A foreign key referencing a contact/hiring manager (HIRINGMANAGERID) in the DIMHIRINGMANAGER table. It is only populated for ActivityCategory of Hiring Manager and Opportunity.
`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.
`DATEKEY`	NUMBER	A foreign key referencing the date in the DIMDATE table.
`EEOUSKEY`	NUMBER	Not used.
`HIREDEXTID`	NUMBER	A foreign key referencing a placement extension (HIREDREQHIREDEXTID) in the DIMHIREDEXTENSIONS table.
`HIREDID`	NUMBER	A foreign key referencing a placement in the DIMHIRED table.
`HIRINGMANAGERID`	NUMBER	A foreign key referencing a contact/hiring manager in the DIMHIRINGMANAGER table. It is populated for Activity Category of Job, Hired, Placement, etc. except for Hiring Manager and Opportunity.
`NOMINATIONSOURCE`	VARCHAR	Not used.
`OPPKEY`	NUMBER	A foreign key referencing an opportunity in the DIMOPPORTUNITY table.
`ORIGINALSOURCE`	VARCHAR	The original source of the applicant for the given job, used to determine whether it comes from Web Apply or Applicant Source.
`REQID`	NUMBER	A foreign key referencing a job requirement 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.
`USERAUTHID`	NUMBER	A key referencing the user who created a contact, job, or talent activity in the DIMUSER table.
`USERCREDITID`	NUMBER	A foreign key referencing a recruiter user in the DIMUSER table.
`USERSALESID`	NUMBER	A foreign key referencing a sales user in the DIMUSER table.
`WEBAPPID`	NUMBER	A foreign key referencing a web applicant in the DIMWEBAPPLY table.