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
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.    
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.    

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