In this article we will look into the most frequently used lookup codes for the application pages that are used every day in and day out.
Want to learn Fusion Technical tools? Checkout the article
When we navigate the Fusion pages, we see drop down lists for most of the fields having text drop down values. However when we query the underlying base tables, we see some code in that field and we don’t have any clue on which code maps to which drop down list value.
I have listed down the list of lookup types and the corresponding field names in Fusion to the extent that I am aware of across modules.
Description of field and Business Object Lookup Type Absence Adjustment Reason ANC_ABS_PLAN_OTHER_REASONS Absence Adjustment Type ANC_ACCRUAL_ENTRY_TYPE Absence Unit Of Measure ANC_DURATION_UOM Account Type (for bank details) ACC_TYPE Address Type ADDRESS_TYPE Availability Schedule WORK_SCHEDULE Balance Type Category BACKFEED_BT_CATEGORY Bank account name BANK_ACCOUNT_NAME Bank account number BANK_ACCOUNT_NUMBER Bank account type BANK_ACCOUNT_TYPE Bank branch BANK_BRANCH Bank name BANK_NAME Category (absence) ABSENCE_CATEGORY Cluster PER_COMPETENCE_CLUSTER Communication delivery method, Report Method PER_CM_MTHD Competence Type COMPETENCE_TYPE Days of the week HXT_DAY_OF_WEEK Document Category DOCUMENT_CATEGORY Employee Category (WorkerCategory) EMPLOYEE_CATG Employment Category (AssignmentCategory) EMP_CAT Format Type PER_NAME_FORMATS Industry (for salary survey) INDUSTRY Job Name (for salary surveys) SURVEY_JOB_NAME Marital Status MAR_STATUS Nationality NATIONALITY Organization Type ORG_TYPE Person Title (Prefix) TITLE Phone Type PHONE_TYPE Reason (for absence) ABSENCE_REASON Reason (for leaving) LEAV_REAS Reason (for salary proposal) PROPOSAL_REASON Reason (Termination of Contract Workers) NPW_TERMINATION_REASONS Region (for salary surveys) SURVEY_REGION Seniority (for salary surveys) SURVEY_SENIORITY Status (of a vacancy) VACANCY_STATUS Survey Age (for salary surveys) SURVEY_AGE Survey Company (for salary surveys) SURVEY_COMPANY Type (relationship of one person to another) CONTACT Units (qualifying units for probation period) QUALIFYING_UNITS ContractType (Contract) CONTRACT_TYPE EmailType (Person Delivery Method) EMAIL_TYPE RateType (Grade Rates) GRADE_PAY_RATE_TYPE JobFunctionCode (Job) JOB_FUNCTION_CODE CitizenshipStatus (Person Citizenship) PER_CITIZENSHIP_STATUS LicenseType (Person Drivers License) PER_DRIVERS_LICENSE_TYPE Ethnicity (Person Ethnicity) PER_ETHNICITY HighestEducationLevel (Person Legislative Data) PER_HIGHEST_EDUCATION_LEVEL NationalIdentifierType (Person National Ident) PER_NATIONAL_IDENTIFIER_TYPE PassportType (Person Passport) PER_PASSPORT_TYPE Religion (Person Religion) PER_RELIGION ResponsibilityType (Worker) PER_RESPONSIBILITY_TYPES VisaPermitType (Contact Visa) PER_VISA_PERMIT_TYPE ProbationPeriodUnitCd (Position) PROBATION_PERIOD Region of Birth REGION_OF_BIRTH ManagerLevel (Job) MANAGER_LEVEL MeasuredIn(JobEvaluation) EVAL_SYSTEM_MEAS EvaluationSystem(JobEvaluation) EVAL_SYSTEM OfficialLanguageCode(Location) PER_CORRESP_LANG AddressUsageType(LocationOtherAddress) LOCATION_ADDRESS_USAGE_TYPE BargainingUnitCd(Position) BARGAINING_UNIT_CODE SecurityClearance(Position) SECURITY_CLEARANCE ManagerType(Assignment Supervisor) PER_SUPERVISOR_TYPE Unit (Assignment Work Measure) BUDGET_MEASUREMENT_TYPE Honors(Person Names) HONORS MilitaryRank (Person Names) MILITARY_RANK Validity (Person Phones) PER_CONTACT_TIMES VisaPermitStatus (Person Visa) PER_VISA_PERMIT_STATUS TopOrgSelection (Org Security Profile) PER_ORG_SEC_PROF_TOP_ORG_SEL TopPositionSelection (Position Security Profile) PER_POS_SEC_PROF_TOP_POS_SEL ContentSupplierCode (ContentItem) HRT_CONTENT_SUPP_CODE ChecklistCategory (Checklist) CHECKLIST_CATEGORY Category (Calendar Event) PER_CAL_EVENT_CATEGORY CoverageType (Calendar Event) PER_CAL_COVERAGE_TYPE CoverageScope (Calendar Event Coverage) PER_CAL_COVERAGE_SCOPES SalaryBasisComponent CMP_SALARY_COMPONENTS ComponentReasonCode (Salary Component) CMP_PROPOSAL_REASON Category (Person Disability) DISABILITY_CATEGORY Reason (Person Disability) DISABILITY_REASON Status (Person Disability) DISABILITY_STATUS BlockedLeaveCandidate (Person Absence Entry) ANC_BLOCKED_LEAVE ResourceType (Schedule Assignment) PER_AVL_RESOURCE_TYPES ExceptionType (Schedule Exceptions) PER_SHDL_EXCEPTION_TYPES PercentCompleteCode (Goals) HRG_PERCENT_COMPLETE PriorityCode (Goals) HRG_PRIORITY LevelCode (Goals) HRG_GOAL_MEASUREMENT_LEVEL UomCode (Goals) HRG_GOAL_QUANTITATIVE_UOM GoalSubTypeCode (Goals) HRG_SUB_TYPE_CODE ActionTypeCode (Goal Actions) HRG_GOAL_TASK_TYPE Payroll Dimensions PAY_DIMENSION_LEVEL Payroll Action Types (Payroll Actions Table) ACTION_TYPE Unit Of Measure for Elements PAY_UNITS Compensation Ineligibility Reason (Compensation) CMP_CWB_INELIG_REASON
Tip: In most of the cases there is no relation between the lookup code name and the attribute name. Refer this list when you have a requirement to check the lookup code.