3Subject Areas
Subject Areas
Subject Areas
The standard content was delivered using the Recruiting subject area.
For a complete filterable list of fields, refer to the Oracle Taleo Reporting with OBI — Data Dictionary — Recruiting Subject Area for the Recruiting and Administration subject areas.
Administration Subject Area Additional Information
When developing reports and analyses against the Administration subject area, it is important to understand that every top level folder is independent, meaning that reports cannot be directly created across various folders. For example, it is not possible to mix elements from “OLF” and “System Users” in the same query.
Recruiting (Legacy) Subject Area Additional Information
Net new reports should be developed using the contemporary Recruiting subject area, unless the contemporary Recruiting subject area has functional gaps preventing the new report's functional scope to be met.
When a report developer needs to develop a report on requisitions that do not have any job submissions, it is necessary to add the following element in the results of the report:
Context / Requisitions with/without applications
Recruiting Subject Area
| Folder Path | Column | Description | Data Type |
|---|---|---|---|
| Candidate > Candidate Basic Profile & Preferences | Advance Notice | Returns the candidate's preferred advance notice. | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Candidate Education Level | Returns the candidate's education level. | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Candidate Employee Status | Returns the candidate's preferred employee status. | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Candidate Job Level | Returns the candidate's job level. | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Candidate Job Schedule | Returns the candidate's preferred job schedule. | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Candidate Job Shift | Returns the candidate's preferred job shift. | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Candidate Job Type | Returns the candidate's preferred job type. | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Desired Job Field Level1 Name | Desired Job Field Level1 Name | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Desired Job Field Level2 Name | Desired Job Field Level2 Name | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Desired Job Field Level3 Name | Desired Job Field Level3 Name | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Desired Job Field Level4 Name | Desired Job Field Level4 Name | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Desired Location Level1 Name | Desired Location Level1 Name | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Desired Location Level2 Name | Desired Location Level2 Name | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Desired Location Level3 Name | Desired Location Level3 Name | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Desired Location Level4 Name | Desired Location Level4 Name | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Desired Location Level5 Name | Desired Location Level5 Name | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Desired Organization Level1 Name | Desired Organization Level1 Name | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Desired Organization Level10 Name | Desired Organization Level10 Name | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Desired Organization Level11 Name | Desired Organization Level11 Name | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Desired Organization Level12 Name | Desired Organization Level12 Name | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Desired Organization Level13 Name | Desired Organization Level13 Name | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Desired Organization Level14 Name | Desired Organization Level14 Name | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Desired Organization Level15 Name | Desired Organization Level15 Name | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Desired Organization Level16 Name | Desired Organization Level16 Name | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Desired Organization Level17 Name | Desired Organization Level17 Name | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Desired Organization Level18 Name | Desired Organization Level18 Name | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Desired Organization Level19 Name | Desired Organization Level19 Name | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Desired Organization Level2 Name | Desired Organization Level2 Name | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Desired Organization Level20 Name | Desired Organization Level20 Name | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Desired Organization Level3 Name | Desired Organization Level3 Name | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Desired Organization Level4 Name | Desired Organization Level4 Name | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Desired Organization Level5 Name | Desired Organization Level5 Name | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Desired Organization Level6 Name | Desired Organization Level6 Name | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Desired Organization Level7 Name | Desired Organization Level7 Name | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Desired Organization Level8 Name | Desired Organization Level8 Name | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Desired Organization Level9 Name | Desired Organization Level9 Name | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Email Invitations | Returns whether or not the candidate wants to receive email invitations. | Char |
| Candidate > Candidate Basic Profile & Preferences | Hours Per Week - Preference | Returns the candidate's preference of work hours per week. | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Hours Per Week - Willingness | Returns the candidate's threhold of work hours per week. | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Min. Ann. Salary | Returns the candidate's preferred min. annual salary. | Double |
| Candidate > Candidate Basic Profile & Preferences | Travel | Returns the candidate's perferred travel. | Varchar |
| Candidate > Candidate Basic Profile & Preferences | Willing To Work On Holidays | Returns the candidate's willingess to work on holidays. | Char |
| Candidate > Candidate Basic Profile & Preferences | Willing To Work On Weekends | Returns the candidate's willingess to work on weekends. | Char |
| Candidate > Candidate Dates | Availability Date | Returns the candidate availability date | Datetime |
| Candidate > Candidate Dates | Candidate Creation Date | Returns the candidate creation date | Timestamp |
| Candidate > Candidate Dates | Candidate Last Modified Date | Returns the date when the candidate record was last modified | Timestamp |
| Candidate > Candidate Dates | Candidate Last Modified Date (Including CSW) | Returns the date when the candidate record was last modified, including CSW status changes | Timestamp |
| Candidate > Candidate Dates | Most Recent CSW Move Date | Returns the most recent date when the candidate was moved in the CSW | Timestamp |
| Candidate > Candidate Dates | Reference Date | Returns the candidate reference date | Timestamp |
| Candidate > Candidate Dates | Reference End Date | Returns the referral end date. | Datetime |
| Candidate > Candidate General Profile > Profile Certification | Profile Certification Display Sequence | Returns the certification display sequence | Int |
| Candidate > Candidate General Profile > Profile Certification | Profile Certification Expiration Date | Returns the certification expiration date | Date |
| Candidate > Candidate General Profile > Profile Certification | Profile Certification Issue Date | Returns the certification issue date | Date |
| Candidate > Candidate General Profile > Profile Certification | Profile Certification Issuing Organization | Returns the certification issuing organization | Varchar |
| Candidate > Candidate General Profile > Profile Certification | Profile Certification Name | Returns the certification name as it was selected from the list. | Varchar |
| Candidate > Candidate General Profile > Profile Certification | Profile Certification Name (Other) | Returns the certification name as it was entered in free text | Varchar |
| Candidate > Candidate General Profile > Profile Certification | Profile Certification Number/ID | Returns the certification identifier | Varchar |
| Candidate > Candidate General Profile > Profile Dates | Profile Completed Date | Returns the date/time when the general profile was completed | Timestamp |
| Candidate > Candidate General Profile > Profile Dates | Profile Created Date | Returns the date/time when the general profile was created | Timestamp |
| Candidate > Candidate General Profile > Profile Education History | Profile Education Degree Type | Returns the educational degree type achieved | Varchar |
| Candidate > Candidate General Profile > Profile Education History | Profile Education Display Sequence | Returns the education display sequence | Int |
| Candidate > Candidate General Profile > Profile Education History | Profile Education GPA | Returns the profile education GPA | Double |
| Candidate > Candidate General Profile > Profile Education History | Profile Education GPA (Out Of) | Returns the profile education GPA range | Double |
| Candidate > Candidate General Profile > Profile Education History | Profile Education Graduation Date | Returns the educational program graduation date | Datetime |
| Candidate > Candidate General Profile > Profile Education History | Profile Education Graduation Date Is Projected | Returns whether or not the education program graduation date is projected | Char |
| Candidate > Candidate General Profile > Profile Education History | Profile Education Institution Country | Returns the country of the educational institution | Varchar |
| Candidate > Candidate General Profile > Profile Education History | Profile Education Institution Name | Returns the educational institution as it was selected from the list. | Varchar |
| Candidate > Candidate General Profile > Profile Education History | Profile Education Institution Name (Other) | Returns the educational institution as it was entered in free text. | Varchar |
| Candidate > Candidate General Profile > Profile Education History | Profile Education Institution State/Province | Returns the state/province of the educational institution | Varchar |
| Candidate > Candidate General Profile > Profile Education History | Profile Education Is Most Recent Based On Graduation Date | Filters so that only the most recent education is shown, based on the graduation date. | Char |
| Candidate > Candidate General Profile > Profile Education History | Profile Education Program Name | Returns the educational program as it was selected from the list. | Varchar |
| Candidate > Candidate General Profile > Profile Education History | Profile Education Program Name (Other) | Returns the educational program as it was entered in free text. | Varchar |
| Candidate > Candidate General Profile > Profile Education History | Profile Education Start Date | Returns the educational program start date | Datetime |
| Candidate > Candidate General Profile > Profile General Info | Profile Is Completed | Returns whether or not the general profile is complete | Char |
| Candidate > Candidate General Profile > Profile General Info | Profile Is Internal | Returns whether or not the candidate was internal as of when he/she created the general profile | Char |
| Candidate > Candidate General Profile > Profile General Info | Profile Locale | Returns the locale of the general profile | Varchar |
| Candidate > Candidate General Profile > Profile General Info | Profile Medium | Returns the general profile medium | Varchar |
| Candidate > Candidate General Profile > Profile General Info | Profile Originator | Returns the general profile originator type i.e. "Agent", "Candidate", "Recruiter", "Referrer" | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Input Parameter - Code 1 | Returns the code of the passport service request's input parameter | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Input Parameter - Code 10 | Returns the code of the passport service request's input parameter | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Input Parameter - Code 2 | Returns the code of the passport service request's input parameter | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Input Parameter - Code 3 | Returns the code of the passport service request's input parameter | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Input Parameter - Code 4 | Returns the code of the passport service request's input parameter | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Input Parameter - Code 5 | Returns the code of the passport service request's input parameter | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Input Parameter - Code 6 | Returns the code of the passport service request's input parameter | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Input Parameter - Code 7 | Returns the code of the passport service request's input parameter | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Input Parameter - Code 8 | Returns the code of the passport service request's input parameter | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Input Parameter - Code 9 | Returns the code of the passport service request's input parameter | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Input Parameter - Value 1 | Returns the value of the passport service request's input parameter | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Input Parameter - Value 10 | Returns the value of the passport service request's input parameter | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Input Parameter - Value 2 | Returns the value of the passport service request's input parameter | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Input Parameter - Value 3 | Returns the value of the passport service request's input parameter | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Input Parameter - Value 4 | Returns the value of the passport service request's input parameter | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Input Parameter - Value 5 | Returns the value of the passport service request's input parameter | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Input Parameter - Value 6 | Returns the value of the passport service request's input parameter | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Input Parameter - Value 7 | Returns the value of the passport service request's input parameter | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Input Parameter - Value 8 | Returns the value of the passport service request's input parameter | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Input Parameter - Value 9 | Returns the value of the passport service request's input parameter | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Code 1 | Returns the code of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Code 10 | Returns the code of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Code 11 | Returns the code of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Code 12 | Returns the code of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Code 13 | Returns the code of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Code 14 | Returns the code of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Code 15 | Returns the code of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Code 16 | Returns the code of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Code 17 | Returns the code of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Code 18 | Returns the code of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Code 19 | Returns the code of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Code 2 | Returns the code of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Code 20 | Returns the code of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Code 21 | Returns the code of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Code 22 | Returns the code of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Code 23 | Returns the code of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Code 24 | Returns the code of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Code 25 | Returns the code of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Code 26 | Returns the code of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Code 27 | Returns the code of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Code 28 | Returns the code of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Code 29 | Returns the code of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Code 3 | Returns the code of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Code 30 | Returns the code of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Code 4 | Returns the code of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Code 5 | Returns the code of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Code 6 | Returns the code of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Code 7 | Returns the code of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Code 8 | Returns the code of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Code 9 | Returns the code of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Value 1 | Returns the value of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Value 10 | Returns the value of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Value 11 | Returns the value of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Value 12 | Returns the value of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Value 13 | Returns the value of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Value 14 | Returns the value of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Value 15 | Returns the value of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Value 16 | Returns the value of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Value 17 | Returns the value of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Value 18 | Returns the value of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Value 19 | Returns the value of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Value 2 | Returns the value of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Value 20 | Returns the value of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Value 21 | Returns the value of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Value 22 | Returns the value of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Value 23 | Returns the value of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Value 24 | Returns the value of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Value 25 | Returns the value of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Value 26 | Returns the value of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Value 27 | Returns the value of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Value 28 | Returns the value of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Value 29 | Returns the value of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Value 3 | Returns the value of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Value 30 | Returns the value of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Value 4 | Returns the value of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Value 5 | Returns the value of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Value 6 | Returns the value of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Value 7 | Returns the value of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Value 8 | Returns the value of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Passport Result - Value 9 | Returns the value of the passport service results | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Request Is Most Recent Request Per Provider/Alias | Filters so that only the most recent passport service request is displayed. This is calculated for each provider+alias combination. | Char |
| Candidate > Candidate General Profile > Profile Passport | Profile Service Alias | Returns the passport service alias | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Service External Reference Number | Returns the passport service request's external reference number | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Service Internal Reference Number | Returns the passport service request's internal reference number | Double |
| Candidate > Candidate General Profile > Profile Passport | Profile Service Name | Returns the passport service name | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Service Provider | Returns the passport service provider | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Service Request Date | Returns the date/time when the passport service was requested | Timestamp |
| Candidate > Candidate General Profile > Profile Passport | Profile Service Request Status | Returns the current status of the passport service request | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Service Requester | Returns the requester of the passport service | Varchar |
| Candidate > Candidate General Profile > Profile Passport | Profile Service Status Log Date | Returns the date/time the passport service request was changed to its current status | Timestamp |
| Candidate > Candidate General Profile > Profile Passport | Profile Service Type | Returns the passport service type | Varchar |
| Candidate > Candidate General Profile > Profile Source | Profile Source (BL) | Returns the profile source, in its base locale | Varchar |
| Candidate > Candidate General Profile > Profile Source | Profile Source (ML) | Returns the profile source. Use the element "Source Locale" to filter on the appropriate locale. | Varchar |
| Candidate > Candidate General Profile > Profile Source | Profile Source Event Identifier | Returns the general profile source event identifier | Varchar |
| Candidate > Candidate General Profile > Profile Source | Profile Source Event Name | Returns the profile source event name | Varchar |
| Candidate > Candidate General Profile > Profile Source | Profile Source Explanation | Returns the profile source explanation | Varchar |
| Candidate > Candidate General Profile > Profile Source | Profile Source Identifier | Returns the source identifier as seen in the source configuration page | Varchar |
| Candidate > Candidate General Profile > Profile Source | Profile Source Is Available | Returns whether or not the source is currently available. | Char |
| Candidate > Candidate General Profile > Profile Source | Profile Source Locale | Returns the locale of the profile source. | Varchar |
| Candidate > Candidate General Profile > Profile Source | Profile Source Type | Returns the recruitment source type, based on its default display label. | Varchar |
| Candidate > Candidate General Profile > Profile Source | Profile Source Type(Display As) | Returns the recruitment source type, as displayed in the recruiting administration application, under the "display as" column. | Varchar |
| Candidate > Candidate General Profile > Profile Source | Profile Source Was Automatically Entered | Returns whether or not the source was automatically populated into the candidate file | Char |
| Candidate > Candidate General Profile > Profile Source | Source (Agency) | Returns the name of the agency when the source is an agency. | Varchar |
| Candidate > Candidate General Profile > Profile Source | Source (Agent) | Returns the full name of the agent when the source is an agency. | Varchar |
| Candidate > Candidate General Profile > Profile Source | Source (BL) Agent | Returns the description of the agency or 'Not Specified' if no description has been entered for an agency source. | Varchar |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Next Step Code | Returns the profile transitions next step code. | Varchar |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Next Step Name (BL) | Returns the profile transitions next step name in its base locale. | Varchar |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Process Code | Returns the profile transitions process code | Varchar |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Process Current Status | Returns the profile transitions process current status | Varchar |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Process Days Since Creation | If the profile transitions process is in progress, the time in days between the profile transitions process start date and the current date is returned. | Int |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Process Days To Complete | If the profile transitions process is complete, the time in days between the profile transitions process start date and the profile transitions latest status change date. | Int |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Process End Date | Returns the transitions process end date | Timestamp |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Process Is Latest (By Type) | Returns whether or not the profile transitions process is latest (By Type) | Char |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Process Is Visible | Returns whether or not the profile transitions process is sisible | Char |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Process Latest Status Change Date | Returns the profile transitions process latest status change date | Timestamp |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Process Name (BL) | Returns the process name in its base locale | Varchar |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Process Owner Email | Returns the profile transitions process owner email | Varchar |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Process Owner Full Name | Returns the profile transitions process wwner full name | Varchar |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Process Percent Complete | Returns the percent of the profile transitions process that has beeen completed. | Double |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Process Progression Health Is Red | Returns yes if a step or task in the profile transitions process is overdue. | Char |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Process Start Date | Returns the profile transitions process start date | Timestamp |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Process Supervisor Email | Returns the profile transitions process supervisor email | Varchar |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Process Supervisor Full Name | Returns the profile transitions process supervisor full name | Varchar |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Process Type | Returns the profile transitions process type | Varchar |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Step Code | Returns the profile transitions step code | Varchar |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Step Current Status | Returns the profile transitions step current status | Varchar |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Step Days In Progress | If the profile transitions process is in progress, the time in days between the profile transitions process start date and the current date is returned. | Int |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Step Days To Complete | If the profile transitions step is complete, the time in days between the profile transitions step start date and the profile transitions step latest status change date is returned. | Int |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Step Due Date | Returns the profile transitions step due date | Datetime |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Step End Date | Returns the transitions step end date | Timestamp |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Step Expected Duration | Returns the profile transitions step expected duration | Double |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Step Is Overdue | Returns whether or not the profile transitions step ss currently overdue | Char |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Step Latest Status Change Date | Returns the profile transitions step latest status change date | Timestamp |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Step Name (BL) | Returns the profile transisions step name in its base locale | Varchar |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Step Overdue Days | If the profile transitions step is in progress, the time in days between the profile transitions step due date and the current date is returned. | Int |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Step Start Date | Returns the profile transitions step start date | Timestamp |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Step Sub Process Code | Returns the profile transitions step sub process code | Varchar |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Step Sub Process Name (BL) | Returns the step sub-process name in its base locale | Varchar |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Step Type Code | Returns the profile transitions step type code | Varchar |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Task Action | Returns the profile transitions task action | Varchar |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Task Assignee Department | Returns the profile transitions task assignee department | Varchar |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Task Assignee Email | Returns the profile transitions task assignee email | Varchar |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Task Assignee Name | Returns the profile transitions task assignee name | Varchar |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Task Assignment Date | Returns the profile transitions task assignment date | Datetime |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Task Code | Returns the profile transitions task code | Varchar |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Task Comments | Returns the profile transitions task comments | Varchar |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Task Creation Date | Returns the profile transitions task creation date | Timestamp |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Task Current Status | Returns the profile transitions task current status | Varchar |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Task Days Since Creation | If the profile transitions task is in progress, the time in days between the profile transitions task creation date and the current date. | Int |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Task Due Date | Returns the profile transitions task due date | Timestamp |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Task Is Overdue | Returns whether or not the profile transitions task is overdue | Char |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Task Name (BL) | Returns the name of task in its base locale | Varchar |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Task Overdue Days | If the profile transitions task is in progress and the task is overdue, the time in days between the profile transitions task due date and the current date. | Int |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Task Owner Email | Returns the profile transitions task owner email | Varchar |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Task Owner Name | Returns the profile transitions task owner name | Varchar |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Task Related Source (BL) | Returns the task related source in its base locale | Varchar |
| Candidate > Candidate General Profile > Profile Transition Process | Profile Transitions Task Type | Returns the profile transitions task type | Varchar |
| Candidate > Candidate General Profile > Profile Transitions E-Signature | Profile Transitions E-Signature Date | Returns the profile transitions e-signature date | Datetime |
| Candidate > Candidate General Profile > Profile Transitions E-Signature | Profile Transitions E-Signature Definition Name | Returns the profile transitions e-signature definition name | Varchar |
| Candidate > Candidate General Profile > Profile Transitions E-Signature | Profile Transitions E-Signature First & Last Name | Returns the profile transitions e-signature first & last Name. In transitions, this field is titled FullName | Varchar |
| Candidate > Candidate General Profile > Profile Transitions E-Signature | Profile Transitions E-Signature IP Address | Returns the profile transitions e-signature IP address | Varchar |
| Candidate > Candidate General Profile > Profile Work Experience History | Profile Experience Display Sequence | Returns the work experience display sequence | Int |
| Candidate > Candidate General Profile > Profile Work Experience History | Profile Experience Employer Name | Returns the work experience employer as it was selected from the list. | Varchar |
| Candidate > Candidate General Profile > Profile Work Experience History | Profile Experience Employer Name (Other) | Returns the work experience employer as it was entered in free text. | Varchar |
| Candidate > Candidate General Profile > Profile Work Experience History | Profile Experience End Date | Returns the work experience end date | Datetime |
| Candidate > Candidate General Profile > Profile Work Experience History | Profile Experience Is Current Job | Returns whether or not the candidate is currently working for this employer | Char |
| Candidate > Candidate General Profile > Profile Work Experience History | Profile Experience Is Most Recent Based On Start Date | Filters so that only the most recent experience is shown, based on the work start date. | Char |
| Candidate > Candidate General Profile > Profile Work Experience History | Profile Experience Job Title | Returns the work experience job title as it was selected from the list. | Varchar |
| Candidate > Candidate General Profile > Profile Work Experience History | Profile Experience Job Title (Other) | Returns the work experience job title as it was entered in free text. | Varchar |
| Candidate > Candidate General Profile > Profile Work Experience History | Profile Experience Start Date | Returns the work experience start date | Datetime |
| Candidate > Candidate Identification | Address of Residence (Line 1) | Returns the candidate address of residence | Varchar |
| Candidate > Candidate Identification | Address of Residence (Line 2) | Returns the candidate address of residence | Varchar |
| Candidate > Candidate Identification | Age (Years) | Returns the time (in years) between now and the candidate's date of birth. | Double |
| Candidate > Candidate Identification | Candidate Identifier | Returns Candidate ID | Double |
| Candidate > Candidate Identification | Candidate Is Internal | Returns whether or not the candidate is internal | Char |
| Candidate > Candidate Identification | City of Residence | Returns the candidate city of residence | Varchar |
| Candidate > Candidate Identification | Country of Residence | Returns the candidate country of residence | Varchar |
| Candidate > Candidate Identification | Date of Birth | Returns the candidate date of birth | Datetime |
| Candidate > Candidate Identification | Returns the candidate email | Varchar | |
| Candidate > Candidate Identification | Employee Number | Returns the candidate employee number | Varchar |
| Candidate > Candidate Identification | Has Submission | Returns whether or not the candidate has a Submission. | Char |
| Candidate > Candidate Identification | Home Phone | Returns the candidate home phone number | Varchar |
| Candidate > Candidate Identification | Is Anonymous | Returns whether the candidate elected to be anonymous | Char |
| Candidate > Candidate Identification | Is Missing Identification | Returns whether or not the candidate is missing identification information. | Varchar |
| Candidate > Candidate Identification | Mobile Phone | Returns the candidate mobile phone number | Varchar |
| Candidate > Candidate Identification | Name | Returns the candidate name | Varchar |
| Candidate > Candidate Identification | Prefix | Returns the candidate prefix | Varchar |
| Candidate > Candidate Identification | Primary Phone Designation | Returns the candidate primary phone designation | Varchar |
| Candidate > Candidate Identification | Record Status | Returns the status of the candidate record | Varchar |
| Candidate > Candidate Identification | Region of Residence | Returns the candidate region of residence | Varchar |
| Candidate > Candidate Identification | SSN | Returns the candidate social security number | Varchar |
| Candidate > Candidate Identification | State/Prov of Residence | Returns the state/province of residence | Varchar |
| Candidate > Candidate Identification | Suffix | Returns the candidate suffix | Varchar |
| Candidate > Candidate Identification | Work Phone | Returns the candidate work phone number | Varchar |
| Candidate > Candidate Identification | Zip Code of Residence | Returns the candidate zip code of residence | Varchar |
| Candidate > Candidate Most Advanced Job Application | Most Advanced Reference Status | Returns the candidate's most advanced job application reference status | Varchar |
| Candidate > Candidate Most Advanced Job Application | Most Advanced Requisition Identifier | Returns the requisition identifier associated with the candidate's most advanced job application | Varchar |
| Candidate > Candidate Q&A | Answer (Choice) (BL) | Returns the answer to the question in the question's base locale | Varchar |
| Candidate > Candidate Q&A | Answer (Text) | Returns the free text answer to the question | Varchar |
| Candidate > Candidate Q&A | Is Candidate Question On Req. List | Returns whether or not the candidate question is on the requisition question list. | Char |
| Candidate > Candidate Q&A | Question Code | Returns the question code | Varchar |
| Candidate > Candidate Q&A | Question Description (BL) | Returns the description of the question in its base locale | Varchar |
| Candidate > Candidate Referral | Current Referral Status | Returns the current status of the referral | Varchar |
| Candidate > Candidate Referral | Is Currently Referred | Returns whether or not the candidate is currently bound to an active referral | Char |
| Candidate > Candidate Referral | Is Currently Referred By Agent | Returns whether or not the candidate is currently bound to an agent referral | Char |
| Candidate > Candidate Referral | Referral Is Most Recent | Returns whether or not the referral is the most recent for the candidate | Char |
| Candidate > Candidate Referral | Referrer Email | Returns the email of the referrer | Varchar |
| Candidate > Candidate Referral | Referrer Is Employee | Returns whether or not the referrer is an employee | Char |
| Candidate > Candidate Referral | Referrer Name | Returns the name of the referrer | Varchar |
| Candidate > Candidate Referral | Referring Agency Name (BL) | Returns the referring agent's agency, in its base locale | Varchar |
| Candidate > Candidate Referral | Referring Agent Email | Returns the email of the agent | Varchar |
| Candidate > Candidate Referral | Referring Agent Name | Returns the name of the agent | Varchar |
| Candidate > Candidate Regulations | Aboriginal | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Armed Forces Medal Veteran Question Code | Returns the code of the regulation question | Varchar |
| Candidate > Candidate Regulations | Armed Forces Medal Vetran | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Disabled | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Disabled Question Code | Returns the code of the regulation question | Varchar |
| Candidate > Candidate Regulations | Disabled Veteran | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Disabled Veteran Question Code | Returns the code of the regulation question | Varchar |
| Candidate > Candidate Regulations | Ethnicity | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Ethnicity Question Code | Returns the code of the regulation question | Varchar |
| Candidate > Candidate Regulations | Family Status | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Gender | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Gender Question Code | Returns the code of the regulation question | Varchar |
| Candidate > Candidate Regulations | Is Max Standard USA EEO Form With Answer | Returns whether or not this is the most recent EEO form with at least one candidate answer, as it pertains to the standard EEO-USA forms with versions i.e. EEO1, EEO2A and EEO2b. | Char |
| Candidate > Candidate Regulations | Marital Status | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Military Status | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Other Protected Veteran | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Other Protected Veteran Question Code | Returns the code of the regulation question | Varchar |
| Candidate > Candidate Regulations | Political Affiliation | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Race | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Race Question Code | Returns the code of the regulation question | Varchar |
| Candidate > Candidate Regulations | Recently Separated Veteran | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Recently Separated Veteran Question Code | Returns the code of the regulation question | Varchar |
| Candidate > Candidate Regulations | Regulation Form Code | Returns the code associated to the global regulation data collection form. | Varchar |
| Candidate > Candidate Regulations | Regulation Question 1 | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Regulation Question 10 | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Regulation Question 11 | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Regulation Question 12 | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Regulation Question 13 | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Regulation Question 14 | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Regulation Question 15 | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Regulation Question 16 | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Regulation Question 17 | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Regulation Question 18 | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Regulation Question 19 | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Regulation Question 2 | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Regulation Question 20 | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Regulation Question 21 | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Regulation Question 22 | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Regulation Question 23 | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Regulation Question 24 | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Regulation Question 25 | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Regulation Question 3 | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Regulation Question 4 | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Regulation Question 5 | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Regulation Question 6 | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Regulation Question 7 | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Regulation Question 8 | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Regulation Question 9 | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Religion | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Sexual Orientation | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Special Disabled Veteran | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Special Disabled Veteran Question Code | Returns the code of the regulation question | Varchar |
| Candidate > Candidate Regulations | Veteran | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Regulations | Veteran Question Code | Returns the code of the regulation question | Varchar |
| Candidate > Candidate Regulations | Visible Minority | Returns the answer to the regulation question | Varchar |
| Candidate > Candidate Transitions Direct Deposit | Direct Deposit Folio | Returns the direct deposit folio. | Varchar |
| Candidate > Candidate Transitions Direct Deposit | Direct Deposit Institution Name | Returns the direct deposit institution name. | Varchar |
| Candidate > Candidate Transitions Direct Deposit | Direct Deposit Institution Transit Number | Returns the direct deposit institution transit number. | Varchar |
| Candidate > Candidate Transitions Direct Deposit | Direct Deposit Pay Distribution | Returns the direct deposit pay distribution. | Double |
| Candidate > Candidate Transitions I9 | I9 1 Document Expiration Date | Returns the I9 1 document expiration date | Datetime |
| Candidate > Candidate Transitions I9 | I9 1 Document Issuing Authority | Returns the I9 1 document issuing authority | Varchar |
| Candidate > Candidate Transitions I9 | I9 1 Document Number | Returns the I9 1 document number | Varchar |
| Candidate > Candidate Transitions I9 | I9 1 Document Title | Returns the I9 1 document title | Varchar |
| Candidate > Candidate Transitions I9 | I9 1B Document Expiration Date | Returns the I9 1B document expiration date | Datetime |
| Candidate > Candidate Transitions I9 | I9 1B Document Issuing Authority | Returns the I9 1B document issuing authority | Varchar |
| Candidate > Candidate Transitions I9 | I9 1B Document Number | Returns the I9 1B document number | Varchar |
| Candidate > Candidate Transitions I9 | I9 1B Document Title | Returns the I9 1B document title | Varchar |
| Candidate > Candidate Transitions I9 | I9 1C Document Expiration Date | Returns the I9 1C document expiration date | Datetime |
| Candidate > Candidate Transitions I9 | I9 1C Document Issuing Authority | Returns the I9 1C document issuing authority | Varchar |
| Candidate > Candidate Transitions I9 | I9 1C Document Number | Returns the I9 1C document number | Varchar |
| Candidate > Candidate Transitions I9 | I9 1C Document Title | Returns the I9 1C document title | Varchar |
| Candidate > Candidate Transitions I9 | I9 2 Document Expiration Date | Returns the I9 2 document expiration date | Datetime |
| Candidate > Candidate Transitions I9 | I9 2 Document Issuing Authority | Returns the I9 2 document issuing authority | Varchar |
| Candidate > Candidate Transitions I9 | I9 2 Document Number | Returns the I9 2 document number | Varchar |
| Candidate > Candidate Transitions I9 | I9 2 Document Title | Returns the I9 2 document title | Varchar |
| Candidate > Candidate Transitions I9 | I9 3 Document Expiration Date | Returns the I9 3 document expiration date | Datetime |
| Candidate > Candidate Transitions I9 | I9 3 Document Issuing Authority | Returns the I9 3 document issuing authority | Varchar |
| Candidate > Candidate Transitions I9 | I9 3 Document Number | Returns the I9 3 document number | Varchar |
| Candidate > Candidate Transitions I9 | I9 3 Document Title | Returns the I9 3 document title | Varchar |
| Candidate > Candidate Transitions I9 | I9 Employee Alien Number | Returns the I9 employee alien number | Varchar |
| Candidate > Candidate Transitions I9 | I9 Employee Alien Number (2) | Returns the I9 employee alien number (2) | Varchar |
| Candidate > Candidate Transitions I9 | I9 Employee Apartment | Returns the I9 employee apartment | Varchar |
| Candidate > Candidate Transitions I9 | I9 Employee Citizenship | Returns the I9 employee citizenship | Varchar |
| Candidate > Candidate Transitions I9 | I9 Employee Foreign Passport Country | Returns the I9 employee foreign passport country | Varchar |
| Candidate > Candidate Transitions I9 | I9 Employee Foreign Passport Number | Returns the I9 employee foreign passport number | Varchar |
| Candidate > Candidate Transitions I9 | I9 Employee Other Names | Returns the I9 employee other names | Varchar |
| Candidate > Candidate Transitions I9 | I9 Employee Signature Date | Returns the I9 employee signature date | Datetime |
| Candidate > Candidate Transitions I9 | I9 Employee Signature First & Last Name | Returns the I9 employee signature first & last Name. In transitions, this field is titled FullName | Varchar |
| Candidate > Candidate Transitions I9 | I9 Employee Signature IP Address | Returns the I9 employee signature IP address | Varchar |
| Candidate > Candidate Transitions I9 | I9 Employee Work Until Date | Returns the I9 employee work until date | Datetime |
| Candidate > Candidate Transitions I9 | I9 Employer Business Address | Returns the I9 employer business address | Varchar |
| Candidate > Candidate Transitions I9 | I9 Employer Business City | Returns the I9 employer business city | Varchar |
| Candidate > Candidate Transitions I9 | I9 Employer Business Name | Returns the I9 employer business name | Varchar |
| Candidate > Candidate Transitions I9 | I9 Employer Business State | Returns the I9 employer business state | Varchar |
| Candidate > Candidate Transitions I9 | I9 Employer Business Street Address | Returns the I9 employer business street address | Varchar |
| Candidate > Candidate Transitions I9 | I9 Employer Business Zip Code | Returns the I9 employer business zip code | Varchar |
| Candidate > Candidate Transitions I9 | I9 Employer Rep First Name | Returns the I9 employer rep first name | Varchar |
| Candidate > Candidate Transitions I9 | I9 Employer Rep Last Name | Returns the I9 employer rep last name | Varchar |
| Candidate > Candidate Transitions I9 | I9 Employer Rep Signature Date | Returns the I9 employer rep signature date | Datetime |
| Candidate > Candidate Transitions I9 | I9 Employer Rep Signature First & Last Name | Returns the I9 employer rep signature first & last name. In transitions, this field is titled FullName | Varchar |
| Candidate > Candidate Transitions I9 | I9 Employer Rep Signature IP Address | Returns the I9 employer rep signature IP address | Varchar |
| Candidate > Candidate Transitions I9 | I9 Employer Rep Title | Returns the I9 employer rep title | Varchar |
| Candidate > Candidate Transitions I9 | I9 Preparer Address | Returns the I9 preparer address | Varchar |
| Candidate > Candidate Transitions I9 | I9 Preparer City | Returns the I9 preparer city | Varchar |
| Candidate > Candidate Transitions I9 | I9 Preparer First Name | Returns the I9 preparer first name | Varchar |
| Candidate > Candidate Transitions I9 | I9 Preparer Last Name | Returns the I9 preparer last name | Varchar |
| Candidate > Candidate Transitions I9 | I9 Preparer Print Name | Returns the I9 preparer print name | Varchar |
| Candidate > Candidate Transitions I9 | I9 Preparer Signature Date | Returns the I9 preparer signature date | Datetime |
| Candidate > Candidate Transitions I9 | I9 Preparer Signature First & Last Name | Returns the I9 preparer signature first & last name. In transitions, this field is titled FullName | Varchar |
| Candidate > Candidate Transitions I9 | I9 Preparer Signature IP Address | Returns the I9 preparer Signature IP Address | Varchar |
| Candidate > Candidate Transitions I9 | I9 Preparer State | Returns the I9 preparer state | Varchar |
| Candidate > Candidate Transitions I9 | I9 Preparer Street Address | Returns the I9 preparer street address | Varchar |
| Candidate > Candidate Transitions I9 | I9 Preparer Zip Code | Returns the I9 preparer zip code | Varchar |
| Candidate > Candidate Transitions Passport | Transitions Passport Input Parameter - Code * | Returns the code of the passport service request's input parameter | Varchar |
| Candidate > Candidate Transitions Passport | Transitions Passport Input Parameter - Value * | Returns the value of the passport service request's input parameter | Varchar |
| Candidate > Candidate Transitions Passport | Transitions Passport Result - Code * | Returns the code of the passport service results | Varchar |
| Candidate > Candidate Transitions Passport | Transitions Passport Result - Value * | Returns the value of the passport service results | Varchar |
| Candidate > Candidate Transitions Passport | Transitions Request Is Most Recent Per Provider/Alias | Filters so that only the most recent passport service request is displayed. This is calculated for each provider+alias combination. | Double |
| Candidate > Candidate Transitions Passport | Transitions Service Alias | Returns the passport service alias | Varchar |
| Candidate > Candidate Transitions Passport | Transitions Service External Reference Number | Returns the passport service request's external reference number | Varchar |
| Candidate > Candidate Transitions Passport | Transitions Service Internal Reference Number | Returns the passport service request's internal reference number | Double |
| Candidate > Candidate Transitions Passport | Transitions Service Name | Returns the passport service name | Varchar |
| Candidate > Candidate Transitions Passport | Transitions Service Provider | Returns the passport service provider | Varchar |
| Candidate > Candidate Transitions Passport | Transitions Service Provider Request Status | Returns the current provider status of the passport service request | Varchar |
| Candidate > Candidate Transitions Passport | Transitions Service Request Date | Returns the date/time when the passport service was requested | Timestamp |
| Candidate > Candidate Transitions Passport | Transitions Service Request Status | Returns the current status of the passport service request | Double |
| Candidate > Candidate Transitions Passport | Transitions Service Requester | Returns the requester of the passport service | Varchar |
| Candidate > Candidate Transitions Passport | Transitions Service Status Log Date | Returns the date/time the passport service request was changed to its current status | Timestamp |
| Candidate > Candidate Transitions Passport | Transitions Service Type | Returns the passport service type | Varchar |
| Candidate > Candidate Transitions Subject Info | Subject Corporate Email | Returns the subject corporate email | Varchar |
| Candidate > Candidate Transitions Subject Info | Subject Correspondence Email | Returns the subject correspondence email | Varchar |
| Candidate > Candidate Transitions Subject Info | Subject Department Name | Returns the subject department name | Varchar |
| Candidate > Candidate Transitions Subject Info | Subject Fax Number | Returns the subject fax number | Varchar |
| Candidate > Candidate Transitions Subject Info | Subject Home Phone Number | Returns the subject home phone number | Varchar |
| Candidate > Candidate Transitions Subject Info | Subject Mobile Phone Number | Returns the subject mobile phone number | Varchar |
| Candidate > Candidate Transitions Subject Info | Subject Pager Number | Returns the subject pager number | Varchar |
| Candidate > Candidate Transitions Subject Info | Subject Work Phone Number | Returns the subject work phone number | Varchar |
| Candidate > Candidate Transitions Subject Info | Subject Work Phone Number Extension | Returns the subject work phone number extension | Varchar |
| Candidate Facts > Candidate Counts | # Candidates | Returns the number of distinct candidates | Int |
| Candidate Facts > Candidate Counts | # Candidates Currently Referred | Returns the number of distinct candidates whose referral status is active | Int |
| Candidate Facts > Candidate Counts | # Candidates Currently Referred By Agent | Returns the number of distinct candidates who are referred by an agent. | Int |
| Candidate Facts > Candidate Counts | # General Profiles | Returns the number of distinct of general profiles. | Int |
| Candidate Facts > Candidate Counts | # Submissions | Returns the number of distinct job submissions. | Int |
| Candidate Facts > Candidate Counts | # Submissions Ace | Returns the number of distinct job submissions where the candidate is considered to be ACE. | Int |
| Candidate Facts > Candidate Counts | # Submissions By Candidate | Returns the number of distinct submissions divided by the number of distinct candidates. | Double |
| Candidate Facts > Candidate Counts | # Submissions By Recruiter | Returns the number of submissions divided by the number of recruiters. | Double |
| Candidate Facts > Candidate Counts | # Submissions By Requisition | Returns the number of submissions divided by the number of requisitions. | Double |
| Candidate Facts > Candidate Counts | # Submissions Complete | Returns the number of distinct job submissions that are completed. | Int |
| Candidate Facts > Candidate Counts | # Submissions Currently Declined | Returns the number of distinct submissions currently in the "Declined" reference model status | Int |
| Candidate Facts > Candidate Counts | # Submissions Currently Hired | Returns the number of distinct submissions currently in the "Hired" reference model status | Int |
| Candidate Facts > Candidate Counts | # Submissions Currently In 1st Intv. | Returns the number of distinct submissions currently in the "1st Interview" reference model status | Int |
| Candidate Facts > Candidate Counts | # Submissions Currently In 2nd Intv. | Returns the number of distinct submissions currently in the "2nd Interview" reference model status | Int |
| Candidate Facts > Candidate Counts | # Submissions Currently In 3rd Intv. | Returns the number of distinct submissions currently in the "3rd Interview" reference model status | Int |
| Candidate Facts > Candidate Counts | # Submissions Currently In Offer | Returns the number of distinct submissions currently in the "Offer" reference model status | Int |
| Candidate Facts > Candidate Counts | # Submissions Currently In Pipeline | Returns the number of distinct submissions currently in the "Pipeline" reference model status | Int |
| Candidate Facts > Candidate Counts | # Submissions Currently in Review | Returns the number of distinct submissions currently in the "Review" reference model status | Int |
| Candidate Facts > Candidate Counts | # Submissions Currently In Testing | Returns the number of distinct submissions currently in the "Testing" reference model status | Int |
| Candidate Facts > Candidate Counts | # Submissions Currently Inactive | Returns the number of distinct submissions currently in the "Inactive" reference model status | Int |
| Candidate Facts > Candidate Counts | # Submissions Currently New | Returns the number of distinct submissions currently in the "New" reference model status | Int |
| Candidate Facts > Candidate Counts | # Submissions Currently Referred | Returns a distincct count of submissions currently referred. | Double |
| Candidate Facts > Candidate Counts | # Submissions Currently Referred By Agent | Returns a distinct count of submissions current referred by an agent. | Double |
| Candidate Facts > Candidate Counts | # Submissions Currently Rejected | Returns the number of distinct submissions currently in the "Rejected" reference model status | Int |
| Candidate Facts > Candidate Counts | # Submissions External | Returns the number of distinct job submissions that are external | Int |
| Candidate Facts > Candidate Counts | # Submissions Incomplete | Returns the number of distinct job submissions that are not completed. | Int |
| Candidate Facts > Candidate Counts | # Submissions Internal | Returns the number of distinct submissions that are internal | Int |
| Candidate Facts > Candidate Counts | # Submissions Min. Requirements Met | Returns the number of distinct job submissions where the candidate as met all the requisition minimum requirements. | Int |
| Candidate Facts > Candidate Counts | # Submissions Min. Requirements Unmet | Returns the number of distinct job submissions where the candidate as not met all the requisition minimum requirements. | Int |
| Candidate Facts > Candidate Counts | # Submissions Non-Ace | Returns the number of distinct job submissions where the candidate is not considered to be ACE. | Int |
| Candidate Facts > Candidate Counts | # Submissions Offer Accepted | Returns the number of distinct submissions where the offer status is accepted | Int |
| Candidate Facts > Candidate Counts | # Submissions Offer Refused | Returns the number of distinct submissions where the offer status is refused | Int |
| Candidate Facts > Candidate Counts | # Submissions Reached 1st Intv. | Returns the number of distinct submissions that were historically moved to the reference status 1st Interview | Int |
| Candidate Facts > Candidate Counts | # Submissions Reached 2nd Intv. | Returns the number of distinct submissions that were historically moved to the reference status 2nd Interview | Int |
| Candidate Facts > Candidate Counts | # Submissions Reached 3rd Intv. | Returns the number of distinct submissions that were historically moved to the reference status 3rd Interview | Int |
| Candidate Facts > Candidate Counts | # Submissions Reached Offer | Returns the number of distinct submissions that were historically moved to the reference status Offer | Int |
| Candidate Facts > Candidate Counts | # Submissions Reached Reviewed | Returns the number of distinct submissions that were historically moved to the reference status review | Int |
| Candidate Facts > Candidate Counts | # Submissions Reached Testing | Returns the number of distinct submissions that were historically moved to the reference status Testing | Int |
| Candidate Facts > Candidate Cycle Time | Average Submission Cycle Time | Returns the number of days between the submission completed date and the hired date. | Double |
| Candidate Facts > Candidate Cycle Time | Average Time To Complete Submission | Returns the number of days between the submission created date and the submission completed date. | Double |
| Candidate Facts > Candidate Cycle Time | Average Time to Hire | Returns the number of days between the first fully approved date and the hired date. | Double |
| Candidate Facts > Candidate Cycle Time | Average Time to Start | Returns the number of days between the first fully approved date and the hire start date (offer actual start date, if hire start date is null). | Double |
| Candidate Facts > Candidate Cycle Time | Submission Cycle Time | Returns the average number of days between the submission completed date and hired date. | Int |
| Candidate Facts > Candidate Cycle Time | Time to Complete Submission | Returns the average number of days between the submission created date and the submission completed date. | Double |
| Candidate Facts > Candidate Cycle Time | Time to Hire | Returns the average number of days between the first fully approved date and the hired date. | Double |
| Candidate Facts > Candidate Cycle Time | Time to Start | Returns the average number of days between the the first fully approved date and the hire start date (offer actual start date, if hire start date is null). | Double |
| Candidate Facts > Candidate Demographics | # Candidates Age < 40 Years | Returns the number of candidates whose age is under 40 | Int |
| Candidate Facts > Candidate Demographics | # Candidates Age >= 40 Years | Returns the number of candidates whose age is 40 or older. | Int |
| Candidate Facts > Candidate Demographics | # Candidates Asian | Returns the number of candidates whose race is asian | Int |
| Candidate Facts > Candidate Demographics | # Candidates Black | Returns the number of candidates whose race is black | Int |
| Candidate Facts > Candidate Demographics | # Candidates Ethnicity N/S | Returns the number of candidates whose ethnicity is not specified or undisclosed. | Int |
| Candidate Facts > Candidate Demographics | # Candidates Female | Returns the number of candidates whose gender is female. | Int |
| Candidate Facts > Candidate Demographics | # Candidates Gender N/S | Returns the number of candidates whose gender is not specified or undisclosed. | Int |
| Candidate Facts > Candidate Demographics | # Candidates Hispanic | Returns the number of candidates whose ethnicity is hispanic | Int |
| Candidate Facts > Candidate Demographics | # Candidates Indian Native | Returns the number of candidates whose race is indian native | Int |
| Candidate Facts > Candidate Demographics | # Candidates Male | Returns the number of candidates whose gender is male. | Int |
| Candidate Facts > Candidate Demographics | # Candidates Not Hispanic | Returns the number of candidates whose ethnicity is not hispanic | Int |
| Candidate Facts > Candidate Demographics | # Candidates Pacific Native | Returns the number of candidates whose race is pacific native | Int |
| Candidate Facts > Candidate Demographics | # Candidates Race >1 Choice | Returns the number of candidates who responded that they have 2 or more races. | Int |
| Candidate Facts > Candidate Demographics | # Candidates Race N/S | Returns the number of candidates whose race is not specified or undisclosed. | Int |
| Candidate Facts > Candidate Demographics | # Candidates White | Returns the number of candidates whose race is white | Int |
| Candidate Facts > Candidate Demographics | Average Age (Years) | Returns the average time (in years) between now and the candidate's date of birth. | Double |
| Candidate Facts > Candidate Evaluation Questionnaires | # Evaluation Event | Returns a distinct count of scheduled events. Events can be of type feedback or interview. | Integer |
| Candidate Facts > Candidate Evaluation Questionnaires | # Evaluation Interviews | Returns a distinct count of interviews. | Integer |
| Candidate Facts > Candidate Evaluation Questionnaires | # Evaluation Question Responses | Returns the distinct count of answers to individual questions. | Integer |
| Candidate Facts > Candidate Evaluation Questionnaires | # Evaluation Requests | Returns the distinct count of evaluation requests. | Integer |
| Candidate Facts > Candidate Evaluation Questionnaires | # Evaluation Requests Currently Completed | Returns the distinct count of evaluation requests currently in the status of completed. | Integer |
| Candidate Facts > Candidate Evaluation Questionnaires | # Evaluation Requests Currently Requested | Returns the distinct count of evaluation requests currently in the status of requested. | Integer |
| Candidate Facts > Candidate Evaluation Questionnaires | # Evaluation Skill Responses | Returns the distinct count of answers to individual skills. | Integer |
| Candidate Facts > Candidate Evaluation Questionnaires | Average Evaluation Answer Total Score By Question | Returns the average total score by question. | Double |
| Candidate Facts > Candidate Evaluation Questionnaires | Average Evaluation Answer Total Weight By Question | Returns the average total weight by question. | Double |
| Candidate Facts > Candidate Evaluation Questionnaires | Average Evaluation Answer Weight | Returns the average individual answer score. | Double |
| Candidate Facts > Candidate Evaluation Questionnaires | Average Evaluation Questions Total Percent Score | Returns the average question summary percent score. | Double |
| Candidate Facts > Candidate Evaluation Questionnaires | Average Evaluation Questions Total Score | Returns the average question summary score. | Double |
| Candidate Facts > Candidate Evaluation Questionnaires | Average Evaluation Skill Rating Value | Returns the average individual skill rating. | Double |
| Candidate Facts > Candidate Evaluation Questionnaires | Average Evaluation Skills Total Percent Score | Returns the average skill summary percent score. | Double |
| Candidate Facts > Candidate Evaluation Questionnaires | Average Evaluation Skills Total Score | Returns the average skill summary score. | Double |
| Candidate Facts > Candidate Source Types | # Submissions From Agency | Returns the number of submissions where the source type is Agency | Int |
| Candidate Facts > Candidate Source Types | # Submissions From Billboards | Returns the number of submissions where the source type is Billboards | Int |
| Candidate Facts > Candidate Source Types | # Submissions From Broadcast | Returns the number of submissions where the source type is Broadcast | Int |
| Candidate Facts > Candidate Source Types | # Submissions From Career Fair | Returns the number of submissions where the source type is Career Fair | Int |
| Candidate Facts > Candidate Source Types | # Submissions From Direct Mail | Returns the number of submissions where the source type is Direct Mail | Int |
| Candidate Facts > Candidate Source Types | # Submissions From Direct Sourcing | Returns the number of submissions where the source type is Direct Sourcing | Int |
| Candidate Facts > Candidate Source Types | # Submissions From Job Board | Returns the number of submissions where the source type is Job Board | Int |
| Candidate Facts > Candidate Source Types | # Submissions From Magazines and Trade Publications | Returns the number of submissions where the source type is Magazines and Trade Publications | Int |
| Candidate Facts > Candidate Source Types | # Submissions From Mailing List | Returns the number of submissions where the source type is Mailing List | Int |
| Candidate Facts > Candidate Source Types | # Submissions From News Group | Returns the number of submissions where the source type is News Group | Int |
| Candidate Facts > Candidate Source Types | # Submissions From Newspapers | Returns the number of submissions where the source type is Newspapers | Int |
| Candidate Facts > Candidate Source Types | # Submissions From Other | Returns the number of submissions where the source type is Other | Int |
| Candidate Facts > Candidate Source Types | # Submissions From Our Web Site | Returns the number of submissions where the source type is Our Web Site | Int |
| Candidate Facts > Candidate Source Types | # Submissions From Professional Associations | Returns the number of submissions where the source type is Professional Associations | Int |
| Candidate Facts > Candidate Source Types | # Submissions From Referral | Returns the number of submissions where the source type is Referral | Int |
| Candidate Facts > Candidate Source Types | # Submissions From Social Network | Returns the number of submissions where the source type is Social Network | Int |
| Candidate Facts > Candidate Source Types | # Submissions From Talent Exchange | Returns the number of submissions where the source type is Talent Exchange | Int |
| Candidate Facts > Candidate Source Types | # Submissions From Taleo Performance | Returns the number of submissions where the source type is Taleo Performance | Int |
| Candidate Facts > Candidate Source Types | # Submissions From University Recruiting | Returns the number of submissions where the source type is University Recruiting | Int |
| Candidate Facts > Candidate Source Types | # Submissions From Unsolicited | Returns the number of submissions where the source type is Unsolicited | Int |
| Candidate Facts > Profile Transitions Process Counts | # Profile Transitions Processes | Returns the number of profile transitions processes. | Int |
| Candidate Facts > Profile Transitions Process Counts | # Profile Transitions Processes Completed | Returns the number of profile transitions process with a completed status. | Int |
| Candidate Facts > Profile Transitions Process Counts | # Profile Transitions Processes Health Status Red | Returns the number of profile transitions processes where a step or task is overdue. | Int |
| Candidate Facts > Profile Transitions Process Counts | # Profile Transitions Steps | Returns the number of steps that are associated with a profile transitions process. | Int |
| Candidate Facts > Profile Transitions Process Counts | # Profile Transitions Steps Overdue | Returns the number of steps, that are associated with a profile transitions process, that are overdue. | Int |
| Candidate Facts > Profile Transitions Process Counts | # Profile Transitions Tasks | Returns the number of tasks that are associated with a profile transitions process. | Int |
| Candidate Facts > Profile Transitions Process Counts | # Profile Transitions Tasks Overdue | Returns the number of tasks, that are associated with a profile transitions process, that are overdue. | Int |
| Candidate Facts > Profile Transitions Process Time | Average Profile Transitions Process Days In Progress | If the transitions process is in progress, the average time in days between the profile transitions process start date and the current date is returned. | Double |
| Candidate Facts > Profile Transitions Process Time | Average Profile Transitions Process Days To Complete | If the transitions process is complete, the average time in days between the profile transitions process start date and the profile transitions latest status change date | Double |
| Candidate Facts > Profile Transitions Process Time | Average Profile Transitions Step Days In Progress | If the profile transitions step is in progress, the average time in days between the profile transitions step start date and the current date is returned. | Double |
| Candidate Facts > Profile Transitions Process Time | Average Profile Transitions Step Days To Complete | If the profile transitions step is complete, the average time in days between the profile transitions step start date and the profile transitions step latest status change date is returned. | Double |
| Candidate Facts > Profile Transitions Process Time | Average Profile Transitions Step Overdue Days | If the profile transitions step is in progress, the average time in days between the profile transitions step due date and the current date is returned. | Double |
| Candidate Facts > Profile Transitions Process Time | Average Profile Transitions Task Days Since Creation | If the profile transitions task is in progress, the average time in days between the profile transitions task creation date and the current date. | Double |
| Candidate Facts > Profile Transitions Process Time | Average Profile Transitions Task Overdue Days | If the profile transitions task is in progress and the task is overdue, the average time in days between the profile transitions task due date and the current date. | Double |
| Candidate Facts > Submission Aging | Average Time Since Last CSW Status Change | Returns the time (in days) between now and the most recent candidate selection workflow status change. | Double |
| Candidate Facts > Submission Aging | Average Time Since Submission Completion | Returns the time (in days) between now and the candidate submission completion date. | Double |
| Candidate Facts > Submission Aging | Time On Hold Since Last CSW Status Change | Returns the average time (in days) between now and the most recent candidate selection workflow status change. | Double |
| Candidate Facts > Submission Aging | Time On Hold Since Submission Completion | Returns average the time (in days) between now and the candidate submission completion date. | Double |
| Candidate Facts > Submission Aging | Time Since Last CSW Status Change | Returns the time (in days) spent on hold between now and the most recent candidate selection workflow status change. | Double |
| Candidate Facts > Submission Aging | Time Since Submission Completion | Returns the time (in days) the requisition spent on hold between now and the candidate submission completion date. | Int |
| Candidate Facts > Submission Transitions Process Counts | # Submission Transitions Processes | Returns the number of submission transitions processes. | Int |
| Candidate Facts > Submission Transitions Process Counts | # Submission Transitions Processes Completed | Returns the number of submission transitions process with a completed status. | Int |
| Candidate Facts > Submission Transitions Process Counts | # Submission Transitions Processes Health Status Red | Returns the number of submission transitions process where a step or task is overdue. | Int |
| Candidate Facts > Submission Transitions Process Counts | # Submission Transitions Steps | Returns the number of steps that are associated with a submission transitions process. | Int |
| Candidate Facts > Submission Transitions Process Counts | # Submission Transitions Steps Overdue | Returns the number of steps, that are associated with a submission transitions process, that are overdue. | Int |
| Candidate Facts > Submission Transitions Process Counts | # Submission Transitions Tasks | Returns the number of tasks that are associated with a submission transitions process. | Int |
| Candidate Facts > Submission Transitions Process Counts | # Submission Transitions Tasks Overdue | Returns the number of tasks, that are associated with a submission transitions process, that are overdue. | Int |
| Candidate Facts > Submission Transitions Process Time | Average Submission Transitions Process Days In Progress | If the submission transitions process is in progress, the average time in days between the submission transitions process start date and the current date is returned. | Double |
| Candidate Facts > Submission Transitions Process Time | Average Submission Transitions Process Days To Complete | If the transitions process is complete, the average time in days between the submission transitions process start date and the submission transitions latest status change date | Double |
| Candidate Facts > Submission Transitions Process Time | Average Submission Transitions Step Days In Progress | If the submission transitions step is in progress, the average time in days between the submission transitions step start date and the current date is returned. | Double |
| Candidate Facts > Submission Transitions Process Time | Average Submission Transitions Step Days To Complete | If the submission transitions step is complete, the average time in days between the submission transitions step start date and the submission transitions step latest status change date is returned. | Double |
| Candidate Facts > Submission Transitions Process Time | Average Submission Transitions Step Overdue Days | If the submission transitions step is in progress, the average time in days between the submission transitions step due date and the current date is returned. | Double |
| Candidate Facts > Submission Transitions Process Time | Average Submission Transitions Task Days Since Creation | If the submission transitions task is in progress, the average time in days between the submission transitions task creation date and the current date. | Double |
| Candidate Facts > Submission Transitions Process Time | Average Submission Transitions Task Overdue Days | If the submission transitions task is in progress and the task is overdue, the average time in days between the submission transitions task due date and the current date. | Double |
| Felx Fields (UDFs) > Profile Transitions Process Flex Fields | {Transitions Process UDF Label} Code | Returns the code of the transition process flex field (UDF). | Varchar |
| Felx Fields (UDFs) > Profile Transitions Process Flex Fields | {Transitions Process UDF Label} Value | Returns the value of the transition process flex field (UDF). | Varchar |
| Felx Fields (UDFs) > Submission Transitions Process Flex Fields | {Transitions Process UDF Label} Code | Returns the code of the transition process flex field (UDF). | Varchar |
| Felx Fields (UDFs) > Submission Transitions Process Flex Fields | {Transitions Process UDF Label} Value | Returns the value of the transition process flex field (UDF). | Varchar |
| Felx Fields (UDFs) > Transitions Subject Personal Info Flex Fields | {Transitions Subject Personal Info UDF Label} Code | Returns the code of the transition subject personal info flex field (UDF). | Varchar |
| Felx Fields (UDFs) > Transitions Subject Personal Info Flex Fields | {Transitions Subject Personal Info UDF Label} Value | Returns the value of the transition subject personal info flex field (UDF). | Varchar |
| Flex Fields (UDFs) > Candidate Flex Fields | UDF* | Returns a candidate flex field. The first 100 flex fields assigned in SmartOrg are available for reporting. The name will change dynamically to whatever name the flex field was assigned in SmartOrg. | Varchar |
| Flex Fields (UDFs) > Candidate Flex Fields | UDSCODE* | Returns a candidate flex field code. The first 100 flex fields assigned in SmartOrg are available for reporting. The name will change dynamically to whatever name the flex field was assigned in SmartOrg. | Varchar |
| Flex Fields (UDFs) > Department Flex Fields | UDF* | Returns a department flex field code. The first 100 flex fields assigned in SmartOrg are available for reporting. The name will change dynamically to whatever name the flex field was assigned in SmartOrg. | Varchar |
| Flex Fields (UDFs) > Department Flex Fields | UDSCODE* | Returns a department flex field. The first 100 flex fields assigned in SmartOrg are available for reporting. The name will change dynamically to whatever name the flex field was assigned in SmartOrg. | Varchar |
| Flex Fields (UDFs) > Department-Requisition Flex Fields | UDF* | Returns a department-requisition flex field. The first 100 flex fields assigned in SmartOrg are available for reporting. The name will change dynamically to whatever name the flex field was assigned in SmartOrg. | Varchar |
| Flex Fields (UDFs) > Department-Requisition Flex Fields | UDSCODE* | Returns a department-requisition flex field code. The first 100 flex fields assigned in SmartOrg are available for reporting. The name will change dynamically to whatever name the flex field was assigned in SmartOrg. | Varchar |
| Flex Fields (UDFs) > Profile Experience Flex Fields | UDF* | Returns a profile experience flex field. The first 100 flex fields assigned in SmartOrg are available for reporting. The name will change dynamically to whatever name the flex field was assigned in SmartOrg. | Varchar |
| Flex Fields (UDFs) > Profile Experience Flex Fields | UDSCODE* | Returns a profile experience flex field code. The first 100 flex fields assigned in SmartOrg are available for reporting. The name will change dynamically to whatever name the flex field was assigned in SmartOrg. | Varchar |
| Flex Fields (UDFs) > Requisition Compensation Flex Fields | UDF* | Returns a requisition compensation flex field. The first 100 flex fields assigned in SmartOrg are available for reporting. The name will change dynamically to whatever name the flex field was assigned in SmartOrg. | Varchar |
| Flex Fields (UDFs) > Requisition Compensation Flex Fields | UDSCODE* | Returns a requisition compensation flex field code. The first 100 flex fields assigned in SmartOrg are available for reporting. The name will change dynamically to whatever name the flex field was assigned in SmartOrg. | Varchar |
| Flex Fields (UDFs) > Requisition Flex Fields | UDF* | Returns a requisition flex field. The first 100 flex fields assigned in SmartOrg are available for reporting. The name will change dynamically to whatever name the flex field was assigned in SmartOrg. | Varchar |
| Flex Fields (UDFs) > Requisition Flex Fields | UDSCODE* | Returns a requisition flex field code. The first 100 flex fields assigned in SmartOrg are available for reporting. The name will change dynamically to whatever name the flex field was assigned in SmartOrg. | Varchar |
| Flex Fields (UDFs) > Submission Education Flex Fields | UDF* | Returns an education flex field. The first 100 flex fields assigned in SmartOrg are available for reporting. The name will change dynamically to whatever name the flex field was assigned in SmartOrg. | Varchar |
| Flex Fields (UDFs) > Submission Education Flex Fields | UDSCODE* | Returns an education flex field code. The first 100 flex fields assigned in SmartOrg are available for reporting. The name will change dynamically to whatever name the flex field was assigned in SmartOrg. | Varchar |
| Flex Fields (UDFs) > Submission Experience Flex Fields | UDF* | Returns a submission experience flex field. The first 100 flex fields assigned in SmartOrg are available for reporting. The name will change dynamically to whatever name the flex field was assigned in SmartOrg. | Varchar |
| Flex Fields (UDFs) > Submission Experience Flex Fields | UDSCODE* | Returns a submission experience flex field. The first 100 flex fields assigned in SmartOrg are available for reporting. The name will change dynamically to whatever name the flex field was assigned in SmartOrg. | Varchar |
| Flex Fields (UDFs) > Submission Job Offer Flex Fields | UDF* | Returns a submission job offer flex field code. The first 100 flex fields assigned in SmartOrg are available for reporting. The name will change dynamically to whatever name the flex field was assigned in SmartOrg. | Varchar |
| Flex Fields (UDFs) > Submission Job Offer Flex Fields | UDSCODE* | Returns a submission job offer flex field. The first 100 flex fields assigned in SmartOrg are available for reporting. The name will change dynamically to whatever name the flex field was assigned in SmartOrg. | Varchar |
| Job Submission > Submission Certifications | Submission Certification Display Sequence | Returns the certification display sequence | Int |
| Job Submission > Submission Certifications | Submission Certification Expiration Date | Returns the certification expiration date | Date |
| Job Submission > Submission Certifications | Submission Certification Issue Date | Returns the certification issue date | Date |
| Job Submission > Submission Certifications | Submission Certification Issuing Organization | Returns the certification issuing organization | Varchar |
| Job Submission > Submission Certifications | Submission Certification Name | Returns the certification name as it was selected from the list. | Varchar |
| Job Submission > Submission Certifications | Submission Certification Name (Other) | Returns the certification name as it was entered in free text | Varchar |
| Job Submission > Submission Certifications | Submission Certification Number/ID | Returns the certification identifier | Varchar |
| Job Submission > Submission CSW Status - Current | Current Reference Status Name | Returns the current reference status name | Varchar |
| Job Submission > Submission CSW Status - Current | Current Status Name | Returns the current CSW status name | Varchar |
| Job Submission > Submission CSW Status - Current | Current Status Start Date | Returns the date when the candidate was moved to the current status. | Timestamp |
| Job Submission > Submission CSW Status - Current | Current Step Name | Returns the current CSW step name | Varchar |
| Job Submission > Submission CSW Status - Current | Current Workflow Name | Returns the name of the candidate selection workflow used for this job submission. | Varchar |
| Job Submission > Submission CSW Status - Historical | Historical Reference Status Name | Returns the unique identifier of the event | Varchar |
| Job Submission > Submission CSW Status - Historical | Historical Status Change History ID | Returns the step move or status change date. This is the date/time assigned by the user. | Double |
| Job Submission > Submission CSW Status - Historical | Historical Status Event Date | Returns the motives associated with the transaction | Timestamp |
| Job Submission > Submission CSW Status - Historical | Historical Status Motives | Returns the historical CSW status name | Varchar |
| Job Submission > Submission CSW Status - Historical | Historical Status Name | Returns the sequence of the status in its step | Varchar |
| Job Submission > Submission CSW Status - Historical | Historical Status Sequence | Returns the historical CSW step name | Double |
| Job Submission > Submission CSW Status - Historical | Historical Step Name | Returns the sequence of the step in its workflow | Varchar |
| Job Submission > Submission CSW Status - Historical | Historical Step Sequence | Returns who changed the candidate to this status | Double |
| Job Submission > Submission CSW Status - Historical | Historical Step/Status Changed By User | Returns the historical reference status name | Varchar |
| Job Submission > Submission CSW Status - Historical | Historical Step/Status Comments | Returns the comments associated with the csw event. | Varchar |
| Job Submission > Submission CSW Status - Historical | Historical Step/Status Details | Returns the detail text associated with the csw event. | Varchar |
| Job Submission > Submission CSW Status - Historical | Historical Step/Status Duration | Returns how long the candidate was in this status | Double |
| Job Submission > Submission CSW Status - Historical | Historical Step/Status Is Latest Offer | Returns whether or not the offer step/status events are associated with the job submission's most recent (max) offer sequence. | Char |
| Job Submission > Submission CSW Status - Historical | Historical Step/Status Offer ID | Returns the offer id associated with the historical event. | Double |
| Job Submission > Submission CSW Status - Historical | Historical Step/Status Was Reverted | Returns whether or not the step or status was reverted. | Char |
| Job Submission > Submission CSW Status - Historical | Historical Workflow Name | Returns the name of the candidate selection workflow used for this job submission. | Varchar |
| Job Submission > Submission CSW Status - Historical | Is CSW Status Change | Returns whether or not the CSW event is a status change. | Char |
| Job Submission > Submission CSW Status - Historical | Is CSW Step Move | Returns whether or not the CSW event is a step move. | Char |
| Job Submission > Submission CSW Status - Historical | Submission Historical Status End Date | Returns the date/time when the status ended | Timestamp |
| Job Submission > Submission CSW Status - Historical | Submission Historical Status Start Date | Returns the step move or status change date. This is the date/time when the change occurs in the system. | Timestamp |
| Job Submission > Submission Dates | 1st Interviewed Date | Returns the most recent date/time when the candidate was moved to the 1st Interview reference status. | Timestamp |
| Job Submission > Submission Dates | 2nd Interviewed Date | Returns the most recent date/time when the candidate was moved to the 2nd Interview reference status. | Timestamp |
| Job Submission > Submission Dates | 3rd Interviewed Date | Returns the most recent date/time when the candidate was moved to the 3rd Interview reference status. | Timestamp |
| Job Submission > Submission Dates | Declined Date | Returns the most recent date/time when the candidate was moved to the Declined reference status. | Timestamp |
| Job Submission > Submission Dates | Expiration Date | Returns the date when the job submission is set to expire | Timestamp |
| Job Submission > Submission Dates | Hire Start Date | Returns the hire start date/time as entered when the candidate is moved to the Hired reference status | Timestamp |
| Job Submission > Submission Dates | Hired Date | Returns the most recent date/time when the candidate was moved to the Hired reference status. | Timestamp |
| Job Submission > Submission Dates | Most Recent Submission Date | Returns the date/time when the most recent candidate submission was created | Timestamp |
| Job Submission > Submission Dates | Offer Accepted Date | Returns the date/time when the candidate accepted the job offer | Timestamp |
| Job Submission > Submission Dates | Offer Actual Start Date | Returns the hire start date as entered in the candidate job offer section | Timestamp |
| Job Submission > Submission Dates | Offer Decision Date | Returns the date/time when the candidate either accepted or refused the job offer | Datetime |
| Job Submission > Submission Dates | Offer Extended Date | Returns the date/time when the candidate was extended the job offer | Timestamp |
| Job Submission > Submission Dates | Offer Refused Date | Returns the date/time when the candidate refused the job offer | Timestamp |
| Job Submission > Submission Dates | Offer Target Start Date | Returns the target start date as entered in the candidate job offer section | Datetime |
| Job Submission > Submission Dates | Offered Date | Returns the most recent date/time when the candidate was moved to the Offer reference status. | Timestamp |
| Job Submission > Submission Dates | Rejected Date | Returns the most recent date/time when the candidate was moved to the Rejected reference status. | Timestamp |
| Job Submission > Submission Dates | Reviewed Date | Returns the most recent date/time when the candidate was moved to the Review reference status. | Timestamp |
| Job Submission > Submission Dates | Submission Completed Date | Returns the date/time when the submission was completed | Timestamp |
| Job Submission > Submission Dates | Submission Created Date | Returns the date/time when the submission was created | Timestamp |
| Job Submission > Submission Dates | Submission Reference Date | Returns the referral date. | Datetime |
| Job Submission > Submission Dates | Submission Reference End Date | Returns the referral end date. | Datetime |
| Job Submission > Submission Dates | Tested Date | Returns the most recent date/time when the candidate was moved to the Testing reference status. | Timestamp |
| Job Submission > Submission Education History | Submission Education Degree Type | Returns the educational degree type achieved | Varchar |
| Job Submission > Submission Education History | Submission Education Display Sequence | Returns the education display sequence | Int |
| Job Submission > Submission Education History | Submission Education GPA | Returns the job application education GPA | Double |
| Job Submission > Submission Education History | Submission Education GPA (Out Of) | Returns the job application education GPA range | Double |
| Job Submission > Submission Education History | Submission Education Graduation Date | Returns the educational program graduation date | Datetime |
| Job Submission > Submission Education History | Submission Education Graduation Date Is Projected | Returns whether or not the education program graduation date is projected | Char |
| Job Submission > Submission Education History | Submission Education Institution Country | Returns the country of the educational institution | Varchar |
| Job Submission > Submission Education History | Submission Education Institution Name | Returns the educational institution as it was selected from the list. | Varchar |
| Job Submission > Submission Education History | Submission Education Institution Name (Other) | Returns the educational institution as it was entered in free text. | Varchar |
| Job Submission > Submission Education History | Submission Education Institution State/Province | Returns the state/province of the educational institution | Varchar |
| Job Submission > Submission Education History | Submission Education Is Most Recent Based On Graduation Date | Filters so that only the most recent education is shown, based on the graduation date. | Char |
| Job Submission > Submission Education History | Submission Education Program Name | Returns the educational program as it was selected from the list. | Varchar |
| Job Submission > Submission Education History | Submission Education Program Name (Other) | Returns the educational program as it was entered in free text. | Varchar |
| Job Submission > Submission Education History | Submission Education Start Date | Returns the educational program start date | Datetime |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Answer Comments | Returns the comments added to the answer. | Varchar |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Answer Description (BL) | Returns the answer description when the answer is selected on a single or multiple select question. | Varchar |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Answer Text/Date | Returns the answer when the question type is either text or date. | Varchar |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Answer Total Score | Returns the best possible weight achievable on the question divided by the total weight rated for the candidate. | Double |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Answer Total Weight | Returns the aggregated candidate weight on a per question basis, mostly relevant when the question is multiple choice. | Double |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Answer Weight | Returns the weight associated with the candidate answer. | Double |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Current Status | Returns the current status of the evaluation. | Varchar |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Days Since Last Modified Date | Returns the days between the request last modified date and the report refresh date. | Double |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Desired Skill Score | Returns the desired skill score for the questionnaire. | Double |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Evaluator Email | Returns the evaluator email. | Varchar |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Evaluator Name | Returns the evaluator name. | Varchar |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Event Type Code | Returns the event type (interview or feedback) | Varchar |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Expiry Date | Returns the expiration date of the evaluation. | Timestamp |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Interview Location Notes (BL) | Returns the interview location notes in the base locale. | Varchar |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Interview Name (BL) | Returns the interview name in the base locale. | Varchar |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Interview Participant Notes (BL) | Returns the interview participant notes in the base locale. | Varchar |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Interview Resource Email | Returns the interview resource email. | Varchar |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Interview Resource Name | Returns the interview resource name. | Varchar |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Interview Resource Type Name | Returns the interview resource type name. | Varchar |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Interview Short Name (BL) | Returns the interview short name in the base locale. | Varchar |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Interview Start Date | Returns the interview date of the evaluation. | Timestamp |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Interview Status | Returns the current interview status. | Varchar |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Max Possible Question Score | Returns the max possible question score for the questionnaire. | Double |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Max Possible Skill Score | Returns the max possible skill score for the questionnaire. | Double |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Question Category (BL) | Returns the question category. | Varchar |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Question Description (BL) | Returns the question description. | Varchar |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Question Display Sequence | Returns the question display sequence. | Double |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Question Display Type | Returns the question display type. | Varchar |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Question Max Weight | Returns the best possible weight the candidate can achieve on the question. If the question is multiple choice, all answer weights are added. If the question is single choice, the max weight is used. | Double |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Question Short Name (BL) | Returns the question short name. | Varchar |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Questionnaire Category (BL) | Returns the evaulation questionnaire category. | Varchar |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Questionnaire Name (BL) | Returns the evaluation questionnaire name. | Varchar |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Questionnaire Short Name (BL) | Returns the evaluation questionnaire short name. | Varchar |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Questions Total Percent Score | Returns the questions total earned percent score. | Double |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Questions Total Score | Returns the questions total earned score. | Double |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Recommendation Text | Returns the recommendation text associated with the evaluation. | Varchar |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Request Created By Email | Returns the email of the user who created the request. | Varchar |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Request Created By Name | Returns the name of the user who created the request. | Varchar |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Request Created Date | Returns the request creation date. | Timestamp |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Request ID | Returns the evaluation request database identifier. | Double |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Request Modified By Email | Returns the email of the user who last modified the request. | Varchar |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Request Modified By Name | Returns the name of the user who last modified the request. | Varchar |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Request Modified Date | Returns the request last modification date. | Timestamp |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Skill Category (BL) | Returns the skill category. | Varchar |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Skill Desired Rating Value | Returns the skill desired rating value. | Double |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Skill Display Sequence | Returns the skill display sequence. | Double |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Skill Name (BL) | Returns the skill name. | Varchar |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Skill Rating Name (BL) | Returns the selected skill rating name. | Varchar |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Skill Rating Scale Value | Returns the skill max possible rating, based on the questionnaire scale. | Double |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Skill Rating Short Name (BL) | Returns the selected skill rating short name. | Varchar |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Skill Rating Value | Returns the selected skill rating value. | Double |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Skill Short Name (BL) | Returns the skill short name. | Varchar |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Skills Total Percent Score | Returns the skills total earned percent score. | Double |
| Job Submission > Submission Evaluation Questionnaires | Submission Evaluation Skills Total Score | Returns the skills total earned score. | Double |
| Job Submission > Submission General Info | Career Site Application Flow Name (BL) | Returns the name of the submission flow of the career site at the time the candidate applied, in its base locale. | Varchar |
| Job Submission > Submission General Info | Career Site Last Page Reached Name (BL) | Returns the name of the last submission flow page reached at the time the candidate applied, in its base locale. | Varchar |
| Job Submission > Submission General Info | Career Site Last Page Reached Sequence | Returns the sequence of the last submission flow page reached at the time the candidate applied. | Int |
| Job Submission > Submission General Info | Career Site Name (BL) | Returns the job application career site at the time the candidate applied, in its base locale. | Varchar |
| Job Submission > Submission General Info | Consented To Background Check | Returns whether or not the candidate consented to the background check | Char |
| Job Submission > Submission General Info | Disqualification Results | Returns whether or not the candidate passed the disqualification questions | Varchar |
| Job Submission > Submission General Info | Disqualification Results Date | Returns the date when the disqualification results were determined | Timestamp |
| Job Submission > Submission General Info | Is Deleted | Returns whether or not the job submission is deleted | Char |
| Job Submission > Submission General Info | Matched From - Requisition Number | Returns the requisition identifier corresponding the requisition the candidate was matched from | Varchar |
| Job Submission > Submission General Info | Recruiter Score | Returns the score the recruiter assigned to the candidate | Double |
| Job Submission > Submission General Info | Reject/Decline Motives | Returns the candidate rejection/declination motives | Varchar |
| Job Submission > Submission General Info | Reject/Decline Motives (Auto) | Returns the candidate rejection/declination motives when they are automatically generated by the system | Varchar |
| Job Submission > Submission General Info | Self-Withdrew From Career Site | Returns whether or not the candidate self-withdrew from the career site. | Char |
| Job Submission > Submission General Info | Submission Identifier | Returns the submission unique identifier | Double |
| Job Submission > Submission General Info | Submission Is Completed | Returns whether or not the submission is complete | Char |
| Job Submission > Submission General Info | Submission Is Internal | Returns whether or not the candidate was internal as of when he/she created the submission | Char |
| Job Submission > Submission General Info | Submission Locale | Returns the locale of the submission | Varchar |
| Job Submission > Submission General Info | Submission Medium | Returns the submission medium | Varchar |
| Job Submission > Submission General Info | Submission Originator | Returns the submission's originator type i.e. "Agent", "Candidate", "Recruiter", "Referrer" | Varchar |
| Job Submission > Submission Job Offer | Days Per Week | Returns the days per week | Double |
| Job Submission > Submission Job Offer | Hours Per Day | Returns the hours per day | Double |
| Job Submission > Submission Job Offer | Is Most Recent | Returns whether or not the job offer is the most recent on the job application record. | Varchar |
| Job Submission > Submission Job Offer | Refused Offer Comments | Returns the comments associated with the job offer refusal | Varchar |
| Job Submission > Submission Job Offer | Relocation | Returns the relocation amount | Double |
| Job Submission > Submission Job Offer | Salary (Annual) | Returns the annual salary | Double |
| Job Submission > Submission Job Offer | Salary (By Pay Basis) | Returns the salary by pay basis | Double |
| Job Submission > Submission Job Offer | Sequence | Returns the sequence of the job offer | Int |
| Job Submission > Submission Job Offer | Sign-On Bonus | Returns the sign-on bonus | Double |
| Job Submission > Submission Job Offer | Status | Returns the status of the job offer | Varchar |
| Job Submission > Submission Job Offer | Submission Job Offer Currency | Returns the offer currency | Varchar |
| Job Submission > Submission Job Offer | Submission Job Offer Pay Basis | Returns the pay basis | Varchar |
| Job Submission > Submission Passport | Submission Passport Input Parameter - Code 1 | Returns the code of the passport service request's input parameter | Varchar |
| Job Submission > Submission Passport | Submission Passport Input Parameter - Code 10 | Returns the code of the passport service request's input parameter | Varchar |
| Job Submission > Submission Passport | Submission Passport Input Parameter - Code 2 | Returns the code of the passport service request's input parameter | Varchar |
| Job Submission > Submission Passport | Submission Passport Input Parameter - Code 3 | Returns the code of the passport service request's input parameter | Varchar |
| Job Submission > Submission Passport | Submission Passport Input Parameter - Code 4 | Returns the code of the passport service request's input parameter | Varchar |
| Job Submission > Submission Passport | Submission Passport Input Parameter - Code 5 | Returns the code of the passport service request's input parameter | Varchar |
| Job Submission > Submission Passport | Submission Passport Input Parameter - Code 6 | Returns the code of the passport service request's input parameter | Varchar |
| Job Submission > Submission Passport | Submission Passport Input Parameter - Code 7 | Returns the code of the passport service request's input parameter | Varchar |
| Job Submission > Submission Passport | Submission Passport Input Parameter - Code 8 | Returns the code of the passport service request's input parameter | Varchar |
| Job Submission > Submission Passport | Submission Passport Input Parameter - Code 9 | Returns the code of the passport service request's input parameter | Varchar |
| Job Submission > Submission Passport | Submission Passport Input Parameter - Value 1 | Returns the value of the passport service request's input parameter | Varchar |
| Job Submission > Submission Passport | Submission Passport Input Parameter - Value 10 | Returns the value of the passport service request's input parameter | Varchar |
| Job Submission > Submission Passport | Submission Passport Input Parameter - Value 2 | Returns the value of the passport service request's input parameter | Varchar |
| Job Submission > Submission Passport | Submission Passport Input Parameter - Value 3 | Returns the value of the passport service request's input parameter | Varchar |
| Job Submission > Submission Passport | Submission Passport Input Parameter - Value 4 | Returns the value of the passport service request's input parameter | Varchar |
| Job Submission > Submission Passport | Submission Passport Input Parameter - Value 5 | Returns the value of the passport service request's input parameter | Varchar |
| Job Submission > Submission Passport | Submission Passport Input Parameter - Value 6 | Returns the value of the passport service request's input parameter | Varchar |
| Job Submission > Submission Passport | Submission Passport Input Parameter - Value 7 | Returns the value of the passport service request's input parameter | Varchar |
| Job Submission > Submission Passport | Submission Passport Input Parameter - Value 8 | Returns the value of the passport service request's input parameter | Varchar |
| Job Submission > Submission Passport | Submission Passport Input Parameter - Value 9 | Returns the value of the passport service request's input parameter | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Code 1 | Returns the code of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Code 10 | Returns the code of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Code 11 | Returns the code of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Code 12 | Returns the code of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Code 13 | Returns the code of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Code 14 | Returns the code of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Code 15 | Returns the code of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Code 16 | Returns the code of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Code 17 | Returns the code of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Code 18 | Returns the code of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Code 19 | Returns the code of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Code 2 | Returns the code of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Code 20 | Returns the code of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Code 21 | Returns the code of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Code 22 | Returns the code of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Code 23 | Returns the code of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Code 24 | Returns the code of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Code 25 | Returns the code of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Code 26 | Returns the code of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Code 27 | Returns the code of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Code 28 | Returns the code of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Code 29 | Returns the code of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Code 3 | Returns the code of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Code 30 | Returns the code of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Code 4 | Returns the code of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Code 5 | Returns the code of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Code 6 | Returns the code of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Code 7 | Returns the code of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Code 8 | Returns the code of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Code 9 | Returns the code of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Value 1 | Returns the value of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Value 10 | Returns the value of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Value 11 | Returns the value of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Value 12 | Returns the value of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Value 13 | Returns the value of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Value 14 | Returns the value of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Value 15 | Returns the value of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Value 16 | Returns the value of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Value 17 | Returns the value of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Value 18 | Returns the value of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Value 19 | Returns the value of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Value 2 | Returns the value of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Value 20 | Returns the value of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Value 21 | Returns the value of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Value 22 | Returns the value of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Value 23 | Returns the value of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Value 24 | Returns the value of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Value 25 | Returns the value of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Value 26 | Returns the value of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Value 27 | Returns the value of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Value 28 | Returns the value of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Value 29 | Returns the value of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Value 3 | Returns the value of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Value 30 | Returns the value of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Value 4 | Returns the value of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Value 5 | Returns the value of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Value 6 | Returns the value of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Value 7 | Returns the value of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Value 8 | Returns the value of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Passport Result - Value 9 | Returns the value of the passport service results | Varchar |
| Job Submission > Submission Passport | Submission Request Is Most Recent Request Per Provider/Alias | Filters so that only the most recent passport service request is displayed. This is calculated for each provider+alias combination. | Char |
| Job Submission > Submission Passport | Submission Service Alias | Returns the passport service alias | Varchar |
| Job Submission > Submission Passport | Submission Service External Reference Number | Returns the passport service request's external reference number | Varchar |
| Job Submission > Submission Passport | Submission Service Internal Reference Number | Returns the passport service request's internal reference number | Double |
| Job Submission > Submission Passport | Submission Service Name | Returns the passport service name | Varchar |
| Job Submission > Submission Passport | Submission Service Provider | Returns the passport service provider | Varchar |
| Job Submission > Submission Passport | Submission Service Request Date | Returns the date/time when the passport service was requested | Timestamp |
| Job Submission > Submission Passport | Submission Service Request Status | Returns the current status of the passport service request | Varchar |
| Job Submission > Submission Passport | Submission Service Requester | Returns the requester of the passport service | Varchar |
| Job Submission > Submission Passport | Submission Service Status Log Date | Returns the date/time the passport service request was changed to its current status | Timestamp |
| Job Submission > Submission Passport | Submission Service Type | Returns the passport service type | Varchar |
| Job Submission > Submission Prescreening Results | Is Ace | Returns yes or no value based on whether the submission was Ace. | Char |
| Job Submission > Submission Prescreening Results | Minimum Requirements Met | Returns yes or no value based on wheather the submission met minimum requirements. | Char |
| Job Submission > Submission Prescreening Results | Prescreening Score | Returns the prescreening score from the submission. | Int |
| Job Submission > Submission Referral | Submission Current Referral Status | Returns the current status of the referral | Varchar |
| Job Submission > Submission Referral | Submission Is Currently Referred | Returns whether or not the candidate is currently bound to an active referral. | Char |
| Job Submission > Submission Referral | Submission Is Currently Referred By Agent | Returns whether or not the candidate is currently bound to an active agent referral. | Char |
| Job Submission > Submission Referral | Submission Referral Is Most Recent | Returns whether or not the referral is the most recent for the job submission. | Char |
| Job Submission > Submission Referral | Submission Referrer Email | Returns the email of the referrer. | Varchar |
| Job Submission > Submission Referral | Submission Referrer Is Employee | Returns whether or not the referrer is an employee. | Char |
| Job Submission > Submission Referral | Submission Referrer Name | Returns the name of the referrer. | Varchar |
| Job Submission > Submission Referral | Submission Referring Agency Name (BL) | Returns the referring agent's agency, in its base locale. | Varchar |
| Job Submission > Submission Referral | Submission Referring Agent Email | Returns the email of the agent. | Varchar |
| Job Submission > Submission Referral | Submission Referring Agent Name | Returns the name of the agent. | Varchar |
| Job Submission > Submission Source | Submission Source (Agent) | Returns the full name of the agent when the source is an agency. | Varchar |
| Job Submission > Submission Source | Submission Source (BL) | Returns the submission source, in its base locale | Varchar |
| Job Submission > Submission Source | Submission Source (ML) | Returns the submission source. Use the element "Source Locale" to filter on the appropriate locale. | Varchar |
| Job Submission > Submission Source | Submission Source Event Identifier | Returns the submission source event identifier | Varchar |
| Job Submission > Submission Source | Submission Source Event Name | Returns the submission source event name | Varchar |
| Job Submission > Submission Source | Submission Source Explanation | Returns the submission source explanation | Varchar |
| Job Submission > Submission Source | Submission Source Identifier | Returns the source identifier as seen in the source configuration page | Varchar |
| Job Submission > Submission Source | Submission Source Is Available | Returns whether or not the source is currently available. | Char |
| Job Submission > Submission Source | Submission Source Locale | Returns the locale of the submission source. | Varchar |
| Job Submission > Submission Source | Submission Source Type | Returns the recruitment source type, based on its default display label. | Varchar |
| Job Submission > Submission Source | Submission Source Type (Display As) | Returns the recruitment source type, as displayed in the recruiting administration application, under the "display as" column. | Varchar |
| Job Submission > Submission Source | Submission Source Was Automatically Entered | Returns whether or not the source was automatically populated into the candidate file | Char |
| Job Submission > Submission Tracking History | Submission History Transaction By User | Returns the user responsible for the transaction | Varchar |
| Job Submission > Submission Tracking History | Submission History Transaction Date | Returns the date associated with the transaction | Timestamp |
| Job Submission > Submission Tracking History | Transaction Comments | Returns the comments associated with the transaction. | Varchar |
| Job Submission > Submission Tracking History | Transaction Details | Returns the detail text associated with the transaction. | Varchar |
| Job Submission > Submission Tracking History | Transaction Event Date | Returns the date that the user specified when completing the transaction | Timestamp |
| Job Submission > Submission Tracking History | Transaction Event Name | Returns the name of the event associated with the transaction | Varchar |
| Job Submission > Submission Tracking History | Transaction Identifier | Returns the identifier of the transaction, as generated automatically from the database | Double |
| Job Submission > Submission Tracking History | Transaction is Most Recent | Returns whether or not the transaction is the most recent for the candidate submission, based on its sequence of entry. | Char |
| Job Submission > Submission Transitions Process | Submission Transitions Next Step Code | Returns the submission transitions next step code | Varchar |
| Job Submission > Submission Transitions Process | Submission Transitions Next Step Name (BL) | Returns the submission transitions next step name in its base locale | Varchar |
| Job Submission > Submission Transitions Process | Submission Transitions Process Code | Returns the submission transitions process code | Varchar |
| Job Submission > Submission Transitions Process | Submission Transitions Process Current Status | Returns the submission transitions process current status | Varchar |
| Job Submission > Submission Transitions Process | Submission Transitions Process Days In Progress | If the submission transitions process is in progress, the time in days between the submission transitions process start date and the current date is returned. | Int |
| Job Submission > Submission Transitions Process | Submission Transitions Process Days To Complete | If the submission transitions process is complete, the time in days between the profile transitions process start date and the profile transitions latest status change date. | Int |
| Job Submission > Submission Transitions Process | Submission Transitions Process End Date | Returns the submission transitions process end date | Timestamp |
| Job Submission > Submission Transitions Process | Submission Transitions Process Is Latest (By Type) | Returns whether or not the submission transitions process is latest (by type) | Char |
| Job Submission > Submission Transitions Process | Submission Transitions Process Is Visible | Returns whether or not the submission transitions process is visible | Char |
| Job Submission > Submission Transitions Process | Submission Transitions Process Latest Status Change Date | Returns the submission transitions process latest status change date | Timestamp |
| Job Submission > Submission Transitions Process | Submission Transitions Process Name (BL) | Returns the process name in its base locale | Varchar |
| Job Submission > Submission Transitions Process | Submission Transitions Process Owner Email | Returns the submission transitions process owner email | Varchar |
| Job Submission > Submission Transitions Process | Submission Transitions Process Owner Full Name | Returns the submission transitions process owner full name | Varchar |
| Job Submission > Submission Transitions Process | Submission Transitions Process Percent Complete | Returns the submission transitions process percent complete | Double |
| Job Submission > Submission Transitions Process | Submission Transitions Process Progression Health Is Red | Returns yes if a step or task in the submission transitions process is overdue. | Char |
| Job Submission > Submission Transitions Process | Submission Transitions Process Start Date | Returns the submission transitions process start date | Timestamp |
| Job Submission > Submission Transitions Process | Submission Transitions Process Supervisor Email | Returns the submission transitions process supervisor email | Varchar |
| Job Submission > Submission Transitions Process | Submission Transitions Process Supervisor Full Name | Returns the submission transitions process supervisor full name | Varchar |
| Job Submission > Submission Transitions Process | Submission Transitions Process Type | Returns the submission transitions process type | Varchar |
| Job Submission > Submission Transitions Process | Submission Transitions Step Code | Returns the submission transitions step code | Varchar |
| Job Submission > Submission Transitions Process | Submission Transitions Step Current Status | Returns the submission transitions step current status | Varchar |
| Job Submission > Submission Transitions Process | Submission Transitions Step Days In Progress | If the submission transitions step is complete, the time in days between the submission transitions step start date and the submission transitions step latest status change date is returned. | Int |
| Job Submission > Submission Transitions Process | Submission Transitions Step Days To Complete | If the submission transitions step is complete, the time in days between the submission transitions step start date and the submission transitions step latest status change date is returned. | Int |
| Job Submission > Submission Transitions Process | Submission Transitions Step Due Date | Returns the submission transitions step due date | Datetime |
| Job Submission > Submission Transitions Process | Submission Transitions Step End Date | Returns the submission transitions step end date | Timestamp |
| Job Submission > Submission Transitions Process | Submission Transitions Step Expected Duration | Returns the submission transitions step expected duration | Double |
| Job Submission > Submission Transitions Process | Submission Transitions Step Is Overdue | Returns the submission transitions step is overdue | Char |
| Job Submission > Submission Transitions Process | Submission Transitions Step Latest Status Change Date | Returns the submission transitions step latest status change date | Timestamp |
| Job Submission > Submission Transitions Process | Submission Transitions Step Name (BL) | Returns the submission transitions step name in its base locale | Varchar |
| Job Submission > Submission Transitions Process | Submission Transitions Step Overdue Days | If the submission transitions step is in progress, the time in days between the submission transitions step due date and the current date is returned. | Int |
| Job Submission > Submission Transitions Process | Submission Transitions Step Start Date | Returns the submission transitions step start date | Timestamp |
| Job Submission > Submission Transitions Process | Submission Transitions Step Sub Process Code | Returns the submission transitions step sub process code | Varchar |
| Job Submission > Submission Transitions Process | Submission Transitions Step Sub Process Name (BL) | Returns the step sub-process name in its base locale | Varchar |
| Job Submission > Submission Transitions Process | Submission Transitions Step Type Code | Returns the submission transitions step type code | Varchar |
| Job Submission > Submission Transitions Process | Submission Transitions Task Action | Returns the submission transitions task action | Varchar |
| Job Submission > Submission Transitions Process | Submission Transitions Task Assignee Department | Returns the submission transitions task assignee department | Varchar |
| Job Submission > Submission Transitions Process | Submission Transitions Task Assignee Email | Returns the submission transitions task assignee email | Varchar |
| Job Submission > Submission Transitions Process | Submission Transitions Task Assignee Name | Returns the submission transitions task assignee name | Varchar |
| Job Submission > Submission Transitions Process | Submission Transitions Task Assignment Date | Returns the submission transitions task assignment date | Datetime |
| Job Submission > Submission Transitions Process | Submission Transitions Task Code | Returns the submission transitions task code | Varchar |
| Job Submission > Submission Transitions Process | Submission Transitions Task Comments | Returns the submission transitions task comments | Varchar |
| Job Submission > Submission Transitions Process | Submission Transitions Task Creation Date | Returns the submission transitions task creation date | Timestamp |
| Job Submission > Submission Transitions Process | Submission Transitions Task Current Status | Returns the submission transitions task current status | Varchar |
| Job Submission > Submission Transitions Process | Submission Transitions Task Days Since Creation | If the submission transitions task is in progress, the time in days between the submission transitions task creation date and the current date. | Int |
| Job Submission > Submission Transitions Process | Submission Transitions Task Due Date | Returns the submission transitions task due date | Timestamp |
| Job Submission > Submission Transitions Process | Submission Transitions Task Is Overdue | Returns whether or not the submission transitions task is overdue | Char |
| Job Submission > Submission Transitions Process | Submission Transitions Task Name (BL) | Returns the name of task in its base locale | Varchar |
| Job Submission > Submission Transitions Process | Submission Transitions Task Overdue Days | If the submission transitions task is in progress and the task is overdue, the time in days between the submission transitions task due date and the current date. | Int |
| Job Submission > Submission Transitions Process | Submission Transitions Task Owner Email | Returns the submission transitions task owner email | Varchar |
| Job Submission > Submission Transitions Process | Submission Transitions Task Owner Name | Returns the submission transitions task owner name | Varchar |
| Job Submission > Submission Transitions Process | Submission Transitions Task Related Source (BL) | Returns the task related source in its base locale | Varchar |
| Job Submission > Submission Transitions Process | Submission Transitions Task Type | Returns the submission transitions task type | Varchar |
| Job Submission > Submission Work Experience History | Submission Experience Display Sequence | Returns the work experience display sequence | Int |
| Job Submission > Submission Work Experience History | Submission Experience Employer Name | Returns the work experience employer as it was selected from the list. | Varchar |
| Job Submission > Submission Work Experience History | Submission Experience Employer Name (Other) | Returns the work experience employer as it was entered in free text. | Varchar |
| Job Submission > Submission Work Experience History | Submission Experience End Date | Returns the work experience end date | Datetime |
| Job Submission > Submission Work Experience History | Submission Experience Is Current Job | Returns whether or not the candidate is currently working for this employer | Char |
| Job Submission > Submission Work Experience History | Submission Experience Is Most Recent Based On Start Date | Filters so that only the most recent experience is shown, based on the work start date. | Char |
| Job Submission > Submission Work Experience History | Submission Experience Job Title | Returns the work experience job title as it was selected from the list. | Varchar |
| Job Submission > Submission Work Experience History | Submission Experience Job Title (Other) | Returns the work experience job title as it was entered in free text. | Varchar |
| Job Submission > Submission Work Experience History | Submission Experience Start Date | Returns the work experience start date | Datetime |
| Requisition Administration > Requisition Admin Other | Additional Information | Returns requisition additional information. | Varchar |
| Requisition Administration > Requisition Admin Other | Citizenship Status | Returns the required citizenship status for the requisition. | Varchar |
| Requisition Administration > Requisition Admin Other | Overtime Status | Returns the overtime status of the requisition. | Varchar |
| Requisition Administration > Requisition Budgeting | Is Employee Referral Enabled | Returns whether or not the requisition is budgeted for employee referrals. | Varchar |
| Requisition Administration > Requisition Budgeting | Is Public Referral Enabled | Returns whether or not the requisition is budgeted for public referrals. | Varchar |
| Requisition Administration > Requisition Compensation | High Quartile Salary | Returns the high quartile salary of the requisition | Double |
| Requisition Administration > Requisition Compensation | Job Grade | Returns the requisition job grade | Varchar |
| Requisition Administration > Requisition Compensation | Low Quartile Salary | Returns the low quartile salary of the requisition | Double |
| Requisition Administration > Requisition Compensation | Maximum Salary | Returns the maximum salary of the requisition | Double |
| Requisition Administration > Requisition Compensation | Midpoint Salary | Returns the midpoint salary of the requisition | Double |
| Requisition Administration > Requisition Compensation | Minimum Salary | Returns the minimum salary of the requisition | Double |
| Requisition Administration > Requisition Compensation | Req. Compensation Currency | Returns the requisition compensation currency | Varchar |
| Requisition Administration > Requisition Compensation | Req. Pay Basis | Returns the pay basis of the requisition | Varchar |
| Requisition Administration > Requisition CSW | Candidate Selection Workflow Name | Returns the candidate selection workflow associated with the requisition. | Varchar |
| Requisition Administration > Requisition Regulations | EE Occupational Group | If the position is offered in Canada, this is the employment equity occupational group associated with the requisition. Note: There can be many EE Groups for each requisition. | Varchar |
| Requisition Administration > Requisition Regulations | EEO Establishment | If the position is offered in the United States, this is the EEO establishment associated with the requisition. | Varchar |
| Requisition Administration > Requisition Regulations | EEO Job Category | Returns the requisition's EEO job category. | Varchar |
| Requisition Administration > Requisition Regulations | EEO Job Group | Returns the requisition's EEO job group. | Varchar |
| Requisition Approval History | Approver 1 Decision | Returns the decision of the approver. | Varchar |
| Requisition Approval History | Approver 1 Decision Date | Returns the date/time when the approver made the decision. | Timestamp |
| Requisition Approval History | Approver 1 Email | Returns the email of the approver. | Varchar |
| Requisition Approval History | Approver 1 Full Name | Returns the name of the approver. | Varchar |
| Requisition Approval History | Approver 1 Sequence | Returns the sequence of the approver. | Double |
| Requisition Approval History | Approver 10 Decision | Returns the decision of the approver. | Varchar |
| Requisition Approval History | Approver 10 Decision Date | Returns the date/time when the approver made the decision. | Timestamp |
| Requisition Approval History | Approver 10 Email | Returns the email of the approver. | Varchar |
| Requisition Approval History | Approver 10 Full Name | Returns the name of the approver. | Varchar |
| Requisition Approval History | Approver 10 Sequence | Returns the sequence of the approver. | Double |
| Requisition Approval History | Approver 11 Decision | Returns the decision of the approver. | Varchar |
| Requisition Approval History | Approver 11 Decision Date | Returns the date/time when the approver made the decision. | Timestamp |
| Requisition Approval History | Approver 11 Email | Returns the email of the approver. | Varchar |
| Requisition Approval History | Approver 11 Full Name | Returns the name of the approver. | Varchar |
| Requisition Approval History | Approver 11 Sequence | Returns the sequence of the approver. | Double |
| Requisition Approval History | Approver 12 Decision | Returns the decision of the approver. | Varchar |
| Requisition Approval History | Approver 12 Decision Date | Returns the date/time when the approver made the decision. | Timestamp |
| Requisition Approval History | Approver 12 Email | Returns the email of the approver. | Varchar |
| Requisition Approval History | Approver 12 Full Name | Returns the name of the approver. | Varchar |
| Requisition Approval History | Approver 12 Sequence | Returns the sequence of the approver. | Double |
| Requisition Approval History | Approver 2 Decision | Returns the decision of the approver. | Varchar |
| Requisition Approval History | Approver 2 Decision Date | Returns the date/time when the approver made the decision. | Timestamp |
| Requisition Approval History | Approver 2 Email | Returns the email of the approver. | Varchar |
| Requisition Approval History | Approver 2 Full Name | Returns the name of the approver. | Varchar |
| Requisition Approval History | Approver 2 Sequence | Returns the sequence of the approver. | Double |
| Requisition Approval History | Approver 3 Decision | Returns the decision of the approver. | Varchar |
| Requisition Approval History | Approver 3 Decision Date | Returns the date/time when the approver made the decision. | Timestamp |
| Requisition Approval History | Approver 3 Email | Returns the email of the approver. | Varchar |
| Requisition Approval History | Approver 3 Full Name | Returns the name of the approver. | Varchar |
| Requisition Approval History | Approver 3 Sequence | Returns the sequence of the approver. | Double |
| Requisition Approval History | Approver 4 Decision | Returns the decision of the approver. | Varchar |
| Requisition Approval History | Approver 4 Decision Date | Returns the date/time when the approver made the decision. | Timestamp |
| Requisition Approval History | Approver 4 Email | Returns the email of the approver. | Varchar |
| Requisition Approval History | Approver 4 Full Name | Returns the name of the approver. | Varchar |
| Requisition Approval History | Approver 4 Sequence | Returns the sequence of the approver. | Double |
| Requisition Approval History | Approver 5 Decision | Returns the decision of the approver. | Varchar |
| Requisition Approval History | Approver 5 Decision Date | Returns the date/time when the approver made the decision. | Timestamp |
| Requisition Approval History | Approver 5 Email | Returns the email of the approver. | Varchar |
| Requisition Approval History | Approver 5 Full Name | Returns the name of the approver. | Varchar |
| Requisition Approval History | Approver 5 Sequence | Returns the sequence of the approver. | Double |
| Requisition Approval History | Approver 6 Decision | Returns the decision of the approver. | Varchar |
| Requisition Approval History | Approver 6 Decision Date | Returns the date/time when the approver made the decision. | Timestamp |
| Requisition Approval History | Approver 6 Email | Returns the email of the approver. | Varchar |
| Requisition Approval History | Approver 6 Full Name | Returns the name of the approver. | Varchar |
| Requisition Approval History | Approver 6 Sequence | Returns the sequence of the approver. | Double |
| Requisition Approval History | Approver 7 Decision | Returns the decision of the approver. | Varchar |
| Requisition Approval History | Approver 7 Decision Date | Returns the date/time when the approver made the decision. | Timestamp |
| Requisition Approval History | Approver 7 Email | Returns the email of the approver. | Varchar |
| Requisition Approval History | Approver 7 Full Name | Returns the name of the approver. | Varchar |
| Requisition Approval History | Approver 7 Sequence | Returns the sequence of the approver. | Double |
| Requisition Approval History | Approver 8 Decision | Returns the decision of the approver. | Varchar |
| Requisition Approval History | Approver 8 Decision Date | Returns the date/time when the approver made the decision. | Timestamp |
| Requisition Approval History | Approver 8 Email | Returns the email of the approver. | Varchar |
| Requisition Approval History | Approver 8 Full Name | Returns the name of the approver. | Varchar |
| Requisition Approval History | Approver 8 Sequence | Returns the sequence of the approver. | Double |
| Requisition Approval History | Approver 9 Decision | Returns the decision of the approver. | Varchar |
| Requisition Approval History | Approver 9 Decision Date | Returns the date/time when the approver made the decision. | Timestamp |
| Requisition Approval History | Approver 9 Email | Returns the email of the approver. | Varchar |
| Requisition Approval History | Approver 9 Full Name | Returns the name of the approver. | Varchar |
| Requisition Approval History | Approver 9 Sequence | Returns the sequence of the approver. | Double |
| Requisition Dates | External Closing Date | Returns the date/time when the requisition closes externally. | Timestamp |
| Requisition Dates | External Opening Date | Returns the date/time when the requisition opens externally. | Timestamp |
| Requisition Dates | First Fully Approved Date | Returns the date/time when the requisition successfully went through the full approval process for the first time. | Timestamp |
| Requisition Dates | First Sourced After Latest Approved Date | Returns the first time the requisition was put into the sourcing status after the most recent time the requisition the requisition was put into the approved status. | Timestamp |
| Requisition Dates | First Sourced Date | Returns the date/time when the requisition was sourced for the first time. | Timestamp |
| Requisition Dates | First To Be Approved Date | Returns the date when the requisition status was changed to "To Be Approved" for the first time. | Timestamp |
| Requisition Dates | Internal Closing Date | Returns the date/time when the requisition closes internally. | Timestamp |
| Requisition Dates | Internal Opening Date | Returns the date/time when the requisition opens internally. | Timestamp |
| Requisition Dates | Last Position Accepted Date | Returns the date/time when the last position was accepted on the requisition. | Timestamp |
| Requisition Dates | Latest Cancelled Date | Returns the date/time when the requisition was most recently cancelled. | Timestamp |
| Requisition Dates | Latest Filled Date | Returns the date/time when the requisition was most recently filled. | Timestamp |
| Requisition Dates | Latest Fully Approved Date | Returns the date/time when the requisition most recently successfully went through the full approval process. | Timestamp |
| Requisition Dates | Latest On Hold Date | Returns the date/time when the requisition was most recently put into the on hold status. | Timestamp |
| Requisition Dates | Latest Reactivation Date | Returns the date/time when the requisition was most recently reactivated from the on hold status. | Timestamp |
| Requisition Dates | Req. Creation Date | Returns the date/time when the requisition was created. | Timestamp |
| Requisition Dates | Req. Last Modified Date | Returns the date/time when the requisition was last modified. | Timestamp |
| Requisition Dates | Target Start Date | Returns the requisition's target start date. | Datetime |
| Requisition Evaluation Questionnaires | Req. Evaluation Questionnaire Category (BL) | Returns the questionnaire category. | Varchar |
| Requisition Evaluation Questionnaires | Req. Evaluation Questionnaire Evaluator Email | Returns the evaluator email. | Varchar |
| Requisition Evaluation Questionnaires | Req. Evaluation Questionnaire Evaluator Name | Returns the evaluator name. | Varchar |
| Requisition Evaluation Questionnaires | Req. Evaluation Questionnaire ID | Returns the questionnaire database identifier. | Double |
| Requisition Evaluation Questionnaires | Req. Evaluation Questionnaire Name (BL) | Returns the questionnaire name. | Varchar |
| Requisition Evaluation Questionnaires | Req. Evaluation Questionnaire Short Name (BL) | Returns the questionnaire short name. | Varchar |
| Requisition Facts > Requisition Aging | Average Time On Hold In Current Hold Period | Returns the time (in days) the requisition has been on hold in its recent on hold cycle. This is only for requisitions currently on hold. | Double |
| Requisition Facts > Requisition Aging | Average Time Since Creation | Returns the time (in days) the requisition spent on hold between now and the requisition creation date. | Double |
| Requisition Facts > Requisition Aging | Average Time Since Creation (Minus TOH) | Returns the time (in days) the requisition spent on hold between now and the first occurrence of the requisition being changed to the approved status. | Double |
| Requisition Facts > Requisition Aging | Average Time Since First Approval | Returns the time (in days) the requisition spent on hold between now and the first occurrence of the requisition being changed to the sourcing status. | Double |
| Requisition Facts > Requisition Aging | Average Time Since First Approval (Minus TOH) | Returns the time (in days) the requisition spent on hold between now and the most recent occurrence of the requisition being changed to the approved status. | Double |
| Requisition Facts > Requisition Aging | Average Time Since First Sourcing | Returns the time (in days) the requisition spent on hold between now and the first occurrence of the requisition being changed to the sourcing status after the most recent occurrence of the requisition being changed to the approved status. | Double |
| Requisition Facts > Requisition Aging | Average Time Since First Sourcing (Minus TOH) | Returns the time (in days) between now and the requisition creation date. | Double |
| Requisition Facts > Requisition Aging | Average Time Since Most Recent Approval | Returns the time (in days) between now and the first occurrence of the requisition being changed to the approved status. | Double |
| Requisition Facts > Requisition Aging | Average Time Since Most Recent Approval (Minus TOH) | Returns the time (in days) between now and the first occurrence of the requisition being changed to the sourcing status. | Double |
| Requisition Facts > Requisition Aging | Average Time Since Most Recent Initial Sourcing (Minus TOH) | Returns the time (in days) between now and the most recent occurrence of the requisition being changed to the approved status. | Double |
| Requisition Facts > Requisition Aging | Average Time Since Most Recent Reactivation | Returns the time (in days) between now and the first occurrence of the requisition being changed to the sourcing status after the most recent occurrence of the requisition being changed to the approved status. | Double |
| Requisition Facts > Requisition Aging | AverageTime Since Most Recent Initial Sourcing | Returns the time (in days) between now and the most recent occurrence of the requisition being reactivated from the on hold status. | Double |
| Requisition Facts > Requisition Aging | Time Closed Since Creation | Returns the average time (in days) the requisition has been on hold in its recent on hold cycle. This is only for requisitions currently on hold. | Double |
| Requisition Facts > Requisition Aging | Time Closed Since First Approval | Returns the average time (in days) between now and the requisition creation date. | Double |
| Requisition Facts > Requisition Aging | Time Closed Since First Sourcing | Returns the average time (in days) between now and the requisition creation date, minus the time the requisition spent on hold between those two dates. | Double |
| Requisition Facts > Requisition Aging | Time Left Until Target Start Date | Returns the average time (in days) between now and the first occurrence of the requisition being changed to the approved status. | Double |
| Requisition Facts > Requisition Aging | Time On Hold In Current Hold Period | Returns the average time (in days) between now and the first occurrence of the requisition being changed to the approved status, minus the time on hold the requisition spent between the two dates. | Double |
| Requisition Facts > Requisition Aging | Time On Hold Since Creation | Returns the average time (in days) between now and the first occurrence of the requisition being changed to the sourcing status. | Double |
| Requisition Facts > Requisition Aging | Time On Hold Since First Approval | Returns the average time (in days) between now and the first occurrence of the requisition being changed to the sourcing status, minus the time on hold the requisition spent between the two dates. | Double |
| Requisition Facts > Requisition Aging | Time On Hold Since First Sourcing | Returns the average time (in days) between now and the most recent occurrence of the requisition being changed to the approved status. | Double |
| Requisition Facts > Requisition Aging | Time On Hold Since Most Recent Approval | Returns the average time (in days) between now and the most recent occurrence of the requisition being changed to the approved status, minus the time on hold the requisition spent between the two dates. | Double |
| Requisition Facts > Requisition Aging | Time On Hold Since Most Recent Initial Sourcing | Returns the average time (in days) between now and the first occurrence of the requisition being changed to the sourcing status after the most recent occurrence of the requisition being changed to the approved status, minus time spent on hold between both dates. | Double |
| Requisition Facts > Requisition Aging | Time Since Creation | Returns the average time (in days) between now and the most recent occurrence of the requisition being reactivated from the on hold status. | Int |
| Requisition Facts > Requisition Aging | Time Since First Approval | Returns the average time (in days) between now and the first occurrence of the requisition being changed to the sourcing status after the most recent occurrence of the requisition being changed to the approved status. | Int |
| Requisition Facts > Requisition Aging | Time Since First Sourcing | Returns the time (in days) the requisition spent closed between now and the requisition creation date. | Int |
| Requisition Facts > Requisition Aging | Time Since Most Recent Approval | Returns the time (in days) the requisition spent closed between now and the first occurrence of the requisition being changed to the approved status. | Int |
| Requisition Facts > Requisition Aging | Time Since Most Recent Initial Sourcing | Returns the time (in days) the requisition spent closed between now and the first occurrence of the requisition being changed to the sourcing status. | Int |
| Requisition Facts > Requisition Aging | Time Since Most Recent Reactivation | Returns the time (in days) between now and the requisition target start date | Int |
| Requisition Facts > Requisition Counts | # Openings | Returns the number of openings on the requisition(s). | Int |
| Requisition Facts > Requisition Counts | # Openings Left To Fill (Accepted) | Returns the number of positions left to fill on the requisition, based on the number of openings minus the number of candidates with a current standard offer status of Accepted where the candidate does not have a reference status of Declined or Rejected | Int |
| Requisition Facts > Requisition Counts | # Openings Left To Fill (Hired) | Returns the number of positions left to fill on the requisition, based on the number of openings minus the number of candidates in the hired reference status. | Int |
| Requisition Facts > Requisition Counts | # Requisitions | Returns the number of requisitions. | Int |
| Requisition Facts > Requisition Counts | # Requisitions By Recruiter | Returns the number of requisitions divided by the number of recruiters. | Double |
| Requisition Facts > Requisition Counts | # Requisitions Currently Approved | Returns the number of requisitions currently in approved status. | Int |
| Requisition Facts > Requisition Counts | # Requisitions Currently Cancelled | Returns the number of requisitions currently in cancelled status. | Int |
| Requisition Facts > Requisition Counts | # Requisitions Currently Draft | Returns the number of requisitions currently in draft status. | Int |
| Requisition Facts > Requisition Counts | # Requisitions Currently Expired | Returns the number of requisitions currently in expired status on at least one career site or internet job board. | Int |
| Requisition Facts > Requisition Counts | # Requisitions Currently Filled | Returns the number of requisitions currently in filled status. | Int |
| Requisition Facts > Requisition Counts | # Requisitions Currently On Hold | Returns the number of requisitions currently in on hold status. | Int |
| Requisition Facts > Requisition Counts | # Requisitions Currently Posted | Returns the number of requisitions currently in posted status on at least one career site or internet job board. | Int |
| Requisition Facts > Requisition Counts | # Requisitions Currently Sourcing | Returns the number of requisitions currently in sourcing status. | Int |
| Requisition Facts > Requisition Counts | # Requisitions Currently To Be Approved | Returns the number of requisitions currently in to be approved status. | Int |
| Requisition Facts > Requisition Counts | # Requisitions Currently Unposted | Returns the number of requisitions currently in unposted status on at least one career site or internet job board. | Int |
| Requisition Facts > Requisition Cycle Time | Average Cycle Time | Returns the number of days between the req. creation date and the latest filled date. | Double |
| Requisition Facts > Requisition Cycle Time | Average Time To Approve | Returns the number of days between the first to be approved date and the first fully approved date. | Double |
| Requisition Facts > Requisition Cycle Time | Average Time To Fill | Returns the number of days between the first fully approved date and the latest filled date. | Double |
| Requisition Facts > Requisition Cycle Time | Average Time To Last Position Accepted | Returns the number of days between the first fully approved date and the last position accepted date. | Double |
| Requisition Facts > Requisition Cycle Time | Average Time To Source | Returns the number of days between the req. creation date and the first sourced date. | Double |
| Requisition Facts > Requisition Cycle Time | Cycle Time | Returns the average number of days between the req. creation date and the latest filled date. | Int |
| Requisition Facts > Requisition Cycle Time | Time To Approve | Returns the average number of days between the first to be approved date and the first fully approved date. | Int |
| Requisition Facts > Requisition Cycle Time | Time To Fill | Returns the average number of days between the first fully approved date and the latest filled date. | Int |
| Requisition Facts > Requisition Cycle Time | Time To Last Position Accepted | Returns the average number of days between the first fully approved date and the last position accepted date. | Int |
| Requisition Facts > Requisition Cycle Time | Time To Source | Returns the average number of days between the req. creation date and the first sourced date. | Int |
| Requisition Logistics > Requisition Additional Location(s) | Location Level1 Code | Returns the code of the requisition additional location. | Varchar |
| Requisition Logistics > Requisition Additional Location(s) | Location Level1 Name | Returns the name of the requisition additional location. | Varchar |
| Requisition Logistics > Requisition Additional Location(s) | Location Level2 Code | Returns the code of the requisition additional location. | Varchar |
| Requisition Logistics > Requisition Additional Location(s) | Location Level2 Name | Returns the name of the requisition additional location. | Varchar |
| Requisition Logistics > Requisition Additional Location(s) | Location Level3 Code | Returns the code of the requisition additional location. | Varchar |
| Requisition Logistics > Requisition Additional Location(s) | Location Level3 Name | Returns the name of the requisition additional location. | Varchar |
| Requisition Logistics > Requisition Additional Location(s) | Location Level4 Code | Returns the code of the requisition additional location. | Varchar |
| Requisition Logistics > Requisition Additional Location(s) | Location Level4 Name | Returns the name of the requisition additional location. | Varchar |
| Requisition Logistics > Requisition Additional Location(s) | Location Level5 Code | Returns the code of the requisition additional location. | Varchar |
| Requisition Logistics > Requisition Additional Location(s) | Location Level5 Name | Returns the name of the requisition additional location. | Varchar |
| Requisition Logistics > Requisition Collaborator | Collaborator Department Name | Returns the Collaborator's department | Varchar |
| Requisition Logistics > Requisition Collaborator | Collaborator Email | Returns the Collaborator's email | Varchar |
| Requisition Logistics > Requisition Collaborator | Collaborator Employee ID | Returns the Collaborator's employee ID | Varchar |
| Requisition Logistics > Requisition Collaborator | Collaborator First Name | Returns the Collaborator's first name | Varchar |
| Requisition Logistics > Requisition Collaborator | Collaborator ID | Returns the Collaborator's database unique identifier | Double |
| Requisition Logistics > Requisition Collaborator | Collaborator Middle Initial | Returns the Collaborator's middle initial | Varchar |
| Requisition Logistics > Requisition Collaborator | Collaborator Name | Returns the Collaborator's name | Varchar |
| Requisition Logistics > Requisition Collaborator | Collaborator User Group | Returns the Collaborator's user group | Varchar |
| Requisition Logistics > Requisition Collaborator | Collaborator User Type | Returns the Collaborator's user type | Varchar |
| Requisition Logistics > Requisition Collaborator | Collborator Last Name | Returns the Collaborator's last name | Varchar |
| Requisition Logistics > Requisition Department | Department Cost Center | Returns the cost center of the department | Varchar |
| Requisition Logistics > Requisition Department | Department Level 1 Name | Returns the name of the department. | Varchar |
| Requisition Logistics > Requisition Department | Department Level 10 Name | Returns the name of the department. | Varchar |
| Requisition Logistics > Requisition Department | Department Level 11 Name | Returns the name of the department. | Varchar |
| Requisition Logistics > Requisition Department | Department Level 12 Name | Returns the name of the department. | Varchar |
| Requisition Logistics > Requisition Department | Department Level 13 Name | Returns the name of the department. | Varchar |
| Requisition Logistics > Requisition Department | Department Level 14 Name | Returns the name of the department. | Varchar |
| Requisition Logistics > Requisition Department | Department Level 15 Name | Returns the name of the department. | Varchar |
| Requisition Logistics > Requisition Department | Department Level 16 Name | Returns the name of the department. | Varchar |
| Requisition Logistics > Requisition Department | Department Level 17 Name | Returns the name of the department. | Varchar |
| Requisition Logistics > Requisition Department | Department Level 18 Name | Returns the name of the department. | Varchar |
| Requisition Logistics > Requisition Department | Department Level 19 Name | Returns the name of the department. | Varchar |
| Requisition Logistics > Requisition Department | Department Level 2 Name | Returns the name of the department. | Varchar |
| Requisition Logistics > Requisition Department | Department Level 20 Name | Returns the name of the department. | Varchar |
| Requisition Logistics > Requisition Department | Department Level 3 Name | Returns the name of the department. | Varchar |
| Requisition Logistics > Requisition Department | Department Level 4 Name | Returns the name of the department. | Varchar |
| Requisition Logistics > Requisition Department | Department Level 5 Name | Returns the name of the department. | Varchar |
| Requisition Logistics > Requisition Department | Department Level 6 Name | Returns the name of the department. | Varchar |
| Requisition Logistics > Requisition Department | Department Level 7 Name | Returns the name of the department. | Varchar |
| Requisition Logistics > Requisition Department | Department Level 8 Name | Returns the name of the department. | Varchar |
| Requisition Logistics > Requisition Department | Department Level 9 Name | Returns the name of the department. | Varchar |
| Requisition Logistics > Requisition Department | Department Name | Returns the name of the department. | Varchar |
| Requisition Logistics > Requisition Department | Department Number | Returns the department number | Varchar |
| Requisition Logistics > Requisition Department | Parent Department Cost Center | Returns the cost center of the department's parent | Varchar |
| Requisition Logistics > Requisition Department | Parent Department Name | Returns the name of the department's parent. | Varchar |
| Requisition Logistics > Requisition Department | Parent Department Number | Returns the number of the department's parent | Varchar |
| Requisition Logistics > Requisition Department (Unstructered) | Department Description (BL) | Returns the requisition department, in its base language. This is the department field that is populated in free text format. | Varchar |
| Requisition Logistics > Requisition Department (Unstructered) | Department Description (ML) | Returns the requisition department. This is the department field that is populated in free text format. | Varchar |
| Requisition Logistics > Requisition Department (Unstructered) | Department Description Locale | Returns the requisition department language. Use to filter Departement Description (ML)" to the desired locale. | Varchar |
| Requisition Logistics > Requisition Hiring Manager | Hiring Manager Department Name | Returns the hiring manager department | Varchar |
| Requisition Logistics > Requisition Hiring Manager | Hiring Manager Email | Returns the hiring manager email | Varchar |
| Requisition Logistics > Requisition Hiring Manager | Hiring Manager Employee ID | Returns the hiring manager employee ID | Varchar |
| Requisition Logistics > Requisition Hiring Manager | Hiring Manager First Name | Returns the hiring manager first name | Varchar |
| Requisition Logistics > Requisition Hiring Manager | Hiring Manager ID | Returns the hiring manager database unique identifier | Double |
| Requisition Logistics > Requisition Hiring Manager | Hiring Manager Last Name | Returns the hiring manager last name | Varchar |
| Requisition Logistics > Requisition Hiring Manager | Hiring Manager Middle Initial | Returns the hiring manager middle initial | Varchar |
| Requisition Logistics > Requisition Hiring Manager | Hiring Manager Name | Returns the hiring manager name | Varchar |
| Requisition Logistics > Requisition Hiring Manager | Hiring Manager User Group | Returns the hiring manager user group | Varchar |
| Requisition Logistics > Requisition Hiring Manager | Hiring Manager User Type | Returns the hiring manager user type | Varchar |
| Requisition Logistics > Requisition Hiring Manager Assistant | Hiring Manager Assistant Last Name | Returns the hiring manager assistant last name | Varchar |
| Requisition Logistics > Requisition Hiring Manager Assistant | Hiring Manager Assistant Department Name | Returns the hiring manager assistant department | Varchar |
| Requisition Logistics > Requisition Hiring Manager Assistant | Hiring Manager Assistant Email | Returns the hiring manager assistant email | Varchar |
| Requisition Logistics > Requisition Hiring Manager Assistant | Hiring Manager Assistant Employee ID | Returns the hiring manager assistant employee ID | Varchar |
| Requisition Logistics > Requisition Hiring Manager Assistant | Hiring Manager Assistant First Name | Returns the hiring manager assistant first name | Varchar |
| Requisition Logistics > Requisition Hiring Manager Assistant | Hiring Manager Assistant ID | Returns the hiring manager database unique identifier | Double |
| Requisition Logistics > Requisition Hiring Manager Assistant | Hiring Manager Assistant Middle Initial | Returns the hiring manager assistant middle initial | Varchar |
| Requisition Logistics > Requisition Hiring Manager Assistant | Hiring Manager Assistant Name | Returns the hiring manager assistant name | Varchar |
| Requisition Logistics > Requisition Hiring Manager Assistant | Hiring Manager Assistant User Group | Returns the hiring manager assistant user group | Varchar |
| Requisition Logistics > Requisition Hiring Manager Assistant | Hiring Manager Assistant User Type | Returns the hiring manager assistant user type | Varchar |
| Requisition Logistics > Requisition Identification | # Openings | Returns the number of openings on the requisition. | Int |
| Requisition Logistics > Requisition Identification | # Openings Left To Fill (Accepted) | Returns the number of positions left to fill on the requisition, based on the number of openings minus the number of candidates with a current standard offer status of Accepted where the candidate does not have a reference status of Declined or Rejected | Int |
| Requisition Logistics > Requisition Identification | # Openings Left To Fill (Hired) | Returns the number of positions left to fill on the requisition, based on the number of openings minus the number of candidates in the hired reference status. | Int |
| Requisition Logistics > Requisition Identification | Created By User | Returns the user responsible for creating the requisition. | Varchar |
| Requisition Logistics > Requisition Identification | Has Unlimited Openings | Returns whether or not the requisition has an unlimited amount of openings. | Varchar |
| Requisition Logistics > Requisition Identification | Justification | Returns the justification of the requisition. | Varchar |
| Requisition Logistics > Requisition Identification | Req. Identifier |
Returns the requisition id, as displayed in the recruiting application. | Varchar |
| Requisition Logistics > Requisition Identification | Staffing Type | Returns the staffing type associated with the requisition | Varchar |
| Requisition Logistics > Requisition Identification | Title (BL) | Returns the requisition title, in its base language. | Varchar |
| Requisition Logistics > Requisition Identification | Title (Manager) (BL) | Returns the requisition's manager title, in the requisition's base locale | Varchar |
| Requisition Logistics > Requisition Identification | Title (Manager) (ML) | Returns the requisition's manager title. | Varchar |
| Requisition Logistics > Requisition Identification | Title (Manager) Locale | Returns the locale of the requisition manager title. Use to filter "Title (ML)" to the desired locale. | Varchar |
| Requisition Logistics > Requisition Identification | Title (ML) | Returns the requisition title. | Varchar |
| Requisition Logistics > Requisition Identification | Title Locale | Returns the locale of the requisition title. Use to filter "Title (ML)" to the desired locale. | Varchar |
| Requisition Logistics > Requisition Identification | Validity Period | Returns the validity period of the requisition. | Double |
| Requisition Logistics > Requisition Job Field | Job Field Level1 Code | Returns the code of the requisition job field. | Varchar |
| Requisition Logistics > Requisition Job Field | Job Field Level1 Name | Returns the name of the requisition job field. | Varchar |
| Requisition Logistics > Requisition Job Field | Job Field Level2 Code | Returns the code of the requisition job field. | Varchar |
| Requisition Logistics > Requisition Job Field | Job Field Level2 Name | Returns the name of the requisition job field. | Varchar |
| Requisition Logistics > Requisition Job Field | Job Field Level3 Code | Returns the code of the requisition job field. | Varchar |
| Requisition Logistics > Requisition Job Field | Job Field Level3 Name | Returns the name of the requisition job field. | Varchar |
| Requisition Logistics > Requisition Job Field | Job Field Level4 Code | Returns the code of the requisition job field. | Varchar |
| Requisition Logistics > Requisition Job Field | Job Field Level4 Name | Returns the name of the requisition job field. | Varchar |
| Requisition Logistics > Requisition Job Role | Job Role Code | Returns the requisition job role code | Varchar |
| Requisition Logistics > Requisition Job Role | Job Role Name | Returns the requisition job role name | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level1 Code | Returns the code of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level1 Name | Returns the name of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level10 Code | Returns the code of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level10 Name | Returns the name of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level11 Code | Returns the code of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level11 Name | Returns the name of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level12 Code | Returns the code of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level12 Name | Returns the name of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level13 Code | Returns the code of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level13 Name | Returns the name of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level14 Code | Returns the code of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level14 Name | Returns the name of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level15 Code | Returns the code of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level15 Name | Returns the name of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level16 Code | Returns the code of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level16 Name | Returns the name of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level17 Code | Returns the code of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level17 Name | Returns the name of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level18 Code | Returns the code of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level18 Name | Returns the name of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level19 Code | Returns the code of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level19 Name | Returns the name of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level2 Code | Returns the code of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level2 Name | Returns the name of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level20 Code | Returns the code of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level20 Name | Returns the name of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level3 Code | Returns the code of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level3 Name | Returns the name of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level4 Code | Returns the code of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level4 Name | Returns the name of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level5 Code | Returns the code of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level5 Name | Returns the name of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level6 Code | Returns the code of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level6 Name | Returns the name of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level7 Code | Returns the code of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level7 Name | Returns the name of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level8 Code | Returns the code of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level8 Name | Returns the name of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level9 Code | Returns the code of the organization | Varchar |
| Requisition Logistics > Requisition Organization | Organization Level9 Name | Returns the name of the organization | Varchar |
| Requisition Logistics > Requisition Position | Position Code | Returns the requisition's associated position code. | Varchar |
| Requisition Logistics > Requisition Position (Free Text) | Position Description (BL) | Returns the description of the requisition position, in the requisition's base locale. | Varchar |
| Requisition Logistics > Requisition Position (Free Text) | Position Description (ML) | Returns the description of the requisition position. Use the element "Position Description Locale" to filter on the appropriate locale. | Varchar |
| Requisition Logistics > Requisition Position (Free Text) | Position Description Locale | Returns the locale of the requisition position title | Varchar |
| Requisition Logistics > Requisition Primary Location | Location Level1 Code | Returns the code of the requisition primary location. | Varchar |
| Requisition Logistics > Requisition Primary Location | Location Level1 Name | Returns the name of the requisition primary location. | Varchar |
| Requisition Logistics > Requisition Primary Location | Location Level2 Code | Returns the code of the requisition primary location. | Varchar |
| Requisition Logistics > Requisition Primary Location | Location Level2 Name | Returns the name of the requisition primary location. | Varchar |
| Requisition Logistics > Requisition Primary Location | Location Level3 Code | Returns the code of the requisition primary location. | Varchar |
| Requisition Logistics > Requisition Primary Location | Location Level3 Name | Returns the name of the requisition primary location. | Varchar |
| Requisition Logistics > Requisition Primary Location | Location Level4 Code | Returns the code of the requisition primary location. | Varchar |
| Requisition Logistics > Requisition Primary Location | Location Level4 Name | Returns the name of the requisition primary location. | Varchar |
| Requisition Logistics > Requisition Primary Location | Location Level5 Code | Returns the code of the requisition primary location. | Varchar |
| Requisition Logistics > Requisition Primary Location | Location Level5 Name | Returns the name of the requisition primary location. | Varchar |
| Requisition Logistics > Requisition Profile | Education Program | Returns the education program associated with the requisition. | Varchar |
| Requisition Logistics > Requisition Profile | Req. Education Level | Returns the education level associated with the requisition. | Varchar |
| Requisition Logistics > Requisition Profile | Req. Employee Status | Returns the employee status associated with the requisition. | Varchar |
| Requisition Logistics > Requisition Profile | Req. Job Level | Returns the job level associated with the requisition. | Varchar |
| Requisition Logistics > Requisition Profile | Req. Job Schedule | Returns the job schedule associated with the requisition. | Varchar |
| Requisition Logistics > Requisition Profile | Req. Job Shift | Returns the job shift associated with the requisition. | Varchar |
| Requisition Logistics > Requisition Profile | Req. Job Type | Returns the job type associated with the requisition. | Varchar |
| Requisition Logistics > Requisition Profile | Required Travel | Returns the required travel for the requisition. | Varchar |
| Requisition Logistics > Requisition Recruiter | Recruiter Department Name | Returns the recruiter department | Varchar |
| Requisition Logistics > Requisition Recruiter | Recruiter Email | Returns the recruiter email | Varchar |
| Requisition Logistics > Requisition Recruiter | Recruiter Employee ID | Returns the recruiter employee ID | Varchar |
| Requisition Logistics > Requisition Recruiter | Recruiter First Name | Returns the recruiter first name | Varchar |
| Requisition Logistics > Requisition Recruiter | Recruiter ID | Returns the recruiter database unique identifier | Double |
| Requisition Logistics > Requisition Recruiter | Recruiter Last Name | Returns the recruiter last name | Varchar |
| Requisition Logistics > Requisition Recruiter | Recruiter Middle Initial | Returns the recruiter middle initial | Varchar |
| Requisition Logistics > Requisition Recruiter | Recruiter Name | Returns the recruiter name | Varchar |
| Requisition Logistics > Requisition Recruiter | Recruiter User Group | Returns the recruiter user group | Varchar |
| Requisition Logistics > Requisition Recruiter | Recruiter User Type | Returns the recruiter user type | Varchar |
| Requisition Logistics > Requisition Recruiter Assistant | Recruiter Assistant Department Name | Returns the recruiter assistant department | Varchar |
| Requisition Logistics > Requisition Recruiter Assistant | Recruiter Assistant Email | Returns the recruiter assistant email | Varchar |
| Requisition Logistics > Requisition Recruiter Assistant | Recruiter Assistant Employee ID | Returns the recruiter assistant employee ID | Varchar |
| Requisition Logistics > Requisition Recruiter Assistant | Recruiter Assistant First Name | Returns the recruiter assistant first name | Varchar |
| Requisition Logistics > Requisition Recruiter Assistant | Recruiter Assistant ID | Returns the recruiter assistant database unique identifier | Double |
| Requisition Logistics > Requisition Recruiter Assistant | Recruiter Assistant Last Name | Returns the recruiter assistant last name | Varchar |
| Requisition Logistics > Requisition Recruiter Assistant | Recruiter Assistant Middle Initial | Returns the recruiter assistant middle initial | Varchar |
| Requisition Logistics > Requisition Recruiter Assistant | Recruiter Assistant Name | Returns the recruiter assistant name | Varchar |
| Requisition Logistics > Requisition Recruiter Assistant | Recruiter Assistant User Group | Returns the recruiter assistant user group | Varchar |
| Requisition Logistics > Requisition Recruiter Assistant | Recruiter Assistant User Type | Returns the recruiter assistant user type | Varchar |
| Requisition Logistics > Requisition Template | Template ID | Returns the template identifier | Double |
| Requisition Logistics > Requisition Template | Template Job Code | Returns the template job code | Varchar |
| Requisition Logistics > Requisition Template | Template Locale | Returns the locale of the requisition template title | Varchar |
| Requisition Logistics > Requisition Template | Template Title (BL) | Returns the template title in its base locale. | Varchar |
| Requisition Logistics > Requisition Template | Template Title (ML) | Returns the template title. Use the element "Template Locale" to filter on the appropriate locale. | Varchar |
| Requisition Logistics > Requisition User Group | User Group | Returns the user group associated with the requisition. | Varchar |
| Requisition Logistics > Requisition Work Location | Work Location Code | Returns the code of the requisition work location | Varchar |
| Requisition Logistics > Requisition Work Location | Work Location Name | Returns the name of the requisition work location | Varchar |
| Requisition Logistics > Requisition Work Location | Work Location Zip Code | Returns the zip code of the requisition work location | Varchar |
| Requisition Passport | Req. Input Parameter - Value 1 | Returns the value of the passport service request's input parameter | Varchar |
| Requisition Passport | Req. Input Parameter - Value 10 | Returns the value of the passport service request's input parameter | Varchar |
| Requisition Passport | Req. Input Parameter - Value 2 | Returns the value of the passport service request's input parameter | Varchar |
| Requisition Passport | Req. Input Parameter - Value 3 | Returns the value of the passport service request's input parameter | Varchar |
| Requisition Passport | Req. Input Parameter - Value 4 | Returns the value of the passport service request's input parameter | Varchar |
| Requisition Passport | Req. Input Parameter - Value 5 | Returns the value of the passport service request's input parameter | Varchar |
| Requisition Passport | Req. Input Parameter - Value 6 | Returns the value of the passport service request's input parameter | Varchar |
| Requisition Passport | Req. Input Parameter - Value 7 | Returns the value of the passport service request's input parameter | Varchar |
| Requisition Passport | Req. Input Parameter - Value 8 | Returns the value of the passport service request's input parameter | Varchar |
| Requisition Passport | Req. Input Parameter - Value 9 | Returns the value of the passport service request's input parameter | Varchar |
| Requisition Passport | Req. Passport Input Parameter - Code 1 | Returns the code of the passport service request's input parameter | Varchar |
| Requisition Passport | Req. Passport Input Parameter - Code 10 | Returns the code of the passport service request's input parameter | Varchar |
| Requisition Passport | Req. Passport Input Parameter - Code 2 | Returns the code of the passport service request's input parameter | Varchar |
| Requisition Passport | Req. Passport Input Parameter - Code 3 | Returns the code of the passport service request's input parameter | Varchar |
| Requisition Passport | Req. Passport Input Parameter - Code 4 | Returns the code of the passport service request's input parameter | Varchar |
| Requisition Passport | Req. Passport Input Parameter - Code 5 | Returns the code of the passport service request's input parameter | Varchar |
| Requisition Passport | Req. Passport Input Parameter - Code 6 | Returns the code of the passport service request's input parameter | Varchar |
| Requisition Passport | Req. Passport Input Parameter - Code 7 | Returns the code of the passport service request's input parameter | Varchar |
| Requisition Passport | Req. Passport Input Parameter - Code 8 | Returns the code of the passport service request's input parameter | Varchar |
| Requisition Passport | Req. Passport Input Parameter - Code 9 | Returns the code of the passport service request's input parameter | Varchar |
| Requisition Passport | Req. Service Alias | Returns the passport service alias | Varchar |
| Requisition Passport | Req. Service Name | Returns the passport service name | Varchar |
| Requisition Passport | Req. Service Provider | Returns the passport service provider | Varchar |
| Requisition Passport | Req. Service Type | Returns the passport service type | Varchar |
| Requisition Posting & Sourcing | Is Urgent Need | Returns whether or not the requisition is posted as an urgent need job. | Varchar |
| Requisition Posting & Sourcing > Requisition Posting | Is Posted Externally | Returns whether or not the requisition is currently posted to at least one external career site. | Char |
| Requisition Posting & Sourcing > Requisition Posting | Is Posted Internally | Returns whether or not the requisition is currently posted to at least one internal career site. | Char |
| Requisition Posting & Sourcing > Requisition Posting | Posting Board Type | Returns the type of board the requisition is posted to i.e. career site, fee-based job board. | Varchar |
| Requisition Posting & Sourcing > Requisition Posting | Posting Date | Returns the date/time the requisition was posted. | Timestamp |
| Requisition Posting & Sourcing > Requisition Posting | Posting Enables Online Job Applications | Returns whether or not the posting allows candides to apply online. | Varchar |
| Requisition Posting & Sourcing > Requisition Posting | Posting Locale | Returns the locale in which the requisition was posted. | Varchar |
| Requisition Posting & Sourcing > Requisition Posting | Posting Source | Returns the source the requisition is posted to | Varchar |
| Requisition Posting & Sourcing > Requisition Posting | Posting Status | Returns the current status of the job posting | Varchar |
| Requisition Posting & Sourcing > Requisition Posting | Unposting Date | Returns the date/time the requisition was unposted. | Timestamp |
| Requisition Posting & Sourcing > Requisition Sources | Req. Source (BL) | Returns the requisition source, in its base locale | Varchar |
| Requisition Posting & Sourcing > Requisition Sources | Req. Source (ML) | Returns the requisition source. Use the element "Source Locale" to filter on the appropriate locale. | Varchar |
| Requisition Posting & Sourcing > Requisition Sources | Req. Source Identifier | Returns the source identifier as seen in the source configuration page | Varchar |
| Requisition Posting & Sourcing > Requisition Sources | Req. Source Locale | Returns the locale of the requisition source. | Varchar |
| Requisition Posting & Sourcing > Requisition Sources | Req. Source Type | Returns the recruitment source type. This field displays customized source type labels | Varchar |
| Requisition Posting & Sourcing > Requisition Sources | Req. Source Type (Admin) | Returns the recruitment source type, as displayed in the recruiting administration application | Varchar |
| Requisition Status > Requisition Status - Current | Current Posting Status | Returns the posting status as it is displayed in the Recruiting application. | Varchar |
| Requisition Status > Requisition Status - Current | Current Status | Returns the current status of the requisition. Note that the values "Approved" and "Sourcing" roll up to the "Open" status. | Varchar |
| Requisition Status > Requisition Status - Historical | Historical Status | Returns the historical status of the requisition. Note that the values "Approved" and "Sourcing" roll up to the "Open" status. | Varchar |
| Requisition Status > Requisition Status - Historical | Historical Status User | Returns the user responsible for changing the requisition status. | Varchar |
| Requisition Status > Requisition Status - Historical | Req. Historical Status End Date | Returns the date/time when the requisition was changed from the status. If the end date is null, the status is current. | Timestamp |
| Requisition Status > Requisition Status - Historical | Req. Historical Status Start Date | Returns the date/time when the requisition was placed into the status. | Timestamp |
| Requisition Tracking History | Req. History Transaction By User | Returns the user who did the action. | Varchar |
| Requisition Tracking History | Req. History Transaction Date | Returns the date/time associated with the event. | Datetime |
| Requisition Tracking History | Transaction Event Type | Returns the code of the event type. | Varchar |
| Requisition Tracking History | Transaction User Comments | Returns the comments associated with the event. | Varchar |