IT_PLOAD_ERR (SQL Table)	Index Back
ITAM Pre-Staging table Errors ITAM error table for edits for the pre-staging tables IT_DISCO_HW_PRE and IT_DISCO_SW_PRE (see IT_DISCO_HW_ER2 and IT_DISCO_SW_ER2).

IT_PLOAD_ERR

(SQL Table)

ITAM Pre-Staging table Errors

ITAM error table for edits for the pre-staging tables IT_DISCO_HW_PRE and IT_DISCO_SW_PRE (see IT_DISCO_HW_ER2 and IT_DISCO_SW_ER2).

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BATCH_ID Character(18) VARCHAR2(18) NOT NULL Batch ID

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

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 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	BATCH_ID	Character(18)	VARCHAR2(18) NOT NULL	Batch ID
2	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	Serial ID
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	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.