RS_WM_ASSET

(SQL View)

SELECT A.BUSINESS_UNIT %Concat '' %Concat A.ASSET_ID , A.BUSINESS_UNIT , A.ASSET_ID , A.ASSET_STATUS , A.ASSET_TYPE , A.ASSET_SUBTYPE , A.TAG_NUMBER , A.MODEL , A.SERIAL_ID , A.VIN , A.MFG_ID , %TrimSubstr(A.BUSINESS_UNIT,1,5) %Concat 'x' %Concat %TrimSubstr(A.ASSET_ID, 1,12) AS ASSET_KEY , %TrimSubstr(A.BUSINESS_UNIT_WO,1,5) %Concat 'x' %Concat %TrimSubstr(A.SHOP_ID, 1,10) AS SHOP , A.SYNCDTTM FROM PS_ASSET A WHERE A.ASSET_RESOURCE_SW = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DOCID Character(30) VARCHAR2(30) NOT NULL Unique document id for PTSF

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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

4 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

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

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

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

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

10 VIN Character(18) VARCHAR2(18) NOT NULL VIN

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

12 ASSET_KEY Character(18) VARCHAR2(18) NOT NULL Asset Key Tag

13 SHOP Character(16) VARCHAR2(16) NOT NULL Shop Tag

14 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DOCID	Character(30)	VARCHAR2(30) NOT NULL	Unique document id for PTSF
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
4	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
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
7	TAG_NUMBER	Character(12)	VARCHAR2(12) NOT NULL	Tag Number
8	MODEL	Character(30)	VARCHAR2(30) NOT NULL	Model
9	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	Serial ID
10	VIN	Character(18)	VARCHAR2(18) NOT NULL	VIN
11	MFG_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer ID
12	ASSET_KEY	Character(18)	VARCHAR2(18) NOT NULL	Asset Key Tag
13	SHOP	Character(16)	VARCHAR2(16) NOT NULL	Shop Tag
14	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.