...

...

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

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

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.

...

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

...