USSIPC1P -- Execute Instructions 11/21/98 This IPEDS JCL procedure produces two reports, and optionally, a third report which is requested through a parameter card field. 1. "IPEDS C1, Postsecondary Completions" A. Program Completions Below the Baccalaureate B. Program Completions for Baccalaureate and Above C. First-Professional Programs 2. "Number of Degrees and Other Formal Awards" A. By Emphasis Area -- Subtotals by Department (sorted by Campus, AU, Department, Degree Program, Emphasis Area, Degree) B. By Emphasis Area -- Subtotals by Degree Level (sorted by Campus, AU, Department, Degree Program, Degree Level, Degree, Emphasis Area) C. By Emphasis Area -- Subtotals by Degree Level (sorted by Campus, AU, Degree Level, Degree) 3. "Individuals Earning Degrees & Other Formal Awards" (sorted by Campus, AU, Department, Student Name) Processing and selection criteria used by the Mark IV program are described on page 230.20. If selection by student jurisdiction is specified in the parm card and one of the codes for selection is 'B' then students in this jurisdiction will be counted under the separate campus heading 'UM-ROLLA/ST. LOUIS COOPERATIVE ENGINEERING. Core requirement is 4000K. UMSL CPU time is approximately 5 minutes. Sample execution JCL is: // SET CAMPUS=c See Note 1 // SET SYSTEM=ssss See Note 2 //step EXEC USSIPC1P, // SLIF='SLIF.dataset.prefix', production SLIF prefix // SUBFILE='last qualifier of emsas and uids output datsets' //* (optional override for report listing) // RPT='DSN=user.dsn,DISP=disp' //PARMCARD DD * c ttccyy-ttccyy jjj r f ----+----1----+----2----+----3----+----4----+----5----+----6----+----7 1 NOTES: 1. C should equal C,H,K,R or S 2. SSSS should equal PROD for normal production runs. To point to your other databases, code the following: TEST - Campus test databases COPY - Campus copy databases FROZ - Campus frozen databases M4CORD1 -- Parameter Card Layout Location Field + ________ _____ 1 Campus code 3-8 Term1 (external format - ttccyy) is term used in selecting term for which degrees have been awarded 10-15 Term2 (external format - ttccyy) is the ending term for a range of terms will be used in selecting term for which degrees have have been awarded 17-19 Student jurisdiction code(s) - if left blank all jurisdictions will be selected 21 Report 3 select option (Y=yes blank=no) 23 Completer record select option (Y=yes blank=no) 1 Processing and Selection The production SRDB is read to find students who received degrees during a specific term or within a range of terms (see parameter card). A student is selected if: If parm card jurisdiction selection columns = blank then all student jurisdictions selected Else JURI001 = a parm card jurisdiction code DGPP006 = blank (primary degree) or 'S' (secondary degree) DSTA006 = A DGTE006 = parm-term1 (if parm-term2 is blank) or DGTE006 >= parm-term1 and <= parm-term2 DGLVL code for DGSA006 in SISTAB06 > 0 Table look-ups used for column and row classifications are: Table Argument Result fields SISTAB09 DGAU006 Academic unit name Academic unit abbreviation SISTAB04 DDPT006 Department abbreviation SISTAB07 DGPG006/DGEM006 Degree program abbreviation Emphasis area abbreviation CIP code SISTAB06 DGSA006 Degree EMSAS degree level code CIPCODE Hegis code Program title Counts are placed in C1 report columns (parts A-C) on the basis of SSEX016, DGSA006, DGPG006, and degree level: ------------ columns -------------- DGLVL DGSA006 DGPG006 Part A Part B Part C 2 40 7645 5/6 - - 2 40 7650 9/10 - - 2 40 8090 9/10 - - 2 41 -- - 13/14 - 2 45 -- 7/8 - - 3 (all) -- - 11/12 - 4 (all) -- - 13/14 - 5 (all) -- - - 21/22 6 63 -- - 13/14 - 6 78 -- - 13/14 - 6 (all other) -- - 15/16 - 7 (all) -- - 17/18 - 8 (all) -- - 19/20 - Ethnic origin classifications follow the IPEDS standard. There is a separate unknown column for 'unknown' ETHO019 codes. 1 USSIPC1P File Layout (Completer Record) Location Length 1-2 2 Constant of '05' - Degree completer 3-8 6 FICE college code (determined by campus code from parameter card) UMC = '002516' HSSC= '002466' UMKC= '002518' UMR = '002517' UMSL= '002519' 9-10 2 Term indicator for degree awarded '11'- degree awarded in summer (35) semester '21'- degree awarded in fall (43) semester '31'- degree awarded in winter (27) semester '41'- degree awarded in spring (33)semester for Harris-Stowe 11-14 4 Calendar year from the term degree awarded 15-23 9 Student social security number (SSNO001) 24 1 Status of social security number '1'=actual social security number '2'=temporary social security number 25-33 9 Previous student social security number from SLIF; if no number exist zero fill 34 1 Status of previous social security number '1'=zero filled value '2'=previous social security number exists 35-44 10 Campus student number if not social security number else the first 10 characters of last name (UMKC uses SSN, Harris-Stowe uses name) 45 1 Student's sex (SSEX016) 46-47 2 Student's ethnic origin (ETHO019) translated to IPEDS standards. 48-49 2 Highest degree held 1 50-51 2 Degree level 'FA'= award does not fall into any of the categories '11'= certificate requires less than one year of study '20'= certificate requires one year of study '21'= certificate requires more than one year but not more than two years of study '23'= Associate level degree '25'= Baccalaureate level degree '42'= Master's level degree '43'= Educational Specialist '45'= Doctoral level degree '60'= First-professional degree 52-57 6 First major field of study, CIP code from Table 07 58-61 4 First major field of study CIP code option from Table 07 (external emphasis area, right justified with leading blanks zero filled as 0099) 62-67 6 Second major field of study CIP code from Table 07 68-71 4 Second major field of study CIP code option from Table 07 (external emphasis area, right justified with leading blanks zero filled as 0099) 72-90 19 Filler 1 USSIPC1P File Layout (U/IDS Extract Record) Location Length 1-2 2 Term indicator for degree awarded SS - degree awarded in summer (35) semester FS - degree awarded in fall (43) semester WS - degree awarded in winter (27) semester MM - degree awarded in minor semesters 3-6 2 Year - year from term degree awarded 7-15 9 Student social security number (SSNO001) 16 1 Degree program indicator (DGPP006) 17-26 10 Degree program indicator description DGPP006 = ' ' = PRIMARY DGPP006 = 'S' = SECONDARY 27 1 MSAS Degree level '0'=award does not fall into any of the categories (includes Specialist) '1'=certificate requires less than one year of study '2'=certificate requires one year of study '3'=certificate requires more than one year but not more than two years of study '4'=diploma '5'=Associate level degree '6'=Baccalaureate level degree '7'=Master's level degree '8'=Doctoral level degree '9'=First-professional degree 28 1 SIS Degree level (SISTAB06 position 65) 29-58 30 SIS Degree level description (per P&B specs) Degree level = '0' = CERTIFICATE Degree level = '2' = CERTIFICATE Degree level = '3' = BACHELORS Degree level = '4' = PROFESSIONAL DEVELOPMENT Degree level = '5' = PROFESSIONAL Degree level = '6' = MASTERS Degree level = '7' = EDUCATION SPECIALIST Degree level = '8' = DOCTORATES 59-60 2 Degree awarded (DGSA006) 61-110 50 Degree awarded description (SISTAB06 1-50) 111-115 5 Degree awarded abbreviation (SISTAB06 51-55) 116-119 4 Degree program (DGPG006) 1 USSIPC1P File Layout (U/IDS Extract Record) 120-151 32 Degree program description (SISTAB07 1-32) 152-158 7 DEGREE PROGRAM ABBREVIATION (SISTAB07 51-56) 159-160 2 Degree program emphasis area (DGEM006) 161-183 25 Degree program emphasis area description (SISTAB07 79-103) 184-190 7 Degree program emphasis area abbreviation (SISTAB07 58-63) 191-201 11 Campus description 202-203 2 Degree Program Responsible AU (DGAU006) 204-253 50 Degree Program Responsible AU description (SISTAB09 1-50) 254-258 5 Degree Program Responsible AU abbreviation (SISTAB09 51-55) 259-262 4 Degree Program Department (DDPT006) 263-312 50 Degree Program Department description (SISTAB04 1-50) 313-318 6 Degree Program Department abbreviation (SISTAB04 51-56) 319-322 4 MSAS ACT college code UMC = '2382' UMK = '2380' UMR = '2398' UMS = '2383' 323-328 6 Classification of Instructional Program Code (SISTAB07 73-78) 329 1 Degree Honors (DGHN006) 330-333 4P3 GPA at Graduation (DGPA006)