Mapping of fields on Application pages to Lookup Codes
Mapping of fields on Application pages to Lookup Codes

 1,103 total views

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 ObjectLookup Type
Absence Adjustment ReasonANC_ABS_PLAN_OTHER_REASONS
Absence Adjustment TypeANC_ACCRUAL_ENTRY_TYPE
Absence Unit Of MeasureANC_DURATION_UOM
Account Type (for bank details)ACC_TYPE
Address TypeADDRESS_TYPE
Availability ScheduleWORK_SCHEDULE
Balance Type CategoryBACKFEED_BT_CATEGORY
Bank account nameBANK_ACCOUNT_NAME
Bank account numberBANK_ACCOUNT_NUMBER
Bank account typeBANK_ACCOUNT_TYPE
Bank branchBANK_BRANCH
Bank nameBANK_NAME
Category (absence)ABSENCE_CATEGORY
ClusterPER_COMPETENCE_CLUSTER
Communication delivery method, Report MethodPER_CM_MTHD
Competence TypeCOMPETENCE_TYPE
Days of the weekHXT_DAY_OF_WEEK
Document CategoryDOCUMENT_CATEGORY
Employee Category (WorkerCategory)EMPLOYEE_CATG
Employment Category (AssignmentCategory)EMP_CAT
Format TypePER_NAME_FORMATS
Industry (for salary survey)INDUSTRY
Job Name (for salary surveys)SURVEY_JOB_NAME
Marital StatusMAR_STATUS
NationalityNATIONALITY
Organization TypeORG_TYPE
Person Title (Prefix)TITLE
Phone TypePHONE_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 BirthREGION_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
SalaryBasisComponentCMP_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 DimensionsPAY_DIMENSION_LEVEL
Payroll Action Types (Payroll Actions Table)ACTION_TYPE
Unit Of Measure for ElementsPAY_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.

The following two tabs change content below.
Sricharan is a Fusion HCM Solution Architect with over 13+ years of overall experience and 5+ years of Fusion experience. He is passionate about technical aspects of Fusion HCM and writes interesting articles on HCM Extracts, HCM Data Loader, Fast Formula, BI Publisher, Integrations and Automation etc.

Leave a Reply