WM_PM_SRCH2_VW

(SQL View)
 Index Back

PM Schedule Detail

Preventive Maintenance Schedule Detail

SELECT OPRID , WM_FLEXSRCH_ID , BUSINESS_UNIT , PM_SCHD_ID , MAINT_LOOP_ID , PM_TM_SCHD_TYPE , STATUS_CD , WM_PM_APPR_STATUS , BUSINESS_UNIT_AM , ASSET_ID , ASSET_TYPE , ASSET_SUBTYPE ,TAG_NUMBER , SERIAL_ID , ASSET_LOCATION , AREA_ID ,MFG_ID , MODEL , ASSET_CRITICALITY FROM PS_WM_PM_SRCH

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Default Value: OPR_DEF_TBL_FS.OPRID

2 WM_FLEXSRCH_ID Character(15) VARCHAR2(15) NOT NULL Search Name
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_WM.BUSINESS_UNIT

Prompt Table: SP_BU_WM_NONVW

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

Prompt Table: WM_PM_SCHDT3_VW
Set Control Field: BUSINESS_UNIT

5 MAINT_LOOP_ID Character(15) VARCHAR2(15) NOT NULL Loop ID

Prompt Table: WM_PM_LOOP_HDR
Set Control Field: BUSINESS_UNIT

6 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
7 STATUS_CD Character(4) VARCHAR2(4) NOT NULL User defined Status Code

Prompt Table: WM_STATUS_TSK_O
Set Control Field: BUSINESS_UNIT

8 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
9 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

Prompt Table: SP_BU_AM_NONVW

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

Prompt Table: WM_ASSET_VW

11 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
12 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Subtype

Prompt Table: AM_SUBTYPE
Set Control Field: BUSINESS_UNIT_AM

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

Prompt Table: WM_ASSET_VW9T1

14 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID

Prompt Table: WM_ASSET_VW9S

15 ASSET_LOCATION Character(10) VARCHAR2(10) NOT NULL Asset Location

Prompt Table: LOCATION_VW
Set Control Field: BUSINESS_UNIT_AM

16 AREA_ID Character(10) VARCHAR2(10) NOT NULL Area ID

Prompt Table: WM_AREA_PMT_VW
Set Control Field: BUSINESS_UNIT_AM

17 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

Prompt Table: WM_MANUFACTURER
Set Control Field: BUSINESS_UNIT_AM

18 MODEL Character(30) VARCHAR2(30) NOT NULL Model

Prompt Table: MFG_MODEL
Set Control Field: BUSINESS_UNIT_AM

19 ASSET_CRITICALITY Character(2) VARCHAR2(2) NOT NULL Asset Criticality

Prompt Table: AM_CRIT_LVL