...

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.

https://sequoias.atlassian.net/browse/

Contact Hours by

...

Accounting Method

Weekly (W)

Condition(s)

1. CRN has only a STVACCT_WCH of “Y” and STVACCT_INDEPENDENT_IND = "N"

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 (D)

Condition(s)

1. CRN has only a STVACCT_DCH of “Y” and STVACCT_INDEPENDENT_IND = "N"

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

• Sums every session’s Total Contact Hours SSRMEET_HRS_TOTAL.

...

Independent Weekly (IW)

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.

...

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

Returns this for now: "Not setup for IW Non-Credit two Census Avg."

Independent Daily (ID)

Condition(s)

1. STVACCT_DCH = “Y” and STVACCT_INDEPENDENT_IND = “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.

...

Positive or Actual Attendance (P, E)

Condition(s)

1. If SSBSECT_ACCT_CODE has a STVACCT_CODE with STVACCT_ACTUAL_IND = “Y” irrespective of STVACCT_INDEPENDENT_IND 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.

Other Relevant Documentation

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

Colleague Notes

At the 13 Jun 2024 we were shared this:

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