STUDENT LOANS - Q + E QUERIES - CURRENT YEAR

Student Loans Ledger Query

Log On To SYBASEDEV Server

If you do not have Student Ledger Icon in the program manager

1. Double click the Q + E Icon in the program manager.
2. A log on window will appear on the Q + E screen. Enter your ID and Password (Lower case letters only) and press enter.
3. Select File/Open or click the Open icon. Open Table window will appear on the screen.
4. In the Open Table window select Source/Query File, Drive/g, Directory/share/fbunit2/stuloans, and File/ledger.qef. Click OK.

If you have Student Ledger Icon in the program manager

1. Double click the Student Ledger Icon in the program manager.
2. A log on window will appear on the Q + E screen. Enter your ID and Password (Lower case letters only) and press enter.

After Log On

1. After logging on to the Sybasedev server and opening the ledger.qef query, the user will be prompted to ENTER A VALID SSN. Type the SSN and click OK or press Enter.
2. The records for that particular SSN will be retrieved and displayed in a tabular mode.

• SSN: Student Social Security Number
• LAST NAME: Student Last Name
• FIRST NAME: Student First Name
• MIDDLE NAME: Student Middle Name
• STREET: Student Billing Address - Street
• CITY: Student Billing Address - City
• STATE: Student Billing Address - State
• ZIP: Student Billing Address - Zip
• TELEPHONE: Student Telephone Number With Area Code
• DELINQ_LETTER: Delinquency Letter
• EXIT_DTE: Exit Date
• DTE_INTV_YN: Exit Interview Yes Or No
• PYMNT_CYCLE: Payment Cycle
• BILL_DTE: Billing Date
• FUND_REPAY: Fund Repay
• TOTAL_BASIC_PAY: Basic Payment
• FUND: Fund Name
• FUND_STATUS: Account Status
• STATUS_DTE: Account Status Date
• HOLD_STATUS: Hold Status
• HOLD_STAT_DTE: Hold Status Date
• TOT_AMT_BOR:Total Advanced Amount
• TOT_PRINC_CANC: Total Principal Canceled To Date
• TOT_INT_CANC: Total Interest Canceled To Date
• TOT_LATE_FEE_CANC: Total Late Fee Canceled To Date
• TOT_COLLECT_COST_CANC: Total Collect Cost Canceled To Date
• BASIC_PMT: Basic Payment Amount
• DTE_PAID_TO: Date Paid To
• TOT_PRINC: Total Principal Paid To Date
• TOT_INT: Total Interest Paid To Date
• TOT_LATE_FEE: Total Late Fee Paid To Date
• TOT_COLLECT_COST: Total Collect Cost Paid To Date
• PRINC_BAL: Current Balance Principal Amount
• INT_BAL: Current Balance Interest Amount
• LATE_FEE_BAL: Current Balance Late Fee Amount
• COLLECT_COST_BAL: Current Balance Collect cost
• PRINC_PAST_DUE: Principal Past Due
• YRS_DEL: Years Delinquent
• MOS_DEL: Months Delinquent
• DEL_DTE: Delinquency Date
• GRACE_CTR: Grace Counter
• TRN_CODE: Transaction Code
• TRN_DTE: Transaction Date
• TRN_FUND: Fund Number
• TRN_PRINC: Principal Amount Paid
• TRN_INT: Interest Amount
• TRN_LATE_FEE: Late Fee Amount
• TRN_COLLECT_COST: Collect Fee Amount

View Mode

• To shift from Table Mode to Form Mode either select Tools/Run Form or Click on the Form Icon.
• To shift from Form Mode to Table Mode click the Exit button on the Form.

Multiple Records

• To view multiple records in the form mode use the Scroll Bar.
• The current record number is always displayed on the top left corner.
• Record # 1 is always the latest transaction followed by other records in a descending order.

New Query

New Query In The Form Mode

1. To pass on a new query (To view the records of another student), click on the QBE Mode button. The form will become blank.
2. Enter the SSN (Social Security Number) in the space provided below SSN in the top left corner of the form.
3. Click the Query Now button. DO NOT press Enter.
4. The records of the new query will be displayed on the form.

Printing

• You should be in the Table Mode to print the current report.
• Select File/Print or click the Print icon on the tool bar to print reports. Print Report window is displayed on the screen.
• Q + E prints all the records in the current query in a sequential order.
• You can print specific records in the query by substituting the Record #'s for Page Numbers in the Print Report window.

STUDENT LOANS - Q + E QUERIES - HISTORY

Student Loans Ledger Queries

Log On To SYBASEDEV Server

If You Are Not In Q+E

1. Double click the Q + E Icon in the program manager.
2. A log on window will appear on the Q + E screen. Enter your ID and Password (Lower case letters only) and press enter.
3. Select File/Open or click the Open icon. Open Table window will appear on the screen.
4. In the Open Table window select Source/Query File, Drive/g, Directory/share/fbunit2/stuloans, and File/ledger1.qef (or ledger2.qef, ledger3.qef, ledger4.qef, ledger5.qef),. Click OK.
5. After logging on to the Sybasedev server and opening one of the ledger queries, the user will be prompted to ENTER A VALID SSN. Type the SSN and click OK or press Enter.
6. The records for that particular SSN will be retrieved and displayed in a tabular mode.

If You Are In Q+E

1. Close all the files, tables, and queries that are open.
2. Select File/Open or click the Open icon. Open Table window will appear on the screen.
3. In the Open Table window select Source/Query File, Drive/g, Directory/share/fbunit2/stuloans, and File/ledger1.qef (or ledger2.qef, ledger3.qef, ledger4.qef, ledger5.qef),. Click OK.
4. After logging on to the Sybasedev server and opening one of the ledger queries, the user will be prompted to ENTER A VALID SSN. Type the SSN and click OK or press Enter.
5. The records for that particular SSN will be retrieved and displayed in a tabular mode.

View Mode

• To shift from Table Mode to Form Mode either select Tools/Run Form or Click on the Form Icon.
• To shift from Form Mode to Table Mode click the Exit button on the Form.

Multiple Records

• To view multiple records in the form mode use the Scroll Bar.
• The current record number is always displayed on the top left corner.
• Record # 1 is always the latest transaction followed by other records in a descending order.

New Query

New Query In The Form Mode

1. To pass on a new query (To view the records of another student), click on the QBE Mode button. The form will become blank.
2. Enter the SSN (Social Security Number) in the space provided below SSN in the top left corner of the form.
3. Click the Query Now button. DO NOT PRESS ENTER.
4. DO NOT MAKE A QUERY ON A BLANK SCREEN
5. The records of the new query will be displayed on the form.

Printing

• You should be in the Table Mode to print the current report.
• Select File/Print or click the Print icon on the tool bar to print reports. Print Report window is displayed on the screen.
• Q + E prints all the records in the current query in a sequential order.
• You can print specific records in the query by substituting the Record #'s for Page Numbers in the Print Report window.