DW_LABOR_SCHEDULE_LINE_CF (Preview)

This table requires activation of Project Labor Distribution functional area. Table containing the labor schedule distribution lines defining how to distribute applied costs

Details

Module:

Key Columns

RULE_ID, LINE_NUMBER

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
RULE_ID NUMBER 38 0 True Unique identifier for a distribution rule DW_LABOR_ALLOCATION_RULE_D RULE_ID
LINE_NUMBER NUMBER     True Line number of the distribution.    
SOURCE_RECORD_ID VARCHAR2 256     This column is for Oracle Internal use only. System generated unique identifier    
LABOR_SCHEDULE_HEADER_ID NUMBER 38 0   Identifier for the labor distribution rule DW_LABOR_SCHEDULE_D LABOR_SCHEDULE_HEADER_ID
ASSIGNMENT_ID NUMBER 38 0   Assignment ID related to the assignment record for labor schedule. DW_PROJECT_ASSIGNMENT_D ASSIGNMENT_ID
BUSINESS_UNIT_ID NUMBER 38 0   Business Unit identifier. DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
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
ELEMENT_TYPE_ID NUMBER 38 0   Pay element type Identifier. DW_PAY_ELEMENT_TYPE_D ELEMENT_TYPE_ID
PROJECT_ID NUMBER 38 0   Identifier of the project. DW_PROJECT_D PROJECT_ID
TASK_ID NUMBER 38 0   Identifier of the task. DW_PROJECT_ELEMENT_D PROJ_ELEMENT_ID
EXPENDITURE_TYPE_ID NUMBER 38 0   Expenditure type. DW_PROJECT_EXPENDITURE_TYPE_D EXPENDITURE_TYPE_ID
ORGANIZATION_ID NUMBER 38 0   Identifier for expenditure organization DW_INTERNAL_ORG_D ORGANIZATION_ID
CONTRACT_HEADER_ID NUMBER 38 0   Contract or Award Identifier. DW_PROJECT_AWARD_D AWARD_ID
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
START_DATE_ACTIVE DATE       The date when the rule becomes effective DW_DAY_D CALENDAR_DATE
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   Project Organization identifier 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
GL_CODE_COMBINATION_ID NUMBER 38 0   LaborScheduleTargetLnsPEOTargetCcid DW_GL_CODE_COMBINATION_D CODE_COMBINATION_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
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
EXPENDITURE_ITEM_DATE DATE       Date on which a project-related transaction is incurred.    
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 creation of the row.    
LINE_PERCENT NUMBER       Percent of cost to be distributed to the associated project or GL related attributes.    

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