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

LINE_NUMBER, RULE_ID

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.