IT_DISCO_HW_AET

(SQL Table)
Index Back

IT - Hardware Stage AET

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
3 PARENT_SERIAL Character(20) VARCHAR2(20) NOT NULL Parent Serial ID
4 MFG_ID_DISCO Character(200) VARCHAR2(200) NOT NULL Manufacturer ID
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 MODEL_DISCO Character(200) VARCHAR2(200) NOT NULL Discovery Model from 3rd Party
7 PRIMARY_USER Character(64) VARCHAR2(64) NOT NULL Primary Logon User
8 MACHINENAME_DISCO Character(64) VARCHAR2(64) NOT NULL Machine Name from 3rd Party
9 IP_ADDRESS_DISCO Character(39) VARCHAR2(39) NOT NULL IP Address from Third Party
10 DISCOVERY_DATE Date(10) DATE Last Inventory Date
11 IT_UD_CHAR1 Character(50) VARCHAR2(50) NOT NULL IT User Defined Char Field1
12 IT_UD_CHAR2 Character(50) VARCHAR2(50) NOT NULL IT User Defined Char Field2
13 IT_UD_DATE1 Date(10) DATE IT User Defined Date Field