WM_PMSCHDTL_V2

(SQL View)
 Index Back

PM Schedule Detail View

Preventive Maintenance Schedule Detail View Used by PM Mass Update to avoid SV117: The join condition cannot include any subqueries.

SELECT A.BUSINESS_UNIT , A.PM_SCHD_ID , B.EFFDT , B.EFF_STATUS , A.BUSINESS_UNIT_AM , A.ASSET_ID , A.MAINT_LOOP_ID , A.LOCATION , A.MAINT_TYPE , A.DESCR100 , A.START_DATE , A.FIRST_CYCLE_FLG , A.LAST_REVIEWED_DTTM , A.LAST_REVIEWED_BY , B.WO_TEMPLATE_ID , B.THRESHOLD_PCT , B.PM_SCHD_OPT , B.PM_TM_SCHD_TYPE , B.SCHED_DATE , B.INTERVAL_VAL , B.INTERVAL_START_FRM , B.DAY_OFWEEK , B.DATE_OF_MONTH , B.WEEK_OF_MONTH , B.START_FR_END_MONTH , B.DURATION_MLTP , B.SRVC_GRP_ID , B.WO_TYPE , B.BUSINESS_UNIT_PC , B.PROJECT_ID , B.ACTIVITY_ID , B.SHOP_ID , B.PRIORITY_CD , B.STATUS_CD , B.INTERNAL_STATUS , B.STATUS_CD_HDR , B.WO_APPROVAL_STATUS , B.WO_APPRVL_FLG , B.DESCR254 , B.ANNUAL_OCCURANCE , B.CBM_ALERT , B.CBM_SOURCE , B.PROCESS_INSTANCE , B.IN_PROCESS_FLG , B.PM_LEAD_DAYS , B.EMPLID , B.CREW_ID FROM PS_WM_PM_SCHD A , PS_WM_PM_SCHD_DTL B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PM_SCHD_ID = B.PM_SCHD_ID AND B.EFFDT = ( SELECT MAX( D.EFFDT ) FROM PS_WM_PM_SCHD_DTL D WHERE D.BUSINESS_UNIT = B.BUSINESS_UNIT AND D.PM_SCHD_ID = B.PM_SCHD_ID AND D.EFFDT <= %CurrentDateIn )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BUS_UNIT_TBL_WM

2 PM_SCHD_ID Character(10) VARCHAR2(10) NOT NULL Preventive Maintenance Schedule ID
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
5 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

Prompt Table: SP_BU_AM_NONVW

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

Prompt Table: WM_ASSET_VWA

7 MAINT_LOOP_ID Character(15) VARCHAR2(15) NOT NULL Maintenance Loop ID
8 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
9 MAINT_TYPE Character(10) VARCHAR2(10) NOT NULL This field is used for maintenance type

Prompt Table: MAINT_TYPE_TBL

10 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
11 START_DATE Date(10) DATE NOT NULL Start Date for Gen Standing PO
12 FIRST_CYCLE_FLG Character(1) VARCHAR2(1) NOT NULL First Maintenance Cycle

Default Value: Y

13 LAST_REVIEWED_DTTM DateTime(26) TIMESTAMP Last Reviewed
14 LAST_REVIEWED_BY Character(30) VARCHAR2(30) NOT NULL Last reviewed by
15 WO_TEMPLATE_ID Character(25) VARCHAR2(25) NOT NULL Work Order Task/Job Template ID

Prompt Table: WM_WO_JTMPL_VW2
Set Control Field: BUSINESS_UNIT

16 THRESHOLD_PCT Number(3,0) SMALLINT NOT NULL Confidence %

Default Value: 100

17 PM_SCHD_OPT Character(1) VARCHAR2(1) NOT NULL Scheduling Option
1=One Cycle
2=Multiple Cycles Multiple WO
3=Multiple Cycles One WO
4=Non-recurring

Default Value: 1

18 PM_TM_SCHD_TYPE Character(1) VARCHAR2(1) NOT NULL Schedule Type
1=None
2=Specific Date
3=Daily
4=Weekly by Day
5=Monthly by Day
6=Monthly by Date
7=On Demand
19 SCHED_DATE Date(10) DATE Schedule Date
20 INTERVAL_VAL Number(9,0) DECIMAL(9) NOT NULL Interval
21 INTERVAL_START_FRM Character(1) VARCHAR2(1) NOT NULL From the last PM completion
N=No
Y=Yes

Default Value: Y

22 DAY_OFWEEK Character(1) VARCHAR2(1) NOT NULL Day
0=0: Sunday
1=1: Monday
2=2: Tuesday
3=3 :Wednesday
4=4: Thursday
5=5: Friday
6=6: Saturday
23 DATE_OF_MONTH Character(2) VARCHAR2(2) NOT NULL Date of the Month
24 WEEK_OF_MONTH Character(1) VARCHAR2(1) NOT NULL Week of the month
1=1st
2=2nd
3=3rd
4=4th
5=Last
25 START_FR_END_MONTH Character(1) VARCHAR2(1) NOT NULL From the end of the month
N=No
Y=Yes

Default Value: N

26 DURATION_MLTP Number(6,2) DECIMAL(5,2) NOT NULL Duration Multiple

Default Value: 1

27 SRVC_GRP_ID Character(10) VARCHAR2(10) NOT NULL Service Group

Prompt Table: WM_SRVC_GRP_BU

28 WO_TYPE Character(5) VARCHAR2(5) NOT NULL Work Order Type

Prompt Table: WM_WO_TYPE

29 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
30 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: WM_PM_PC_PRJ_VW

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

Prompt Table: PROJ_ACT_FS

32 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification

Prompt Table: WM_SRVC_SHOP_VW

33 PRIORITY_CD Character(3) VARCHAR2(3) NOT NULL Priority Code

Prompt Table: WM_PRIORITY

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

Prompt Table: WM_STATUS_TSK_O
Set Control Field: BUSINESS_UNIT

35 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

Default Value: 01

36 STATUS_CD_HDR Character(4) VARCHAR2(4) NOT NULL Header Status

Prompt Table: WM_STATUS_HDR

37 WO_APPROVAL_STATUS Character(1) VARCHAR2(1) NOT NULL work order approval status
A=Approved
C=Cancelled
E=Denied
I=Initial
P=Pending Approval

Default Value: A

38 WO_APPRVL_FLG Character(1) VARCHAR2(1) NOT NULL Work Management Approval
1=Pre-Approved
3=Workflow Approval
39 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
40 ANNUAL_OCCURANCE Character(1) VARCHAR2(1) NOT NULL Annual Occurance
41 CBM_ALERT Character(1) VARCHAR2(1) NOT NULL Force WO. Disregard options.
1=On
2=Off
42 CBM_SOURCE Character(1) VARCHAR2(1) NOT NULL CBM Alert source
1=AM Reading Tolerance
2=MM Alert
3=Alert set manually
43 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
44 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag

Default Value: N

45 PM_LEAD_DAYS Number(3,0) SMALLINT NOT NULL LEAD DAYS
46 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: WM_ELGBL_WRKR

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

Prompt Table: WM_PREFCREW2_VW