How Banner 320 calculates Total Student Contact Hours (TSCH), 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 Total Student 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
Non Positive Attendance Methods
Independent Attendance Methods
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”
If SSBSECT_ACCT_CODE has STVACCT_CODE with
STVACCT_WCH='Y” and STVACCT_INDEPENDENT_IND = “N”,
or STVACCT_WCH=”Y” and STVACCT_INDPENDENT_IND = “Y”,
or STVACCT_INDPENDENT_LAB_IND only
Then multiply STVTERM_TERM_LEN_MULT for SSRMEET_TERM_CODE by SSRMEET_HRS_WEEK
Daily Attendance - “D”
If SSBSECT_ACCT_CODE has a STVACCT_CODE with
STVACCT_DCH = 'Y” and STVACCT_INDEPENDENT_IND = “N”,
or STVACCT_DCH = “Y” and STVACCT_INDEPENDENT_IND = “Y”
Then multiply SSRMEET_MEET_NO by SSRMEET_HRS_DAY
Positive Attendance - “P” (also known as Actual Attendance)
If SSBSECT_ACCT_CODE has a STVACCT_CODE with STVACCT_ACTUAL_IND = “Y”
then sum SFAALST>Hours Attend
Add Comment