Complete Matches (Match Records)

The Complete Matches button performs the following functionality:

·       Inserts missing rows in the PF_APPLICANT_MASTER table for PowerFAIDS applicants with an ALTERNATE_ID value. These are PowerFAIDS records where the ALTERNATE_ID has already been populated manually or by other J1 Financial Aid functions

·       Inserts missing PF_POE_DEF rows for PF applicants with POE assignments. The POE Definition window opens and displays data from PowerFAIDS that you must modify and save or save as shown or cancel.

·       Inserts missing rows in the PF_APPLICANT_MASTER table for all records with a Good SSN Match status

·       Inserts rows in PF_STDNT_MSTR for the records with a status of Good SSN Match. If corresponding rows in PF_STDNT_MSTR already exist, it updates PD_STDNT_MSTR.POE_ID with PowerFAIDS STU_AY_POE.POE_ID.

·       Creates corresponding records in the EXTERNAL_DATA table in PowerFAIDS. The record contains SSN, AWARD_YEAR_TOKEN, and EX_ID_NUM for the ALTERNATE_ID. It will also include any additional data elements flagged for transfer in the Configure Optional Student Data Elements for Transfer task.

·       Displays the Match Records - Create Student Update Parameters window, which prompts you for needed values. When you enter these values and click OK, the process completes.

To Learn More...

Match Records Window