Versions Compared

Version Old Version 1 New Version Current
Changes made by

Jordan Lamb

Jordan Lamb

Saved on

Key

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

...

  1. Carry Forward (CF) for Hanford, Tulare and the District is understated.

    1. Three CRNs were miscalculated only on the CF and only partially backed out of the total FTES filed. Specifically, I messed up on a flat file to Excel column creation anytime there were greater than 99 students (3-character length) enrolled at census.

      1. Term 202230 (Summer 2022); CRNs 30620 (10 FTES more for Hanford CF), 31038 (10 FTES more for Tulare CF), and 30369 (10 FTES more for Tulare CF).

    2. Term 202230, CRN 30524 (2.6 FTES more for Hanford CF) was found to not have been generated in the last Banner 320 report. It generated on a test rerun that I did today. This has CF implications.

  2. Term 202220 (Spring 2022), CRN 25484 will be reported next 320 cycle as it straddles reporting cycles. Census day of 5/12/2022 in this reporting cycle and end date of 7/20/2022 in next reporting cycle. 320 report considers the Reporting Year of “2023” on scheduling screen (SSASECT).

  3. Term 202230, CRNs 30498/30090 now have positive attendance data entered. This has no CF implications and was documented in the Annual Workspace Document.

  4. 202230, CRNs 30498/30090 now have positive attendance data entered. This has no CF implications and was documented in the Annual Workspace Document.

Summary

  1. Total Difference from Annual to Recal

Annual

Recal

Difference

 District

8,955.10

8,977.76

22.66

2. Carry Forward Difference from Annual to Recal

Annual

Recal

Difference

 Hanford 

20.37

31.54

11.17

 Tulare 

180.00

188.70

8.7

 District (includes HAC,TCC) 

289.73

305.26

15.53

👟 Run 1

Expand
titleSFAALST Positive Attendance, With Passing Grades, Without Hours Entered
Code Block
languagesql
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
Expand
titleℹ️ How To

Populate Academic Year

District: Do it for 561, 562, 563

Reporting Period:

P1 - 2

P2 - 1

Info

Not needed for Annual or Recal

  •  SVRCALX
  •  Sort through the list and resolve errors prior to the next step
Panel
panelIconId23f3
panelIcon:hourglass_flowing_sand:
panelIconText⏳
bgColor#F4F5F7

Runtime ~5 minutes

Expand
titleℹ️ How To

04 – Include Exceptions - "Y"

  •  SVRCALD - Include Student Details
  •  SVRCALD - Do Not Include Student Details
Panel
panelIconId23f3
panelIcon:hourglass_flowing_sand:
panelIconText⏳
bgColor#F4F5F7

Runtime ~1 minute

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

No true warnings existed.

  •  SVRCALP
Panel
panelIconId23f3
panelIcon:hourglass_flowing_sand:
panelIconText⏳
bgColor#F4F5F7

Runtime <1 minute

  •  SEND TO REGINA FOR FIXES - none returned
Expand
titleℹ️ How To

(PE, Concurrent)

04 – Exceptions Only - "Y"

05 – Page break – just formatting

  •  SVRCALU
Panel
panelIconId23f3
panelIcon:hourglass_flowing_sand:
panelIconText⏳
bgColor#F4F5F7

Runtime >3 minutes

  •  SVRCALS
Panel
panelIconId23f3
panelIcon:hourglass_flowing_sand:
panelIconText⏳
bgColor#F4F5F7

Runtime >5 minutes

  •  SVRCAL9
Expand
titleHow To

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

Panel
panelIconId23f3
panelIcon:hourglass_flowing_sand:
panelIconText⏳
bgColor#F4F5F7

Runtime >5 minutes

Info

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

Info

Documented in Backup Spreadsheet but tracked here.

  •  SVRCALU feeds "Supplemental"

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

  •  Part IV

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

  •  Part IX
Info

Pull from SVRCAL9

  •  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

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

 

  •  REMOVE CARRY FORWARD

FTES Total

 Campus/District 

 Resident 

Resident Ext Hours 

 Non-Resident 

 Totals 

 Hanford 

17.90

13.20

0.45

31.54

 Tulare 

187.04

1.67

188.70

 District (includes HAC,TCC)

276.97

25.79

2.50

305.26

Expand
titleCensus Date or End Date is > 7/1
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

 

  •  CCFS-317 Explain Recal Reasoning