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