WM_PM_SCH_SVW

(SQL View)
 Index Back

PM Schedule Search View

PM Schedule Search View

SELECT A.BUSINESS_UNIT , A.PM_SCHD_ID , A.MAINT_TYPE , A.BUSINESS_UNIT_AM , B.ASSET_TYPE , B.ASSET_SUBTYPE , A.ASSET_ID , B.TAG_NUMBER , B.SERIAL_ID , B.VIN , A.MAINT_LOOP_ID , A.LOCATION , A.DESCR100 FROM PS_WM_PM_SCHD A LEFT OUTER JOIN PS_ASSET B ON A.BUSINESS_UNIT_AM = B.BUSINESS_UNIT AND A.ASSET_ID = B.ASSET_ID

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

Default Value: OPR_DEF_TBL_WM.BUSINESS_UNIT

Prompt Table: SP_BU_WM_NONVW

2 PM_SCHD_ID Character(10) VARCHAR2(10) NOT NULL Preventive Maintenance Schedule ID

Default Value: NEXT

3 MAINT_TYPE Character(10) VARCHAR2(10) NOT NULL This field is used for maintenance type

Prompt Table: MAINT_TYPE_TBL
Set Control Field: BUSINESS_UNIT

4 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

Default Value: OPR_DEF_TBL_WM.BUSINESS_UNIT_AM

Prompt Table: SP_BU_AM_NONVW

5 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
6 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype

Prompt Table: AM_SUBTYPE
Set Control Field: BUSINESS_UNIT_AM

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

Prompt Table: WM_ASSET_VW

8 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number

Prompt Table: WM_ASSET_VW9T1

9 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
10 VIN Character(18) VARCHAR2(18) NOT NULL VIN
11 MAINT_LOOP_ID Character(15) VARCHAR2(15) NOT NULL Maintenance Loop ID
12 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
13 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description