WM_WO_INSP_S_VW

(SQL View)
 Index Back

Inspection Search View


SELECT DISTINCT A.BUSINESS_UNIT , A.WO_ID , A.WO_TASK_ID , A.INSPECTION_ID , A.EMPLID , I.DESCR254 , W.DESCR254 , T.ALERT_INDICATOR , T.BUSINESS_UNIT_AM , T.ASSET_ID , AM.DESCR_LONG , AM.DESCR , T.ASSET_LOCATION , T.LOCATION , I.WO_INSPECT_STATUS , I.INSP_RSLT_STAT_VAL , I.WO_DURATION , I.WO_DURATION2 , T.STATUS_CD , T.STATUS_DTTM , 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.PROBLEM_GROUP , T.PROBLEM_CD , T.CAUSE_CD , T.RESOLUTION_CD FROM PS_WM_WO_INSPC_ACT A LEFT OUTER JOIN PS_WM_WO_SCHED_LBR L ON %Join(COMMON_KEYS, WM_WO_INSPC_ACT A, WM_WO_SCHED_LBR L) AND A.EMPLID = L.EMPLID , PS_WM_WO_INSPC_HDR I , PS_WM_WO_TSK T , PS_WM_WO_HDR W , PS_ASSET AM WHERE %Join(COMMON_KEYS, WM_WO_INSPC_ACT A, WM_WO_INSPC_HDR I) AND %Join(COMMON_KEYS, WM_WO_INSPC_ACT A, WM_WO_TSK T) AND %Join(COMMON_KEYS, WM_WO_INSPC_ACT A, WM_WO_HDR W) AND T.BUSINESS_UNIT_AM = AM.BUSINESS_UNIT AND T.ASSET_ID = AM.ASSET_ID

# 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 INSPECTION_ID Character(10) VARCHAR2(10) NOT NULL Inspection ID
5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
6 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
7 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
8 ALERT_INDICATOR Character(3) VARCHAR2(3) NOT NULL Note alert indicator
000=None
001=Outstanding Request
002=Reply Received
9 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

Prompt Table: BUS_UNIT_AM_VW

10 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
11 ASSET_DESCR Character(254) VARCHAR2(254) NOT NULL Asset Description
12 ASSET_DESCR30 Character(30) VARCHAR2(30) NOT NULL Asset Description
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 WO_INSPECT_STATUS Character(2) VARCHAR2(2) NOT NULL Inspection Status
01=Created
02=Assigned
03=In Progress
09=Completed
99=Terminated
16 INSP_RSLT_STAT_VAL Character(10) VARCHAR2(10) NOT NULL Result Status Value

Prompt Table: WM_WO_IPRSVL_VW

17 WO_DURATION Number(8,2) DECIMAL(7,2) NOT NULL Estimated Work Order Duration
18 WO_DURATION2 Number(8,2) DECIMAL(7,2) NOT NULL Work Order Duration
19 STATUS_CD Character(4) VARCHAR2(4) NOT NULL User defined Status Code
20 STATUS_DTTM DateTime(26) TIMESTAMP 05/13/02 EGS (CN#PL900-1): Added
21 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
22 PRIORITY_CD Character(3) VARCHAR2(3) NOT NULL Priority Code
23 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
24 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification
25 SUPERVISOR Character(30) VARCHAR2(30) NOT NULL Supervisor

Prompt Table: PERSONAL_DATA

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

Default Value: BUS_UNIT_TBL_WM.BUSINESS_UNIT_PC

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

Default Value: WM_WO_HDR.PROJECT_ID

Prompt Table: WM_PC_PRJ_VW

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

Prompt Table: PROJ_ACTIVITY

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

Prompt Table: PERSONAL_DATA

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

Prompt Table: WM_SHOP_SCHEDLR

39 PROBLEM_GROUP Character(15) VARCHAR2(15) NOT NULL Problem Group

Prompt Table: WM_PCR_CLSF_DVW

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

Prompt Table: WM_PCR_PRBAC_VW

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

Prompt Table: WM_PCR_CSEAC_VW

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

Prompt Table: WM_PCR_RESAC_VW