The purpose of the Corporate Student System is to collect, validate, and integrate student data from the UC campuses and make it available for retrieval and reporting. Input data is received in machine readable form from campus operational systems. This campus data is edited, consolidated, and then extracted/loaded into the Corporate Data Warehouse where it is available to UC personnel for reporting.

The following types of information are collected:

· Information about enrolled students, both as of the third week of classes and as of the end of a term.

· Information about applicants for admission as undergraduates. This data is processed by the Undergraduate Admission System (UAD) and transformed to CSS formats by a step in that system.

· Information about students granted degrees.

· Information about recipients of financial aid.

· Information about applicants for admission as graduates.

The data received from campuses is used to update the following FOCUS databases on MVS:

Focus MASTER	DSN on MVS	Description
CSSADMC	CSS.FOC.CSSADMC.ALLYRS	?
CSSFAI	CSS.FOC.CSSFAI.mmmyy	Financial Aid database (includes Demographic and award summary data for all students)
CSSGADM	CSS.FOC.CSSGADM.Yyyyy	Graduate Admissions database (includes admission, previous academic data, and test scores for graduates)
CSSGLONG	CSS.FOC.CSSGLONG.ALLYRS	Graduate Student Longitudinal database
CSSREG	CSS.FOC.CSSREG.Yyyyy CSS.FOC.CSSREGIN.Yyyyy	Registration database (this database uses the database as a cross-referenced database) (includes demographic data for all students plus admission, previous academic data, and test scores for undergraduates; registration, performance, and degree awarded data for all students.)
CSSSUM	CSS.FOC.CSSSUM.Yyyyy CSS.FOC.CSSSUMIN.Yyyyy	Registration database for summer quarter
CSSULONG	CSS.FOC.CSSULONG.ALLYRS CSS.FOC.CSSUL1.ALLYRS	Undergraduate Student Longitudinal database

The two longitudinal databases (CSSGLONG and CSSULONG) are identical in structure and differ only in some elements and in the population included (GLONG is for Graduate students and ULONG is for Undergraduate students). These two longitudinal databases are updated based on other CSS FOCUS databases (rather than directly from campus input files). The longitudinal databases obtain data from the following:

CSSREG – student registration database
CSSGADM – Graduate admission
CSSFAI – Financial Aid

The purpose of the Student longitudinal databases is to collect registration and performance data on enrolled students across time, thus providing the capability to examine and compare their persistence, performance, and graduation rates. The two longitudinal databases contain the following types of information.

· Demographic data on students when they first enter

· Admission data, previous academic data, and test scores on students when they first enter

· Registration and performance data on students for each year in which they have enrolled

· Data on degrees awarded to students

· Derived indicators of persistence status on students for each year in which they are enrolled

· Financial aid demographic and award summary data on students for each year in which they are enrolled and receiving financial aid

· Information on students' disabilities for each year in which they are enrolled

The operating cycle for the two longitudinal databases is annual, taking place after the rest of CSS processing for the academic year is complete. In order to keep the databases from growing without bound only seven years' data is kept for undergraduate students and thirteen years for graduates, older data being removed. Additional years are kept in the Corporate Data Warehouse – student tables.

The primary users of these data are staff in the offices of the Senior Vice President - Academic Affairs.

CSS Data Flow Diagram

1.2 System Interfaces TO CSS

Last Updated: June 9, 2010

Local Campus student systems to CSS

The primary interface to the Corporate Student System (CSS) is the campus input files from the local campus student systems. There are seven different files submitted by campuses to CSS:

Residents file

Frequency: sent annually at end of the 6^th week of classes for the Fall term

Filename on vsftp server:

/ftphome/ftpusr[n]/put/css/CSSRES.Q2yy

where n is 1, 2, 3, 4, 6 or 9 indicating the campus and

yy is calendar year

Note: The Residents file is only sent by the following campuses: Berkeley, San Francisco, Davis, Los Angeles, San Diego and Irvine

File Format: fixed blocked, record length is 250

Third Week file

Frequency: sent quarterly, as of the third week of the term

Filename on vsftp server:

/ftphome/ftpusr[n]/put/css/CSS3WK.Qqyy

where n is 1 – 10 indicating the campus,

q is the quarter (1=Summer, 2=Fall, 3=Winter, 4=Spring) and

yy is calendar year

Note: Berkeley and Merced are on the semester system whereas all other campuses are on the quarter system. Berkeley and Merced do not submit files for the Winter quarter cycle (q=3).

File Format: fixed blocked, record length is 250

End of Term

Frequency: sent quarterly, as of the end of the term

Filename on vsftp server:

/ftphome/ftpusr[n]/put/css/CSSEOT.Qqyy

where n is 1, 3 – 10 indicating the campus,

q is the quarter (1=Summer, 2=Fall, 3=Winter, 4=Spring) and

yy is calendar year

Note: Berkeley and Merced are on the semester system whereas all other campuses are on the quarter system. Berkeley and Merced do not submit files for the Winter quarter cycle (q=3).

Note: San Francisco campus (n=2) does not send End of Term files.

File Format: fixed blocked, record length is 250

Degree

Frequency: sent annually (files due beginning of last week in October)

Filename on vsftp server:

/ftphome/ftpusr[n]/put/css/CSSDEG.Yyyyy

where n is 1 – 10 indicating the campus and

yyyy is the year the degree was conferred (e.g. the file with yyyy=2006 includes degrees conferred in the academic year 2005-2006. Specifically, the year/quarter field (yyq) in the 2006 campus files includes values of 051 (summer 2005), 052 (fall 2005), 063 (winter 2006) and 064 (spring 2006))

Note: A summer degree file will soon be added as a new input file from campuses (August 2007)

File Format: fixed blocked, record length is 80

Financial Aid

Frequency: sent for JAN (quarter 2 – Fall), MAY (quarter 3 – Winter), OCT (quarter 4 – Spring), and NOV (quarter 1 – Summer).

Filename on vsftp server:

/ftphome/ftpusr[n]/put/css/CSSFAI.mmmyy

where n is 1 – 10 indicating the campus and

mmm is JAN (quarter 2 – Fall), MAY (quarter 3 – Winter), OCT (quarter 4 – Spring) or NOV (quarter 1 – Summer)

Note: Berkeley and Merced are on the semester system whereas all other campuses are on the quarter system. Berkeley and Merced do not submit files for the Winter quarter cycle (q=3).

File Format: fixed blocked, record length is 150

Graduate Admission

Frequency: sent annually in early December

Filename on vsftp server:

/ftphome/ftpusr[n]/put/css/CSSGAD.Yyyyy

where n is 1 – 10 indicating the campus and

yyyy is the academic year

File Format: fixed blocked, record length is 80

Corporate Personnel System (CPS aka FCP) to CSS

The FCPXCSS job produces an annual interface file for CSS containing SSN, earnings and work study gross earnings. This file is used to update the CSS Financial Aid Focus database (CSS.FOC.CSSFAI.mmmyy).

School Code Table (SCT) to CSS

The School Code Table (SCT) application provides the SAS Admissions and Outreach office with a method for updating the school code data via the web. The application also updates the school code data with high school and college data received from the Educational Testing Service (ETS). The application is a Sybase/java application running on the unix platform.

The SCT application provides extract files to rebuild three Focus cross-reference databases in CSS: the location table, the California districts table and the school code table. The CSSCLD job on MVS captures the extract files from the SCT application on unix (that is, copies them using ftp) and recreates the Focus databases.

Description of Table	SCT extract file on unix in /apps/iscprod/css/data subdirectory	Sequential File Copied to MVS	Focus Database Built
school code table	cssatp_extract.dat	CSS.CSSATP.SYBEXT	CSS.FOC.CSSATP.ALLYRS
California districts	california_districts_extract.dat	CSS.CSSDIST.SYBEXT	CSS.FOC.CSSDIST.ALLYRS
Location (see note)	location_extract.dat	CSS.CSSLOC.SYBEXT	CSS.FOC.CSSLOC.ALLYRS

Note: Location in the Corporate Student System does NOT mean campus location, as it does in some other corporate systems.

See SCT Ops Doc for more information on this application.

CSS Cross-Reference Tables (CSX) to CSS

Last Updated: June 11, 2010

The CSX application allows UCOP and campus staff to maintain a number of degree/major-related tables which are used to validate Corporate Student System campus files.

Online Application:

The CSX online application resides under the CSG umbrella.

It consists of:

· an operational component for campus users: CSXOPS

allows campus registrar staff to request new majors, new instances of majors, major de-activations or other changes to existing major instances.

· an operational component for DWCS staff: CSXADM

allows UCOP IR staff to verify and implement major requests made by campuses, and to make changes to the other tables.

· a reporting component: CSXDWR

allows users to search and download the various CSS cross-reference tables. This reporting facility is also accessible from the public CSG.

See CSX User Documentation for more information on CSX application.

Database:

csstbl in UCDB1 Sybase ASE server.

The CSX application provides extract files to rebuild six Focus cross-reference databases in CSS (Sunday through Thursday at 8:00 PM). The CSSXTBL Zeke event extracts data from the csstbl tables and deposits the resulting flat files on Bert.

The CSSXLD Zeke event then captures the extract files from via ftp and recreates the Focus databases on MVS.

Tables in csstbl	Description of Table	SCT extract file on unix in /apps/iscprod/css/data subdirectory	Sequential File Copied to MVS	Focus Database Built
csscol	College code	csscol_extract.dat	CSS.CSSCOL.SYBEXT	CSS.FOC.CSSCOL.ALLYRS
csscip	CIP (Classification of Instructional Programs) Code	csscip_extract.dat	CSS.CSSCIP.SYBEXT	CSS.FOC.CSSCIP.ALLYRS
cssucdsp	UC Discipline Code	cssucdsp_extract.dat	CSS.CSSUCDSP.SYBEXT	CSS.FOC.CSSUCDSP.ALLYRS
cssmajor	Major code	cssmajor_extract.dat	CSS.CSSMAJOR.SYBEXT	CSS.FOC.CSSMAJOR.ALLYRS
cssccm	CCM – Campus, College, and Major	cssccm_extract.dat	CSS.CSSCCM.SYBEXT	CSS.FOC.CSSCCM.ALLYRS
cssdeg	Degree code	cssdeg_extract.dat	CSS.CSSDEG.SYBEXT	CSS.FOC.CSSDEG.ALLYRS

Financial Aid Table (CSF) to CSS

The Financial Aid Table (CSF) application provides web-based online update for the Financial Aid table required by the Corporate Student System. The application is a Sybase/java application running on the unix platform.

The CSF application provides an extract file to rebuild one Focus cross-reference database in CSS (see table below). The CSSFTYLD job on MVS captures the extract file from the CSF application on unix (that is, copies the file using ftp) and recreates the Focus database.

Description of Table

SCT extract file on unix in /apps/iscprod/css/data subdirectory

Sequential File

Copied to MVS

Focus Database Built

Financial Aid Table

cssftyp2_extract.dat

CSS.CSSFTYP2.SYBEXT

CSS.FOC.CSSFTYP2.ALLYRS

Undergraduate Admissions System (UAD) to CSS

CSS receives undergraduate admissions data from the UAD system four times each academic year. The data is processed by job CSSUPA which updates both the REG and ADMC data bases with it.

1.3 System Interfaces FROM CSS

Last Updated: August 27, 2007

CSS to Corporate Data Warehouse (CDW)

Corporate Student System data is extracted from the CSS Focus databases and sent to the Corporate Data Warehouse. The following extract jobs send data to the data warehouse:

Description	MVS Job	MVS Extract file(s)	Files on unix (sybserv2.ucop.edu) in /datawh/ctl/prod/dwhstu/data
Financial Aid Extracts for JAN (qtr 2 – Fall), MAY (qtr 3 – Winter) and OCT (qtr 4 – Spring)	CSSWFAI	CSS.CSSWFAID CSS.CSSWFDC CSS.CSSWFAIY CSS.CSSWFAIA CSS.CSSWFAC	fai/dwh_stu_fai_demo.dat fai/dwh_stu_fai_demo_cnt.dat fai/dwh_stu_fai_cycle.dat fai/dwh_stu_fai_award.dat fai/dwh_stu_fai_award_cnt.dat
Financial Aid Extracts for NOV (q1 – Summer)	CSSWFAIS	CSS.CSSWSUFD CSS.CSSWSFDC CSS.CSSWSFCY CSS.CSSWSUFA CSS.CSSWSFAC	fai/dwh_stu_fai_summer_demo.dat fai/dwh_stu_fai_summer_demo_cnt.dat fai/dwh_stu_fai_summer_cycle.dat fai/dwh_stu_fai_summer_award.dat fai/dwh_stu_fai_summer_award_cnt.dat
Graduate Admissions Extracts	CSSWGAD	CSS.CSSWGAD CSS.CSSWGADC CSS.CSSWGADY	gad/dwh_stu_gad_applic.daat gad/dwh_stu_gad_applic_cnt.dat gad/dwh_stu_gad_cycle.dat
Graduate Longitudinal Extracts	CSSWGL	CSS.CSSWGLA CSS.CSSWGLAC CSS.CSSWGLS CSS.CSSWGLSC CSS.CSSWGLY CSS.CSSWGLYC CSS.CSSWGLCY	glong/dwh_stu_glong_award.dat glong/dwh_stu_glong_award_cnt.dat glong/dwh_stu_glong_student.dat glong/dwh_stu_glong_student_cnt.dat glong/dwh_stu_glong_year.dat glong/dwh_stu_glong_year_cnt.dat glong/dwh_stu_glong_cycle.dat
Student Registration Extracts (except summer): · Reg · ADMC · Admission · Degree (annually only)	CSSWREG	CSS.CSSWREG CSS.CSSWREGC CSS.CSSWREGY CSS.CSSADM CSS.CSSADMC CSS.CSSAMI CSS.CSSAMIC CSS.CSSWDEG CSS.CSSWDEGC	reg/dwh_stu_reg_reginfo.dat reg/dwh_stu_reg_reginfo_cnt.dat reg/dwh_stu_reg_cycle.dat reg/dwh_stu_reg_admc.dat reg/dwh_stu_reg_admc_cnt.dat reg/dwh_stu_reg_admiss.dat reg/dwh_stu_reg_admiss_cnt.dat reg/dwh_stu_reg_degree.dat reg/dwh_stu_reg_degree_cnt.dat
Student Registration Extracts - summer	CSSWSUM	CSS.CSSWSUM CSS.CSSWSUMC CSS.CSSWSUMY	reg/dwh_stu_reg_summer_reginfo.dat reg/dwh_stu_reg_summer_reginfo_cnt.dat reg/dwh_stu_reg_summer_cycle.dat
Undergraduate Longitudinal Extracts	CSSWUL	CSS.CSSWULA CSS.CSSWULAC CSS.CSSWULS CSS.CSSWULSC CSS.CSSWULY CSS.CSSWULYC CSS.CSSWULCY	ulong/dwh_stu_ulong_award.dat ulong/dwh_stu_ulong_award_cnt.dat ulong/dwh_stu_ulong_student.dat ulong/dwh_stu_student_cnt.dat ulong/dwh_stu_ulong_year.dat ulong/dwh_stu_ulong_year_cnt.dat ulong/dwh_stu_ulong_cycle.dat

CSS to Undergraduate Admissions System (UAD)

CSS CROSS-REFERENCE TABLES

The Undergraduate Admissions System (UAD) uses some of the lookup tables in CSS. The following CSS Focus databases are cross-referenced in the UADM database (UAD.FOC.UADM.CURRENT):

CSS.FOC.CSSATP.ALLYRS school code table

CSS.FOC.CSSCOL.ALLYRS colleges

CSS.FOC.CSSLOC.ALLYRS location

CSS.FOC.CSSMAJOR.ALLYRS major codes

The UADRCMP (edit a campus UAD input file) and UADUCMP (Update the UADM Focus database wit hcampus UAD input data) jobs extract some data from the following three CSS tables:

CSS.FOC.CSSCCM.ALLYRS campus, college and major

CSS.FOC.CSSLOC.ALLYRS location

CSS.FOC.CSSATP.ALLYRS school code table

The UADWEXT job that extracts UAD data for the Corporate Data warehouse uses most (perhaps all) of the CSS cross-reference tables:

CSS.FOC.CSSLOC.ALLYRS

CSS.FOC.CSSCOL.ALLYRS

CSS.FOC.CSSATP.ALLYRS

CSS.FOC.CSSMAJOR.ALLYRS

CSS.FOC.CSSCCM.ALLYRS

CSS.FOC.CSSCIP.ALLYRS

CSS.FOC.CSSUCDSP.ALLYRS

CSS REG FOCUS DATABASE

The UADUREG job extracts register flags from the CSS REG Focus database (CSS.FOC.REG.Yayyy and CSS.FOC.REGIN.Yayyy). This extract is then used to update the UADM Focus database.

1.4 Application Control Information

Last Updated: October 12, 2011

Project Contacts

Production Control: Matt Valenzuela

Matthew.Valenzuela@ucop.edu

3^rd floor Kaiser Building

(510) 987-0330

UCOP Production Control Manager

ctlmgr@ucop.edu

3^rd floor Kaiser Building

Maintenance: Chris Handy

Chris.Handy@ucop.edu

12^th floor Kaiser Building

(510) 987-9417

DWCS Analyst: Chris Handy

Chris.Handy@ucop.edu

12^th Floor Kaiser Building

(510) 987-9417

Functional Office Customers:

CSS: Annette Holmes

Financial Aid: Gema Fonseca

Undergrad Admission: Liz Tamayo

SAS

Graduate Admission: Kathleen Merchant

School Code Table (SCT) Liz Tamayo

SAS

CSS Code Tables (CSX) Annette Holmes

Schedule

Each Fall, the Data Warehouse and Corporate Systems (DWCS) Analyst will supply a schedule for the year giving calendar dates based upon the academic year schedule. Academic schedules vary from campus to campus and from year to year, so generally the latest appropriate date for a processing cycle is chosen.

Only Berkeley & Merced are on the semester system; all others are on the quarter system. As a result, Winter quarter data for Berkeley & Merced is not processed or received. In addition, due dates for Berkeley & Merced Fall and Spring quarter data are typically much earlier than for other campuses.

The following dates are approximations of the actual schedule dates which are announced annually. Yearly submission schedules are posted on the CSS Campus Specs site at http://www.ucop.edu/irc/campus_specs/css/welcome.html

Residents

File Availability Date: End of 6th week of class: Fall

Production Start Date: Processed in Fall Third Week cycle

Production Stop Date: End of next to last week in Dec

Output Due Date: End of next to last week in Dec

Third Week

File Availability Date: End of 6th week of class: Fall, Winter, Spring. 9/15 for Summer.

Production Start Date: File availability date + 1 day

Production Stop Date: Fall - end of next to last week in Dec; Winter, Spring: end of week prior to Oct 1

Output Due Date: Fall: end of next to last week in Dec; Winter, Spring: Oct 1

End of Term

File Availability Date: Fall - end of eighth week after end of term; Winter, Spring - end of sixth week after end of term. 10/31/ for Summer.

Production Start Date: File availability date + 1 day

Production Stop Date: End of week prior to Oct 1

Output Due Date: Oct 1

Degree

File Availability Date: Beginning of the third week in September

Production Start Date: File availability date + 1 day

Production Stop Date: By October 17 for IPEDS

Output Due Date: Dec 1

Financial Aid

File Availability Date: Jan 15, May 1, Oct 1

Production Start Date: File availability date + 1 day

Production Stop Date: Jan 22, May 7, Oct 7

Output Due Date: Jan 31, May 15, Oct 15

Graduate Admission

File Availability Date: Feb 1

Production Start Date: File availability date + 1 day

Production Stop Date: End of last week in March

Output Due Date: April 1

1.5 MVS Production Libraries

Last Updated: July 30, 2007

The libraries where current production code resides on MVS are as follows:

Library Description

PRO.CTL.CNTLIB Control cards (e.g. sort control cards or program control cards)

PRO.CTL.ISPPLIB ISPF Panels for Job Submission

PRO.CTL.ISPSLIB ISPF Skeletons (run JCL)

PRO.CTL.PROCLIB JCL Cataloged Procedures (PROCs)

PRO.CTL.FTPLIB FTP commands (generally only machine, userid and password; remainder of commands is kept in each job skeleton)

Note: this library is not generally accessible – only production control can read the contents

PRO.MNT.COBOL COBOL Source Code

PRO.MNT.COPYLIB COBOL Copy Members

PRO.MNT.FOCEXEC FOCUS source code (i.e. Focexecs)

PRO.MNT.INCLUDE PL/I Include Members

PRO.MNT.LOADLIB Load Modules for compiled batch programs

PRO.MNT.MASTER FOCUS Masters

PRO.MNT.PLI PL/I Source Code

The following libraries are for archiving old versions of code (one generation of backup is retained):

CTLADM.BKPCTL.CNTLIB Backup of control cards

CTLADM.BKPCTL.ISPPLIB Backup of ISPF Panels for Job Submission

CTLADM.BKPCTL.ISPSLIB Backup of ISPF Skeletons (run JCL)

CTLADM.BKPCTL.PROCLIB Backup of JCL Cataloged Procedures (PROCs)

MNTADM.BKPMNT.COBOL Backup of COBOL Source Code

MNTADM.BKPMNT.COPYLIB Backup of COBOL Copy Members

MNTADM.BKPMNT.FOCEXEC Backup of FOCUS source code (i.e. Focexecs)

MNTADM.BKPMNT.INCLUDE Backup of PL/I Include Members

MNTADM.BKPMNT.MASTER Backup of FOCUS Masters

MNTADM.BKPMNT.PLI Backup of PL/I Source Code

1.6 Reports

Last Updated: June 9, 2010

With the exception of the edit reports (and a few status reports from update jobs), all reports for CSS have been converted to WebFocus and are available in the Corporate Data Warehouse environment.

Each type of campus input file received by CSS is edited on MVS and various edit reports are produced. Three of these files have identical record format, are edited by the same programs (including the CSSREGED Cobol edit program), and the same edit reports are produced:

Third Week file (CSS3WK)
End of Term file (CSSEOT)
Resident file (CSSRES)

The edit reports for these three registration files are described below under “Registration Files”. The remaining edit reports are described in separate sections:

Degree
Financial Aid
Graduate Admission
Student Earnings

Besides edit reports, the database update jobs that apply the campus data to the Focus databases in CSS produce a few status reports – these are also described below in the “Update Report” section.

1.6.1 Third Week Edit Reports – edit job CSSER3

The following edit reports are produced:

CSS.CSSER3.ER32cc.RPT

CSS.CSSER3.ER33cc.RPT

CSS.CSSER3.ER34cc.RPT

where cc is BK, SF, DV, LA, RV, SD, SC, SB, IR, MC (all campuses)

These three edit report files are then combined into the following single edit report file:

CSS.CSS3EDcc.Qqyy.RPT

This consolidated edit report is then converted to PDF format before it is ftp’ed to the vsftp site for campus pickup:

CSS.CSS3EDcc.PDF

The filenames on the vsftp site are:

/ftphome/ftpusr[n]/get/css/CSS3ED.Qqyy.PDF

/ftphome/ftpusru/get/css/CSS3ED[cc].Qqyy.PDF

where n = 1 – 10 for the campus

cc = BK, etc. for the campus

q = 1 (summer), 2 (fall), 3 (winter) or 4 (spring)

1.6.2 End of Term Edit Reports – edit job CSSERE

The following edit reports are produced:

CSS.CSSERE.ERE2cc.RPT

CSS.CSSERE.ERE3cc.RPT

CSS.CSSERE.ERE4cc.RPT

where cc is BK, DV, LA, RV, SD, SC, SB, IR, MC (not SF)

These three edit report files are then combined into the following single edit report file:

CSS.CSSEEDcc.Qqyy.RPT

This consolidated edit report is then converted to PDF format before it is ftp’ed to the vsftp site for campus pickup:

CSS.CSSEEDcc.PDF

The filenames on the vsftp site are:

/ftphome/ftpusr[n]./get/css/CSSEED.Qqyy.PDF

/ftphome/ftpusru/get/css/CSSEED[cc].Qqyy.PDF

where n = 1 – 10 for the campus (not 2, for SF)

cc = BK, etc. for the campus (not SF)

q = 1 (summer), 2 (fall), 3 (winter) or 4 (spring)

1.6.3 Resident Edit Reports – edit job CSSERR

The following edit reports are produced:

CSS.CSSERR.ERR2cc.RPT

CSS.CSSERR.ERR3cc.RPT

CSS.CSSERR.ERR4cc.RPT

where cc is BK, DV, LA, SD, IR

These three edit report files are then combined into the following single edit report file:

CSS.CSSREDcc.Qqyy.RPT

This consolidated edit report is then converted to PDF format before it is ftp’ed to the vsftp site for campus pickup:

CSS.CSSREDcc.PDF

The filenames on the vsftp site are:

/ftphome/ftpusr[n]/get/css/CSSRED.Q2yy.PDF

/ftphome/ftpusru/get/css/CSSRED[cc].Q2yy.PDF

where n = 1, 2, 3, 4, 6, 9

cc = BK, SF, DV, LA, SD, IR for the campus

1.6.4 Degree Edit Reports – edit job CSSERD

Last Updated: August 27, 2007

This job uses ftp to copy the campus Degree (Degrees Conferred) input file from vsftp to MVS, rename the campus input file on vsftp, and also delete one older cycle (prior year) from vsftp. The campus file is edited and edit reports are produced and sent to the vsftp site for campuses.

Frequency:

Yearly

Programs Executed:

STEP1 – Proc CSSGETFL

PSTEP01 IEFBR14 delete file

PSTEP02 IEFBR14 pre-allocate temporary MVS copy of campus input file

PSTEP03 FTP copy campus input file from vsftp to MVS, rename file on vsftp, and delete older cycle on vsftp

PSTEP04 IRXJCL, IRCEMPTY rexx exec to check if campus input file is empty

STEP2 – Proc CSSERD

PSTEP01 IEFBR14 delete file

PSTEP02 FOCUS, CSSERD1 Extract code tables

PSTEP03 IEFBR14 delete file

PSTEP04 COBOL, CSSDEGED edit input file

PSTEP05 FILEAID copy input file

PSTEP06 IEFBR14 delete file

PSTEP07 FOCUS, CSSERD2 produce edit reports

PSTEP08 IEFBR14 delete file

PSTEP09 FOCUS, CSS009 produce edit report CSS009 and create CSSDEGT database

PSTEP10 IEFBR14 delete files

PSTEP11 SORT combine report files into a single file

PSTEP12 IRC2PDF FOCUS convert report file to PDF format

STEP4 – FTP (no proc)

Input Files:

on vsftp.ucop.edu site:

/ftphome/ftpusrC/put/css/CSSDEG.cycle (renamed CSSDEG.cycle.SENT)

where C is the campus: 1=Berkeley, 2=San Francisco, 3=Davis, 4=Los Angeles, 5=Riverside, 6=San Diego, 7=Santa Cruz, 8=Santa Barbara, 9=Irvine, and 10=Merced

where cycle is Yyyy for academic year files or Q1yy for summer files

PRO.CTL.FTPLIB(CSS2VSF)

CSS.FOC.CSSCCM.ALLYRS

CSS.FOC.CSSDEG.ALLYRS

CSS.FOC.CSSLOC.ALLYRS

CSS.FOC.CSSATP.ALLYRS

PRO.CTL.CNTLIB(CSSERD1)

PRO.CTL.CNTLIB(CSSERD2)

PRO.CTL.CNTLIB(SORTCOPY)

PRO.CTL.CNTLIB(FICOPY)

PRO.CTL.CNTLIB(IRC2PDF)

Created Files:

CSS.CSSDEGcc.TEMP

where cc is the campus abbreviation: BK, SF, DV, LA, RV, SD, SC, SB, IR, MC

CSS.CSSERD.DEGCODES.TEMP

CSS.CSSERD.CCMCODES.TEMP

CSS.CSSERD.HLCODES. TEMP

CSS.CSSERD.ATPCODES. TEMP

CSS.CSSDEGEDcc.TEMP

CSS.CSSERD.EDERR.TEMP

CSS.CSSERD.EDSERR.TEMP

CSS.CSSERD.EDGERR.TEMP

CSS.CSSERD.EDSTAT.TEMP

CSS.CSSDEGcc.cycle

CSS.CSSERD.ERD2cc.RPT

CSS.CSSERD.ERD3cc.RPT

CSS.FOC.CSSDEGT.cc.TEMP

CSS.CSSERDcc.cycle.RPT

CSS.CSSERDcc.PDF

On vsftp.ucop.edu:

/ftphome/ftpusrC/get/css/CSSDED.cycle.PDF

/ftphome/ftpusru/get/css/CSSDEDcc.cycle.PDF

Updated Files:

None

Deleted Files:

on vsftp.ucop.edu site:

/ftphome/ftpusrC/put/css/CSSDEG.pcycle.SENT

where C is the campus: 1=Berkeley, 2=San Francisco, 3=Davis, 4=Los Angeles, 5=Riverside, 6=San Diego, 7=Santa Cruz, 8=Santa Barbara, 9=Irvine, and 10=Merced; and

where pcycle is the previous cycle: Yyyy for academic year files or Q1yy for summer files

Reports:

On MVS: CSS.CSSGEDcc.cycle..RPT

On vsftp: /ftphome/ftpusr[c]/get/css/ CSSDED.cycle.PDF

/ftphome/ftpusru/get/css/ CSSDEDcc.cycle.PDF

Resource Requirements:

Elapsed Time - 15 minutes

CPU Time - 15-70 seconds

Print Lines - 1500-15000

Tape Drives - None

Pre-processing Instructions:

Dependencies:

· The campus file has been received on vsftp

Prompted variables:

· &YYYY - 4-digit year of file to be edited. (e.g. 2005). For academic year files, this is the end year ex: 2007 = 2006-2007

· &L – cycle type A = Academic year, S= Summer

· &CC - 2 character alpha campus code – valid values are: BK, SF, DV, LA, RV, SD, SC, SB, IR

Post-processing Instructions:

Verification:

· Condition codes must be zero.

· Check OUTPUT file for initial ftp step copying file from vsftp to MVS

· Check OUTPUT file for final ftp step copying edit report file from MVS to vsftp

Log entries:

· Date campus file received

· File record count

Report distribution/notification:

· Notify Chris Handy that reports are ready for pickup

Rerun Procedures:

Job is rerunnable:

If the campus has resubmitted the file with the correct input name on the vsftp site, then:

RERUN from STEP1.PSTEP01

If we need to rerun with the same input file and the first ftp step to copy the campus input file from vsftp to MVS worked, then:

RESTART the job in STEP2.PSTEP01

1.6.5 Financial Aid Edit Reports – edit job CSSERF

The following edit reports are produced:

CSS.CSSERF.ERFcc.RPT

CSS.CSSERF.EXFcc.RPT

where cc is BK, SF, DV, LA, RV, SD, SC, SB, IR, MC (all campuses)

These edit report files are then combined into the following single edit report file:

CSS.CSSFEDcc.mmmyy.RPT

This consolidated edit report is then converted to PDF format before it is ftp’ed to the vsftp site for campus pickup:

CSS.CSSFEDcc.PDF

The filenames on the vsftp site are:

/ftphome/ftpusr[n]/get/css/CSSFED.mmmyy.PDF

/ftphome/ftpusru/get/css/CSSFED[cc].mmmyy.PDF

where n = 1 – 10 for the campus

cc = BK, etc. for the campus

mmm = JAN, MAY, OCT or NOV

1.6.6 Graduate Admissions Edit Reports – edit job CSSERG

The following edit reports are produced:

CSS.CSSERG.ERG2cc.RPT

CSS.CSSERG.ERG3cc.RPT

where cc is BK, SF, DV, LA, RV, SD, SC, SB, IR, MC (all campuses)

These edit report files are then combined into the following single edit report file:

CSS.CSSERGcc.Yyyyy.RPT

This consolidated edit report is then converted to PDF format before it is ftp’ed to the vsftp site for campus pickup:

CSS.CSSGEDcc.PDF

The filenames on the vsftp site are:

/ftphome/ftpusr[n]/get/css/CSSGED.Yyyyy.PDF

/ftphome/ftpusru/get/css/CSSGED[cc].Yyyyy.PDF

where n = 1 – 10 for the campus

cc = BK, etc. for the campus

1.6.7 Student Earnings Edit Reports – edit job CSSEARES

The student earnings input file is created from the Corporate Personnel System (CPS, or FCP).

The following edit reports are produced:

CSS.CSSEARES.ERRSEVR.Yyyyy.RPT

CSS.CSSEARES.ERRADVS.Yyyyy.RPT

CSS.CSSEARES.DUPRCDS.Yyyyy.RPT

CSS.CSSEARES.OFFLINE.Yyyyy.RPT

CSS.CSSEARES.EDITSTA.Yyyyy.RPT

CSS.CSSEARES.OVER100.Yyyyy.RPT

These edit report files are then combined into the following single edit report file converted to PDF format before it is ftp’ed to the vsftp site for campus pickup::

CSS.CSSEARES.Yyyyy.PDF

This consolidated edit report is then converted to PDF format before it is ftp’ed to the vsftp site for campus pickup:

CSS.CSSPEDcc.PDF

The filename on the vsftp site is:

/ftphome/ftpusru/get/css/CSSEARES.Yyyyy.PDF

1.6.8 Status Reports from Update Jobs

The majority of reports still produced on the MVS platform are the edit reports described above. In addition to the edit reports, the following update jobs also produce short status reports:

Status Reports for Update Jobs
Job	Report ID	DSN	Description (report heading)
CSSUP3	CSS004	CSS.CSSUP3.ET32AL.RPT	CAMPUS THIRD WEEK REGISTRANT INPUT STATUS REPORT
CSSUP3	CSS004	CSS.CSSUP3.ET33AL.RPT	CAMPUS RESIDENT INPUT STATUS REPORT
CSSUPE	CSS004	CSS.CSSUPE.ETE2AL.RPT	CAMPUS END OF TERM REGISTRANT INPUT STATUS REPORT
CSSUP3S	CSS004	CSS.CSSUP3S.ET32AL.RPT	CAMPUS THIRD WEEK REGISTRANT INPUT STATUS REPORT
CSSUP3S	CSSSUM1	CSS.CSS.CSSSUM1.RPT	SUMMARY OF STUDENT ENROLLMENT BY SUMMER STUDENT TYPE
CSSUP3S	CSSSUM2	CSS.CSS.CSSSUM1.RPT	SUMMARY OF STUDENT ENROLLMENT BY HOME CAMPUS
CSSUPES	CSS004