Transcript Document

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
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
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
SV09 and SB30
• SGAUSDF: new fields
– ‘VTEA Vocational Migrant Worker’ checkbox for
SV09 STUDENT-VOCATIONAL-MIGRANT-WORKERSTATUS; checked = ‘M’ on report.
– ‘Basic Skills Waiver’ checkbox for SB30 STUDENTBASIC-SKILLS-WAIVER-STATUS; checked = ‘W’ on
report.
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.
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.
SB29: GTVRRAC Race Code
• GTVRRAC seed data scripts: gtvrrac_ins.sql and
gtvrrac_del.sql
– Adds a ‘X’ Other/Unknown value (default for
Hispanic)
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)
SB29: GORRACE Race Code Rules
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).
SB29: STVETHN Ethnic Code
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.
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.
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.
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-7RHNO5
Customer Support Center website:
http://connect.sungardhe.com