1 / 15

Session Overview

Session 16 MIS Reporting: 2009 changes TJ Baugus, Principal Functional Consultant, Banner Student California Community College Solution Center, SunGard Higher Education To print this presentation: UDC Support Center FAQ 1-7RHNO5 Customer Support Center website: http://connect.sungardhe.com.

trumble
Download Presentation

Session Overview

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Session 16MIS Reporting: 2009 changesTJ Baugus, Principal Functional Consultant, Banner StudentCalifornia Community College Solution Center, SunGard Higher EducationTo print this presentation:UDC Support Center FAQ 1-7RHNO5Customer Support Center website: http://connect.sungardhe.com

  2. Session Overview • MIS Summer 2009 changes • Setups for ethnicity reporting in new element SB29 • EB report EB14 • General CALB MIS Q&A as time permits

  3. C3SC Releases • CALB 7.7 and CALB 8.1 • Student MIS Summer 2009 changes • Several defect fixes for MIS and more • CALBHR 7.2 with a patch • EB report MIS Summer 2009 changes

  4. SV09 and SB30 • SGAUSDF: new fields • ‘VTEA Vocational Migrant Worker’ checkbox for SV09 STUDENT-VOCATIONAL-MIGRANT-WORKER-STATUS; checked = ‘M’ on report. • ‘Basic Skills Waiver’ checkbox for SB30 STUDENT-BASIC-SKILLS-WAIVER-STATUS; checked = ‘W’ on report.

  5. CB00: SX, XB, XF, and XE • CB00 Course-Control-Number • Element and function from CB report duplicated on the other reports. • SCADETL form, Supplemental Data tab.

  6. SB29 Student-Multi-Ethnicity • CALB added no new fields/columns for data. • 100% baseline functionality. • CALB scripts to populate defaults for MIS into baseline tables. • A baseline script to update existing students with MIS defaults in the new baseline fields.

  7. SB29: GTVRRAC Race Code • GTVRRAC seed data scripts: gtvrrac_ins.sql and gtvrrac_del.sql • Adds a ‘X’ Other/Unknown value (default for Hispanic)

  8. SB29: GORRACE Race Code Rules • GORRACE seed data scripts: gorrace_ins.sql and gorrace_del.sql • Institution Race = the MIS position in SB29 for positions SB29.02 – SB29.21 • 02, Mexican/Mex-American/Chicano (with Regulatory Race of ‘X’ Other/Unknown) • 11, Asian Cambodian (with Regulatory Race of ‘2’ Asian)

  9. SB29: GORRACE Race Code Rules

  10. SB29: STVETHN Ethnic Code • Prior SB05/EB04 data. • STVETHN seed data scripts: • stvethn_ins.sql and stvethn_del.sql • Inserts new STVETHN entries (no existing data). - OR - • stvethn_upd_race_cde.sql • Updates existing STVETHN entries if Institution Race Code is null (existing data).

  11. SB29: STVETHN Ethnic Code

  12. SB29: Baseline gurethnicity.sql • Updates existing students (people): • Updates SPBPERS and GORPRAC adding race and new ethnicity (where the Ethnicity Code = STVETHN Code). • If New Ethnicity is null, updates New Ethnicity from STVETHN. • If no Race records exist, inserts a Race record for the student.

  13. SB29: Student example • If student had Ethnicity ‘PH’, gurethnicity.sql sets New Ethnicity and adds ’18’ Race. • Any race can be added manually for SB29.02 – SB29.21. • New Ethnicity is used for SB29.01.

  14. EB14 Employee-Multi-Ethnicity • EB report: Employee Demographic Data • HR module (not Student) • CALBHR 7.2 with patch p_mis_eb14_calbhr70200 (not CALB 7.7) • EB14 is identical to SB29. • EB report is not in report engine. • PEPEDEX Employee Demographic Extract Process • Same setups and similar scripts were used.

  15. Questions? • Questions on CALB 7.7/8.1 MIS Summer 2009 updates or other MIS topics. To print this presentation:UDC Support Center FAQ 1-7RHNO5Customer Support Center website: http://connect.sungardhe.com

More Related