DW_JOB_FAMILY_D_TL

DW_JOB_FAMILY_D_TL contains translation of JOB FAMILY ID of DW_JOB_FAMILY_D

Details

Module: Global Human Resources

Key Columns

EFFECTIVE_END_DATE, LANGUAGE, EFFECTIVE_START_DATE, JOB_FAMILY_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
JOB_FAMILY_ID NUMBER 38 0 True Job Family ID of Job generated in transaction system.    
EFFECTIVE_START_DATE DATE     True Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.    
EFFECTIVE_END_DATE DATE     True Date Effective Entity: indicates the date at the end of the date range within which the row is effective.    
LANGUAGE VARCHAR2 16   True Indicates the code of the language into which the contents of the translatable columns are translated.    
SOURCE_RECORD_ID VARCHAR2 128     Unique Source Record Identifier This column contains JOB_FAMILY_ID,EFFECTIVE_START_DATE and EFFECTIVE_END_DATE.    
JOB_FAMILY_NAME VARCHAR2 256     Name for the Job family