It holds Rating scale, Rating categories and boundaries grouped under models for person.
Module: Global Human Resources
RATING_LEVEL_ID
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 | 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, 2023, Oracle and/or its affiliates.