| Note |
|---|
Will require IW/ID Report Logic fixes once March CALBSTU release happens. |
| Jira Legacy | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
This page documents how Banner calculates Contact Hours, Total Student Contact Hours, and FTES.
| Info |
|---|
CALB Student Handbook 8.8 was used as the primary source of truth for this documentation. |
SAAM is also helpful for what is allowed.
History
Coronavirus scheduling uncovered that our historical precedents made tasks easier, but not granular enough to be accurate and adaptable.
Current Status
Argos and EIS FTES reports both have incomplete logic to correctly calculate FTES for Independent Weekly and Independent Daily sections with a Lab/Activity/Other component.
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
Contact Hours by
...
Accounting Method
Weekly (W)
Condition(s)
CRN has only a
STVACCT_WCHof “Y” andSTVACCT_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)
Calculation
Sum all values on each Hours per Week SSRMEET_HRS_WEEK and multiply that by the Term Length Multiplier STVTERM_TERM_LEN_MULT.
Daily (D)
Condition(s)
CRN has only a
STVACCT_DCHof “Y” andSTVACCT_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)
Calculation
Sums every session’s Total Contact Hours
SSRMEET_HRS_TOTAL.
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Note |
|---|
Does not use |
...
🚧 2022 Updated Independent Weekly (IW)
Condition(s)
STVACCT_INDEPENDENT_IND= “Y” andSTVACCT_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)
Calculation
All sessions with a Meeting Type
GTVMTYP_LAB_INDof Lab, the values of the sessions' Session Credit HoursSSRMEET_CREDIT_HR_SESSare summed, then multiplied by “3”.
| Note |
|---|
That “3” is hard coded in the logic. |
If we schedule activity sessions, we should consider utilizing a Meeting Type with GTVMTYP_LAB_IND of Lab and put in .66 on SSRMEET_CREDIT_HR_SESS for every 1 unit of activity. That would report 1.98 contact hours for that session. Closest current fix for the hard coded “3”.
All sessions with a Meeting Type
GTVMTYP_LAB_INDof not Lab, the values of all sessions' Session Credit HoursSSRMEET_CREDIT_HR_SESSare summed.
Then the two bullet points above are summed and then multiplied by the Independent Study Term Length Multiplier STVTERM_TERM_LEN_MULT_IS.
...
together” like previously documented. It may do that logic when Override Hours |
Independent Weekly (IW)
Condition(s)
STVACCT_INDEPENDENT_IND= “Y” andSTVACCT_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)
Calculation
All sessions with a Meeting Type
GTVMTYP_LAB_INDof Lab, the values of the sessions' Hours Per WeekSSRMEET_HRS_WEEKare summed.All sessions with a Meeting Type
GTVMTYP_LAB_INDof not Lab, the values of all sessions' Session Credit HoursSSRMEET_CREDIT_HR_SESSare summed.
...
| Info |
|---|
Also validated from Banner Student Consulting meeting 3/4/21 @ 57 minute mark. |
Confirmed by Change Request: CR-000184369 (force.com)
Independent Weekly Non-Credit census (two-census-averaging)
| Note |
|---|
We aren’t setup for this. If it becomes in use by Academic Services programming augmentation will have to take place. |
Condition(s)
STVACCT_INDEPENDENT_IND= “Y” andSTVACCT_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)
Calculation
Returns this for now: "Not setup for IW Non-Credit two Census Avg."
🚧 2022 Updated Independent Daily (ID)
Condition(s)
STVACCT_DCH= “Y” andSTVACCT_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)
Calculation
...
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.
...
Then the two bullet points above are summed.
Independent Daily (ID)
Condition(s)
STVACCT_DCH= “Y” andSTVACCT_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)
Calculation
For sessions that have a Meeting Type
SSRMEET_MTYP_CODEwith aGTVMTYP_LAB_INDof “N”, it will sum the Session Credit HoursSSRMEET_CREDIT_HR_SESSand multiply that by the Independent Study Term Length MultiplierSTVTERM_TERM_LEN_MULT_IS.For sessions that have a Meeting Type
SSRMEET_MTYP_CODEwith aGTVMTYP_LAB_INDof “Y”, it will take sum the session’s Total Contact HoursSSRMEET_HRS_TOTAL.
...
| Info |
|---|
Also validated from Banner Student Consulting meeting 3/11/21 @ 23 minute mark |
Positive or Actual Attendance (P, E)
Condition(s)
If
SSBSECT_ACCT_CODEhas aSTVACCT_CODEwithSTVACCT_ACTUAL_IND= “Y” irrespective ofSTVACCT_INDEPENDENT_INDvalueCRN can be credit or not
SCBCRSE_CREDIT_STATUS_CODE
Calculation
Sum SFRSCTR_ATTEND_HR
| Info |
|---|
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 Accounting Methods are calculating the Contact Hours before multiplying by enrollment data. |
Test Cases
All independent study to make sure all of them have FTES. Some courses run active without enrollment (SSBSECT_ENRL).
...
Expect not to see results other than the 0 enrollment.
Other Relevant Documentation
| Code Block |
|---|
/* * ========================== * 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."
Reporting Date Procedures
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.
...
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 - Manuals | California Community Colleges Chancellor's Office (cccco.edu))
| Info |
|---|
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 |
For Daily and Independent Daily sections, it was decided to use the Census Date for the Reporting Year calculation for our local reporting. Decisions of push/pull can still be made outside of this decision.
Decision: Kristin Robinson (Dean of Enrollment Management) on .
Title 5 allows Census Date or Part of Term End Date.
Colleague Notes
At the we were shared this:
| Code Block |
|---|
IF ( is Daily Census on SSASECT is Intersession term on STVTERM has a Part of term code on SSASECT is Leading Summer on SVAACYR ) AND Census Date is less than the Academic Year START DATE on SVAACYR THEN PREVIOUS YEAR ELSE IF is Actual Hours Part of Term End Date is greater than the Academic Year END DATE on SVAACYR THEN NEXT YEAR Part of Term End Date is less than the Academic Year START DATE on SVAACYR THEN PREVIOUS YEAR |
Also, the SVPACAD process will update SSBSECT_ACYR_CODE, the next CALBSTU release includes an enhancement to the process by adding a parameter value to not update that field.
Related articles
| Filter by label (Content by label) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
| Change History |
|---|