DW_WRKFRC_SENIORITY_FIELD_D_TL
Lookup table for Seniority or Triggering Field
Details
Module: Global Human Resources
Key Columns
SENIORITY_FIELD_CODE_TYPE, LANGUAGE, SENIORITY_FIELD_CODE
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| SENIORITY_FIELD_CODE_TYPE | VARCHAR2 | 128 | True | Seniority Field Code Lookup Type | |||
| SENIORITY_FIELD_CODE | VARCHAR2 | 128 | True | Seniority Field Code | |||
| LANGUAGE | VARCHAR2 | 64 | True | Translation language | |||
| SOURCE_RECORD_ID | VARCHAR2 | 512 | This column is for Oracle Internal use only. Source record identifier. Value is combination of code type and code and language. | ||||
| SENIORITY_FIELD_NAME | VARCHAR2 | 128 | Business name or value of the Seniority Field. | ||||
| SENIORITY_FIELD_DESCRIPTION | VARCHAR2 | 256 | Seniority Field Description |