This window allows you to review loan disbursement records that failed processing when uploaded from PowerFAIDS. It displays all known error conditions for the record and allows you to determine the corrective action to take. These corrective actions may include editing the ID Number, Fund Code, and POE ID.
The Search By criteria allows you to search by Individual (SSN/Name) or by using a Query, which is customizable through InfoMaker. Both types of selections are restricted to only records found in both the PF_DISB_LOANS and PF_DISB_LOANS_ERROR tables.
· If you search by Individual, you can highlight a name in the drop-down list and then click the Select button, which populates the Selection Results data window with the Name, Fund Code, and POE ID of all transactions associated to the selected SSN.
· If you choose to search by Query, the default query finds all records from the PF_DISB_LOANS and PF_DISB_LOANS_ERROR tables. If you want to restrict the results of the query, you must customize it (use the Customize button). The Retrieve button is used to populate the Selection Results data window with the query results in alphabetical order. The default query is d_query_loans_not_processed.
· The Clear List button clears the Selection Results data window of any data currently loaded by the Individual or Query selection methods.
When you highlight a name in the Selection Results data window, the following information for that selected name is displayed in the Disbursement Record data window:
· Name: PowerFAIDS name from the roster
· J1 Name: J1 Name from Name Master when found via PowerFAIDS SSN link to Biograph Master and ID Number link to Name Master
· SSN: PowerFAIDS SSN from the roster
· Alternate ID#: PowerFAIDS Alternate ID# from the roster; may or may not be based on the SSN link; editable
· Fund Code: PowerFAIDS Fund Ledger # and the Fund Short name from the roster; editable
· Award Year: PowerFAIDS Award Year from the roster
· Loan Amount: PowerFAIDS disbursement amount from the roster
· Release Date: Release Date from the disbursement roster
The columns that are editable allow for transactions to be adjusted for successful processing, but it does not update the data in PowerFAIDS. In order for future loan disbursement transactions for this student and fund to be successful, edits in PowerFAIDS may also be needed.
The Error data window displays all errors generated for the selected transaction from the PF_DISB_LOANS_ERROR table. Each error includes an Error Message to help you determine how to correct the error. See CommonLine Loan Disbursement Warnings and Errors for details about each error message.
Once corrective action is taken, the unprocessed loan disbursement transaction can be re-processed in one of two ways:
· Manually by opening the Loan Disbursement window and executing an Unprocessed Disbursement Only
· By running another disbursement roster either interactively or automatically as both the Single File and All Files in Folder methods include unprocessed loan disbursement transactions
The Delete Record button is available if you are assigned PF Manager security in the Tasklist module. Clicking this button deletes the displayed record in the PF_DISB_LOANS table and all related records in the PF_DISB_LOAN_ERROR table.