DW_RATING_LEVEL_D

It holds Rating scale, Rating categories and boundaries grouped under models for person.

Details

Module: Global Human Resources

Key Columns

RATING_LEVEL_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
RATING_LEVEL_ID NUMBER 38 0 True Transaction system generated primary key column.For translation refer table DW_RATING_LEVEL_D_TL for Level name and description and join with RATING_LEVEL_ID. DW_RATING_LEVEL_D_TL RATING_LEVEL_ID
SOURCE_RECORD_ID VARCHAR2 128     This column is for Oracle Internal use only. Unique Source Record Identifier.This column contains RATING_LEVEL_ID, RATING_MODEL_ID and CATEGORY_ID .    
RATING_MODEL_ID NUMBER 38 0   Transaction system generated primary key column.For translation refer table DW_RATING_LEVEL_D_TL for Model name and description and join with RATING_LEVEL_ID. DW_RATING_LEVEL_D_TL RATING_LEVEL_ID
CATEGORY_ID NUMBER 38 0   Transaction system generated primary key column.For translation refer table DW_RATING_LEVEL_D_TL for Category name and description and join with RATING_LEVEL_ID. DW_RATING_LEVEL_D_TL RATING_LEVEL_ID
RATING_LEVEL_CODE VARCHAR2 32     Code of the job    
RATING_MODEL_CODE VARCHAR2 32     Identifier of the job family. #2 DW_JOB_FAMILY_D JOB_FAMILY_ID
NUMERIC_RATING NUMBER       Indicates if a job is active or inactive.    

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