This table requires activation of Time and Labor functional area. Qualifying information about a time record
Module: Time and Labor
USAGES_SOURCE_VERSION, USAGES_SOURCE_ID
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 | 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, 2023, Oracle and/or its affiliates.