VIEW: HR.PAY_BALANCE_DIMENSIONS#

Source

View Text - Preformatted

select BALANCE_DIMENSION_ID BALANCE_DIMENSION_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, LEGISLATION_CODE LEGISLATION_CODE, ROUTE_ID ROUTE_ID, DATABASE_ITEM_SUFFIX DATABASE_ITEM_SUFFIX, DIMENSION_NAME DIMENSION_NAME, DIMENSION_TYPE DIMENSION_TYPE, DESCRIPTION DESCRIPTION, FEED_CHECKING_CODE FEED_CHECKING_CODE, LEGISLATION_SUBGROUP LEGISLATION_SUBGROUP, PAYMENTS_FLAG PAYMENTS_FLAG, EXPIRY_CHECKING_CODE EXPIRY_CHECKING_CODE, EXPIRY_CHECKING_LEVEL EXPIRY_CHECKING_LEVEL, FEED_CHECKING_TYPE FEED_CHECKING_TYPE, DIMENSION_LEVEL DIMENSION_LEVEL, PERIOD_TYPE PERIOD_TYPE, ASG_ACTION_BALANCE_DIM_ID ASG_ACTION_BALANCE_DIM_ID, DATABASE_ITEM_FUNCTION DATABASE_ITEM_FUNCTION, SAVE_RUN_BALANCE_ENABLED SAVE_RUN_BALANCE_ENABLED, START_DATE_CODE START_DATE_CODE, APPLICATION_ID APPLICATION_ID, ZD_EDITION_NAME ZD_EDITION_NAME from "HR"."PAY_BALANCE_DIMENSIONS"

View Text - HTML Formatted

SELECT BALANCE_DIMENSION_ID BALANCE_DIMENSION_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, LEGISLATION_CODE LEGISLATION_CODE
, ROUTE_ID ROUTE_ID
, DATABASE_ITEM_SUFFIX DATABASE_ITEM_SUFFIX
, DIMENSION_NAME DIMENSION_NAME
, DIMENSION_TYPE DIMENSION_TYPE
, DESCRIPTION DESCRIPTION
, FEED_CHECKING_CODE FEED_CHECKING_CODE
, LEGISLATION_SUBGROUP LEGISLATION_SUBGROUP
, PAYMENTS_FLAG PAYMENTS_FLAG
, EXPIRY_CHECKING_CODE EXPIRY_CHECKING_CODE
, EXPIRY_CHECKING_LEVEL EXPIRY_CHECKING_LEVEL
, FEED_CHECKING_TYPE FEED_CHECKING_TYPE
, DIMENSION_LEVEL DIMENSION_LEVEL
, PERIOD_TYPE PERIOD_TYPE
, ASG_ACTION_BALANCE_DIM_ID ASG_ACTION_BALANCE_DIM_ID
, DATABASE_ITEM_FUNCTION DATABASE_ITEM_FUNCTION
, SAVE_RUN_BALANCE_ENABLED SAVE_RUN_BALANCE_ENABLED
, START_DATE_CODE START_DATE_CODE
, APPLICATION_ID APPLICATION_ID
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "HR"."PAY_BALANCE_DIMENSIONS"