IT_DHW_ERR_C

(SQL Table)
 Index Back

Discovery Data Hardware Error

Table used as a record for IT Hardware Asset Types that failed an error edit in the IT_LOAD_PROC. Reconciliation/Compare will re-process these error conditions when it runs stand-alone. *** This is a BTF table *****

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TEST_CASE Character(30) VARCHAR2(30) NOT NULL BTF Test Case
2 COMPARE_TYPE Character(1) VARCHAR2(1) NOT NULL Compare report type
1=Delta (Results v.s Expected)
2=Expected data not in Results
3=Unexpected data in Results
3 COMPARE_SOURCE Character(1) VARCHAR2(1) NOT NULL Compare data source (Actuals or Expected results).
A=Actuals
E=Expected
4 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
5 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
6 PARENT_SERIAL Character(20) VARCHAR2(20) NOT NULL Parent Serial ID
7 MFG_ID_DISCO Character(200) VARCHAR2(200) NOT NULL Manufacturer ID
8 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.
9 MODEL_DISCO Character(200) VARCHAR2(200) NOT NULL Discovery Model from 3rd Party
10 PRIMARY_USER Character(64) VARCHAR2(64) NOT NULL Primary Logon User
11 USER_DOMAIN Character(64) VARCHAR2(64) NOT NULL Network User Domain
12 MACHINENAME_DISCO Character(64) VARCHAR2(64) NOT NULL Machine Name from 3rd Party
13 IP_ADDRESS_DISCO Character(39) VARCHAR2(39) NOT NULL IP Address from Third Party
14 DISCOVERY_DATE Date(10) DATE Last Inventory Date
15 IT_UD_CHAR1 Character(50) VARCHAR2(50) NOT NULL IT User Defined Char Field1
16 IT_UD_CHAR2 Character(50) VARCHAR2(50) NOT NULL IT User Defined Char Field2
17 IT_UD_DATE1 Date(10) DATE IT User Defined Date Field