...

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

...

Status

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

...

Contact Hours

...

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.

...

Weekly

Condition(s)

1. CRN has only a STVACCT_WCH of “Y”

2. CRN must be a credit course:IF SCBCRSE_CREDIT_STATUS_CODE IN (SELECT SVVCCST_CREDIT_STATUS FROM svvccst WHERE SVVCCST_CREDIT_COURSE = 'Y')

3. 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

Condition(s)

1. CRN has only a STVACCT_DCH of “Y”

2. CRN must be a credit course:IF SCBCRSE_CREDIT_STATUS_CODE IN (SELECT SVVCCST_CREDIT_STATUS FROM svvccst WHERE SVVCCST_CREDIT_COURSE = 'Y')

3. CRN is not Inmate-only CRN. (Not currently used by COS and not programmed to handle this use case)

Calculation

SSRMEET_HRS_DAY multiplied by SSRMEET_MEET_NO for each session and then sum each session together.

Independent Weekly

Condition(s)

1. STVACCT_INDEPENDENT_IND = “Y” and STVACCT_WCH = “Y”

2. CRN must be a credit course:IF SCBCRSE_CREDIT_STATUS_CODE IN (SELECT SVVCCST_CREDIT_STATUS FROM svvccst WHERE SVVCCST_CREDIT_COURSE = 'Y')

3. 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_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.

Independent

...

Weekly Non-Credit census (two-census-averaging)

Condition(s)

1. STVACCT_INDEPENDENT_IND = “Y” and STVACCT_WCH = “Y”

2. CRN must be a non-credit course: IF SVVCCST_CREDIT_STATUS FROM svvccst WHERE SVVCCST_CREDIT_COURSE = 'N')

3. Or CRN is Inmate-only CRN. (Not currently used by COS and not programmed to handle this use case)

Calculation

Independent Daily

Condition(s)

1. STVACCT_DCH = “Y” and

...

1. STVACCT_INDEPENDENT_IND =

...

1. “Y”

2. CRN must be a credit course:IF SCBCRSE_CREDIT_STATUS_CODE IN (SELECT SVVCCST_CREDIT_STATUS FROM svvccst WHERE SVVCCST_CREDIT_COURSE = 'Y')

3. 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.

• 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.

...

Positive Attendance -

...

“P” (also known as Actual Attendance)

Condition(s)

1. If SSBSECT_ACCT_CODE has a STVACCT_CODE with

...

1. STVACCT_

...

1. ACTUAL_IND = “Y” irrespective of STVACCT_INDEPENDENT_IND

...

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

...

1. value

2. CRN can be credit or not SCBCRSE_CREDIT_STATUS_CODE

 Calculation

Sum SFRSCTR_ATTEND_HR

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.

WHERE STVACCT_CODE IN ('I','ID','IW','TE','WE') AND CONTACT_HOURS_FTES IS NULL

Information

 /* 
    * ==========================
    * 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
    *
    */

Related articles