Generate Student Statements
Purpose: Use this document as a resource for how to generate a student billing statement in ctcLink.
Audience: Student Financials Staff.
You must have at least one of these local college-managed security roles:
- ZZ SF Processing
- ZZ SF Student Stmts
and
- ZD_DS_QRY_STUDENT_FINANCE
If you need assistance with the above security roles, please contact your local college supervisor or IT Admin to request role access.
Navigation: Student Financials > CTC Custom > CTC SF Reports > Generate Student Statements
- The Generate Student Invoice run control search page displays.
- If you have run this process or report in the past, select the Find an Existing Value tab to enter an existing Run Control ID and select the Search button. If this is the first time running this process or report, select the Add a New Value tab to create a new Run Control ID and select the Add button.
- NOTE: It is important to note that Run Control IDs cannot be deleted. Do not include spaces in your Run Control. We encourage the Run Control ID to have the same process naming convention but unique to the step; because of this, including your institution code and a short process description in the Run Control ID is recommended--e.g., WA220_ADM_FYR_5 (Admissions Letter, Summer, FYR Admit Type).
- The Student Statement page displays.
- In the Student Invoice Parameters section, enter or search for the:
- Business Unit.
- Student ID.
- Beginning term to include on the billing statement in the From Term field.
- Ending term to include on the billing statement in the To Term field.
- Select the Generate Report button.
- A confirmation Message displays.
- Select the OK button and the Student Statement page displays.
- Please refer to the Report Manager steps for further instructions.
When the time comes to make updates to this statement, please submit a ticket to SF Customer Support with a copy of the desired changes/as much detail as possible. All template updates/adjustments need to have a ticket submitted.
- Process complete.
Video Tutorial
The video below demonstrates the process actions described in the steps listed above. There is no audio included with this video. Select the play button to start the video.
Video Tutorial via Panopto
View the external link to Generate Individual Student Statement. This link will open in a new tab/window.
The BI-Report allows you to run one student, a batch up to 25 students (separated with commas), or all students. You can also run the process for one specific term or a term range.
Navigation: Reporting Tools > Bi Publisher > BIP Query Report Scheduler
- The Query Report Scheduler search page displays.
- If you have run this process or report in the past, select the Find an Existing Value tab to enter an existing Run Control ID and select the Search button. If this is the first time running this process or report, select the Add a New Value tab to create a new Run Control ID and select the Add button.
- NOTE: It is important to note that Run Control IDs cannot be deleted. Do not include spaces in your Run Control. We encourage the Run Control ID to have the same process naming convention but unique to the step; because of this, including your institution code and a short process description in the Run Control ID is recommended--e.g., WA220_ADM_FYR_5 (Admissions Letter, Summer, FYR Admit Type).
- The Query Report Scheduler page displays.
- Select the Data Source Type drop-down and select Query.
- Enter or look up the Report Name BCS_SF_STMNT.
- Select the Update Parameters hyperlink if you have run this process before utilizing an old Run Control ID.
- The Report dialogue box displays.
- Enter the Business Unit.
- Enter the From Term.
- Enter the To Term.
- Optional: Enter the EMPLID.
- Select the OK button.
- The Query Report Scheduler page displays.
- Enter or look up the Template ID BCS_SF_STMNT_1.
- Enter the Template As Of Date as the Current Date.
- Select the Run button. Please refer to the Report Manager steps for further instructions.
- Process complete.
This BI-Report allows you to run one student, a batch up to 25 students (separated with commas), or all students. You can also run the process for one specific term or a term range.
Video Tutorial
The video below demonstrates the process actions described in the steps listed above. There is no audio included with this video. Select the play button to start the video.
Video Tutorial via Panopto
View the external link to Batch Generate Student Statements. This link will open in a new tab/window.
Lee
Hello: Can the Individual Student Statements be generated for pre-conversion terms (ie Fall 2020 activity in the conversion term on the Customer Account)?
Alec Risk
Hi Lee,
Unfortunately, you cannot generate Student Statements for pre-conversion terms. That information will need to be obtained through Legacy resources.
Gary McCune
It seems that ZD_DS_QRY_STUDENT_FINANCE is required even when the user has either the "ZZ SF Processing" or "ZZ SF Student Stmts" security roles.
This has not been the case in the past. If confirm, please update ZD_DS_QRY_STUDENT_FINANCE as always required
Tanjagay Martin
Hello Gary!
I appreciate your comment and apologize for any inconvenience caused. The QRG was updated to include the ZD_DS_QRY_STUDENT_FINANCE role. Thank you so much for your time. ~Tanjagay Martin | CS Core Trainer