Adding Group Member Assets with Background Processing

Add group member assets by using background processing if the assets originated in another system. In that case, all asset data exists in either relational tables or a flat file format. To load the asset data into PeopleSoft Asset Management, you perform the steps discussed here.

To add group member assets with background processing:

1. Add a value for the PROFILE_ID field to each asset record.

2. Set the value of the PROFILE_ID field to equal the asset profile on which you want to base the group member assets.

   Information in the profile populates the GROUP_ASSET_ID field and GROUP_ASSET_FLAG field in the Asset Management loader tables.

   Note:

   The GROUP_ASSET_FLAG field must be set to M, and the GROUP_ASSET_ID field must be populated with the ID of a group asset. If these aren't set properly, group asset accounting does not work.

   The next step depends on whether the data resides in relational tables or in flat files.

Relational Table Data

If the data resides in relational tables, write a Structured Query Report (SQR) to transfer the data to the PeopleSoft Asset Management loader tables. Then run the Transaction Loader process to transfer the load lines into PeopleSoft Asset Management as open transactions.

Note:

Follow the same procedure outlined within the Custom SQR Conversion section in the Converting to PeopleSoft Asset Management topic.