IT_HW_CACHE_S

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TEST_CASE	Character(30)	VARCHAR2(30) NOT NULL	BTF Test Case
2	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	Serial ID
3	MFG_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer ID Prompt Table: IT_MFG_IDS
4	ASSET_SUBTYPE	Character(15)	VARCHAR2(15) NOT NULL	Asset Subtype Prompt Table: IT_AM_SUBTYPES
5	IT_SUBTYPE	Character(15)	VARCHAR2(15) NOT NULL	IT Subtype Prompt Table: IT_SUBTYPE
6	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.
7	PARENT_SERIAL	Character(20)	VARCHAR2(20) NOT NULL	Parent Serial ID
8	MACHINENAME	Character(30)	VARCHAR2(30) NOT NULL	Machine Name
9	MODEL	Character(30)	VARCHAR2(30) NOT NULL	Model
10	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
11	BUSINESS_UNIT_HR	Character(5)	VARCHAR2(5) NOT NULL	Business Unit HR Prompt Table: BUS_UNIT_TBL_FS
12	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
13	IP_ADDRESS	Character(39)	VARCHAR2(39) NOT NULL	Internet Protocol Address
14	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
15	DISCOVERY_DATE	Date(10)	DATE	Last Inventory Date
16	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: IT_LOCATIONS
17	VPN_FLAG	Character(1)	VARCHAR2(1) NOT NULL	IP Address for VPN
18	IT_UD_CHAR1	Character(50)	VARCHAR2(50) NOT NULL	IT User Defined Char Field1
19	IT_UD_CHAR2	Character(50)	VARCHAR2(50) NOT NULL	IT User Defined Char Field2
20	IT_UD_DATE1	Date(10)	DATE	IT User Defined Date Field
21	PROCESS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Process Flag A=Purge All S=Only purge items with at least
22	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance