CU*BASE Query: Q-Student Loan Inq. (MEMBER5)

This Query is used to view student loan information contained in the CU*BASE “MEMBER5” file. This file stores information about all loan account types, but the Query is designed to display only student loan processing types.

Specifications

File(s) used by this Query: MEMBER5

Access: Tool #830: Student Loan Accounts (MEMBER5)

Records will be grouped by processing type and loan category, with each group sorted in date order. The following fields will be displayed in this Query:

Loan Category
Processing Type
Account Base
Account Suffix
Current Balance
Member Owed Interest Due
Government Owed Interest Due
GL Account Number
Interest Rate
Government Interest Flag
Student Loan Deferment Flag
Student Loan Category
Variable Interest Rate Code
Beginning Deferment Date
Ending Deferment Date

Sample Conditions

The following table lists a few sample conditions which can be used in the LN Student Loan Inq. Query.

IMPORTANT: Notice the default condition that is already entered for this Query. Because this condition is important to perform the Query properly, be sure to leave it as is and add any other conditions below it.

Description

Field

Test

Value

Show all student loans with the government interest flag set to “1.00” (meaning the flag has been turned ON).

AND

PRTYPE

GIPER1

LIST

'S' 'P'

1.00