WM_HGRID

(SQL View)
Index Back

Asset Hierarchy view

Asset Hierarchy view

SELECT 'S' , 'N' , A.TAG_NUMBER , A.SERIAL_ID , A.VIN , A.DESCR_LONG , L.LOCATION , L.AREA_ID , A.ASSET_TYPE , A.ASSET_SUBTYPE , A.MANUFACTURER , A.MODEL , A.BUSINESS_UNIT , A.ASSET_ID , A.ASSET_STATUS , A.ASSET_CRITICALITY , A.LINEAR_ASSET_SW , A.COMPONENT_OF_ID , A.COMPONENT_OF_ID , 0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 FROM PS_WM_ASSETBASE_VW A , PS_ASSET_LOCATION L WHERE A.BUSINESS_UNIT = L.BUSINESS_UNIT AND A.ASSET_ID = L.ASSET_ID AND L.EFFDT = ( SELECT MAX(L2.EFFDT) FROM PS_ASSET_LOCATION L2 WHERE L2.BUSINESS_UNIT = L.BUSINESS_UNIT AND L2.ASSET_ID = L.ASSET_ID) AND L.EFFSEQ = ( SELECT MAX(L2.EFFSEQ) FROM PS_ASSET_LOCATION L2 WHERE L2.BUSINESS_UNIT = L.BUSINESS_UNIT AND L2.ASSET_ID = L.ASSET_ID AND L2.EFFDT = L.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SELECT_PB Character(1) VARCHAR2(1) NOT NULL Select
2 SELECT_FLAG Character(1) VARCHAR2(1) NOT NULL Selection Flag
N=No
Y=Yes
3 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
4 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
5 VIN Character(18) VARCHAR2(18) NOT NULL VIN
6 DESCR_LONG Character(254) VARCHAR2(254) NOT NULL Long Description
7 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
8 AREA_ID Character(10) VARCHAR2(10) NOT NULL Area ID
9 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
10 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype
11 MANUFACTURER Character(60) VARCHAR2(60) NOT NULL Manufacturer Name
12 MODEL Character(30) VARCHAR2(30) NOT NULL Model
13 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
14 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
15 ASSET_STATUS Character(1) VARCHAR2(1) NOT NULL Asset Status
A=Received (Not in Service)
B=Budgeted
C=Commitment
D=Disposed
I=In Service
M=Suspended
R=Requisitioned
T=Transferred
W=Work In Progress

Default Value: I

16 ASSET_CRITICALITY Character(2) VARCHAR2(2) NOT NULL Asset Criticality
17 LINEAR_ASSET_SW Character(1) VARCHAR2(1) NOT NULL Linear Asset

Y/N Table Edit

18 COMPONENT_OF_ID Character(12) VARCHAR2(12) NOT NULL Component of Asset

Prompt Table: AM_COMPONENT

19 COMPONENT_PREV Character(12) VARCHAR2(12) NOT NULL Component of Asset
20 LEVEL_NUM Number(3,0) SMALLINT NOT NULL Level
21 LEVEL1 Number(5,0) INTEGER NOT NULL Level 1
22 LEVEL2 Number(5,0) INTEGER NOT NULL Level 2
23 LEVEL3 Number(5,0) INTEGER NOT NULL Level 3
24 LEVEL4 Number(5,0) INTEGER NOT NULL Level 4
25 LEVEL5 Number(5,0) INTEGER NOT NULL Level 5
26 LEVEL6 Number(5,0) INTEGER NOT NULL Level 6
27 LEVEL7 Number(5,0) INTEGER NOT NULL Level 7
28 LEVEL8 Number(5,0) INTEGER NOT NULL Level 8
29 LEVEL9 Number(5,0) INTEGER NOT NULL Level 9