How Banner 320 calculates contact hours, and thus FTES, by Attendance Method.
History
Coronavirus scheduling uncovered that our historical precedents made tasks easier but not granular enough to be accurate and adaptable. This page will document how Banner calculates contact hours, and thus FTES based on the specified Attendance Method.
Current Deficiencies
Argos and EIS FTES reports both have incomplete logic to correctly calculate FTES for IW/ID sections with a lab/activity/other component.https://sequoias.atlassian.net/browse/AP-58
Attendance Method
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.
WHERE STVACCT_CODE IN ('I','ID','IW','TE','WE') AND CONTACT_HOURS_FTES IS NULL
Independent Weekly - STVACCT_CODE with only Weekly STVACCT_WCH = “Y” and Independent Study STVACCT_INDEPENDENT_IND = ”Y”
For Sessions that have a Meeting Type SSRMEET_MTYP_CODE with a GTVMTYP_LAB_IND of “N”, it will take the Session Credit Hours SSRMEET_CREDIT_HR_SESS and multiply it by the Term’s Term Length Multiplier STVTERM_TERM_LEN_MULT.
For Sessions that have a Meeting Type SSRMEET_MTYP_CODE with a GTVMTYP_LAB_IND of “Y”, it will take Session Hours per Week SSRMEET_HRS_WEEK and multiply it by the Term’s Term Length Multiplier STVTERM_TERM_LEN_MULT.
Sourced from Banner Student Consulting meeting 3/4/21
Independent Daily - STVACCT_CODE with only Daily STVACCT_DCH = “Y” and Independent Study STVACCT_INDEPENDENT_IND = ”Y”
For Sessions that have a Meeting Type SSRMEET_MTYP_CODE with a GTVMTYP_LAB_IND of “N”, it will take the Session Credit Hours SSRMEET_CREDIT_HR_SESS and multiply it by the Term’s Term Length Multiplier STVTERM_TERM_LEN_MULT.
For Sessions that have a Meeting Type SSRMEET_MTYP_CODE with a GTVMTYP_LAB_IND of “Y”, it will take the Session Total Contact Hours SSRMEET_HRS_TOTAL.
Sourced from Banner Student Consulting meeting 3/11/21 @ 23 minute mark
Weekly Attendance - “W”
https://sequoias.atlassian.net/browse/AP-57
Daily Attendance - “D”
https://sequoias.atlassian.net/browse/AP-57
Positive Attendance - “P” (also known as Actual Attendance)
Pulled from SFRSTCR_ATTEND_HR where SSBSECT_ACCT_CODE = STVACCT_ACTUAL_IND
Add Comment