Oracle Apps - R12 - Core HR Lookups

There are a list of Lookups that are available in core HR and that you can extend for your own purpose.

See below the list of lookups and their purpose:

LOOK UP CODE	DESCRIPTION
TITLE	Represents TITLE in People Screen.
SEX	Represents Gender in People Screen.
PERSON_TYPE	Represents Person Types in People Screen.
ORG_TYPE	Represents the Organization Type.
MAR_STATUS	Represents Marital Status in People Screen.
NATIONALITY	Represents Nationality in People Screen.
REGISTERED_DISABLED	Represents Registered Disabled in People Screen.
ADDRESS_TYPE	Represents Address Type in People Screen.
ABSENCE_CATEGORY	Represents Absence Category in Absence Screen.
ABSENCE_REASON	Represents Absence Reason in Absence Screen.
APL_ASSIGN_REASON	Represents Assignment Change Reason in Application Screen.
APL_INTERVIEW_TYPE	Represents Interview Type in Interview Screen.
EMP_EVENT_TYPE	Represents Type in Bookings Screen.
PER_CM_MTHD	Represents Delivery Methods in Communication Delivery Methods Screen.
PROFICIENCY_SOURCE	Represents Source of Proficiency Rating in Competence Profile Screen.
CERTIFICATION_METHOD	Represents Source of Certification Method in Competence Profile Screen.
CONTACT	Represents Relationship Type in Contact Screen.
CONTRACT_TYPE	Represents Contract Type in Contract Screen.
CONTRACT_STATUS	Represents Contract Status in Contract Screen.
CONTRACT_STATUS_REASON	Represents Contract Status Reason in Contract Screen.
DOCUMENT_STATUS	Represents Document Status in Contract Screen.
CONTRACT_START_REASON	Represents Contract Start Reason in Contract Screen.
CONTRACT_END_REASON	Represents Contract End Reason in Contract Screen.
DISABILITY_CATEGORY	Represents Disability Category in Disability Screen.
DISABILITY_REASON	Represents Disability Reason in Disability Screen.
TERM_APL_REASON	Represents Reason for Ending an Application in End Application Screen.
LEAV_REAS	Represents Leaving Reason in End Employment Screen.
CONSULTATION_TYPE	Represents Consultation Type in Medical Assessment Screen.
CONSULTATION_RESULT	Represents Consultation Result in Medical Assessment Screen.
PHONE_TYPE	Represents Phone Type in Phones Screen.
PER_SUBJECT_STATUSES	Represents Status of Qualification in Qualifications Screen.
PER_SUBJECT	Represents Subject in Qualification Screen.
PER_WORK_HOURS	Represents Work Hours in Work Preferences Screen.
PER_WORK_SCHEDULE	Represents Work Schedule in Work Preferences Screen.
PER_FTE_CAPACITY	Represents FTE Capacity in Work Preferences Screen.
VACANCY_CATEGORY	Represents Vacancy Category in Requisition and Vacancy Screen.
VACANCY_STATUS	Represents Vacancy Status in Requisition and Vacancy Screen.
REC_TYPE	Represents Source Type for Recruitment Activity in Requisition and Vacancy Screen.
FREQUENCY	Represents Frequency for Review Salary, Review Performance, and Working Hours in Assignment Screen.
QUALIFYING UNITS	Represents Units for Probation Period and Notice Period in Assignment Screen.
PQP_EMPLOYER_TYPE	Represents Employer Type in Employment History Screen.
PQP_EMPLOYER_SUBTYPE	Represents Employer Sub Type in Employment History Screen.
DOCUMENT_CATEGORY	Represents Document Category in Documents of Record Screen.