Analytics Catalog/Data dictionary/HCM_EXTENDED_LOOKUP_CODES_VL
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · Data dictionary

HCM_EXTENDED_LOOKUP_CODES_VL

SharedUsed in 0 subject areas81 reporting columnsBICC incremental-ready

view layer, joins the base table with translations for the current language.

Likely primary key: LOOKUP_TYPE, LOOKUP_CODE (inferred from Oracle naming conventions, verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE

Columns

ColumnKeyIn reportsDescription (inferred)
CREATED_BY●User who created the row.
CREATION_DATE●Date and time the row was created.
ENTERPRISE_ID●Identifier for the enterprise.
EXTENDED_LOOKUP_CODE●Lookup code for the extended.
EXTENDED_LOOKUP_CODE_ID●Identifier for the extended lookup code.
EXTENDED_LOOKUP_CODE_NAME●Name of the extended lookup code.
INFORMATION1●Information1.
INFORMATION10●Information10.
INFORMATION11●Information11.
INFORMATION12●Information12.
INFORMATION13●Information13.
INFORMATION14●Information14.
INFORMATION15●Information15.
INFORMATION16●Information16.
INFORMATION17●Information17.
INFORMATION18●Information18.
INFORMATION19●Information19.
INFORMATION2●Information2.
INFORMATION20●Information20.
INFORMATION21●Information21.
INFORMATION22●Information22.
INFORMATION23●Information23.
INFORMATION24●Information24.
INFORMATION25●Information25.
INFORMATION26●Information26.
INFORMATION27●Information27.
INFORMATION28●Information28.
INFORMATION29●Information29.
INFORMATION3●Information3.
INFORMATION30●Information30.
INFORMATION4●Information4.
INFORMATION5●Information5.
INFORMATION6●Information6.
INFORMATION7●Information7.
INFORMATION8●Information8.
INFORMATION9●Information9.
INFORMATION_CATEGORY●Information category.
INFORMATION_DATE1●Information date1.
INFORMATION_DATE10●Information date10.
INFORMATION_DATE11●Information date11.
INFORMATION_DATE12●Information date12.
INFORMATION_DATE13●Information date13.
INFORMATION_DATE14●Information date14.
INFORMATION_DATE15●Information date15.
INFORMATION_DATE2●Information date2.
INFORMATION_DATE3●Information date3.
INFORMATION_DATE4●Information date4.
INFORMATION_DATE5●Information date5.
INFORMATION_DATE6●Information date6.
INFORMATION_DATE7●Information date7.
INFORMATION_DATE8●Information date8.
INFORMATION_DATE9●Information date9.
INFORMATION_NUMBER1●Information number1.
INFORMATION_NUMBER10●Information number10.
INFORMATION_NUMBER11●Information number11.
INFORMATION_NUMBER12●Information number12.
INFORMATION_NUMBER13●Information number13.
INFORMATION_NUMBER14●Information number14.
INFORMATION_NUMBER15●Information number15.
INFORMATION_NUMBER16●Information number16.
INFORMATION_NUMBER17●Information number17.
INFORMATION_NUMBER18●Information number18.
INFORMATION_NUMBER19●Information number19.
INFORMATION_NUMBER2●Information number2.
INFORMATION_NUMBER20●Information number20.
INFORMATION_NUMBER3●Information number3.
INFORMATION_NUMBER4●Information number4.
INFORMATION_NUMBER5●Information number5.
INFORMATION_NUMBER6●Information number6.
INFORMATION_NUMBER7●Information number7.
INFORMATION_NUMBER8●Information number8.
INFORMATION_NUMBER9●Information number9.
LAST_UPDATED_BY●User who last updated the row.
LAST_UPDATE_DATEINCR●Date and time the row was last updated (the incremental-extract key).
LAST_UPDATE_LOGIN●Session login of the user who last updated the row.
LEGISLATION_CODE●Code identifying the legislation.
LOOKUP_CODEPK?●Code identifying the lookup.
LOOKUP_TYPEPK?●Type of lookup.
MODULE_ID●Identifier for the module.
OBJECT_VERSION_NUMBER●Optimistic-locking version number, incremented on each update.
ROW_ID●Identifier for the row.

Used by reports

No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.

Subject areas

Need the extract + dbt staging for HCM_EXTENDED_LOOKUP_CODES_VL?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us
Problems that run through this table
What the extract does not carry · The export ceiling · The extraction pattern