Attributes for Job Requisition
This table lists the main attributes of the Job Requisition business object and exceptions for any attribute, if any.
|
Attribute |
Field Name |
Description |
Supported by LOV |
|---|---|---|---|
|
RECRUITING_TYPE_ CODE |
Recruiting Type |
Stores the type of Recruiting as a lookup code. The corresponding lookup type is ORA_IRC_RECRUITING_TYPE. This column accepts NULL values. |
|
|
PIPELINE_REQUISITION_FLAG |
Requisition Type |
Stores whether the requisition is a pipeline requisition |
Yes |
|
REQUISITION_NUMBER |
Requisition Number |
Unique readable number for the Requisition. |
|
|
TITLE |
Requisition Title |
Title of the requisition. |
|
|
NUMBER_TO_HIRE |
Number of Openings |
Stores the number of people to hire for this Requisition. |
|
|
UNLIMITED_HIRE_FLAG |
Unlimited Openings |
Stores whether this Requisition can hire unlimited number of people. |
|
|
POSITION_ID |
Position |
Stores the corresponding position ID. Foreign key to HR_ALL_POSITIONS_F table. |
Yes |
|
JUSTIFICATION_CODE |
Business Justification |
Stores the Justification for this Requisition as a lookup code. The corresponding lookup type is ORA_IRC_REQ_JUSTIFICATION. |
Yes |
|
HIRING_MANAGER_ID |
Hiring Manager |
Stores the PERSON_ID of the hiring manager for this Requisition. Foreign key to PER_PERSONS table. |
|
|
RECRUITER_ID |
Recruiter |
Stores the PERSON_ID of the recruiter for this Requisition. Foreign key to PER_PERSONS table. |
|
|
ORGANIZATION_ID |
Organization |
Foreign key to HR_ALL_ORGANIZATION_UNITS_F table. |
Yes |
|
LOCATION_ID |
Primary Location |
Stores the primary work location of the requisition. Foreign key to PER_LOCATIONS. |
Yes |
|
JOB_FAMILY_ID |
Job Family |
Foreign key to PER_JOB_FAMILY_F. |
Yes |
|
JOB_FUNCTION_CODE |
Job Function |
Stores the job function code for this Requisition as a lookup code. The corresponding lookup type is JOB_FUNCTION_CODE. |
Yes |
|
ATTRIBUTE_CHAR1 |
Flexfields - AttributeChar1-30 |
Descriptive Flexfield: segment of the user descriptive flexfield. |
|
|
ATTRIBUTE_NUMBER1 |
Flexfields - AttributeNumber1-20 |
Descriptive Flexfield: segment of the user descriptive flexfield. |
|
|
ATTRIBUTE_DATE1 |
Flexfields - AttributeDate1-10 |
Descriptive Flexfield: segment of the user descriptive flexfield. |
For more information on the Job Requisition attributes, refer to the Tables and Views for HCM guide on the Oracle Help Center.