Skip to content

DIMHIRED

This dimension table stores all placement/assignment related information.

Columns

Column Data type Description
APPID NUMBER The identifier for the talent/applicant.
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 client record in the DIMCUSTOMER table.
HIREACTIVE NUMBER This is set to 1 if the talent/applicant is currently active by checking to see if the current date is between their hired start and end dates. Otherwise, it's set to 0.
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 start and end dates, number of weeks worked, hourly rate and burden. Formula: CASE WHEN [HiredStartDate] = [HiredEndDate] THEN 0 ELSE CONVERT(decimal(19, 4), CONVERT(decimal(19, 4), DATEDIFF(day, [HiredStartDate], [HiredEndDate]) ) / 7 ) * ([HiredPayRate] * (1 + [HiredBurden])) END
HIREDCONTESTREV NUMBER The estimated revenue for a contractor hired based on the placement start and end dates and their hourly billing rate. Formula: CASE WHEN [HiredStartDate] = [HiredEndDate] THEN 0 ELSE CONVERT(decimal(19,4), CONVERT(decimal(19,4), DATEDIFF(day, [HiredStartDate], [HiredEndDate]) ) / 7 ) * [HiredBillRate] END
HIREDDATE TIMESTAMP_NTZ The date of the placement/assignment.
HIREDDISCOUNTS NUMBER The discounts applied to the placement/assignment.
HIREDEMPTYPE VARCHAR The type of employment (W-2, C2C, or 1099 worker type).
HIREDEMPTYPEDESC VARCHAR The description of the employee type for the placement.
HIREDENDDATE TIMESTAMP_NTZ The placement end date.
HIREDENDREASONID NUMBER A foreign key referencing a placement end reason in the DIMHIREDENDREASON table.
HIREDENDREASONKEY NUMBER A foreign key referencing a placement end reason in the DIMHIREDENDREASON table.
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 a placement/assignment.
HIREDPAYRATE NUMBER The placement pay rate value.
HIREDPLACEFEE NUMBER A fee charged by a staffing company for placing a candidate on the placement/assignment.
HIREDSTARTDATE TIMESTAMP_NTZ The placement start date.
HIREDTYPEID NUMBER A foreign key referencing a placement type in the DIMHIREDTYPE table.
HIREDTYPEKEY NUMBER A foreign key referencing a placement type in the DIMHIREDTYPE table.
HIREDVMS NUMBER The deduction made by the Vendor Management System (VMS) on behalf of a staffing agency. It is calculated as vms_deduct/100.
JOBDAYSLENGTH NUMBER The total number of days the job placement/assignment lasts.
REQHIREDID NUMBER The identifier for the placement/assignment.
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.