GROSSPROFIT_FACT¶

This fact table stores information about gross profit.

Relationships¶

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

GROSSPROFIT_FACT relationship diagram

Columns¶

Column	Data type	Description
`ACCOUNTINGPERIODDATE`	DATE	The accounting period date.
`ACCOUNTINGPERIODNUMERICDATE`	NUMBER	The numeric representation of the accounting period date. Default value: 0
`AGENCYCOST`	NUMBER	The dollar amount paid to the associated Agency. For a visual reference of this data element in the source system, see Appendix B: AGENCYCOST.
`APPLICANTID`	NUMBER	The identifier for the applicant/talent.
`BILLAMOUNT`	NUMBER	The total amount billed to the client. For a visual reference of this data element in the source system, see Appendix B: BILLAMOUNT.
`BILLDTHOURS`	NUMBER	The number of hours charged as Double Time.
`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.
`BILLOTHERHOURS`	NUMBER	The number of hours charged that do not fall under RT, OT, or DT categories and have CalculateWorkerCompCost property set to True and IsDeduction set to False.
`BILLOTHOURS`	NUMBER	The number of hours charged as Over Time.
`BILLRATE`	NUMBER	The bill rate value. For a visual reference of this data element in the source system, see Appendix B: BILLRATE.
`BILLRTHOURS`	NUMBER	The number of hours charged as Regular Time.
`BILLTOTALHOURS`	NUMBER	The total number of hours charged.
`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.
`BURDEN`	NUMBER	The actual cost incurred by a company to employ an individual, including health insurance, pension costs, payroll taxes. For a visual reference of this data element in the source system, see Appendix B: BURDEN.
`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.
`CREDITCARDFEE`	NUMBER	The fee charged for processing credit card transactions.
`CUSTOMERID`	NUMBER	The identifier for the customer. For a visual reference of this data element in the source system, see Appendix B: CUSTOMERID.
`CUSTOMERKEY`	NUMBER	A foreign key referencing the customer record in the DIMCUSTOMER table.
`CUSTOMERNAME`	VARCHAR	The name of the customer.
`DEPARTMENTNAME`	VARCHAR	The name of the department. For a visual reference of this data element in the source system, see Appendix B: DEPARTMENTNAME.
`DISCOUNTAMOUNT`	NUMBER	The amount of discount applied to the bill amount. For a visual reference of this data element in the source system, see Appendix B: DISCOUNTAMOUNT.
`EMPLOYEEPAID`	VARCHAR	An indication of whether the talent is paid for the given accounting period date or not.
`EMPLOYERCONTRIBUTION`	NUMBER	The amount contributed by the employer. For a visual reference of this data element in the source system, see Appendix B: EMPLOYERCONTRIBUTION.
`EMPLOYERTAXES`	NUMBER	The amount of taxes charged to the employer. For a visual reference of this data element in the source system, see Appendix B: EMPLOYERTAXES.
`GPADJUSTMENTBILL`	NUMBER	The sum of Item Bill Transaction types that is nontaxable and has property GPCalculation set to True.
`GPADJUSTMENTCOST`	NUMBER	The adjustments made to the gross profit cost. For a visual reference of this data element in the source system, see Appendix B: GPADJUSTMENTCOST.
`GPADJUSTMENTPAY`	NUMBER	The adjustments made to the gross profit pay. For a visual reference of this data element in the source system, see Appendix B: GPADJUSTMENTPAY.
`GROSSPROFIT`	NUMBER	The profit made by a staffing company on the transaction. Formula: (BillAmount + GPAdjBill – DiscountAmount) – (GrossWages + AgencyCost + EmployerTaxes + WorkerComp + GPAdjPay + GPAdjCost + Burden). For a visual reference of this data element in the source system, see Appendix B: GROSSPROFIT.
`GROSSPROFITKEY`	NUMBER	The primary key referencing gross profit.
`GROSSWAGES`	NUMBER	The taxable income which does not include pass through deductions. For a visual reference of this data element in the source system, see Appendix B: GROSSWAGES.
`INVOICEGUID`	VARCHAR	A globally unique identifier for the invoice.
`NONADJUSTMENTCOST`	NUMBER	The costs that are not subject to any adjustments or changes.
`NONGPADJBILL`	NUMBER	The non-gross profit adjustments made to the billed amount.
`NONGPADJPAY`	NUMBER	The non-gross profit adjustments made to the pay amount.
`OFFICEID`	NUMBER	A foreign key referencing the office in the DIMOFFICE table. Default value: 0
`OFFICEKEY`	NUMBER	A foreign key referencing the office in the DIMOFFICE table. Default value: 0
`PAYDTHOURS`	NUMBER	The total amount of Double Time hours worked by the employee.
`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.
`PAYOTHERHOURS`	NUMBER	The number of hours paid that do not fall under RT, OT, or DT categories and have CalculateWorkerCompCost property set to True and IsDeduction set to False.
`PAYOTHOURS`	NUMBER	The total amount of Over Time hours worked by the employee.
`PAYRATE`	NUMBER	The pay rate value. For a visual reference of this data element in the source system, see Appendix B: PAYRATE.
`PAYRATETOBILLRATE`	NUMBER	The ratio of the difference between BILLRATE and PAYRATE to either BILLRATE or 1 (if BILLRATE is 0). Formula: ( (IFNULL(BILLRATE, 0) - IFNULL(PAYRATE, 0)) / CASE WHEN IFNULL(BILLRATE, 0) = 0 THEN 1 ELSE IFNULL(BILLRATE, 1) END ) AS PAYRATETOBILLRATE
`PAYRTHOURS`	NUMBER	The total amount of Regular Time hours worked by the employee.
`PAYTOTALHOURS`	NUMBER	The total number of hours paid.
`REBATEAMOUNT`	NUMBER	The rebate amount from transaction.
`RECRUITERUSERID`	NUMBER	A foreign key referencing a recruiter user in the DIMUSER table.
`RECRUITERUSERKEY`	NUMBER	A foreign key referencing a recruiter user in the DIMUSER table.
`REQHIREDID`	NUMBER	The identifier for the placement/assignment.
`REQRECORDID`	NUMBER	The identifier for the requirement.
`SALESREPUSERID`	NUMBER	A foreign key referencing a sales representative user in the DIMUSER table.
`SALESREPUSERKEY`	NUMBER	A foreign key referencing a sales representative user in the DIMUSER table.
`SYSTEMNAME`	VARCHAR	The transaction type of Reg, OT, and DT.
`TRANSACTIONGUID`	VARCHAR	A globally unique identifier for the transaction.
`WORKERCOMPCOST`	NUMBER	The cost of worker's compensation. For a visual reference of this data element in the source system, see Appendix B: WORKERCOMPCOST.