WM_WOE_VW

(SQL View)
 Index Back

SELECT DISTINCT B.OPRID , B.BUSINESS_UNIT , B.WO_ID , B.WO_TASK_ID , L.EMPLID , B.CHECKED , L.RES_LN_NBR , T.DESCR254 , W.DESCR254 , T.ALERT_INDICATOR , T.BUSINESS_UNIT_AM , T.ASSET_ID , T.ASSET_LOCATION , T.LOCATION , T.STATUS_CD , T.STATUS_DTTM , S.DESCR , T.INTERNAL_STATUS , W.PRIORITY_CD , T.TASK_ACTION , W.SHOP_ID , T.SUPERVISOR , T.REQ_START_DT , T.REQ_START_TIME , T.REQ_END_DT , T.REQ_END_TIME , (CASE WHEN L.SCHED_START_DT IS NULL THEN T.SCHED_START_DT ELSE L.SCHED_START_DT END) , (CASE WHEN L.SCHED_START_TIME IS NULL THEN T.SCHED_START_TIME ELSE L.SCHED_START_TIME END) , (CASE WHEN L.SCHED_END_DT IS NULL THEN T.SCHED_END_DT ELSE L.SCHED_END_DT END) , (CASE WHEN L.SCHED_END_TIME IS NULL THEN T.SCHED_END_TIME ELSE L.SCHED_END_TIME END) , T.BUSINESS_UNIT_PC , T.PROJECT_ID , T.ACTIVITY_ID , T.LEAD_PERSON , T.SCHEDULER_CODE , T.ACTL_START_DT , T.ACTL_START_TIME , T.ACTL_END_DT , T.ACTL_END_TIME , %Sql(WM_TOTAL_HOURS_SEL) , L.TIME_SHEET_ID , (CASE WHEN L.ACTL_SOURCE_CD IS NULL THEN ' ' WHEN L.ACTL_SOURCE_CD = ' ' AND L.ACTL_DURATION > 0 THEN 'T' ELSE L.ACTL_SOURCE_CD END) , %Sql(WM_TIME_SOURCES_SEL) , %Sql(WM_TIME_RECS_SEL) , L.CRAFT_ID , ( SELECT %DatePart(MIN(%Dttm(ACTL_START_DT, ACTL_START_TIME))) FROM PS_WM_WO_SCHED_LBR X WHERE %Join(COMMON_KEYS, WM_WO_SCHED_LBR X, WM_WOE_TW_VW B) AND X.EMPLID = L.EMPLID) , ( SELECT %TimePart(MIN(%Dttm(ACTL_START_DT, ACTL_START_TIME))) FROM PS_WM_WO_SCHED_LBR X WHERE %Join(COMMON_KEYS, WM_WO_SCHED_LBR X, WM_WOE_TW_VW B) AND X.EMPLID = L.EMPLID) , ( SELECT %DatePart(MAX(%Dttm(ACTL_END_DT, ACTL_END_TIME))) FROM PS_WM_WO_SCHED_LBR X WHERE %Join(COMMON_KEYS, WM_WO_SCHED_LBR X, WM_WOE_TW_VW B) AND X.EMPLID = L.EMPLID) , ( SELECT %TimePart(MAX(%Dttm(ACTL_END_DT, ACTL_END_TIME))) FROM PS_WM_WO_SCHED_LBR X WHERE %Join(COMMON_KEYS, WM_WO_SCHED_LBR X, WM_WOE_TW_VW B) AND X.EMPLID = L.EMPLID) , T.SCHED_START_DT , T.SCHED_START_TIME , T.SCHED_END_DT , T.SCHED_END_TIME , T.PROBLEM_GROUP , T.PROBLEM_CD , T.CAUSE_CD , T.RESOLUTION_CD , GIS.SETID , GIS.EFFDT , GIS.ADDRESS1 , GIS.ADDRESS2 , GIS.ADDRESS3 , GIS.ADDRESS4 , GIS.CITY , GIS.STATE , GIS.POSTAL , GIS.COUNTRY , GIS.COUNTRY_2CHAR , GIS.LONGITUDE , GIS.LATITUDE , W.PM_SCHD_ID FROM PS_WM_WOE_TW_VW B JOIN PS_FS_GIS_TASK_VW GIS ON GIS.BUSINESS_UNIT = B.BUSINESS_UNIT AND GIS.WO_ID = B.WO_ID AND GIS.WO_TASK_ID = B.WO_TASK_ID LEFT OUTER JOIN PS_WM_WO_SCHED_LBR L ON %Join(COMMON_KEYS, WM_WOE_TW_VW B, WM_WO_SCHED_LBR L) AND B.RES_LN_NBR = L.RES_LN_NBR , PS_WM_WO_HDR W , PS_WM_WO_TSK T , PS_WM_STATUS_TSK S WHERE %Join(COMMON_KEYS, WM_WOE_TW_VW B, WM_WO_TSK T) AND %Join(COMMON_KEYS, WM_WO_HDR W, WM_WO_TSK T) AND S.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE RECNAME = 'WM_STATUS_TSK' AND SETCNTRLVALUE = T.BUSINESS_UNIT) AND S.STATUS_CD = T.STATUS_CD

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: WM_ELGBL_WRKR

6 CHECKED Character(1) VARCHAR2(1) NOT NULL Check box for Reason Code
N=No
Y=Yes
7 RES_LN_NBR Number(5,0) INTEGER NOT NULL Resource Line No.
8 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
9 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
10 ALERT_INDICATOR Character(3) VARCHAR2(3) NOT NULL Note alert indicator
000=None
001=Outstanding Request
002=Reply Received
11 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

Prompt Table: BUS_UNIT_AM_VW

12 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
13 ASSET_LOCATION Character(10) VARCHAR2(10) NOT NULL Asset Location

Prompt Table: ASSET_LOCATION

14 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL

15 STATUS_CD Character(4) VARCHAR2(4) NOT NULL User defined Status Code

Prompt Table: WM_STATUS_TSK

16 STATUS_DTTM DateTime(26) TIMESTAMP 05/13/02 EGS (CN#PL900-1): Added
17 DESCR Character(30) VARCHAR2(30) NOT NULL Description
18 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
19 PRIORITY_CD Character(3) VARCHAR2(3) NOT NULL Priority Code
20 TASK_ACTION Character(1) VARCHAR2(1) NOT NULL The purpose of this field is to identify the kind of action that may be done for a task.
1=No Change
2=Install Component
3=Repair
4=Remove
5=Retire
6=Remove and Sell
7=Replacement asset
8=Ownership Change
21 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification
22 SUPERVISOR Character(30) VARCHAR2(30) NOT NULL Supervisor

Prompt Table: PERSONAL_DATA

23 REQ_START_DT Date(10) DATE Required Start
24 REQ_START_TIME Time(15) TIMESTAMP Required Start Time
25 REQ_END_DT Date(10) DATE Required End
26 REQ_END_TIME Time(15) TIMESTAMP Required End Time
27 SCHED_START_DT Date(10) DATE Scheduled Start Date
28 SCHED_START_TIME Time(15) TIMESTAMP Schedule Start Time
29 SCHED_END_DT Date(10) DATE Scheduled End Date
30 SCHED_END_TIME Time(15) TIMESTAMP Schedule End Time
31 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Default Value: BUS_UNIT_TBL_WM.BUSINESS_UNIT_PC

32 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Default Value: WM_WO_HDR.PROJECT_ID

Prompt Table: WM_PC_PRJ_VW

33 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: PROJ_ACTIVITY

34 LEAD_PERSON Character(30) VARCHAR2(30) NOT NULL Lead Person

Prompt Table: PERSONAL_DATA

35 SCHEDULER_CODE Character(10) VARCHAR2(10) NOT NULL Scheduler Code

Prompt Table: WM_SHOP_SCHEDLR

36 ACTL_START_DT Date(10) DATE Actual Start Date
37 ACTL_START_TIME Time(15) TIMESTAMP Actual Start Time
38 ACTL_END_DT Date(10) DATE Actual End Date
39 ACTL_END_TIME Time(15) TIMESTAMP Actual End Time
40 ACTL_DURATION Signed Number(9,2) DECIMAL(7,2) NOT NULL Actual Duration
41 TIME_SHEET_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)
42 ACTL_SOURCE_CD Character(2) VARCHAR2(2) NOT NULL Actuals Source Code
2=Multiple Sources
A=Actual Hours
I=Mobile Inspection
M=My Tasks
T=Elapsed Time Entry
W=Work Order Completion
43 WM_NO_TRANS Number(10,0) DECIMAL(10) NOT NULL Number of Transactions
44 WM_LABOR_COUNT Number(3,0) SMALLINT NOT NULL Count Work Field
45 CRAFT_ID Character(16) VARCHAR2(16) NOT NULL Craft Identification

Prompt Table: RS_CRAFT_DETAIL

46 START_DT Date(10) DATE Start Date
47 START_TIME Time(15) TIMESTAMP Start of Shift
48 END_DT Date(10) DATE End Date
49 END_TIME Time(15) TIMESTAMP End of Shift
50 START_DATE Date(10) DATE Start Date for Gen Standing PO
51 START_TM Time(15) TIMESTAMP Represents the process starting time associated with position calculation.
52 END_DATE Date(10) DATE End Date
53 END_TM Time(15) TIMESTAMP End Time
54 PROBLEM_GROUP Character(15) VARCHAR2(15) NOT NULL Problem Group

Prompt Table: WM_PCR_CLSF_DVW

55 PROBLEM_CD Character(15) VARCHAR2(15) NOT NULL Problem code

Prompt Table: WM_PCR_PRBAC_VW

56 CAUSE_CD Character(15) VARCHAR2(15) NOT NULL Cause Code

Prompt Table: WM_PCR_CSEAC_VW

57 RESOLUTION_CD Character(15) VARCHAR2(15) NOT NULL Resolution code

Prompt Table: WM_PCR_RESAC_VW

58 SETID Character(5) VARCHAR2(5) NOT NULL SetID
59 EFFDT Date(10) DATE Effective Date

Default Value: %date

60 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
61 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
62 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
63 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
64 CITY Character(30) VARCHAR2(30) NOT NULL City
65 STATE Character(6) VARCHAR2(6) NOT NULL State
66 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
67 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
68 COUNTRY_2CHAR Character(2) VARCHAR2(2) NOT NULL 2-Char Country Code
69 LONGITUDE Signed Number(12,7) DECIMAL(10,7) NOT NULL Longitude
70 LATITUDE Signed Number(12,7) DECIMAL(10,7) NOT NULL Latitude
71 PM_SCHD_ID Character(10) VARCHAR2(10) NOT NULL Preventive Maintenance Schedule ID