FO_FACT¶

This fact table stores Front Office only information.

Relationships¶

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

FO_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.
`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.
`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.
`COMPCONTACTKEY`	NUMBER	A foreign key referencing a contact/hiring manager (HIRINGMANAGERKEY) in the vw_rpt_contact view.
`COMPOSITESTAGEKEY`	VARCHAR	A composite key for various activities, combining the Applicant and Job keys.
`CONTACTID`	NUMBER	A foreign key referencing a contact/hiring manager (HIRINGMANAGERKEY) in the DIMHIRINGMANAGER table.
`CONTACTKEY`	NUMBER	A foreign key referencing a contact/hiring manager (HIRINGMANAGERKEY) in the DIMHIRINGMANAGER table.
`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.
`FOACTIVITYKEY`	NUMBER	The primary key referencing the activity. It auto increments the value by 1.
`HIREDEXTID`	NUMBER	A foreign key referencing a placement extension in the DIMHIREDEXTENSIONS table. Default value: 0
`HIREDEXTKEY`	NUMBER	A foreign key referencing a placement extension in the DIMHIREDEXTENSIONS table. Default value: 0
`HIREDID`	NUMBER	A foreign key referencing a placement in the DIMHIRED table.
`HIREDKEY`	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.
`HIRINGMANAGERKEY`	NUMBER	A foreign key referencing a contact/hiring manager in the DIMHIRINGMANAGER table.
`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.
`REQKEY`	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.
`USERAUTHKEY`	NUMBER	A key referencing the user who created a contact, job, or talent activity.
`USERCREDITID`	NUMBER	A foreign key referencing a recruiter user in the DIMUSER table.
`USERCREDITKEY`	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.
`USERSALESKEY`	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.
`WEBAPPKEY`	NUMBER	A foreign key referencing a web applicant in the DIMWEBAPPLY table.