IT_LOAD_SFTWR (SQL View)	Index Back
ITAM - Software in Error Table IT Load Error Table - table containing (1) Duplicate Serial IDs (2) Unmapped Manufacturers (3) Unmapped Software Titles (4) Unmapped IP Addresses. View selects the distinct Software Titles (KNOWN_AS) from 3rd party source that errored out. Users can map these errored out Software Titles and map them to existing PSFT Software Titles (IT_SFTWR table).

IT_LOAD_SFTWR

(SQL View)

ITAM - Software in Error Table

IT Load Error Table - table containing (1) Duplicate Serial IDs (2) Unmapped Manufacturers (3) Unmapped Software Titles (4) Unmapped IP Addresses. View selects the distinct Software Titles (KNOWN_AS) from 3rd party source that errored out. Users can map these errored out Software Titles and map them to existing PSFT Software Titles (IT_SFTWR table).

SELECT DISTINCT(KNOWN_AS) FROM PS_IT_LOAD_ERR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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