Bulk Update of Accounts to Securitization Pool

6.2.1 Bulk Update of Accounts to Securitization Pool

In addition to manually adding / removing accounts from Securitization pool, you can perform bulk update of records using file upload process. In this process, all the accounts which are to be either attached or detached from respective pool can be collated into a single file as individual record and uploaded into the system through input file processing.

During bulk update, you can,

Add accounts to pool
Remove accounts from pool
Transfer account from Pool A to Pool B (depending on configured pool status)

In-order to perform bulk upload, the upload file should be a csv (comma separated value) file and need to contain two main parameters namely Pool ID and Account ID separated by comma as one record. Multiple rows can be included in a single upload file to process the data in bulk.

For example,

POOL A,20190100010673,
SEC_POOL_1,20190100010673,
,20181200010027,

If there is no value provided for Pool ID, then system assumes it as NULL and respective account is removed from the Pool to which it is currently attached.

The below table indicates the possible combinations on how data in upload file is processed based on Pool ID and Account ID value in upload file:

Table 6-13 Bulk Update of Accounts to Securitization Pool

Condition	Pool ID	Account ID	Results
If account is not attached to any Pool	A	ABC	Account ABC is attached to pool A
If account is attached to Pool A	NULL or no value	ABC	Account ABC is detached from pool A
If account is attached to Pool A	B	ABC	Account ABC is detached from Pool A and attached to pool B
If account is attached to Pool A	A	ABC	Indicates error -Account ABC is already mapped to Pool.

During processing of upload file data, separate transactions either to ADD ACCOUNT or REMOVE ACCOUNT or both, are automatically posted on respective pool.

The processing of data in upload file is also controlled by the following lookup types:

Table 6-14 Lookup types:

Lookup Type	Description
POOL_ADD_ACC_CRITERIA	CRITERIA TO ADD ACCOUNT TO POOL
POOL_REMOVE_ACC_CRITERIA	POOL CRITERIA FOR REMOVING ACCOUNT FROM POOL

Each Lookup Type can have on or more lookup code which are basically the configured pool status and acts as the criteria to allow an account to either get attached or detached from a specific Securitization pool, Lookup can be defined in Setup > Administration > System > Lookups screen.

Figure 6-3 Pool Upload - Lookup Code

Description of "Figure 6-3 Pool Upload - Lookup Code"

As per the above configuration, for Lookup Type POOL_ADD_ACC_CRITERIA an account is attached to only those Securitization pool which are in status OPEN, HELD, NEW, and SOLD. Any other status is not processed in the system and is indicated as error.

Processing Bulk Update of Accounts to Securitization Pool

The upload file is to be placed in the location - /scratch/work_area/<domain name>/input/isc. During the scheduled execution of batch job - SET-IFP-ISCPRC_BJ_100_01 (SECURITIZATION POOL FILE UPLOAD) in SET-IFP (Input File Processing), the file is picked up for processing and data within is loaded into respective table. The status of batch job can be viewed in DashBoard > System Monitor > Batch Jobs screen.

After the batch processing, the records which are successfully processed during bulk update can be viewed in Servicing > Securitization > Pool Inquiry > Pool Accounts tab.

The records which resulted in error are listed in the bad file indicating the account number in specific row with inappropriate data that was not processed. For example, record 1,3,5 failed due to improper data.

Parent topic: Pool Creation