WM_PM_PJC_VW

(SQL View)
 Index Back

Projection Record


SELECT A.PROCESS_INSTANCE , A.BUSINESS_UNIT , A.PM_SCHD_ID , A.BUSINESS_UNIT_AM , A.ASSET_ID , A.NEXT_DUE_DT , A.NEXT_RDG , A.MAINT_TYPE , A.PERCENT_DUE , A.SETID , A.MAINT_LOOP_ID , A.LOCATION , A.PJC_ID , D.WM_PM_RUN_DTTM , B.DESCR , B.ASSET_TYPE , B.ASSET_SUBTYPE , B.MODEL , B.MFG_ID , B.MANUFACTURER , D.OPRID , D.RUN_CNTL_ID , D.REQUEST_ID , D.REQUEST_DT , D.DESCR , D.PM_SELCT_TYPE , D.SAMPLING_METHOD , D.SAMPLING_SIZE , D.PROJECTED_FROM , D.FROM_DATE , D.TO_DATE , D.PM_OCCURRENCES , A.CREATE_WO_FLG FROM PS_WM_PM_PJC A , PS_ASSET B , PS_WM_PM_PJC_RUN D WHERE A.BUSINESS_UNIT_AM = B.BUSINESS_UNIT AND A.ASSET_ID = B.ASSET_ID AND A.PROCESS_INSTANCE = D.PROCESS_INSTANCE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 PM_SCHD_ID Character(10) VARCHAR2(10) NOT NULL Preventive Maintenance Schedule ID
4 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
5 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
6 NEXT_DUE_DT Date(10) DATE Preventive Maintenance due date
7 NEXT_RDG Signed Number(21,4) DECIMAL(19,4) NOT NULL Next preventive maintenance due reading
8 MAINT_TYPE Character(10) VARCHAR2(10) NOT NULL This field is used for maintenance type
9 PERCENT_DUE Signed Number(16,0) DECIMAL(15) NOT NULL Preventive Maintenance percent due
10 SETID Character(5) VARCHAR2(5) NOT NULL SetID
11 MAINT_LOOP_ID Character(15) VARCHAR2(15) NOT NULL Maintenance Loop ID
12 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
13 PJC_ID Character(10) VARCHAR2(10) NOT NULL Projection ID
14 WM_PM_RUN_DTTM DateTime(26) TIMESTAMP Process Run Date Time
15 DESCR Character(30) VARCHAR2(30) NOT NULL Description
16 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
17 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype
18 MODEL Character(30) VARCHAR2(30) NOT NULL Model
19 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
20 MANUFACTURER Character(60) VARCHAR2(60) NOT NULL Manufacturer Name
21 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Default Value: OPR_DEF_TBL_WM.OPRID

Prompt Table: OPR_DEF_TBL_FS
Set Control Field: OPRID

22 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
23 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
24 REQUEST_DT Date(10) DATE Request Date
25 DESCR_2 Character(30) VARCHAR2(30) NOT NULL Description
26 PM_SELCT_TYPE Character(1) VARCHAR2(1) NOT NULL Selection Type
1=All business units
2=AM business unit list
3=Location list
4=Asset classification
5=Maintenance type list
6=PM schedule selection
7=WO business unit list
8=Projection List
9=Shop List

Default Value: 1

27 SAMPLING_METHOD Character(4) VARCHAR2(4) NOT NULL Used in Preventive Maintenance to allow the system to project the meter usage based on historic data (the sample).
CYCL=Cycles
DAYS=Days
READ=Readings
28 SAMPLING_SIZE Number(5,0) INTEGER NOT NULL Used in Preventive Maintenance to allow the system to project the meter usage based on historic data (the sample).
29 PROJECTED_FROM Character(4) VARCHAR2(4) NOT NULL Used in Preventive Maintenance to calculate PM's start date based on projection of meter usage.
LAST=Last PM Completion Date
THRU=Current System Date
30 FROM_DATE Date(10) DATE From Date
31 TO_DATE Date(10) DATE To Date
32 PM_OCCURRENCES Number(3,0) SMALLINT NOT NULL Occurrences
33 CREATE_WO_FLG Character(1) VARCHAR2(1) NOT NULL Create Work Order