DW_JOB_D_TL

DW_JOB_D_TL contains translation of JOB ID of DW_JOB_D

Details

Module: Global Human Resources

Key Columns

EFFECTIVE_END_DATE, LANGUAGE, EFFECTIVE_START_DATE, JOB_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
JOB_ID NUMBER 38 0 True Job 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_ID,EFFECTIVE_START_DATE and EFFECTIVE_END_DATE.    
JOB_NAME VARCHAR2 256     Name for the Job