IT_LOAD_ERR_C (SQL Table)	Index Back
IT Load Error Table IT Load Error Table - table containing (1) Duplicate Serial IDs (2) Unmapped Manufacturers (3) Unmapped Software Titles (4) Unmapped IP Addresses * This is a BTF table *

IT_LOAD_ERR_C

(SQL Table)

IT Load Error Table

IT Load Error Table - table containing (1) Duplicate Serial IDs (2) Unmapped Manufacturers (3) Unmapped Software Titles (4) Unmapped IP Addresses *** 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 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial 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 IT_ERR_CODE Character(3) VARCHAR2(3) NOT NULL IT Load Error Code
010=Duplicate Serial ID Error
020=IU Duplicate Serial ID Error
030=Unmapped IP Address Error
040=Unmapped Manufacturer Error
050=Unmapped Primary User - EMPLID
060=Unmapped Asset Subtype
070=No GL BU mapped to HR BU
080=Unmapped IT Resource Error
090=Unmapped Software Title Error
100=Software data missing parent

7 MFG_ID_DISCO Character(200) VARCHAR2(200) NOT NULL Manufacturer ID

8 KNOWN_AS Character(128) VARCHAR2(128) NOT NULL Software Known As

9 DESCR Character(30) VARCHAR2(30) NOT NULL Description

10 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	Serial 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	IT_ERR_CODE	Character(3)	VARCHAR2(3) NOT NULL	IT Load Error Code 010=Duplicate Serial ID Error 020=IU Duplicate Serial ID Error 030=Unmapped IP Address Error 040=Unmapped Manufacturer Error 050=Unmapped Primary User - EMPLID 060=Unmapped Asset Subtype 070=No GL BU mapped to HR BU 080=Unmapped IT Resource Error 090=Unmapped Software Title Error 100=Software data missing parent
7	MFG_ID_DISCO	Character(200)	VARCHAR2(200) NOT NULL	Manufacturer ID
8	KNOWN_AS	Character(128)	VARCHAR2(128) NOT NULL	Software Known As
9	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
10	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.