Results for “dimension_type_code”
23 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PAYBV_BALANCE_DIMENSION is an APPS-owned database view within the Payroll (PAY) product family of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It presents balance dimension definitions stored in the PAY_BALANCE_DIMENSIONS table, decoded for human-readable reporting and secured according to the session's business group and legislation context. Balance dimensions define the level at which payroll balances accumulate — for example, assignment, assignment action, or run — and therefore govern how gross-to-net, tax, deduction, and accrual balances are maintained.
The view exists primarily to support Oracle Business Intelligence (BIS) reporting and balance-related inquiry screens. Rather than exposing raw lookup codes, it joins to HR_BIS.BIS_DECODE_LOOKUP to translate coded values for DIMENSION_TYPE, PAYMENTS_FLAG, EXPIRY_CHECKING_LEVEL, and SAVE_RUN_BALANCE_ENABLED into their display meanings. A search for expiry_checking_level resolves directly to the decoded EXPIRY_CHECKING_LEVEL column, which controls whether a balance dimension enforces an expiry check and at what level that check is applied.
Underlying Base Objects
The view is defined over two documented referenced objects:
- PAY_BALANCE_DIMENSIONS (SYNONYM) — the base table holding the authoritative balance dimension definitions. The view aliases this table as PBD and selects from it with a WITH READ ONLY clause, guaranteeing that consumers cannot perform DML through the view.
- HR_BIS (PACKAGE) — the decoding package invoked for each translated attribute via BIS_DECODE_LOOKUP, and for security context through GET_LEGISLATION_CODE and GET_SEC_PROFILE_BG_ID.
Because the view is read-only and reflects the base table directly, it aligns one-to-one with rows in PAY_BALANCE_DIMENSIONS; no aggregation or filtering is applied beyond the derived security flag.
Key Columns
- DIMENSION_NAME / DATABASE_ITEM_SUFFIX — the balance dimension name and the suffix used to form the corresponding database item.
- DIMENSION_TYPE, PAYMENTS_FLAG, SAVE_RUN_BALANCE_ENABLED, EXPIRY_CHECKING_LEVEL — decoded display values from BIS_DECODE_LOOKUP.
- DIMENSION_TYPE_CODE, PAYMENTS_FLAG_CODE, EXPIRY_CHECKING_LEVEL_CODE, SAVE_RUN_BALANCE_ENABLED_CODE — the underlying stored codes, retained for programmatic use.
- EXPIRY_CHECKING_CODE — the raw expiry checking code associated with the dimension.
- LEGISLATION_CODE / LEGISLATION_SUBGROUP — the legislative scope under which the dimension applies.
- DIMENSION_LEVEL, PERIOD_TYPE, DATABASE_ITEM_FUNCTION, START_DATE_CODE — accumulation level, period, database item function, and start date behaviour.
- BALANCE_DIMENSION_ID, BUSINESS_GROUP_ID, ASG_ACTION_BALANCE_DIM_ID — identifiers, including the assignment action association.
- BG_SECURITY_FLAG_CODE — a derived 'Y'/'N' indicator computed via CASE logic that evaluates whether the row is visible under the session's legislation code and security profile business group.
Common Use Cases and Queries
The view is commonly queried to audit dimension configuration, to verify expiry checking behaviour, and to drive reports that must respect business group security. A representative query filters on expiry checking level:
SELECT dimension_name, dimension_type, expiry_checking_level, expiry_checking_level_code, legislation_code FROM paybv_balance_dimension WHERE bg_security_flag_code = 'Y' ORDER BY dimension_name;SELECT dimension_name, database_item_suffix, save_run_balance_enabled FROM paybv_balance_dimension WHERE payments_flag = 'Yes' AND expiry_checking_code IS NOT NULL;SELECT dimension_name, dimension_level, period_type FROM paybv_balance_dimension WHERE balance_dimension_id = :p_dim_id;
Filtering on BG_SECURITY_FLAG_CODE ensures only dimensions valid for the current business group and legislation are returned, which is essential for multi-legislative implementations.
-
APPS.PAYBV_BALANCE_DIMENSION·↳ HR_BIS·↳ PAY_BALANCE_DIMENSIONS·Explore PAY module →
-
APPS.PAYBV_BALANCE_DIMENSION·↳ HR_BIS·↳ PAY_BALANCE_DIMENSIONS·Explore PAY module →
-
eTRM - PAY Tables and Views 12.1.1
Temporary table used to hold invalid location addresses.
-
eTRM - PAY Tables and Views 12.2.2
Temporary table used to hold invalid location addresses.