WM_PM_PJC_LBRRQ

(SQL Table)
Index Back

Projection Labor requirements

Projection Labor requirements

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 PJC_ID Character(10) VARCHAR2(10) NOT NULL Projection ID
4 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number
5 RQMT_LN_NBR Number(5,0) INTEGER NOT NULL Requirement Line Number

Default Value: 1

6 CRAFT_ID Character(16) VARCHAR2(16) NOT NULL Craft Identification

Prompt Table: RS_CRAFT_DETAIL

7 RQMT_QTY Signed Number(12,0) DECIMAL(11) NOT NULL Required Quantity
8 RQMT_UOM Character(3) VARCHAR2(3) NOT NULL Unit of Measure for requirement
9 REQ_DURATION Signed Number(9,2) DECIMAL(7,2) NOT NULL Schedule Duration
10 REQ_START_DT Date(10) DATE Required Start

Default Value: WM_WO_TSK.REQ_START_DT

11 REQ_END_DT Date(10) DATE Required End

Default Value: WM_WO_TSK.REQ_END_DT

12 LABOR_COST_RATE Number(27,3) DECIMAL(26,3) NOT NULL Cost Rate
13 LABOR_BILL_RATE Number(27,3) DECIMAL(26,3) NOT NULL Billing Rate
14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
15 EST_COST_LBR Signed Number(28,3) DECIMAL(26,3) NOT NULL Estimated Labor Cost
16 EST_BILL_LBR Signed Number(28,3) DECIMAL(26,3) NOT NULL Estimated Labor Billing Amount