WM_RESCHED_VW

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT , A.WO_ID , A.WO_TASK_ID , A.RQMT_LN_NBR , A.SEQ_NBR_5 , B.CRAFT_ID , A.CREW_BU , A.CREW_SHOP , A.CREW_ID , A.SCHED_PATTERN , A.SCHED_START_DT , A.SCHED_START_TIME , A.SCHED_END_DT , A.SCHED_END_TIME , A.CREW_SCHED_STATUS , A.REMAINING_MAN_HRS , A.COMPLETE_HRS , A.REASON_CD , A.DESCRLONG , A.LAST_UPDATE_DT , A.LAST_UPDATED_BY FROM PS_WM_RESCHED_HST A , PS_WM_WO_RQMT_LBR B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.WO_ID = B.WO_ID AND A.WO_TASK_ID = B.WO_TASK_ID AND A.RQMT_LN_NBR = B.RQMT_LN_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
3 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number
4 RQMT_LN_NBR Number(5,0) INTEGER NOT NULL Requirement Line Number
5 SEQ_NBR_5 Number(5,0) INTEGER NOT NULL Sequence number five digits long
6 CRAFT_ID Character(16) VARCHAR2(16) NOT NULL Craft Identification
7 CREW_BU Character(5) VARCHAR2(5) NOT NULL Crew Business Unit
8 CREW_SHOP Character(10) VARCHAR2(10) NOT NULL Crew Shop ID
9 CREW_ID Character(10) VARCHAR2(10) NOT NULL Crew Name
10 SCHED_PATTERN Character(5) VARCHAR2(5) NOT NULL Schedule Pattern
11 SCHED_START_DT Date(10) DATE Scheduled Start Date
12 SCHED_START_TIME Time(15) TIMESTAMP Schedule Start Time
13 SCHED_END_DT Date(10) DATE Scheduled End Date
14 SCHED_END_TIME Time(15) TIMESTAMP Schedule End Time
15 CREW_SCHED_STATUS Character(1) VARCHAR2(1) NOT NULL Crew Schedule Status
1=Unscheduled
2=Scheduled
3=Unplanned / Emergency
4=Schedule Confirmed
16 REMAINING_MAN_HRS Number(15,2) DECIMAL(14,2) NOT NULL Carryover Hours
17 COMPLETE_HRS Number(15,2) DECIMAL(14,2) NOT NULL Completed hours
18 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code
19 DESCRLONG Long Character CLOB Long Description
20 LAST_UPDATE_DT Date(10) DATE Last Updated
21 LAST_UPDATED_BY Character(30) VARCHAR2(30) NOT NULL LastUpdatedUser