DIMRPTREQ¶
This dimension table stores information about the job requirements and is preferable to use over the DIMREQ table because it includes more columns. Note: The DIMREQ table has been deprecated, and, depending on when your DataLink account was created, this table may or may not exist in your account. DIMRPTREQ should be used for information about job requirements.
Columns¶
| Column | Data type | Description |
|---|---|---|
BRANCHID |
NUMBER | The Branch ID. Note: This Branch ID is the Branch ID associated with a particular Job Requirement. This is (or can be) different than a Hiring Manager's Branch ID. In other words, the Hiring Manager associated with a particular Job Requirement can have a different Branch from the Branch associated directly with the Job Requirement. |
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. |
COMPANYBRANCHADDRESS1 |
VARCHAR | The company branch street address, line 1. |
COMPANYBRANCHADDRESS2 |
VARCHAR | The company branch street address, line 2. |
COMPANYBRANCHCITY |
VARCHAR | The company branch’s city. |
COMPANYBRANCHCOUNTRY |
VARCHAR | The company branch’s country. |
COMPANYBRANCHKEY |
NUMBER | This Branch Key is the Branch Key associated with a particular Job Requirement (see additional Information above In the description for BRANCHID). |
COMPANYBRANCHSTATE |
VARCHAR | The company branch’s state. |
COMPANYBRANCHZIP |
VARCHAR | The company branch’s ZIP/postal code. |
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. |
DAYSTOFILL |
NUMBER | The number of days from the job requirement created to the placement of a candidate. For a visual reference of this data element in the source system, see Appendix B: DAYSTOFILL. |
DAYSTOINTERVIEW |
NUMBER | The number of days from the job requirement created to the interview date of a candidate. For a visual reference of this data element in the source system, see Appendix B: DAYSTOINTERVIEW. |
DAYSTOSUBMIT |
NUMBER | The number of days from the job requirement created to the submission of a candidate. For a visual reference of this data element in the source system, see Appendix B: DAYSTOSUBMIT. |
HIRINGMANAGERID |
NUMBER | A foreign key referencing a contact/hiring manager in the DIMHIRINGMANAGER table. |
HIRINGMANAGERKEY |
NUMBER | A foreign key referencing a contact/hiring manager in the DIMHIRINGMANAGER table. |
JOBDAYSLENGTH |
NUMBER | The total number of days the job placement lasts. |
JOBDETAIL |
VARCHAR | The Job Detail information for the req. |
JOBTITLE |
VARCHAR | The title of the job. For a visual reference of this data element in the source system, see Appendix B: JOBTITLE. |
JOBTITLELINK |
VARCHAR | The job profile URL. |
JOBTITLEURL |
VARCHAR | The URL to the job title. |
JOBTYPEID |
NUMBER | A foreign key referencing a job type in the DIMJOBTYPE table. |
JOBTYPEKEY |
NUMBER | A foreign key referencing a job type in the DIMJOBTYPE table. |
OFFICEID |
NUMBER | A foreign key referencing the office in the DIMOFFICE table. |
OFFICEKEY |
NUMBER | A foreign key referencing the office in the DIMOFFICE table. |
OPPID |
NUMBER | The identifier for the opportunity. |
ORIGINREQPOSITIONS |
NUMBER | Not used. |
OTTYPE |
VARCHAR | The type of the overtime. For a visual reference of this data element in the source system, see Appendix B: OTTYPE. |
PIPELINECOUNT |
NUMBER | The number of talent pipelined for the job. For a visual reference of this data element in the source system, see Appendix B: PIPELINECOUNT. |
POSITIONSFILLED |
NUMBER | The number of filled positions. For a visual reference of this data element in the source system, see Appendix B: POSITIONSFILLED. |
POSITIONSOPEN |
NUMBER | The number of open positions. For a visual reference of this data element in the source system, see Appendix B: POSITIONSOPEN. |
RECRUITERACTIVEFLAG |
VARCHAR | An indication of whether the recruiter is active at the job level. |
REQACTBILLRATE |
NUMBER | The actual bill rate value. For a visual reference of this data element in the source system, see Appendix B: REQACTBILLRATE. |
REQACTPAYRATE |
NUMBER | The actual pay rate value. For a visual reference of this data element in the source system, see Appendix B: REQACTPAYRATE. |
REQARCHIVE |
NUMBER | An indication of whether the job requirement is archived or not. |
REQBILLMAX |
NUMBER | The maximum bill rate value. For a visual reference of this data element in the source system, see Appendix B: REQBILLMAX. |
REQBILLMIN |
NUMBER | The minimum bill rate value. For a visual reference of this data element in the source system, see Appendix B: REQBILLMIN. |
REQBILLRATE |
NUMBER | The bill rate value. For a visual reference of this data element in the source system, see Appendix B: REQBILLRATE. |
REQBURDEN |
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: REQBURDEN. |
REQBURDENDEFAULT |
NUMBER | The default burden value assigned based on ReqType which can be either C2C, W-2, or 1099. |
REQCANDREP |
VARCHAR | The candidate's representative. For a visual reference of this data element in the source system, see Appendix B: REQCANDREP. |
REQCREATEDATE |
DATE | The date and time when the job requirement was created. |
REQCREATEWK |
NUMBER | Not used. |
REQCUSTOMID |
VARCHAR | Not used. |
REQDAYSOPEN |
NUMBER | The number of days from the job requirement created to the current date. For a visual reference of this data element in the source system, see Appendix B: REQDAYSOPEN. |
REQDEPARTMENT |
VARCHAR | The department associated with the job requirement. For a visual reference of this data element in the source system, see Appendix B: REQDEPARTMENT. |
REQDIVISION |
VARCHAR | The division associated with the job requirement. |
REQENDDATE |
DATE | The estimated end date. For a visual reference of this data element in the source system, see Appendix B: REQENDDATE. |
REQEOR |
VARCHAR | The types of jobs, such as contract, part time, contract to perm, etc. For a visual reference of this data element in the source system, see Appendix B: REQEOR. |
REQESTWEEKS |
NUMBER | The estimated number of weeks between the job requirement start and end dates. |
REQFORECASTGP |
NUMBER | The forecasted Gross Profit for the job requirement. For a visual reference of this data element in the source system, see Appendix B: REQFORECASTGP. |
REQFORECASTREV |
NUMBER | The forecasted revenue for the job requirement. When the job is 'Permanent', REQFORECASTREV is calculated as ReqPlacementFee; otherwise, it is calculated as ReqPositions * ReqActBillRate * ReqEstWeeks * 38. |
REQID |
NUMBER | The identifier for the requirement. For a visual reference of this data element in the source system, see Appendix B: REQID. |
REQKEY |
NUMBER | A foreign key referencing a job requirement in the DIMRPTREQ table. |
REQLOCATION |
VARCHAR | The location associated with the job requirement. |
REQOWNERCOMBINED |
VARCHAR | The additional owner(s) of the job requirement. |
REQOWNERPRIMARY |
VARCHAR | A primary owner of the job requirement. |
REQOWNERUSERID |
NUMBER | The original job owner assigned under the New Order activity type for the given job. |
REQOWNERUSERKEY |
NUMBER | The original job owner assigned under the New Order activity type for the given job. |
REQPAYMAX |
NUMBER | The maximum pay rate value. For a visual reference of this data element in the source system, see Appendix B: REQPAYMAX. |
REQPAYMIN |
NUMBER | The minimum pay rate value. For a visual reference of this data element in the source system, see Appendix B: REQPAYMIN. |
REQPAYRATE |
NUMBER | The pay rate value. For a visual reference of this data element in the source system, see Appendix B: REQPAYRATE. |
REQPLACEMENTFEE |
NUMBER | The placement fee for the job. |
REQPLACEMENTPCT |
NUMBER | The placement percentage for the job. |
REQPO |
VARCHAR | The purchase order description. |
REQPOSITIONS |
NUMBER | The number of job positions. |
REQPOSITIONTYPE |
VARCHAR | The position type associated with the job requirement. Note: In the DBO Schema, this column name is REQPOSINTYPE. |
REQREFID |
VARCHAR | An additional identifier for the job requirement. For a visual reference of this data element in the source system, see Appendix B: REQREFID. |
REQSALESREP |
VARCHAR | The sales representative. For a visual reference of this data element in the source system, see Appendix B: REQSALESREP. |
REQSTARTDATE |
DATE | The estimated start date. For a visual reference of this data element in the source system, see Appendix B: REQSTARTDATE. |
REQTIERID |
NUMBER | A foreign key referencing a job requirement tier/status in the DIMREQTIER table. |
REQTIERKEY |
NUMBER | A foreign key referencing a job requirement tier/status in the DIMREQTIER table. |
REQTYPE |
VARCHAR | The type of requirement. For a visual reference of this data element in the source system, see Appendix B: REQTYPE. |
REQUPDATEDATE |
DATE | The date and time when the job requirement was last updated. |
REQUSERCANDID |
NUMBER | A foreign key referencing a recruiter user in the DIMUSER table. |
REQUSERCANDKEY |
NUMBER | A foreign key referencing a recruiter user in the DIMUSER table. |
REQUSERCREATEID |
NUMBER | A foreign key referencing a user who created a job requirement in the DIMUSER table. |
REQUSERCREATEKEY |
NUMBER | A foreign key referencing a user who created a job requirement in the DIMUSER table. |
REQUSERSALESID |
NUMBER | A foreign key referencing a sales user in the DIMUSER table. |
REQUSERSALESKEY |
NUMBER | A foreign key referencing a sales user in the DIMUSER table. |
RPTREQKEY |
NUMBER | The primary key referencing a job requirement. |
SALESACTIVEFLAG |
VARCHAR | An indication of whether the Sales Representative is active at the job level. |