PeopleSoft Student Financials Reports: A to Z
This appendix provides an overview of Student Financials reports, and enables you to view a summary tables of all reports.
Note. For samples of some of these reports, see the Portable Document Format (PDF) files published on CD-ROM with your documentation.
See Also
PeopleTools PeopleBook: PeopleSoft Process Scheduler
PeopleSoft Student Financials Reports: A to Z
This table lists the Student Financials reports, sorted alphanumerically by report ID.
Crystal and SQR Reports
Setup Table Reports
Note. On June 1, 2011, Oracle discontinued distribution of SAP’s Business Objects Enterprise and Crystal Reports with PeopleTools. Existing customers may use Business Objects Enterprise and Crystal Reports licenses previously received from Oracle. Customers who wish to use future versions of Business Objects and Crystal Reports products with PeopleSoft will need to obtain appropriate license and support directly from SAP/Business Objects.
Crystal and SQR Reports|
Report ID and Report Name |
Description |
Navigation |
Run Control Page |
|
SF707 Group Summary Report |
Group posting summary report of student financial system. (Crystal) |
Student Financials, Charges and Payments, Group Processing, Group Summary |
RUNCTL_SF707 |
|
SF708 Fee Calculation Errors Report |
This report lists all error messages for a batch ID. (Crystal) |
Student Financials, Tuition and Fees, Calculate Batch Tuition, Tuition Calc Error Report |
RUNCTL_SF708 |
|
SF709 Fees After Calculation Report |
This report lists all tuition and fees for a student. (Crystal) |
Student Financials, Tuition and Fees, Calculate Batch Tuition, Fees After Calculation Report |
RUNCTL_SF709 |
|
SF710 Fees Prior to Posting Report |
This report lists a student's tuition and fees prior to posting. (Crystal) |
Student Financials, Tuition and Fees, Calculate Batch Tuition, Fees Prior to Posting Report |
RUNCTL_SF710 |
|
SF711ABI Crystal Bill for Student Financials |
This report generates a student bill for print using Crystal. (Crystal) |
Student Financials, Bill Customers, Student Bills, Print Invoice Crystal |
RUNCTL_SF711AB |
|
SF726 Daily Activity |
Summary of daily posting activity, by Item type Code. (Crystal) |
Student Financials, Charges and Payments, Posting Reports, Daily Activity |
RUNCTL_SF726 |
|
SF727 Daily Posting Activity |
Daily posting activity for student post. (Crystal) |
Student Financials, Charges and Payments, Posting Reports, Daily Posting Activity |
RUNCTL_SF727 |
|
SF728 Enrollment Cancellation Report |
This report lists all students who have been processed for enrollment cancellation for term or class cancellations. (Crystal) |
Student Financials, Tuition and Fees, Cancellation, Report Cancellation |
RUNCTL_SF728 |
|
SF732 Refund Customers Rpt |
This report lists information on individual refunds. (Crystal) |
Student Financials, Refunds, Reports, Individual Refunds |
RUNCTL_SF732 |
|
SF736 Run Organization Report |
Refund External Organization Report by business unit. (Crystal) |
Student Financials, Refunds, Reports, Corporation Refunds |
RUNCTL_SF732 |
|
SF750 Receipts per Business Day |
This report lists all information about receipts processed on a specific business date in cashiering. (Crystal) |
Student Financials, Cashiering, Balance by Business Day, Receipts By Business Date |
RUNCTL_SF750 |
|
SF750R Receipt by Number |
This report generates a cashiering receipt for print using Crystal. It lists all receipt information. (Crystal) |
Student Financials, Cashiering, Balance by Business Day, Receipts By Number Summary |
RUNCTL_SF750R |
|
SF753ABI Crystal Org Bill for SF |
This report generates an external organization bill for print using Crystal. (Crystal) |
Student Financials, Bill Customers, Corporate Bills, Print Invoice Crystal |
RUNCTL_SF753AB_ORG |
|
SF754 Students in Collections |
This report lists students placed in collections. (Crystal) |
Student Financials, Collections, Customers in Collection |
RUNCTL_COLLECT_SF |
|
SF755 Organizations in Collections |
This report lists all organizations placed in collections. (Crystal) |
Student Financials, Collections, Corporations in Collection |
RUNCTL_COLLECT_SF |
|
SF756 Group Detail Report |
Group posting detail report. (Crystal) |
Student Financials, Charges and Payments, Group Processing, Group Detail |
RUNCTL_SF707 |
|
SF757 Receipts by Deposit ID |
This report lists all information about receipts processed using a specified deposit ID within cashiering. (Crystal) |
Student Financials, Cashiering, Balance By Business Day, Receipts by Deposit ID Summary |
RUNCTL_SF757 |
|
SF783 Late Fees Report |
This report lists all individuals who were assessed late fees for a given batch ID. (Crystal) |
Student Financials, Charges and Payments, Late Fees, Late Fees Report |
RUNCTL_SF783 |
|
SF800 Business Unit Permission List |
SF security listing of business units secured by a permission list. (Crystal) |
Set Up SACR, Security, Secure Student Financials, Permission List Reports, Business Unit |
PRCSRUNCNTL_SF |
|
SF801 Business Unit User ID |
SF security listing of business units secured by a single user ID. (Crystal) |
Set Up SACR, Security, Secure Student Financials, User Reports, Business Unit |
PRCSRUNCNTL_SF |
|
SF802 Cashier Office Permission List |
This report lists any permission lists with security for specified cashier offices. (Crystal) |
Set Up SACR, Security, Secure Student Financials, Permission List Reports, Cashier Office |
PRCSRUNCNTL_SF |
|
SF803 Cashier Office User ID |
This report lists all user IDs with security for specified cashier offices. (Crystal) |
Set Up SACR, Security, Secure Student Financials, User Reports, Cashier Office |
PRCSRUNCNTL_SF |
|
SF804 Credit Card Permission List |
This report lists any permission lists with credit card security. (Crystal) |
Set Up SACR, Security, Secure Student Financials, Permission List Reports, Credit Card |
PRCSRUNCNTL_SF |
|
SF805 Credit Card User ID |
This report lists any user IDs with credit card security. (Crystal) |
Set Up SACR, Security, Secure Student Financials, User Reports, Credit Card |
PRCSRUNCNTL_SF |
|
SF806 Company Permission List |
SF security listing of companies secured by a permission list. (Crystal) |
Set Up SACR, Security, Secure Student Financials, Permission List Reports, Company |
PRCSRUNCNTL_SF |
|
SF807 Company User ID |
SF security listing of companies secured by a single user ID. (Crystal) |
Set Up SACR, Security, Secure Student Financials, User Reports, Company |
PRCSRUNCNTL_SF |
|
SF809 Item Type Permission List |
SF security listing of item types secured by a permission list. (Crystal) |
Set Up SACR, Security, Secure Student Financials, Permission List Reports, Item Type |
PRCSRUNCNTL_SF |
|
SF810 Item Type User ID |
SF security listing of item types secured by a single user ID. (Crystal) |
Set Up SACR, Security, Secure Student Financials, User Reports, Item Type |
PRCSRUNCNTL_SF |
|
SF811 SetID Permission List |
SF security listing of setIDs secured by a permission list. (Crystal) |
Set Up SACR, Security, Secure Student Financials, Permission List Reports, SetID |
PRCSRUNCNTL_SF |
|
SF812 SetID User ID |
SF security listing of setIDs secured by an individual user ID. (Crystal) |
SetID Set Up SACR, Security, Secure Student Financials, User Reports, SetID |
PRCSRUNCNTL_SF |
|
SF815E Trial Bal by Acct (Eff Dt) |
This report lists the trial balance by account by item effective date. (Crystal) |
Student Financials, GL Interface, Trial Balance Reports, By Account |
RUNCTL_SF815 |
|
SF815P Trial Bal by Acct (Post Date) |
This report lists trial balances by account by posted date. (Crystal) |
Student Financials, GL Interface, Trial Balance Reports, By Account |
RUNCTL_SF815 |
|
SF816E Trial Bal by Stud Itm (Eff Dt) |
Trial balance by student item (item effective date). (Crystal) |
Student Financials, GL Interface, Trial Balance Reports, By Student Item |
RUNCTL_SF815 |
|
SF816P Trial Bal by Stud Itm (Pst Dt) |
Trial balance by student item (post date). (Crystal) |
Student Financials, GL Interface, Trial Balance Reports, By Student Item |
RUNCTL_SF815 |
|
SF817E Trial Bal by Student (Eff Dt) |
Trial balance by student (item effective date). (Crystal) |
Student Financials, GL Interface, Trial Balance Reports, By Student |
RUNCTL_SF815 |
|
SF817P Trial Bal by Student (Post Dt) |
Trial balance by student (post date). (Crystal) |
Student Financials, GL Interface, Trial Balance Reports, By Student |
RUNCTL_SF815 |
|
SF818E Trl Bal Corp by Acct (Eff Dt) |
Trial balance corporation by account (item effective date). (Crystal) |
Student Financials, GL Interface, Trial Balance Reports, By Corporate Account |
RUNCTL_SF815 |
|
SF818P Trl Bal Corp by Acct (Pst Dt) |
Trial balance organization by account (post date). (Crystal) |
Student Financials, GL Interface, Trial Balance Reports, By Corporate Account |
RUNCTL_SF815 |
|
SF819E Trial Bal by Corp Itm (Eff Dt) |
Trial balance by corporation item (item effective date). (Crystal) |
Student Financials, GL Interface, Trial Balance Reports, By Corporate Item |
RUNCTL_SF815 |
|
SF819P Trial Bal by Corp Itm (Pst Dt) |
Trial balance by corporation item (post date). (Crystal) |
Student Financials, GL Interface, Trial Balance Reports, By Corporate Item |
RUNCTL_SF815 |
|
SF820E Trial Bal by Corp (Eff Date) |
Trial balance by corporation (item effective date). (Crystal) |
Student Financials, GL Interface, Trial Balance Reports, By Corporation |
RUNCTL_SF815 |
|
SF820P Trial Bal by Corp (Post Date) |
Trial balance by corporation (post date). (Crystal) |
Student Financials, GL Interface, Trial Balance Reports, By Corporation |
RUNCTL_SF815 |
|
SF821 Credit History for All Students |
Credit history for all students, for a specified business unit and effective date. (Crystal) |
Student Financials, Collections, Credit History, All Customer Report |
RUNCTL_SFBU_ASOFDT |
|
SF822 Credit History for One Student |
Credit history for one student, for a specified business unit and effective date. (Crystal) |
Student Financials, Collections, Credit History, One Customer Report |
RUNCTL_SF822 |
|
SF823 Credit History for All Corporations |
Credit history for all corporations, for a specified business unit and effective date. (Crystal) |
Student Financials, Collections, Credit History, All Corporation Report |
RUNCTL_SF823 |
|
SF824 Credit History for One Corporation |
Credit history for one corporation, for a specified business unit and effective date. (Crystal) |
Student Financials, Collections, Credit History, One Corporation Report |
RUNCTL_SF824 |
|
SF825 Credit History Student by Acct |
Credit history for all students, by account, for a specified business unit and effective date. (Crystal) |
Student Financials, Collections, Credit History, Customer Report by Account |
RUNCTL_SF825 |
|
SF826 Credit History by Account for Corporations |
Credit history for all corporations, by account number, for a specified business unit and effective date. (Crystal) |
Student Financials, Collections, Credit History, Corporate Account Report |
RUNCTL_SF826 |
|
SF828 Open Refunds |
Open refunds, sorted by student name. (Crystal) |
Student Financials, Refunds, Reports, Open Refunds |
RUNCTL_SF828 |
|
SF829 Refunds by Date |
This report lists all refunds processed for a certain date. (Crystal) |
Student Financials, Refunds, Reports, Refunds by Date |
RUNCTL_SF829 |
|
SF830 Completed Refunds by Date |
This report lists all completed refunds by date. It also lists information on paycheck gross, taxes and net amounts. (Crystal) |
Student Financials, Refunds, Reports, Completed Refunds by Date |
RUNCTL_SF830 |
|
SF847 Group Post Suspended Report |
Detailed list of transactions that have not been posted through the Group Post process. (Crystal) |
Student Financials, Charges and Payments, Group Processing, Group Post — Suspended |
RUNCTL_SF847 |
|
SF853 Batch Refund |
This report lists all refunds processed within a specified Batch ID. (Crystal) |
Student Financials, Refunds, Process Batch Refunds, Report Batch Refunds |
RUNCTL_SF853 |
|
SF854 Batch Refund Messages |
This report lists all error or warning messages encountered during a specified Batch ID. (Crystal) |
Student Financials, Refunds, Process Batch Refunds, Report Batch Messages |
RUNCTL_SF854 |
|
SF856 Account Audit Statement |
Detail transaction listing for an individual or external organization. (Crystal) |
Student Financials, Charges and Payments, Posting Reports, Account Audit Statement Report |
RUNCTL_SF856 |
|
SF859 Tax Assessment Summary Report |
The tax assessment summary report for a given period by business unit and tax authority. (Crystal) |
Student Financials, Taxes, Tax Reports, GST Tax Summary Report |
RUNCTL_SF859 |
|
SF860 Individual tax detail |
Individual tax detail report for a given reporting period. (Crystal) |
Student Financials, Taxes, Tax Reports, Individual GST Tax Detail |
RUNCTL_SF860 |
|
SF861 Organization Tax Detail |
Organization tax detail report for a given reporting period. (Crystal) |
Student Financials, Taxes, Tax Reports, Organization GST Tax Detail |
RUNCTL_SF861 |
|
SF862 Batch Credit Card Detail Rpt |
This report lists all the relevant credit card details per batch ID from the Refund Credit Card − Web process. (Crystal) |
Student Financials, Refunds, Electronic Payment Refunds, Batch ePayment Refund Details |
RUN_CNTL_SF862 |
|
SF1098RP Print 1098-T Forms |
This process prints 1098-T forms and creates electronic transmission files. (SQR) |
Student Financials, Taxes, Tax Reports, 1098–T Form Print |
RUNCTL_SF_SF1098RP |
|
SF1098VP 1098-T Validation and Audit |
The 1098-T Validation Report lists any records with invalid data and assigns a validation status to records on the 1098-T Audit report. The Audit report lists all records generated in the 1098-T generation process for review before printing or transmitting the file. (SQR) |
Student Financials, Taxes, Tax Reports, 1098–T Audit Report |
RUNCTL_SF_SF1098VP |
|
SFBILLIV Print Non-Extract File Invoice |
This report generates bills for printing. (XML Publisher) (SQR) |
|
RUN_CNTL_PBILL RUN_CNTL_PBILL_ORG |
|
SFBKPOST SF Backup Post |
This process purges the QUICK_POST_TBL and consolidates the transactions into a posting group for review. A listing of these transactions may be generated. (SQR) |
Student Financials, Charges and Payments, Group Processing, Purge Posting Table |
RUN_CNTL_SFBKPOST |
|
SFCALTUI Tuition Residency Calculation |
This report lists all students for whom tuition residency calculation has been processed. (SQR) |
Student Financials, Tuition and Fees, Calculate Batch Tuition, Calculate Terms in Residency |
RUNCTL_CALC_TUIT_R |
|
SFCOLLEC Collections |
This report lists each student or corporation that has been assigned to collections. This includes the past due categories and amounts. (SQR) |
Student Financials, Collections, Process Collections |
RUNCTL_COLLECT_SF |
|
SFCOLLTR Collections Dunning Letter |
This is a process that creates communication records in PeopleSoft Campus Community for each collection letter requiring generation. (SQR) |
Student Financials, Collections, Letter Generation, Generate Dunning Letters |
RUNCTL_SFBU |
|
SFCPTMFE Copy Term Fees |
This program copies term fees from one term or one session to another. The report shows the details of the added term fees. (SQR) |
Set Up SACR, Product Related, Student Financials, Tuition and Fees, Copy Term Fees |
RUNCTL_SFCPTMFE |
|
SFDONAT Generate Donation Receipts |
This program generates the information for receipts for donations received by Universities from third parties. (SQR) |
Student Financials, Taxes, Generate Donation Receipts |
RUN_PARM_DONAT |
|
SFGENT4 SF Generate T4A Data |
Generates T4A data in preparation for printing T4A slips. (SQR) |
Student Financials, Taxes, Generate T4A |
RUNCTL_SF_GENT4 |
|
SFGLVAL1 Invalid GL Interface Chartfield Report |
Lists invalid chartfields in SF targets, tenders, class/course fees and item types by term. (SQR) |
Set Up SACR, Product Related, Student Financials, General Ledger Interface, ChartField Validation |
RUNCTL_SFGLVAL1 |
|
SFGT2202 SF Generate T2202 Data |
Generates T2202A data in preparation for printing T2202A forms. (SQR) |
Student Financials, Taxes, Generate T2202A |
RUNCTL_SF_SFGT2202 |
|
SFJT2202 Process T2202A Report File |
This process generates the T2202A information. It will either update the tables in preparation for printing, or generate a report for review. (SQR) |
Student Financials, Taxes, Create T2202A Extract File |
RUNCTL_SF_SFJT2202 |
|
SFLOCKIN Lock In Tuition and Fees |
This report lists students who have had their tuition locked in. (SQR) |
Student Financials, Tuition and Fees, Process Tuition Lock In |
RUNCTL_LCK_IN_TUIT |
|
SFPENRDP SF Enrollment Deposits |
Creates and releases service indicators based on student payment of enrollment deposits. (SQR) |
Student Financials, Charges and Payments, Enrollment Deposits |
RUNCTL_ENRL_DPST RUNCTL_ENRL_DPST2 |
|
SFPR2202 Print T2202A Tax Forms |
This process prints T2202A tax forms. (SQR) |
Student Financials, Taxes, Print T2202A |
RUNCTL_SFPR2202 |
|
SFPRGPLD SF External File Load |
The process to load external files. A detail listing of the transactions loaded may be generated. (SQR) |
Student Financials, Charges and Payments, Group Processing, External Files |
RUNCTL_SFGPLOAD |
|
SFRCRCPT Print Receipt |
This program prints student payment / department receipts. (SQR) It generates income tax receipts for students enrolled in non degree courses (Canadian) |
Student Financials, Taxes, Generate Tax Receipts |
RUNCTL_SFRECEPT |
|
SFRSCVW SF Load Security Views |
Listing of table views used in SF security. (SQR) |
Set Up SACR, Security, Secure Student Financials, Process, Set Security |
RUNCTL_SFSCRTY |
|
SFRVRGRP Group Reversal |
Used to reverse a group after it has been posted. (SQR) |
Student Financials, Charges and Payments, Group Processing, Reverse Groups |
RUNCTL_SFRVRGRP |
|
SFTBLVAL Table Validation Report |
This process reports on, and/or corrects any referential integrity issues within SF tables. (SQR) |
Student Financials, Charges and Payments, Validate Tables |
RUN_CNTL_SFTBLVAL |
|
SFTRMCPY Copy Term Session |
This process copies chartfield information by Item Type Classification from one Term to another. (SQR) |
Set Up SACR, Product Related, Student Financials, General Ledger Interface, Copy Term |
RUNCTL_SFGL_FEE |
|
SFWRTOFF Batch Write off |
Detailed listing of accounts flagged to be written off. (SQR) |
Student Financials, Collections, Write Offs, Run Write-off Process |
RUNCTL_WRITE_OFF |
Setup Table Crystal Reports|
Report ID and Report Name |
Description |
Navigation |
Run Control Page |
|
SF701 Term Fees Table |
This report lists all information from the Term Fees Table. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SFSETID |
|
SF702 Term Sub Fees Report |
This report lists information from the Term Subfees Table. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SF703 |
|
SF703 Class Fees Report |
This report lists all information from the Class Fees Table. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SF704 |
|
SF704 Course Fees Report |
This report lists all information from the Course Fees Table. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SF705 |
|
SF705 Course Rates Table |
This report lists all information from the Course Rates Table. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SFSETID |
|
SF712 Billing and Due Calendars |
This report lists all information from the Billing and Due Calendars Table. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SF712 |
|
SF713 Keyword Table |
This report lists all information in the Keyword Table. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SFSETID |
|
SF714 Account Type Table |
Detailed setup report of the institution's SF account types. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SF714 |
|
SF717 Fee Class Table |
This report lists all information in the Fee Class Table. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SF717 |
|
SF718 Item Reason Table |
Listing of item reason values created. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SF718 |
|
SF719 Charge Priority List |
Listing of values defined in the Charge Priority List setup. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SF719 |
|
SF720 Business Unit Table |
Business Unit Table. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SF720 |
|
SF721 Group Type Table |
Listing of the Group Type Table. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SF721 |
|
SF722 Origin Table |
Listing of values defined the origin table setup. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SF722 |
|
SF730 Selection Criteria |
This report lists information in the Criteria Table. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SF730 |
|
SF733 Cash Offered Table Report |
This report lists information relative to cashiering offices. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SF733 |
|
SF734 Tender Key Table Report |
Report for the Tender Key Table. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SF734 |
|
SF735 Target Key Table Report |
Report for the Target Key Table. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SF735 |
|
SF740 Cashier Message Business Date |
This report lists all cashiering office messages. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SF740 |
|
SF741 Cashier Message Tender |
This report lists any Cashier Tender messages within a cashiering office. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SF741 |
|
SF742 Cashier Message Target |
This report lists any Cashier Target messages within a cashiering office. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SF742 |
|
SF743 Valid Cashiers Per Office |
Report of the valid cashiers for each office. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SF743 |
|
SF744 Follow Up Table |
This report lists follow up actions for collections activity by setID and as of date. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SFASOFDT |
|
SF745 Collection Criteria |
This report lists the criteria used to assign student collection items to the appropriate collector. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SFBU |
|
SF746 Corp Collection Criteria |
This report lists the criteria used to assign corporate collection items to the appropriate collector. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SFBU |
|
SF747 Collector |
This report lists the collectors by user ID. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SFBU_ASOFDT |
|
SF748 Reason In Table |
This report lists all information in the Reason In table for collection activity. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SFASOFDT |
|
SF749 Reason Out Table |
This report lists all information in the Reason Out table to remove a student/corporation from collections. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SFASOFDT |
|
SF769 Waiver Form Table |
This lists all information on the Waiver Form Table. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SFASOFDT |
|
SF773 Application Fee |
List of application fee codes with subfees for each term. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SFSETID |
|
SF774A Course List |
This report contains the Course List Details. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SFASOFDT |
|
SF774B Course List Fees |
This report lists all information from the Course List Fee and Course List Subfee Table. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SFSETID |
|
SF775 Deposit Fees |
This report lists all information from the Deposit Fee Table. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SFSETID |
|
SF776 Minimum Maximum Fee |
This lists all information on the Minimum Maximum Fee Table. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SFSETID |
|
SF777 Optional Fee Table |
This report lists all values in the Optional Fee Table. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SFASOFDT |
|
SF778 Optional Fee Term |
This report lists all valid values in the Optional Fees per Term Table. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SFSETID |
|
SF779 Transaction Fees |
This report lists all information on the Transaction Fee Table. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SF779 |
|
SF779 Transaction Fee Table |
Transaction Fee Table. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SFSETID |
|
SF780 Calc Control Table |
List of careers in use for each term and the parameters (auto calc tuition/waivers, term and transaction wash periods). (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SF771 |
|
SF781 Waiver Table |
This report lists all information on the Waiver Table. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SFSETID |
|
SF784 Billing Aging Messages |
This report lists all billing aging messages set up for a business unit. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SFBU_ASOFDT |
|
SF785 Billing Message Table |
Billing Message Table. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SFASOFDT |
|
SF786 Billing Scan Line |
This report lists all information from the Billing Scan Line table. (Crystal) |
Reporting Tools, Query, Query Manager |
PRCSRUNCNTL_SF |
|
SF787 Billing Type Table |
This report lists all information from the Billing Type Table. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SFASOFDT |
|
SF788 Billing Messages for Students |
This report lists information from the Billing Messages page. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SFBU_ASOFDT |
|
SF789 Billing Messages for Corp |
This report lists information from the Corporate Messages page. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SFBU_ASOFDT |
|
SF790 Billing Messages for Customers |
This report lists information from the Customer Messages page. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SFBU_ASOFDT |
|
SF791 Invoice Layout |
This report lists all information from the Invoice Layout component. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SFSETID |
|
SF792 Invoice Number |
This report lists all information from the Invoice Number page. (Crystal) |
Reporting Tools, Query, Query Manager |
PRCSRUNCNTL_SF |
|
SF793 Messages by Item Type |
Messages by item type. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SFBU_ASOFDT |
|
SF794 Billing Message Category |
This report lists information from the Billing Message Category page. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SFBU_ASOFDT |
|
SF795 Billing Standard Request |
This report lists all information from the Billing Standard Request table based on setID. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SFASOFDT |
|
SF855 Adjustment Calendars |
List of detail for all adjustment codes in the database. Includes adjustment options, adjust reasons, terms, and line data for each category. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SF855 |
|
SF858 Tuition Group Report |
This report lists all information for tuition groups. (Crystal) |
Reporting Tools, Query, Query Manager |
RUNCTL_SF858 |