IT_HRDWR_CACHE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	Serial ID
2	MFG_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer ID Prompt Table: IT_MFG_IDS
3	ASSET_SUBTYPE	Character(15)	VARCHAR2(15) NOT NULL	Asset Subtype Prompt Table: IT_AM_SUBTYPES
4	IT_SUBTYPE	Character(15)	VARCHAR2(15) NOT NULL	IT Subtype Prompt Table: IT_SUBTYPE
5	IT_RESOURCE	Character(30)	VARCHAR2(30) NOT NULL	ITAM - Used for mapping the IT Devices. Example: The values Mini-Tower and Desktop from 3rd Party will be mapped to PSFT value of Desktop.
6	PARENT_SERIAL	Character(20)	VARCHAR2(20) NOT NULL	Parent Serial ID
7	MACHINENAME	Character(30)	VARCHAR2(30) NOT NULL	Machine Name
8	MODEL	Character(30)	VARCHAR2(30) NOT NULL	Model
9	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
10	BUSINESS_UNIT_HR	Character(5)	VARCHAR2(5) NOT NULL	Business Unit HR Prompt Table: BUS_UNIT_TBL_FS
11	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
12	IP_ADDRESS	Character(39)	VARCHAR2(39) NOT NULL	Internet Protocol Address
13	IP_ADDR_FORMAT1	Character(39)	VARCHAR2(39) NOT NULL	Used in formatting an IP Address entered online or received from a 3rd party integration source. Format is: xxx.xxx.xxx.xxx
14	DISCOVERY_DATE	Date(10)	DATE	Last Inventory Date
15	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: IT_LOCATIONS
16	VPN_FLAG	Character(1)	VARCHAR2(1) NOT NULL	IP Address for VPN
17	IT_UD_CHAR1	Character(50)	VARCHAR2(50) NOT NULL	IT User Defined Char Field1
18	IT_UD_CHAR2	Character(50)	VARCHAR2(50) NOT NULL	IT User Defined Char Field2
19	IT_UD_DATE1	Date(10)	DATE	IT User Defined Date Field
20	PROCESS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Process Flag A=Purge All S=Only purge items with at least
21	SPECIAL_HANDLING	Character(1)	VARCHAR2(1) NOT NULL	Special Handling N=No Y=Yes Default Value: N
22	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance