Skip to content

DIMHIREDEXTENSIONS

This dimension table stores information about placement extensions.

Columns

Column Data type Description
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.
CUSTOMERKEY NUMBER A foreign key referencing the customer record in the DIMCUSTOMER table.
HIREDBILLRATE NUMBER The placement bill rate value.
HIREDBURDEN NUMBER The actual cost incurred by a company to employ an individual, including health insurance, pension costs, payroll taxes.
HIREDCANDREPID NUMBER A foreign key referencing a recruiter who created the placement/assignment in the DIMUSER table.
HIREDCANDREPKEY NUMBER A foreign key referencing a recruiter who created the placement/assignment in the DIMUSER table.
HIREDCONTESTCOST NUMBER The estimated cost of a contractor hired based on the placement billed rate, HiredVMS Fee, HiredPayRate, HiredBurden and HiredEstHours. Formula: [HiredContEstCost] AS ((([HiredBillRate] - [HiredBillRate] * [HiredVMS]) - [HiredPayRate] * ((1) + [HiredBurden])) * [HiredEstHours]).
HIREDCONTESTREV NUMBER The estimated revenue for a contractor hired based on a billing rate, VMS fee, and estimated hours worked. Formula:(([HiredBillRate] - [HiredBillRate] * [HiredVMS]) * [HiredEstHours]).
HIREDDATE TIMESTAMP_NTZ The date of placement/assignment.
HIREDDISCOUNTS NUMBER The discounts applied to the placement/assignment.
HIREDEMPTYPE VARCHAR The type of employment.
HIREDEMPTYPEDESC VARCHAR The description of the employee type for the placement/assignment.
HIREDENDDATE TIMESTAMP_NTZ The placement end date.
HIREDESTHOURS NUMBER The estimated hours for the placement/assignment.
HIREDFLATFEES NUMBER The flat fees associated with the placement/assignment.
HIREDKEY NUMBER The primary key referencing the placement.
HIREDORIGENDDATE TIMESTAMP_NTZ The original end date of the placement.
HIREDORIGSTART TIMESTAMP_NTZ The original start date of the placement.
HIREDPAYRATE NUMBER The placement pay rate value.
HIREDPERMREV NUMBER The revenue for permanent placement which equals placement and flat fees minus discounts. Formula: (([HiredPlaceFee] + [HiredFlatFees]) - [HiredDiscounts]).
HIREDPLACEFEE NUMBER A fee charged by a staffing company for placing a candidate on the placement/assignment.
HIREDREQHIREDEXTID NUMBER The identifier for the extended placement.
HIREDSALARY NUMBER The base salary that was given to the permanent employee during the hiring process.
HIREDSTARTDATE TIMESTAMP_NTZ The placement start date.
HIREDVMS NUMBER The deduction made by the Vendor Management System (VMS) on behalf of a staffing agency. It is calculated as vms_deduct/100.
REQHIREDID NUMBER The identifier for the placement/assignment.