Understanding the Load Process

Once all the requested data (Message GET_DISCOVERYDATA_ACK) has been received, the View Request Status page displays "Success". All of the data from the XML has been received and written to application staging tables during subscription. An Application Engine process (IT_LOAD_PROC) is automatically submitted and uses the staging tables as input to produce translated data in the cache and error tables.

This cache data is then used by the compare process.

Note: You can view the results of the data integration via PeopleSoft Integration Broker Message Details. Check the status of the following Messages: GET_DISCOVERYDATA, GET_DISCOVERYDATA_STATUS_ACK, GET_DISCOVERYDATA_ACK.

The Load Process validates and translates the third-party data, consisting of. Serial Number, Manufacturer, Computer Type (IT Resource), Model, Primary User, Primary User Domain, Machine Name, IP Address, Date of Last Inventory, Software Titles, and Total Run Time. The Load Process translates the data from the third-party into data that is familiar to the asset repository (for example, Primary User + Domain = Employee ID). When this translation is successful, data is inserted into the cache table. Errors occurring during these translation edits will prohibit the IT device or software title from being inserted into the cache tables. Instead errors encountered will be inserted into the error tables with the applicable error code as well as a table that preserves the original third-party values. This is done to allow later processing of the data either by the comparison process or again by Load once a valid translation for the data has been created.

You can view the errors produced by the load process for the latest discovery request from a high level pagelet and drill down to the details on the View Integration Data Load Errors page.

This table lists the order of processing the translation edits:

Application Engine: IT_LOAD_PROC	IT_ERR_CODE	Comment	Reference
Checks for Duplicate Serial Numbers	010	Duplicate Serial ID Error	ASSET
Checks for the existence of a mapping of the primary user and domain to an employee ID	050	Unmapped Primary User/Domain - Empl ID	IT_LDAP
Retrieves Department and HR business unit for an Empl ID from the PS_JOB table for Employees "Primary Job".		HCM Integrated data	JOB
Retrieves the mapped GL Business Unit value for the HR Business Unit		HCM to GL Business Unit	BUS_UNIT_TBL_HR
Checks for unmapped/blank GL Business Unit value for the HR Business Unit	070	No GL BU Mapped to HR BU	BUS_UNIT_TBL_HR
Check for no HR Business Unit value in PS_JOB table	070	No GL BU Mapped to HR BU	BUS_UNIT_TBL_HR
Retrieves the max AM Business Unit value in the BU_BOOK_TBL table for the GL Business Unit			BU_BOOK_TBL
Retrieves the SetIDs for Asset Subtype (AM_SUBTYPE), Manufacturer (MANUFACTURER), Location (LOCATION_TBL) where there is a MFG_ID			SET_CNTRL_REC
Retrieves the SetIDs for Asset Subtype (AM_SUBTYPE), Manufacturer (MANUFACTURER), Location (LOCATION_TBL) where MFG_ID is blank.			SET_CNTRL_REC
Retrieves the Manufacturer when provided. Error if provided value is not in mappings.	040	Unmapped Manufacturer Error	IT_MAP_CD
Retrieves the IT_SUBTYPE and AM_SUBTYPE from the 3rd party value. Error if no mapping.	060	Unmapped Asset Subtype	AM_SUBTYPE, IT_SUBTYPE_LN
Retrieves the Location for IP Addresses that are not VPN. Error if not in mapping.	030	Unmapped IP Address Error	IT_IP_ADDR, IT_IP_ADDR_MAP

When no MFG_ID is returned from the third-party application , PeopleSoft IT Asset Management stores a blank MFG_ID to the IT_HRDWR_CACHE table.

Once completed, the system sets the "Last Request Date" to the current date for the IT Subtypes and reprocesses errors from prior requests unless more current data comes from the third-party application.