IT_DISCO_SW_ERR (SQL Table)	Index Back
IT Software Errors IT Software Error table is populated with IT_DISCO_SW_STG rows that fail software edits in the IT_LOAD_PROC. Used to re-process the errors when the Reconciliation/Compare process is executed stand-alone.

IT_DISCO_SW_ERR

(SQL Table)

IT Software Errors

IT Software Error table is populated with IT_DISCO_SW_STG rows that fail software edits in the IT_LOAD_PROC. Used to re-process the errors when the Reconciliation/Compare process is executed stand-alone.

# 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 KNOWN_AS Character(128) VARCHAR2(128) NOT NULL Software Known As

4 PRIMARY_USER Character(64) VARCHAR2(64) NOT NULL Primary Logon User

5 USER_DOMAIN Character(64) VARCHAR2(64) NOT NULL Network User Domain

6 DISCOVERY_DATE Date(10) DATE Last Inventory Date

7 SFTWR_INSTALL_DT Date(10) DATE Software Installation Date

8 TOTAL_RUN_TIME Number(31,0) DECIMAL(31) NOT NULL Total Run Time in Seconds

#	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	KNOWN_AS	Character(128)	VARCHAR2(128) NOT NULL	Software Known As
4	PRIMARY_USER	Character(64)	VARCHAR2(64) NOT NULL	Primary Logon User
5	USER_DOMAIN	Character(64)	VARCHAR2(64) NOT NULL	Network User Domain
6	DISCOVERY_DATE	Date(10)	DATE	Last Inventory Date
7	SFTWR_INSTALL_DT	Date(10)	DATE	Software Installation Date
8	TOTAL_RUN_TIME	Number(31,0)	DECIMAL(31) NOT NULL	Total Run Time in Seconds