DW_TNL_ATRBS_D (Preview)

This table requires activation of Time and Labor functional area. Qualifying information about a time record

Details

Module: Time and Labor

Key Columns

USAGES_SOURCE_ID, USAGES_SOURCE_VERSION

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
USAGES_SOURCE_ID NUMBER 38 0 True Primary Key    
USAGES_SOURCE_VERSION NUMBER 38 0 True Primary Key    
SOURCE_RECORD_ID VARCHAR2 256     This column is for Oracle Internal use only. System    
PJC_BILLABLE_FLAG VARCHAR2 256     AttributeVarchar1    
PJC_PROJECT_ID NUMBER       AttributeNumber1    
PJC_TASK_ID NUMBER       AttributeNumber2    
PJC_PROJECT_UNIT NUMBER       AttributeNumber4    
PJC_WORK_TYPE NUMBER       AttributeNumber7    
PJC_DOCUMENT_TYPE VARCHAR2 128     AttributeCategory    
PJC_EXPENDITURE_TYPE NUMBER       AttributeCategory    
PAY_PAYROLL_TIME_TYPE VARCHAR2 128     AttributeCategory    
TOIL_TIME_TYPE NUMBER       AttributeCategory    
ANC_ABSENCE_ENTRY_ID NUMBER       AttributeNumber3    
ANC_DURATION_PAID NUMBER       AttributeNumber1    
ANC_ABSENCE_TYPE NUMBER       AttributeCategory    

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