WM_APPR_PM_VW

(SQL View)
 Index Back

SELECT DISTINCT X.BUSINESS_UNIT , X.PM_SCHD_ID , X.EFFDT , U.EOAWSTEP_STATUS , U.OPRID , W.SUBMIT_DTTM , A.BUSINESS_UNIT_AM , A.ASSET_ID , A.MAINT_TYPE , A.START_DATE , W.THRESHOLD_PCT , W.PM_LEAD_DAYS , W.INTERVAL_VAL , W.PM_TM_SCHD_TYPE , W.PM_SCHD_OPT , W.WO_TEMPLATE_ID FROM PS_WM_PM_AW X , PS_EOAW_STEPINST S , PS_EOAW_USERINST U , PS_WM_PM_SCHD_DTL W , PS_WM_PM_SCHD A WHERE X.EOAWTHREAD_ID = S.EOAWTHREAD_ID AND X.EOAWPRCS_ID = S.EOAWPRCS_ID AND S.EOAWSTEP_INSTANCE = U.EOAWSTEP_INSTANCE AND X.BUSINESS_UNIT = W.BUSINESS_UNIT AND X.PM_SCHD_ID = W.PM_SCHD_ID AND X.EFFDT = W.EFFDT AND X.BUSINESS_UNIT = A.BUSINESS_UNIT AND X.PM_SCHD_ID = A.PM_SCHD_ID AND X.EOAWTHREAD_STATUS <> 'T'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
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 EOAWSTEP_STATUS Character(1) VARCHAR2(1) NOT NULL Step Instance Status
A=Approved
B=Pushed back
C=Auto Approved
D=Denied
E=Administrator denied
F=Deleted
G=Bypassed
H=On Hold
I=No Action Taken
K=Skipped
L=Terminated
M=Administrator approved
N=Not Active
P=Pending
R=No longer in role
T=Terminated
U=Auto approved
X=Deleted
Z=Pending Denial
5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: PSOPRDEFN

6 SUBMIT_DTTM DateTime(26) TIMESTAMP Report Submitted On - DateTime
7 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
8 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
9 MAINT_TYPE Character(10) VARCHAR2(10) NOT NULL This field is used for maintenance type
10 START_DATE Date(10) DATE Start Date for Gen Standing PO
11 THRESHOLD_PCT Number(3,0) SMALLINT NOT NULL Confidence %
12 PM_LEAD_DAYS Number(3,0) SMALLINT NOT NULL LEAD DAYS
13 INTERVAL_VAL Number(9,0) DECIMAL(9) NOT NULL Interval
14 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
15 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
16 WO_TEMPLATE_ID Character(25) VARCHAR2(25) NOT NULL Work Order Task/Job Template ID