IT_UNDISC2_TAO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
3	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
4	IT_TIMESPAN_ID	Character(15)	VARCHAR2(15) NOT NULL	Inventory Age
5	IT_TIMESPAN_SEQ	Number(5,0)	INTEGER NOT NULL	Inventory Age Seq
6	ASSET_SUBTYPE	Character(15)	VARCHAR2(15) NOT NULL	Asset Subtype
7	DISCO_SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	Serial ID
8	ARM_MFG_ID	Character(50)	VARCHAR2(50) NOT NULL	ARM Manufacturer ID
9	MANUFACTURER	Character(60)	VARCHAR2(60) NOT NULL	Manufacturer Name
10	DISCO_MFG_ID	Character(50)	VARCHAR2(50) NOT NULL	Discovery Manufacturer ID
11	MANUFACTURER_B	Character(60)	VARCHAR2(60) NOT NULL	Manufacturer Name
12	ARM_MODEL	Character(30)	VARCHAR2(30) NOT NULL	Model
13	DISCO_MODEL	Character(30)	VARCHAR2(30) NOT NULL	Model
14	MACHINENAME_DISCO	Character(64)	VARCHAR2(64) NOT NULL	Machine Name from 3rd Party
15	TAG_NUMBER	Character(12)	VARCHAR2(12) NOT NULL	Tag Number
16	DISCOVERY_DATE	Date(10)	DATE	Last Inventory Date
17	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
18	DEPTID_2	Character(10)	VARCHAR2(10) NOT NULL	Department ID
19	CSTDN_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Custodian Empl Id
20	PUSER_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Primary User Empl Id
21	DISCO_LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Discovery Location Code
22	ARM_LOCATION	Character(10)	VARCHAR2(10) NOT NULL	ARM Location Code
23	IP_ADDRESS_DISCO	Character(39)	VARCHAR2(39) NOT NULL	IP Address from Third Party
24	LOCATION_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Location
25	FINANCIAL_ASSET_SW	Character(1)	VARCHAR2(1) NOT NULL	Capitalized Asset N=Non Cap Y=Capitalize