PeopleSoft Student Financials Reports: A to ZThis 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
Enterprise PeopleTools PeopleBook: Process Scheduler
PeopleSoft Student Financials Reports: A to ZThis table lists the Student Financials reports, sorted alphanumerically by report ID.
Crystal and SQR Reports
Setup Table Reports
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 Finanacials, 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 |
|
SF814 TP Contracts |
Third-party contract setup values. (Crystal) |
Student Financials, Payment Plans, Third Party Contract, Third Party Contract Report |
RUNCTL_SF814 |
|
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 |