WM_CS_HRSRPT_VW

(SQL View)
 Index Back

Remaining/Completed Hrs and Dt

Remaining Hrs and Completed Hrs and Date view

SELECT WB.OPRID , WB.BUSINESS_UNIT , WB.WO_ID , WB.WO_TASK_ID , LBR.RQMT_LN_NBR , T.BUSINESS_UNIT_AM , T.ASSET_ID , T.ASSET_LOCATION , T.AREA_ID , T.ASSET_UP_FLG , T.STATUS_CD , T.INTERNAL_STATUS , T.DESCR254 , LBR.CRAFT_ID , LBR.RQMT_QTY , LBR.REQ_DURATION , LBR.RQMT_QTY * LBR.REQ_DURATION , %subrec(WM_CREW_SBR, LBR) , LBR.CREW_SCHED_STATUS , LBR.PERIOD_START_DT , LBR.SCHED_START_DT , LBR.SCHED_START_TIME , LBR.SCHED_END_DT , LBR.SCHED_END_TIME , LBR.WO_SCHED_HRS , LBR.REMAINING_MAN_HRS , LBR.COMPLETE_HRS , LBR.COMPLTED_DT FROM PS_WM_WOE_WB_VW WB , PS_WM_WO_RQMT_LBR LBR , PS_WM_WO_TSK T WHERE %Join(COMMON_KEYS, WM_WOE_WB_VW WB, WM_WO_TSK T) AND %Join(COMMON_KEYS, WM_WO_TSK T, WM_WO_RQMT_LBR LBR) AND LBR.CREW_ID <> ' ' AND T.INTERNAL_STATUS NOT IN('05', '06', '07', '09')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
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: WM_WO_TSK.LAST_RQMTLN_LBR

6 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

Prompt Table: BUS_UNIT_AM_VW

7 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

Prompt Table: WM_ASSET_VWA

8 ASSET_LOCATION Character(10) VARCHAR2(10) NOT NULL Asset Location

Prompt Table: LOCATION_VW

9 AREA_ID Character(10) VARCHAR2(10) NOT NULL Area ID

Prompt Table: AM_AREA_TBL

10 ASSET_UP_FLG Character(1) VARCHAR2(1) NOT NULL Asset in Production Flag
11 STATUS_CD Character(4) VARCHAR2(4) NOT NULL User defined Status Code
12 INTERNAL_STATUS Character(2) VARCHAR2(2) NOT NULL Internal Status
01=Open
02=Awaiting Schedule
03=Scheduled
04=Work In Progress
05=Complete
06=Closed
07=Canceled
08=On Hold
09=Work Order Created
13 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
14 CRAFT_ID Character(16) VARCHAR2(16) NOT NULL Craft Identification

Prompt Table: RS_CRAFT_DETAIL

15 RQMT_QTY Signed Number(12,0) DECIMAL(11) NOT NULL Required Quantity
16 REQ_DURATION Signed Number(9,2) DECIMAL(7,2) NOT NULL Schedule Duration
17 REQ_MAN_HRS Number(15,2) DECIMAL(14,2) NOT NULL Estimated Man Hours
18 CREW_BU Character(5) VARCHAR2(5) NOT NULL Crew Business Unit

Prompt Table: SP_BU_WM_NONVW

19 CREW_SHOP Character(10) VARCHAR2(10) NOT NULL Crew Shop ID

Prompt Table: WM_CREWSHOP_VW

20 CREW_ID Character(10) VARCHAR2(10) NOT NULL Crew Name

Prompt Table: WM_PREFCREW_VW

21 CREW_SCHED_STATUS Character(1) VARCHAR2(1) NOT NULL Crew Schedule Status
1=Unscheduled
2=Scheduled
3=Unplanned / Emergency
4=Schedule Confirmed

Default Value: 1

22 PERIOD_START_DT Date(10) DATE Represents the date commencement point for a given time set utilized in cash worksheet processing.
23 SCHED_START_DT Date(10) DATE Scheduled Start Date
24 SCHED_START_TIME Time(15) TIMESTAMP Schedule Start Time
25 SCHED_END_DT Date(10) DATE Scheduled End Date
26 SCHED_END_TIME Time(15) TIMESTAMP Schedule End Time
27 WO_SCHED_HRS Number(15,2) DECIMAL(14,2) NOT NULL Scheduled Hours
28 REMAINING_MAN_HRS Number(15,2) DECIMAL(14,2) NOT NULL Carryover Hours
29 COMPLETE_HRS Number(15,2) DECIMAL(14,2) NOT NULL Completed hours
30 COMPLTED_DT Date(10) DATE Completed Date