1. Tables and Views for HCM
  2. PAY_BALANCE_CLASSIFICATIONS

PAY_BALANCE_CLASSIFICATIONS

Details

  • Schema: FUSION

  • Object owner: PAY

  • Object type: VIEW

Columns

Name

BALANCE_CLASSIFICATION_ID

LEGISLATIVE_DATA_GROUP_ID

LEGISLATION_CODE

MODULE_ID

BALANCE_TYPE_ID

CLASSIFICATION_ID

SCALE

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

CREATED_BY

CREATION_DATE

OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT

PAY_BAL_CLASSIFICATIONS.BALANCE_CLASSIFICATION_ID BALANCE_CLASSIFICATION_ID,

PAY_BAL_CLASSIFICATIONS.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID,

PAY_BAL_CLASSIFICATIONS.LEGISLATION_CODE LEGISLATION_CODE,

PAY_BAL_CLASSIFICATIONS.MODULE_ID MODULE_ID,

PAY_BAL_CLASSIFICATIONS.BALANCE_TYPE_ID BALANCE_TYPE_ID,

PAY_BAL_CLASSIFICATIONS.CLASSIFICATION_ID CLASSIFICATION_ID,

PAY_BAL_CLASSIFICATIONS.SCALE SCALE,

PAY_BAL_CLASSIFICATIONS.LAST_UPDATE_DATE LAST_UPDATE_DATE,

PAY_BAL_CLASSIFICATIONS.LAST_UPDATED_BY LAST_UPDATED_BY,

PAY_BAL_CLASSIFICATIONS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

PAY_BAL_CLASSIFICATIONS.CREATED_BY CREATED_BY,

PAY_BAL_CLASSIFICATIONS.CREATION_DATE CREATION_DATE,

PAY_BAL_CLASSIFICATIONS.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER

FROM

PAY_BAL_CLASSIFICATIONS