Return to Navigation

Reviewing and Managing CL 4 Loan Files

As you run the EDI Manager processes to either create or load CommonLine 4 files into the system, the system generates high level information that you can review in the EC Queue Review component.

This section discusses how to view CommonLine 4 EC queue records.

Page Name

Definition Name

Navigation

Usage

EC Queue Review (electronic commerce queue review)

FA_LN_EDI_ECQUEUE

select Financial Aid, then select File Management, then select CommonLine Loans, then select Review CL 4 File Transactions, then select EC Queue Review

Review files that were either created (outbound) or loaded (inbound) by EDI Manager.

Access the EC Queue Review page (select Financial Aid, then select File Management, then select CommonLine Loans, then select Review CL 4 File Transactions, then select EC Queue Review)).

Image: EC Queue Review page: File Status Information tab

This example illustrates the fields and controls on the EC Queue Review page: File Status Information tab. You can find definitions for the fields and controls later on this page.

EC Queue Review page: File Status Information tab

This page displays information for all loan files processed by EDI Manager in the selected loan type. Use this component to verify the status of each file, control the processing of files, and diagnose EDI Manager problems.

Field or Control

Definition

Trans ID (transmission identification)

Displays the EDI Manager map name. For CommonLine 4, the system uses the file ID. This is also part of the search record for the component so that you can select only the files types you want to see. The values are:

A004P: Application Send

C004P: Change Transaction Send

R004P: Application Response

E004P: EFT roster

EC Driver DateTime (electronic commerce driver date time)

Displays the date and time that the inbound EC agent process loaded the file into the staging tables for inbound files.

Displays the date and time the outbound EC agent created the loan file for outbound files.

EC Queue Control Number (electronic commerce queue control number)

Displays the file batch ID for outbound loan files. For inbound loan files, the system displays the file source name.

Update Status

Click to change the EC Queue status value. The EC Queue Status informs you of the state of the file represented by each row in the grid.

A value of Loaded indicates that for incoming files the system has loaded the file into the staging tables, but the data in the file has not been completely processed. For outgoing files, this indicates that the system moved the application files into the staging tables, but the physical file has not yet been created.

A value of Processed indicates that for incoming files the system resolved all of the records in the file, and the file should no longer be processed. For outgoing files, this indicates that the system created physical files and no further processing is required.

Use the Update Status button to exercise special control over your loan files. For example, you can regenerate outbound files that may have become lost by changing the status from Processed to Loaded. The regenerated file is identical to the one lost. To control the order in which multiple loaded files are processed, change the status from Loaded to Processed to prevent the system from processing the file. Then update the status back to Loaded when you want the file to be processed.

Bus Unit/Cust/Vndr Info Tab

Select the Bus Unit/Cust/Vndr Info tab.

Image: EC Queue Review page: Bus Unit/Cust/Vndr Info tab

This example illustrates the fields and controls on the EC Queue Review page: Bus Unit/Cust/Vndr Info tab. You can find definitions for the fields and controls later on this page.

EC Queue Review page: Bus Unit/Cust/Vndr Info tab

Field or Control

Definition

Business Unit

For outbound files only. The EC entity code used to represent the business unit responsible for the loan. This value corresponds with the loan transfer ID page setup information for the transaction ID value.

EC BU Cd (electronic commerce business unit code)

For outbound files only. Indicates the EC entity code that represents the greater university. This value corresponds with the loan transfer ID page setup information for the transaction ID value.

Cust/Vndr (customer/vendor)

For outbound files only. The loan destination profile ID.

EC Ext Cd (electronic commerce external code)

For outbound files only. Indicates the EC entity code that represents the external loan entities. This value corresponds with the loan transfer ID page setup information for the transaction ID value.

Note: For outgoing files, if the business unit, EC BU Cd, Cust/Vndr, and EC Ext Cd fields are blank, this means that the Loan Transfer ID setting have not yet been created. Files cannot be created until this setup is completed each year for CommonLine 4 loans.