DW_PAY_GRADE_CURRENT_D

It stores current records of pay grade dimension.

Details

Module: Global Human Resources

Key Columns

GRADE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
GRADE_ID NUMBER 38 0 True System generated primary key column, For translation refer DW_PAY_GRADE_D_CURRENT_TL and join with this ID. DW_PAY_GRADE_D_CURRENT_TL GRADE_ID
SOURCE_RECORD_ID VARCHAR2 128     Unique Source Record Identifier This column contains GRADE_ID,EFFECTIVE_START_DATE and EFFECTIVE_END_DATE.    
ACTIVE_STATUS VARCHAR2 32     Indicates if a grade is active or inactive    
GRADE_CODE VARCHAR2 32     Code of grade    
GRADE_TYPE VARCHAR2 32     Type of the grade.    

Copyright © 2019, 2023, Oracle and/or its affiliates.