👟 Run 1

08 Jul 2022

SFAALST Positive Attendance, With Passing Grades, Without Hours Entered

SELECT      SSBSECT_TERM_CODE
            ,SSBSECT_CRN
            ,SSBSECT_SUBJ_CODE
            ,SSBSECT_CRSE_NUMB
            ,SSBSECT_ACCT_CODE
            ,SFRSTCR_GRDE_CODE
            ,SSBSECT_PTRM_END_DATE
            ,F_GETSPRIDENID(SIRASGN_PIDM) AS "BANNER ID"
            ,F_FORMAT_NAME(SIRASGN_PIDM, 'FL')
FROM        SSBSECT
LEFT JOIN   SFRSTCR ON SSBSECT_TERM_CODE = SFRSTCR_TERM_CODE AND SSBSECT_CRN = SFRSTCR_CRN
LEFT JOIN   SIRASGN ON SSBSECT_TERM_CODE = SIRASGN_TERM_CODE AND SSBSECT_CRN = SIRASGN_CRN
WHERE       SSBSECT_SSTS_CODE = 'A'
--AND         SSBSECT_TERM_CODE IN ('202130','202210','202220')
AND         SSBSECT_ACCT_CODE IN ('P','E')
AND         SFRSTCR_ATTEND_HR IS NULL
AND         (SFRSTCR_GRDE_CODE IS NOT NULL AND SFRSTCR_GRDE_CODE NOT IN ('W','NP','I','NC','EW','F','NG'))
AND         SIRASGN_PRIMARY_IND = 'Y'
ORDER BY    SSBSECT_TERM_CODE DESC

Baseline

SVAAPIZ

ℹ️ How To

Populate Academic Year

District: Do it for 561, 562, 563

Reporting Period:

P1 - 2

P2 - 1

Not needed for Annual

SVRCALX

Sort through the list and resolve errors prior to the next step

Runtime ~5 minutes

ℹ️ How To

04 – Include Exceptions - "Y"

SVRCALD

Runtime ~1 minute

SEND "*WARNING* Total CH is not equal to (Length Mult * Std CH)" To Vanessa Escobar it's about Attendance Method

11 sections. Emailed Scheduling Coordinator 6 sections that I viewed as incorrect. -05 Jul 2022

Scheduling Coordinator fixed 4 sections. Leaving BIOL 040 stacked CRNs 30498/30090 up to VP Academic Services. That CRN, as is, accounts for 8.657 FTES (4545.1 Contact Hours/525) - 08 Jul 2022

SVRCALP

Runtime <1 minute

SEND TO REGINA FOR FIXES - none returned

ℹ️ How To

(PE, Concurrent)

04 – Exceptions Only - "Y"

05 – Page break – just formatting

SVRCALU

Runtime >3 minutes

SVRCALS

Runtime >5 minutes

SVRCAL9

How To

AB 540 Resident Code(s): A, B, D

Runtime >5 minutes

Regarding drops. Sometimes Argos doesn't show dropped students but Banner does. Work with Velia but usually Banner is king.

Compare summary to previous Annual

Hard to compare given pandemic shifts.

Manual Entry/Edits

Documented in Backup Spreadsheet but tracked here.

SVRCALU feeds "Supplemental"

ATTENDANCE FTES* OF STATE RESIDENTS(and Nonresidents Attending Noncredit courses)

Part IX

Pull from SVRCAL9

NON CREDIT, NON RESIDENT

Part IV
CDCP section

SVRCALU populates this.

For noncredit FTES (including CDCP noncredit) the attendance of both residents and nonresidents is reported in the Residents column of Part IV and in the CDCP section of the report. - Natalie Wagner

ADD CARRY FORWARD

Added to District Totals

P1 and P2 do not allow CENTER FTES adjustments

Campus/District	Resident	Resident Ext Hours	Non Resident	Totals
CONTACT HOURS
Hanford	49,209.50	n/a	472.50	49,682.00
Tulare	20,440.00	1,470.00	105.00	22,015.00
District (includes HAC,TCC)	164,778.00	2,730.00	1,312.50	168,820.50
FTES
Campus/District	Resident	Resident Ext Hours	Non Resident	Totals
Hanford	93.73	n/a	0.90	94.63
Tulare	38.93	2.80	0.20	41.93
District (includes HAC,TCC)	313.86	5.20	2.50	321.56

Workspace 2021-22, Annual

👟 Run 1

Baseline

Manual Entry/Edits

0 Comments