This page documents how Banner calculates Contact Hours, Total Student Contact Hours, and FTES.
CALB Student Handbook 8.8 was used as the primary source of truth for this documentation. |
SAAM is also helpful for what is allowed.
SAAM is also helpful for what is allowed.
Coronavirus scheduling uncovered that our historical precedents made tasks easier, but not granular enough to be accurate and adaptable.
CRN has only a STVACCT_WCH of “Y” and STVACCT_INDEPENDENT_IND = "N"
CRN must be a credit course:IF SCBCRSE_CREDIT_STATUS_CODE IN (SELECT SVVCCST_CREDIT_STATUS FROM svvccst WHERE SVVCCST_CREDIT_COURSE = 'Y')
CRN is not Inmate-only CRN. (Not currently used by COS and not programmed to handle this use case)
Sum all values on each Hours per Week SSRMEET_HRS_WEEK and multiply that by the Term Length Multiplier STVTERM_TERM_LEN_MULT.
CRN has only a STVACCT_DCH of “Y” and STVACCT_INDEPENDENT_IND = "N"
CRN must be a credit course:IF SCBCRSE_CREDIT_STATUS_CODE IN (SELECT SVVCCST_CREDIT_STATUS FROM svvccst WHERE SVVCCST_CREDIT_COURSE = 'Y')
CRN is not Inmate-only CRN. (Not currently used by COS and not programmed to handle this use case)
SSRMEET_HRS_DAY multiplied by SSRMEET_MEET_NO for each session and then sum each session together.
STVACCT_INDEPENDENT_IND = “Y” and STVACCT_WCH = “Y”
CRN must be a credit course:IF SCBCRSE_CREDIT_STATUS_CODE IN (SELECT SVVCCST_CREDIT_STATUS FROM svvccst WHERE SVVCCST_CREDIT_COURSE = 'Y')
CRN is not Inmate-only CRN. (Not currently used by COS and not programmed to handle this use case)
All sessions with a Meeting Type GTVMTYP_LAB_IND of Lab, the values of the sessions' Hours Per Week SSRMEET_HRS_WEEK are summed.
All sessions with a Meeting Type GTVMTYP_LAB_IND of not Lab, the values of all sessions' Session Credit Hours SSRMEET_CREDIT_HR_SESS are summed.
Then the two bullet points above are summed and then multiplied by the Independent Study Term Length Multiplier STVTERM_TERM_LEN_MULT_IS.
Also validated from Banner Student Consulting meeting 3/4/21 |
Confirmed by Change Request: CR-000184369 (force.com)
Confirmed by Change Request: CR-000184369 (force.com)
We aren’t setup for this. If it becomes in use by Academic Services programming augmentation will have to take place. |
STVACCT_INDEPENDENT_IND = “Y” and STVACCT_WCH = “Y”
CRN must be a non-credit course: IF SVVCCST_CREDIT_STATUS FROM svvccst WHERE SVVCCST_CREDIT_COURSE = 'N')
Or CRN is Inmate-only CRN. (Not currently used by COS and not programmed to handle this use case)
Returns this for now: "Not setup for IW Non-Credit two Census Avg."
STVACCT_DCH = “Y” and STVACCT_INDEPENDENT_IND = “Y”
CRN must be a credit course:IF SCBCRSE_CREDIT_STATUS_CODE IN (SELECT SVVCCST_CREDIT_STATUS FROM svvccst WHERE SVVCCST_CREDIT_COURSE = 'Y')
CRN is not Inmate-only CRN. (Not currently used by COS and not programmed to handle this use case)
For sessions that have a Meeting Type SSRMEET_MTYP_CODE with a GTVMTYP_LAB_IND of “N”, it will sum the Session Credit Hours SSRMEET_CREDIT_HR_SESS and multiply that by the Independent Study Term Length Multiplier STVTERM_TERM_LEN_MULT_IS.
For sessions that have a Meeting Type SSRMEET_MTYP_CODE with a GTVMTYP_LAB_IND of “Y”, it will take sum the session’s Total Contact Hours SSRMEET_HRS_TOTAL.
Then the two bullet points above are summed.
Also validated from Banner Student Consulting meeting 3/11/21 @ 23 minute mark |
If SSBSECT_ACCT_CODE has a STVACCT_CODE with STVACCT_ACTUAL_IND = “Y” irrespective of STVACCT_INDEPENDENT_IND value
CRN can be credit or not SCBCRSE_CREDIT_STATUS_CODE
Sum SFRSCTR_ATTEND_HR
Unlike the rest of the Accounting Methods that are only calculating the Total Contact Hours, Positive Attendance calculates the Total Student Contact Hours (TSCH). Other Attendance Methods are calculating the Contact Hours before multiplying by enrollment data. |
All independent study to make sure all of them have FTES. Some courses run active without enrollment (SSBSECT_ENRL).
WHERE STVACCT_CODE IN ('I','ID','IW','TE','WE') AND CONTACT_HOURS_FTES IS NULL |
Expect not to see results other than the 0 enrollment.
/* * ========================== * NOTE (Banner column docs): * ========================== * STVACCT_INDEPENDENT_IND - Independent study indicator, may be Y or blank, cannot be Y if any other indicator is Y * STVACCT_WCH - Weekly accounting method indicator, may be Y or blank, cannot be Y if DCH is Y * STVACCT_DCH - Daily accounting method indicator, may be Y or blank, cannot be Y if WCH is Y * */ |
"In Banner® CALBSTU, a contact hour is calculated and saved on each CRN Meeting
SSRMEET record. This value is summed and displayed in fields in the main window of
SSASECT, but it is not saved with the SSBSECT records."
1. Census Procedure Courses For Weekly or Daily Census courses in primary terms, including Alternative Attendance Accounting Procedure courses, the full-time equivalent student (FTES) is to be reported in the period in which the census accounting procedure is completed, even if the course is not completed by the deadline for reporting.
For summer intersession Daily Census courses that cross fiscal years, including Alternative Attendance Accounting Procedure courses, the hours and FTES are to be reported in the fiscal year in which the census date occurs (both census dates for noncredit course sections that apply the Alternative Attendance Accounting Procedure per CCR §58003.1(f)((2)), or when the course ends. These FTES can be selected on a courses-by-course basis. 3-23 Student Attendance Accounting Manual California Community Colleges
2. Actual Hours of Attendance Courses (Positive Attendance) For courses for which Actual Hours of Attendance Procedure are reported (Positive Attendance), the full-time equivalent student (FTES) is to be reported in the period in which the course is completed, even if the course overlaps fiscal years. Reference: T5 58003.1, 58010
Source (SAAM)
Sorry for the delay on this. I’m inclined to say these Alternative Attendance Accounting Procedure-Daily Census courses also have the summer shift reporting option. Title 5 section 58010(a) states “Full-time equivalent student for courses using census procedure may be reported in either the fiscal year in which the census day procedure is completed or in which the course ends.” I know that this provision does not apply to positive attendance courses (those must be reported in the period in which the course ends), however, I do not see any reason that it would not apply to courses on the alternative attendance accounting procedure- daily census.
As is the case with regular daily census courses, you would want to make sure that appropriate records are maintained to show that FTES were claimed appropriately and not claimed in both fiscal years. -Natalie Wagner 7/15/2021 |
The content by label feature displays related articles automatically, based on labels you choose. To edit options for this feature, select the placeholder below and tap the pencil icon.