REVENUE_ACTIVITY_FACT¶

This fact table stores information about revenue and job activity.

Relationships¶

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

REVENUE_ACTIVITY_FACT relationship diagram

Columns¶

Column	Data type	Description
`ACCOUNTINGPERIODDATE`	DATE	The date corresponding to the accounting period.
`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.
`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.
`COMPANYKEY`	NUMBER	The identifier for the company.
`CUSTOMERKEY`	NUMBER	A foreign key referencing the customer record in the DIMCUSTOMER table.
`DISCOUNTAMOUNT`	NUMBER	The dollar amount of a discount applied to a bill.
`GPADJUSTMENTBILL`	NUMBER	The adjustments made to the gross profit billed.
`INTERVIEWCOUNT`	NUMBER	The total number of interviews conducted. Default value: 0. For a visual reference of this data element in the source system, see Appendix B: INTERVIEWCOUNT.
`INTERVIEWED`	VARCHAR	An input text indicating ‘Interview’ if the record is tied to the candidate interviews.
`OFFICEID`	NUMBER	A foreign key referencing the office in the DIMOFFICE table.
`OFFICEKEY`	NUMBER	A foreign key referencing the office in the DIMOFFICE table.
`PIPELINECOUNT`	NUMBER	The total number of candidates in the pipeline. Default value: 0
`PLACEMENTCOUNT`	NUMBER	The total number of candidate placements. Default value: 0
`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.
`ROWCNT`	NUMBER	A row count as 1 for each row.
`SUBMITTALCOUNT`	NUMBER	The total number of candidate submissions. Default value: 0 For a visual reference of this data element in the source system, see Appendix B: SUBMITTALCOUNT.
`SUBMITTED`	VARCHAR	An input text indication ‘Submitted’ if the record is tied to the candidate submissions.