Versions Compared

Old Version 31

changes.mady.by.user Jordan Lamb

Saved on

compared with

New Version Current

changes.mady.by.user Jordan Lamb

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info

CALB Student Handbook 8.8 was used as the primary source of truth for this documentation.

SAAM is also helpful for what is allowed.

...

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.

Jira Legacy
serverSystem JIRAJira
serverId8b861ae3-ff87-316b-a17e-97c61a7e2fb4
keyAP-58

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.

Jira Legacy
serverSystem Jira
serverId8b861ae3-ff87-316b-a17e-97c61a7e2fb4
keyAP-499

Note

Does not use SSRMEET_HRS_DAY multiplied by SSRMEET_MEET_NO for each session and then sum each session

...

together” like previously documented. It may do that logic when Override Hours SSRMEET_HRS_OVER_IND is unchecked, but there is no difference as Total Contact Hours SSRMEET_HRS_TOTAL would also match that same logic.

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.

...

Info

Also validated from Banner Student Consulting meeting 3/4/21 @ 57 minute mark.

Confirmed by Change Request: CR-000184369 (force.com)

...

Note

We aren’t setup for this. If it becomes in use by Academic Services programming augmentation will have to take place.

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.

...

Info

Also validated from Banner Student Consulting meeting 3/11/21 @ 23 minute mark

Note

Change Request: CR-000182178 (force.com) seems to disagree with this. Says:
For ISDAY, the non-lab hrs value in total contact hrs calculation is multiplied with ISTLM when the term type parameter is SEMESTER.

See how the dust settles on this before creating a project to change local report.

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

Info

Unlike the rest of the Accounting Methods that are only calculating the Total Contact Hours, Positive Attendance calculates the Total Student Contact Hours (TSCH). Other Attendance Accounting Methods are calculating the Contact Hours before multiplying by enrollment data.

...

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

Info

Sorry for the delay on this. I’m inclined to say these Alternative Attendance Accounting Procedure-Daily Census courses also have the summer shift reporting option. Title 5 section 58010(a) states “Full-time equivalent student for courses using census procedure may be reported in either the fiscal year in which the census day procedure is completed or in which the course ends.” I know that this provision does not apply to positive attendance courses (those must be reported in the period in which the course ends), however, I do not see any reason that it would not apply to courses on the alternative attendance accounting procedure- daily census.

 

As is the case with regular daily census courses, you would want to make sure that appropriate records are maintained to show that FTES were claimed appropriately and not claimed in both fiscal years.

-Natalie Wagner 7/15/2021

For Daily and Independent Daily sections, it was decided to use the Census Date for the Reporting Year calculation for our local reporting. Decisions of push/pull can still be made outside of this decision.

  1. Decision: Kristin Robinson (Dean of Enrollment Management) on .

  2. Title 5 allows Census Date or Part of Term End Date.

Colleague Notes

At the we were shared this:

Code Block
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.

Filter by label (Content by label)
showLabelsfalse
max5
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@844
sortmodified
showSpacefalse
reversetrue
typepage
cqllabel = "documentation" and type = "page" and space = "BF"
labelsdocumentation
Change History