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
Joins (inferred from key columns): LEGISLATIVE_DATA_GROUP_ID → PER_LEGISLATIVE_DATA_GROUPS
Columns
| Column | Key | In reports | Description (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_DATE | INCR | ● | 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.
Problems that run through this table