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

PAY_BALANCE_CATEGORIES_VL

PayrollUsed in 0 subject areas83 reporting columnsBICC incremental-ready

Payroll (PAY) — view layer — joins the base table with translations for the current language.

Primary key: not yet catalogued for PAY_BALANCE_CATEGORIES_VL — reference Oracle Tables & Views guide. · Incremental key: LAST_UPDATE_DATE

Columns

ColumnKeyIn reportsDescription (inferred)
BALANCE_CATEGORY_ID●Identifier for the balance category.
BASE_BALANCE_CATEGORY_ID●Identifier for the base balance category.
BASE_CATEGORY_NAME●Name of the base category.
CREATED_BY●User who created the row.
CREATION_DATE●Date and time the row was created.
EFFECTIVE_END_DATE●End date of the effective-dated record.
EFFECTIVE_START_DATE●Start date of the effective-dated record.
ENTERPRISE_ID●Identifier for the enterprise.
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.
LEGISLATIVE_DATA_GROUP_ID●Identifier for the legislative data group.
MODULE_ID●Identifier for the module.
OBJECT_VERSION_NUMBER●Optimistic-locking version number, incremented on each update.
PBC_INFORMATION1●Pbc information1.
PBC_INFORMATION10●Pbc information10.
PBC_INFORMATION11●Pbc information11.
PBC_INFORMATION12●Pbc information12.
PBC_INFORMATION13●Pbc information13.
PBC_INFORMATION14●Pbc information14.
PBC_INFORMATION15●Pbc information15.
PBC_INFORMATION16●Pbc information16.
PBC_INFORMATION17●Pbc information17.
PBC_INFORMATION18●Pbc information18.
PBC_INFORMATION19●Pbc information19.
PBC_INFORMATION2●Pbc information2.
PBC_INFORMATION20●Pbc information20.
PBC_INFORMATION21●Pbc information21.
PBC_INFORMATION22●Pbc information22.
PBC_INFORMATION23●Pbc information23.
PBC_INFORMATION24●Pbc information24.
PBC_INFORMATION25●Pbc information25.
PBC_INFORMATION26●Pbc information26.
PBC_INFORMATION27●Pbc information27.
PBC_INFORMATION28●Pbc information28.
PBC_INFORMATION29●Pbc information29.
PBC_INFORMATION3●Pbc information3.
PBC_INFORMATION30●Pbc information30.
PBC_INFORMATION4●Pbc information4.
PBC_INFORMATION5●Pbc information5.
PBC_INFORMATION6●Pbc information6.
PBC_INFORMATION7●Pbc information7.
PBC_INFORMATION8●Pbc information8.
PBC_INFORMATION9●Pbc information9.
PBC_INFORMATION_CATEGORY●Pbc information category.
PBC_INFORMATION_DATE1●Pbc information date1.
PBC_INFORMATION_DATE10●Pbc information date10.
PBC_INFORMATION_DATE11●Pbc information date11.
PBC_INFORMATION_DATE12●Pbc information date12.
PBC_INFORMATION_DATE13●Pbc information date13.
PBC_INFORMATION_DATE14●Pbc information date14.
PBC_INFORMATION_DATE15●Pbc information date15.
PBC_INFORMATION_DATE2●Pbc information date2.
PBC_INFORMATION_DATE3●Pbc information date3.
PBC_INFORMATION_DATE4●Pbc information date4.
PBC_INFORMATION_DATE5●Pbc information date5.
PBC_INFORMATION_DATE6●Pbc information date6.
PBC_INFORMATION_DATE7●Pbc information date7.
PBC_INFORMATION_DATE8●Pbc information date8.
PBC_INFORMATION_DATE9●Pbc information date9.
PBC_INFORMATION_NUMBER1●Pbc information number1.
PBC_INFORMATION_NUMBER10●Pbc information number10.
PBC_INFORMATION_NUMBER11●Pbc information number11.
PBC_INFORMATION_NUMBER12●Pbc information number12.
PBC_INFORMATION_NUMBER13●Pbc information number13.
PBC_INFORMATION_NUMBER14●Pbc information number14.
PBC_INFORMATION_NUMBER15●Pbc information number15.
PBC_INFORMATION_NUMBER16●Pbc information number16.
PBC_INFORMATION_NUMBER17●Pbc information number17.
PBC_INFORMATION_NUMBER18●Pbc information number18.
PBC_INFORMATION_NUMBER19●Pbc information number19.
PBC_INFORMATION_NUMBER2●Pbc information number2.
PBC_INFORMATION_NUMBER20●Pbc information number20.
PBC_INFORMATION_NUMBER3●Pbc information number3.
PBC_INFORMATION_NUMBER4●Pbc information number4.
PBC_INFORMATION_NUMBER5●Pbc information number5.
PBC_INFORMATION_NUMBER6●Pbc information number6.
PBC_INFORMATION_NUMBER7●Pbc information number7.
PBC_INFORMATION_NUMBER8●Pbc information number8.
PBC_INFORMATION_NUMBER9●Pbc information number9.
SAVE_RUN_BALANCE_ENABLED●Save run balance enabled.
USER_CATEGORY_NAME●Name of the user category.

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 PAY_BALANCE_CATEGORIES_VL?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us