IT_LOAD_MFG (SQL View)	Index Back
ITAM - MFGs from 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 Manufacturers from 3rd party source that errored out. Users can map these errored out MFGs and map them to existing PSFT MFG_IDs.

IT_LOAD_MFG

(SQL View)

ITAM - MFGs from 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 Manufacturers from 3rd party source that errored out. Users can map these errored out MFGs and map them to existing PSFT MFG_IDs.

SELECT DISTINCT(MFG_ID_DISCO) FROM PS_IT_LOAD_ERR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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