A LOOKUP is a specific list of values which can be set by a user. LOOKUPS have a 'type' and are either:
Access
levels of Lookups and differences
- USER (where the user can add/amend/delete items)
- EXTENSIBLE (where the user can add or amend his own items, but cannot change any of the 'seeded' values)
- SYSTEM (where the user cannot do anything to the 'seeded' values)
LOOKUPs are used directly by
forms in the system.
Navigation:-
Global HRMS Manager > Other Definitions > Application Utilities Lookups
Lookup codes
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.
|
25% OFF on Oracle Apps R12 Financials Self Paced Course along with 11 Additional Add On Courses (321 Session Videos of 120 Hours Recordings). Our Top Trending Course with 1700 Enrolled Udemy Students
ReplyDeletePlease Check https://www.oracleappstechnical.com for details