DW_LABOR_COST_DISTRIBUTION_CF (Preview)

This table requires activation of Project Labor Distribution functional area. Table containing the labor distribution transaction details.

Details

Module:

Key Columns

ALLOC_TXN_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ALLOC_TXN_ID NUMBER 38 0 True Allocation transaction id
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. System generated key
RULE_ID NUMBER 38 0 Allocation rule identification number DW_LABOR_ALLOCATION_RULE_D RULE_ID
RUN_ID NUMBER 38 0 Allocation run identification number DW_LABOR_DIST_EXCEPTION_MAP_G RUN_ID
RUN_TARGET_ID NUMBER 38 0 Run target ID DW_LABOR_DIST_EXCEPTION_MAP_G RUN_TARGET_ID
LD_TRANSACTION_ID NUMBER 38 0 Labor Distribution Transaction Id
LABOR_SCHEDULE_HEADER_ID NUMBER 38 0 Identifier for Labor Schedule Header DW_LABOR_SCHEDULE_D LABOR_SCHEDULE_HEADER_ID
PROJECT_ID NUMBER 38 0 Project Identifier DW_PROJECT_D PROJECT_ID
TASK_ID NUMBER 38 0 Task Identifier DW_PROJECT_ELEMENT_D PROJ_ELEMENT_ID
STATUS_CODE VARCHAR2 16 Transactions status. It can be P (pending),R (rejected) or A (accepted)
EXPENDITURE_ITEM_ID NUMBER 38 0 Expenditure item id when expenditure item is created
EXPENDITURE_TYPE_ID NUMBER 38 0 Identifier of expenditure type. DW_PROJECT_EXPENDITURE_TYPE_D EXPENDITURE_TYPE_ID
CONTRACT_HEADER_ID NUMBER 38 0 Contract or Award Identifier. DW_PROJECT_AWARD_D AWARD_ID
EXPENDITURE_ITEM_DATE DATE Date on which a project-related transaction is incurred.
ORGANIZATION_ID NUMBER 38 0 Identifier for expenditure organization DW_INTERNAL_ORG_D ORGANIZATION_ID
BILLABLE_FLAG VARCHAR2 16 Flag that indicates if a project-related item is available to be billed to customers. DW_Y_N_D_TL CODE
CAPITALIZABLE_FLAG VARCHAR2 16 Flag that indicates if a project-related item is eligible for capitalization. DW_Y_N_D_TL CODE
FUNDING_SOURCE_ID NUMBER 38 0 Identifier of funding source for sponsored project. DW_AWARD_FUNDING_SOURCE_D FUNDING_SOURCE_ID
GMS_AWARD_FUNDING_SRC_ID NUMBER 38 0 Award Funding Source Id DW_GMS_AWARD_FUNDING_SRC_D GMS_AWARD_FUNDING_SRC_ID
LINE_NUMBER NUMBER Line number
TRANSACTION_TYPE VARCHAR2 16 Transactions type. It can be T (Allocation) or O(offset) DW_LD_ALLOC_TRANSACTION_TYPE_LKP_TL LD_ALLOC_TRANSACTION_TYPE
LD_BATCH_NAME VARCHAR2 256 Name of the payroll batch
LD_PERIOD_START_DATE DATE Start date of the payroll period for the person DW_DAY_D CALENDAR_DATE
LD_PERIOD_END_DATE DATE End date of the payroll period for the person.
LD_ORIG_TRANSACTION_REFERENCE VARCHAR2 128 Unique identifier of this record in the payroll system.
PROCESSING_START_DATE DATE Processing start date.
PROCESSING_END_DATE DATE Processing end date.
RUN_STATUS VARCHAR2 16 Allocation run status. DW_LD_COST_RUN_STATUS_LKP_TL LD_COST_RUN_STATUS
TRANSACTION_CURRENCY_CODE VARCHAR2 16 Denomination currency code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
PERSON_ID NUMBER 38 0 Person ID related to the person record for labor schedule. DW_PERSON_D PERSON_ID
PERSON_TYPE_ID NUMBER 38 0 Person Type Identifier DW_PERSON_TYPE_D PERSON_TYPE_ID
DEPARTMENT_ID NUMBER 38 0 Department Identifie DW_DEPARTMENT_D DEPARTMENT_ID
JOB_ID NUMBER 38 0 Job Identifier DW_JOB_D JOB_ID
BUSINESS_UNIT_ID NUMBER 38 0 Business Unit identifier. DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
LEDGER_ID NUMBER 38 0 Ledger identifier for the line.
ELEMENT_TYPE_ID NUMBER 38 0 Pay element type Identifier. DW_PAY_ELEMENT_TYPE_D ELEMENT_TYPE_ID
ASSIGNMENT_ID NUMBER 38 0 Assignment ID related to the assignment record for labor schedule. DW_PROJECT_ASSIGNMENT_D ASSIGNMENT_ID
FISCAL_PERIOD_TYPE VARCHAR2 16 The GL period type in which the transaction is posted. DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
FISCAL_PERIOD_SET_NAME VARCHAR2 16 GL Calendar Name for Provider business unit. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
PROJECT_ORGANIZATION_ID NUMBER 38 0 Identifer for Project Organization. DW_INTERNAL_ORG_D ORGANIZATION_ID
PROJECT_BUSINESS_UNIT_ID NUMBER 38 0 Project Business Unit identifier DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
PROJECT_UNIT_ID NUMBER 38 0 Project unit assigned to the project DW_INTERNAL_ORG_D ORGANIZATION_ID
LD_TARGET_CCID NUMBER 38 0 GL account to which the cost will be distributed based on the line percent.
LD_ADJUSTED_ALLOC_TXN_ID NUMBER 38 0 Adjustment Allocation ID which the current distribution applies.
LD_INTERFACE_ID NUMBER 38 0 Labor distribution interface Id
GL_BALANCING_SEGMENT VARCHAR2 32 Balancing segment for the ledger. DW_BALANCING_SEGMENT_D GL_BALANCING_SEGMENT
GL_BLNC_SGMNT_VALUESET_CODE VARCHAR2 64 Balancing segment value set code. DW_BALANCING_SEGMENT_D GL_BLNC_SGMNT_VALUESET_CODE
COST_CENTER_SEGMENT VARCHAR2 32 Cost center segment. DW_COST_CENTER_D COST_CENTER_SEGMENT
COST_CENTER_VALUESET_CODE VARCHAR2 64 Cost center value set code. DW_COST_CENTER_D COST_CENTER_VALUESET_CODE
NATURAL_ACCOUNT_SEGMENT VARCHAR2 32 Natural account segment. DW_NATURAL_ACCOUNT_D NATURAL_ACCOUNT_SEGMENT
NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64 Natural account value set code. DW_NATURAL_ACCOUNT_D NTRL_ACNT_SGMNT_VALUESET_CODE
GL_SEGMENT1 VARCHAR2 32 Accounting segment 1. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT1_VALUESET_CODE VARCHAR2 64 Accounting segment 1 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT2 VARCHAR2 32 Accounting segment 2. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT2_VALUESET_CODE VARCHAR2 64 Accounting segment 2 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT3 VARCHAR2 32 Accounting segment 3. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT3_VALUESET_CODE VARCHAR2 64 Accounting segment 3 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT4 VARCHAR2 32 Accounting segment 4. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT4_VALUESET_CODE VARCHAR2 64 Accounting segment 4 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT5 VARCHAR2 32 Accounting segment 5. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT5_VALUESET_CODE VARCHAR2 64 Accounting segment 5 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT6 VARCHAR2 32 Accounting segment 6. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT6_VALUESET_CODE VARCHAR2 64 Accounting segment 6 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT7 VARCHAR2 32 Accounting segment 7. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT7_VALUESET_CODE VARCHAR2 64 Accounting segment 7 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT8 VARCHAR2 32 Accounting segment 8. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT8_VALUESET_CODE VARCHAR2 64 Accounting segment 8 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT9 VARCHAR2 32 Accounting segment 9. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT9_VALUESET_CODE VARCHAR2 64 Accounting segment 9 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT10 VARCHAR2 32 Accounting segment 10. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT10_VALUESET_CODE VARCHAR2 64 Accounting segment 10 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
TOTAL_ALLOCATION NUMBER Total amount to allocate
TOTAL_POOL_AMOUNT NUMBER Total source pool amount
LINE_PERCENT NUMBER Allocation percentage specified at the target line level
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 128 Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row.