IT_LOAD_ERR (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

IT_LOAD_ERR

(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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID

2 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.

3 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

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

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

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

7 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	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	Serial ID
2	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.
3	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
4	MFG_ID_DISCO	Character(200)	VARCHAR2(200) NOT NULL	Manufacturer ID
5	KNOWN_AS	Character(128)	VARCHAR2(128) NOT NULL	Software Known As
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	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.