RECRUITER_SUMMARY_FACT¶

This fact table stores information for the executive recruiter summary.

Relationships¶

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

RECRUITER_SUMMARY_FACT relationship diagram

Columns¶

Column	Data type	Description
`ACCOUNTINGPERIODNUMERICDATE`	NUMBER	The accounting period date. Default value: 0
`ACTIVITYTYPEID`	NUMBER	An ID representing the Activity Type. This 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. Default value: 0
`APHIREENDDATE`	DATE	Set to Null. Not used.
`APHIRESTARTDATE`	DATE	Set to Null. Not used.
`APPENDDATE`	DATE	Set to Null. Not used.
`APPID`	NUMBER	The identifier for the talent/applicant. For a visual reference of this data element in the source system, see Appendix B: APPID.
`APPLICANTKEY`	NUMBER	A foreign key referencing an applicant record in the DIMAPPLICANT table. Default value: 0
`APPSTARTDATE`	DATE	Set to Null. Not used.
`ARAGINGINVOICEDUESTATUS`	VARCHAR	The status of the invoice indicating whether it is Within Due or Over Due. Default value: N/A.
`BALANCEAMOUNT`	NUMBER	The remaining amount of the invoice. For a visual reference of this data element in the source system, see Appendix B: BALANCEAMOUNT.
`BILLAMOUNT`	NUMBER	The total amount billed.
`BILLEDAMOUNT`	NUMBER	The total amount billed. Formula: BILLEDAMOUNT = SUM(BILLAMOUNT + GPADJUSTMENTBILL - DISCOUNTAMOUNT). For a visual reference of this data element in the source system, see Appendix B: BILLEDAMOUNT.
`BILLRATE`	NUMBER	The bill rate value. For a visual reference of this data element in the source system, see Appendix B: BILLRATE.
`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.
`COUNTACTIVITY`	NUMBER	The count of recorded activities. This column is set to 1.
`CUSTOMERID`	NUMBER	The identifier for the company/customer. For a visual reference of this data element in the source system, see Appendix B: CUSTOMERID.
`DISCOUNTAMOUNT`	NUMBER	The dollar amount of a discount applied to an invoice.
`GPADJUSTMENTBILL`	NUMBER	The adjustments made to the gross profit billed.
`GROSSPROFIT`	NUMBER	The total profit before any deductions. For a visual reference of this data element in the source system, see Appendix B: GPADJUSTMENTPAY.
`INVOICEAMOUNT`	NUMBER	The total amount of the invoice. For a visual reference of this data element in the source system, see Appendix B: INVOICEAMOUNT.
`INVOICEDATE`	DATE	The date on which the invoice was issued. For a visual reference of this data element in the source system, see Appendix B: INVOICEDATE.
`INVOICENUMBER`	VARCHAR	A unique identifier assigned to an invoice. For a visual reference of this data element in the source system, see Appendix B: INVOICENUMBER.
`INVOICETOPAYMENTSTATUS`	VARCHAR	The status of the invoice.
`HIRINGMANAGERID`	NUMBER	A foreign key referencing a contact/hiring manager in the DIMHIRINGMANAGER table. Default value: 0
`OFFICEID`	NUMBER	A foreign key referencing the office in the DIMOFFICE table. Default value: 0
`PAYMENTCOST`	NUMBER	The sum of Gross Wages, Agency Cost, WC Cost, Employer taxes, and Burden. For a visual reference of this data element in the source system, see Appendix B: FINGPADJPAY.
`PAYRATE`	NUMBER	The pay rate value. For a visual reference of this data element in the source system, see Appendix B: PAYRATE.
`PIPELINECOUNT`	NUMBER	The total number of candidates in the pipeline.
`PLACEMENTACTIVITYCOUNT`	NUMBER	The count of placement activities.
`RECRUITERSUMMARYKEY`	NUMBER	The primary key referencing an executive recruiter summary.
`RECRUITERUSERID`	NUMBER	A foreign key referencing a recruiter user in the DIMUSER 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. Default value: 0
`SALESREPUSERID`	NUMBER	A foreign key referencing a sales representative user 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.
`SYSTEMNAME`	VARCHAR	The transaction type of Reg, OT, and DT.