Page Comparison

How Banner 320 calculates contact hoursTotal 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 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.

...

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.

...

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

Related articles