WM_PM_SCHD5_VW

(SQL View)
 Index Back

PM Schedule Detail

Preventive Maintenance Schedule Detail

SELECT A.BUSINESS_UNIT , A.PM_SCHD_ID , A.EFFDT , B.BUSINESS_UNIT_AM , B.ASSET_ID , B.MAINT_LOOP_ID , B.LOCATION , B.MAINT_TYPE , B.DESCR100 , B.START_DATE , B.FIRST_CYCLE_FLG ,B.LAST_REVIEWED_DTTM ,B.LAST_REVIEWED_BY ,B.HAZARDOUS_SW ,A.EFF_STATUS ,A.WO_TEMPLATE_ID ,A.THRESHOLD_PCT ,A.PM_SCHD_OPT ,A.PM_TM_SCHD_TYPE ,A.SCHED_DATE ,A.INTERVAL_VAL ,A.INTERVAL_START_FRM ,A.DAY_OFWEEK ,A.DATE_OF_MONTH ,A.WEEK_OF_MONTH ,A.START_FR_END_MONTH ,A.DURATION_MLTP ,A.SRVC_GRP_ID ,A.WO_TYPE ,A.BUSINESS_UNIT_PC ,A.PROJECT_ID ,A.ACTIVITY_ID ,A.SHOP_ID ,A.PRIORITY_CD ,A.STATUS_CD ,A.INTERNAL_STATUS ,A.STATUS_CD_HDR ,A.WO_APPROVAL_STATUS ,A.WO_APPRVL_FLG ,A.DESCR254 ,A.ANNUAL_OCCURANCE ,A.CBM_ALERT ,A.CBM_SOURCE ,A.PM_LEAD_DAYS ,A.WM_PM_LINK_FLAG ,A.WM_PM_APPR_STATUS ,A.WM_PM_APPRVL_FLG ,A.HOLIDAY_LIST_ID ,A.SUBMIT_DTTM ,A.OPRID ,A.WM_PARENTCHILD_FLG ,A.PROCESS_INSTANCE ,A.IN_PROCESS_FLG , D.TAG_NUMBER , D.DESCR , D.SERIAL_ID , D.VIN , D.ASSET_TYPE , D.ASSET_SUBTYPE FROM PS_WM_PM_SCHD_DTL A , PS_WM_PM_SCHD B , PS_ASSET D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PM_SCHD_ID = B.PM_SCHD_ID AND B.BUSINESS_UNIT_AM = D.BUSINESS_UNIT AND B.ASSET_ID = D.ASSET_ID

# 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 NOT NULL Effective Date

Default Value: %date

4 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
5 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

Prompt Table: WM_ASSET_VW

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

Prompt Table: WM_MAINT_DVW
Set Control Field: BUSINESS_UNIT

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

Default Value: Y

12 LAST_REVIEWED_DTTM DateTime(26) TIMESTAMP Last Reviewed
13 LAST_REVIEWED_BY Character(30) VARCHAR2(30) NOT NULL Last reviewed by
14 HAZARDOUS_SW Character(1) VARCHAR2(1) NOT NULL Hazardous Asset

Y/N Table Edit

Default Value: N

15 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

16 WO_TEMPLATE_ID Character(25) VARCHAR2(25) NOT NULL Work Order Task/Job Template ID

Prompt Table: %EDITTABLE
Set Control Field: BUSINESS_UNIT

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

Default Value: 100

18 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

19 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
20 SCHED_DATE Date(10) DATE Schedule Date
21 INTERVAL_VAL Number(9,0) DECIMAL(9) NOT NULL Interval
22 INTERVAL_START_FRM Character(1) VARCHAR2(1) NOT NULL From the last PM completion
N=No
Y=Yes

Default Value: Y

23 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
24 DATE_OF_MONTH Character(2) VARCHAR2(2) NOT NULL Date of the Month
25 WEEK_OF_MONTH Character(1) VARCHAR2(1) NOT NULL Week of the month
1=1st
2=2nd
3=3rd
4=4th
5=Last
26 START_FR_END_MONTH Character(1) VARCHAR2(1) NOT NULL From the end of the month
N=No
Y=Yes

Default Value: N

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

Default Value: 1

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

Prompt Table: WM_SRVC_GRP_BU

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

Prompt Table: WM_WO_TYPE

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

Prompt Table: WM_PC_PRJ_DVW2

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

Prompt Table: PROJ_ACT_FS

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

Prompt Table: WM_SRVC_SHOP_VW

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

Prompt Table: WM_PRIORITY

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

Prompt Table: WM_STATUS_TSK_O
Set Control Field: BUSINESS_UNIT

36 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

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

Prompt Table: WM_STATUS_HDR

38 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

39 WO_APPRVL_FLG Character(1) VARCHAR2(1) NOT NULL Work Management Approval
1=Pre-Approved
3=Workflow Approval
40 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
41 ANNUAL_OCCURANCE Character(1) VARCHAR2(1) NOT NULL Annual Occurance
42 CBM_ALERT Character(1) VARCHAR2(1) NOT NULL Force WO. Disregard options.
1=On
2=Off

Default Value: 2

43 CBM_SOURCE Character(1) VARCHAR2(1) NOT NULL CBM Alert source
1=AM Reading Tolerance
2=MM Alert
3=Alert set manually
44 PM_LEAD_DAYS Number(3,0) SMALLINT NOT NULL LEAD DAYS
45 WM_PM_LINK_FLAG Character(1) VARCHAR2(1) NOT NULL Linked

Default Value: N

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

Default Value: I

47 WM_PM_APPRVL_FLG Character(1) VARCHAR2(1) NOT NULL Work Management Approval
1=Pre-Approved
3=Workflow Approval
48 HOLIDAY_LIST_ID Character(10) VARCHAR2(10) NOT NULL This is used to identify what holiday calendar to use. This is the access field for all financials groups.

Prompt Table: BUS_CAL_HOL_DFN

49 SUBMIT_DTTM DateTime(26) TIMESTAMP Report Submitted On - DateTime
50 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Default Value: OPR_DEF_TBL_FS.OPRID

51 WM_PARENTCHILD_FLG Character(1) VARCHAR2(1) NOT NULL Parent/Child

Y/N Table Edit

Default Value: N

52 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
53 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag

Default Value: N

54 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
55 DESCR Character(30) VARCHAR2(30) NOT NULL Description
56 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
57 VIN Character(18) VARCHAR2(18) NOT NULL VIN
58 ASSET_TYPE Character(3) VARCHAR2(3) NOT NULL Asset Type
010=IT Hardware
020=IT Software
040=Equipment
050=Property
060=Fleet
070=Machinery
080=Furniture
090=Facility
100=Intangible
200=Asset Retirement Obligations
999=Other
59 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype