WM_WO_TLS_VW(SQL View) |
Index Back |
---|---|
WO Tools/Resource Assets ViewView on AM Asset Repository (ASSET) table -- selection includes "Tools/Resource" assets only; e.g., used as prompt table for WO Task Template Tools Requirement lookups |
SELECT B.SETID , A.BUSINESS_UNIT AS BUSINESS_UNIT_AM , A.ASSET_ID , A.DESCR , A.DESCRSHORT , A.TAG_NUMBER , A.SERIAL_ID , A.ASSET_TYPE , A.ASSET_SUBTYPE , A.MFG_ID , A.MANUFACTURER , A.MODEL , A.ASSET_RESOURCE_SW , A.SCHEDULABLE_SW , A.REPAIRABLE_FLG , A.EPL_TMPL_ID FROM PS_WM_ASSETBASE_VW A , PS_SET_CNTRL_REC B WHERE A.ASSET_RESOURCE_SW = 'Y' AND A.ASSET_TYPE <> ' ' AND A.ASSET_SUBTYPE <> ' ' AND B.SETCNTRLVALUE = A.BUSINESS_UNIT AND B.REC_GROUP_ID = 'AM_15' AND B.RECNAME = 'AM_SUBTYPE' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
2 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL |
AM Business Unit
Prompt Table: SP_BU_AM_NONVW |
3 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
6 | TAG_NUMBER | Character(12) | VARCHAR2(12) NOT NULL | Tag Number |
7 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
8 | 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 |
9 | ASSET_SUBTYPE | Character(15) | VARCHAR2(15) NOT NULL |
Asset Subtype
Prompt Table: AM_SUBTYPE |
10 | MFG_ID | Character(50) | VARCHAR2(50) NOT NULL |
Manufacturer ID
Prompt Table: MANUFACTURER |
11 | MANUFACTURER | Character(60) | VARCHAR2(60) NOT NULL |
Manufacturer Name
Prompt Table: MANUF_FS_VW |
12 | MODEL | Character(30) | VARCHAR2(30) NOT NULL | Model |
13 | ASSET_RESOURCE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Field to indicate that an Asset is used as a tool or resource
Y/N Table Edit Default Value: N |
14 | SCHEDULABLE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Schedulable Switch
Y/N Table Edit Default Value: N |
15 | REPAIRABLE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Repairable Flag
Y/N Table Edit Default Value: N |
16 | EPL_TMPL_ID | Character(15) | VARCHAR2(15) NOT NULL |
Parts List Template
Prompt Table: EPL_LOOKUP_VW |