SMS Job Scheduling
CMxxxxJ FCxxxxJ ISxxxxJ SDxxxxJ SMxxxxJ SRxxxxJ MGxxxx SGxxxx Other

MG112R
Smis Student Retention Reports, System

This job group extracts student data from the SMIS and SMISX data bases and prints the student retention reports from the data extracted.
Special Instructions This job group cannot be run simultaneously with itself and it is for SBCTC use only. See also SPECIAL INSTRUCTIONS in SR1228S.
Operator Instructions None


Job Group Definition

Req/
Opt
Seq # Prior
Seq #
Job
Number
Description/Reports
R 01 00 SR1228J
Student Retention File Extract, System
O 02 01 SR1180J
Print Student Retention Report SR1180, System
  Num of Quarters Enrolled by Orientation of Student (SR1180A)
  Num of Quarters Enrolled by Orientation of Student (SR1180B)
O 03 02 SR1181J
Print Student Retention Report SR1181, System
  Num of Quarters Enrolled by Purpose of Attendance (SR1181A)
  Num of Quarters Enrolled by Purpose of Attendance (SR1181B)
O 04 03 SR1182J
Print Student Retention Report SR1182, System
  Num of Qtrs Enrolled by Planned Length of Attndnce (SR1182A)
  Num of Qtrs Enrolled by Planned Length of Attndnce (SR1182B)
O 05 04 SR1183J
Print Student Retention Report SR1183, System
  Num of Qtrs Dev Students Enrolled by Subject Area (SR1183A)
  Num of Qtrs Dev Students Enrolled by Subject Area (SR1183B)


Parameters

MIS-COL Enter ALL, 999 or a valid college for which report is to be produced:
ALL = Produce a college report for all colleges.
999 = Produce a system rollup report only.
nnn = Produce a report for the specified college only (where 'nnn' is a valid college code).
MIS-PROC-OPT Enter processing option to indicate college type for which report is to be produced. Valid values are C, T, B, or blank.
C = Produce report for community colleges.
T = Produce report for technical colleges.
B = Produced report for both community and technical colleges. Blank should only be used when MIS-COL is a valid college code.
SMIS-DB-AYR Leave blank to use current academic year's data base as input. Otherwise, enter academic year of SMIS data base to be used for input (e.g., for academic year 1990-91, enter 9091).
SR1228-1ST-YRQ Enter year-quarter of first reportable enroll- ment for students to be included on report.
SR1228-BEG-AGE Enter age of students to be selected (2 digit numeric) OR Enter beginning age of range of ages for students to be selected. Enter zeroes if you do not wish student selection based on age.
SR1228-END-AGE Enter ending age of range of ages for students to be selected. When a range is entered, beginning and ending ages are inclusive. If students are not to be selected by age range, enter zeroes.
SR1228-ETH-SEL Enter up to 6 Ethnic Origin codes and a lowercase 'b'. If more than one code is entered, do not separate entries with spaces or commas. Valid values are 0, 1, 2, 3, 4, 6, and b (b is blank response). If the entire SR1228-ETH-SEL is left blank, no selection is made based on ethnic origin
SR1228-FAM-STAT Enter a two-digit code indicating family status of students at first quarter to attend the college to be selected. Leave blank to select all.
SR1228-HISP-SEL1
SR1228-HISP-SEL2
Up to 20 Census Hispanic codes (10 codes per line) may be entered for selection in the format: XXX XXX XXX XXX XXX Leave blank to select all.
SR1228-LAST-YRQ Enter last year-quarter of reportable enrollment to be counted. A maxinum of 15 quarters can be counted.
SR1228-PLAN-ATT Enter a two-digit code indicating planned length of attendance at the college of students to be selected. Leave blank to select all.
SR1228-PRIOR-ED Enter a two-digit code indicating student's level of education before attending the college. If left blank, no selection is made based on student's prior level of education.
SR1228-RACE-SEL1
SR1228-RACE-SEL2
Up to 20 Census race codes (10 codes per line) may be entered for selection in the following format: XXX XXX XXX XXX XXX Leave blank to select all.
SR1228-RUN-VER Enter 2 digit run version number to be printed on the report.
SR1228-SEX-SEL Enter M or F to select students for inclusion based on sex.
M = Include only male students in report
F = Include only female students in report spaces = no selection based on sex
SR1228-WORK-ATT Enter a two-digit code indicating working status of students while they are attending college to be selected. Leave blank to select all.
TC-CR-HR-IND Enter value to specify method for calculating
FTES. This parameter is for Technical College use only, and will have no affect on reports run for community colleges.
C = calculate report based on credit values. H or Blank = calculate report based on clock hour values.

Distribution: SMS P999
Created: WED, JAN 04, 2012, 07:19 AM