Limited Use USUB Jobs

These jobs are limited for special purposes or functions within the offices of OEM or OAA.
You can see the parameters for any job by clicking on its name.

Report Category: I-APPLICANTS
Job Name Title Description

U_ADAPPT Admissions Appointments Generate and email a report of recent admission appointments

U_APPFILE Application File Generate a CSV file of applicants matching specific characteristics.

U_HOOPELIG Set HOOP eligibility date Set the HOOP eligibility cutoff date for admits and tests

U_PROVET Recently admitted veterans generate PROVET merge file of recently admitted veterans

U_WUE WUE financial aid applicants Produce a CSV file of financial aid applicants with a WUE rate code

Report Category: I-CATALOG
Job Name Title Description

U_CATAUDITS Catalog Audit Reports Various Catalog Audits for a given term.

U_CATPREREQ_ALL Course Prerequisites Detail Course prerequisites report with all level details as entered in Banner form

U_CMSHR_UPDATE_COURSES Export courses for CMS HR Export New, Changed, and Inactivated courses for CMS HR faculty workload module

U_CRSEHIST Course modification history For a given course, list history of all modifications to all parts of the course

U_MSFAUDITS Collection of MSF fee audits Various MSF fee audits for catalog and schedule

U_SCRCAT_PRINT Master catalog report print Print master catalog report at computer center on wide paper

U_SOJSCH9 Populate Sched. w/ prereq/test Sends e-mail transmittal to jcontrol to update class schedule prerequsites based on the catalog. Run after schedule roll and wheneve. Run after schedule roll, and whenever the catalog audits indicate.

U_SOJSCH9_ATTR Pop. Schd w/ Catalog Deg Attr Sends e-mail transmittal to jcontrol to run job to populate class schedule with catalog degree attributes. Run after schedule roll and whenever catalog audits indicate.

U_SUBJECTS_ACTIVE Active Subject Codes Active Subject Codes with Dept and Coll Links for a given term.

Report Category: I-DEGREES
Job Name Title Description

U_DEGCOMM Degree Candidate Communication Generalized job to help communicate with people receiving degrees. Additional Documentation

U_DEGLET Degree granted letters generate DEGLET merge file for recently granted bachelors and masters degrees

U_DEGPENDMON Degree Seekers - Month Degree Seekers by a given month.

U_DEGR-ACADYEAR Academic Year Degree Rpts Graduation stats for the academic year

U_DEGR-CLEARING Degree Clearing Reports Runs reports to clear degrees

U_DEGR-FINAL Final Degree Clearing Final degree clearing report set

U_DEGR-HONORS Degrees with Honors List of degrees with honors

U_DEGR-PRELIMINARY Preliminary Degree Clearning Report sets for Preliminary Degree Clearing

U_DEGR-VALIDATION Validation for UG, 2B & GR Validation list

U_DEGSEEKMAJ Degree Seekers - Major List of Degree Seekers with a given major.

U_DEGSTATS Degree Statistics Statistics of degree status of A and D

U_DIPHOLDS Diploma Holds Report Generate a list of outstanding diploma holds without any other hold on file.

U_DIPLOMA_ORDER End of Semester Diploma Order SPACMNT list, Diploma mailing labels, FinAid holds list and labels

U_DIPLOMAS Diplomas Tab delimited file produced to import into Excel, merge with Word template and print diplomas

U_ERSD Request an ERSD job get run SHJERD9 transmittal form (sends email to jcontrol)

U_GRADDATES Grad Date Audit Audit to find incorrect graduation dates

U_GRADFIX Fix graduation dates SHPDGM9 Transmittal form (sends email to jcontrol)

Report Category: I-DIPLOMAS
Job Name Title Description

U_CHAPPELL Chappell Photography List of current year graduates (SO, A) for photos taken at graduation.

U_COMMENC_BOOK List for Commencement Book runs 9 jobs to generate lists for commencement book

Report Category: I-FACULTY
Job Name Title Description

U_ADVISOR Advisor list list of current advisors suitable for email merge

U_FACASSIGN_DET Assigned Time w/ CSV file Detailed assigned time report and CSV file

U_FACAUDITS Various Faculty Audits fachomeless, facbadcoll, bacbaddept, faccolldept, facover100, fac)tbs, facctgry, facctgry_mismatch, facnotype, facmissing_con, faccontracts, facconchk, facadvchk, facnistcode

U_FACBYTYPE Selected Instructors data comma separated data file of instructors selected by type (Lect, Prof, etc.) - see notes

U_INSTRUCTOR_HISTORY Summary of Insructor Appts Summary of instructor appointments by term

U_MAJADVIS List of Advisors List of advisors and advisees for a given term and major

Report Category: I-FISCAL
Job Name Title Description

U_RECONCILE Reconcilation Reports Group of reports run depending on parameter entered.

Report Category: I-JOBS
Job Name Title Description

U_RESEND Resend Re-emails the .lis file for a given job name. Can be used for Transcripts.

Report Category: I-MISC
Job Name Title Description

U_NOCOMM No communication sent Remove records from SUAMAIL after a PRO/STU/DEGCOMM job is run

Report Category: I-PROSPECTS
Job Name Title Description

U_INTERNAT_STATS International Stats-Recruit Stats on international students - inq, app, enr and degree data.

U_PROCOMM Communication to Prospects Inserts records into SUAMAIL, creates data file and optional labels. Additional Documentation

U_PROVISIT Letters for Recruiting Visit Generate mailmerge file to prior to a recruiting visit defined on SRASRCE.

Report Category: I-REGISTRAR
Job Name Title Description

U_EPR_OPENING EPR Workbook Data Data for EPR Workbook - Early EPR submission to Chancellor's Office

U_FTEAFTER FTE Generated After Census Tab delimited file of Students with course and reg data who registered after census for import into Excel.

U_REGISTRARCNTS Counts of Processed Items Counts of processed items for given time constraints.

Report Category: I-ROOMS
Job Name Title Description

U_ROOMDIR_ALL Master Room Directory Reports Runs Building inventory, Room attributes, Unrestricted Classrooms, Restricted Classrooms, All Non-Classrooms reports.

Report Category: I-SCHOLARSHIP
Job Name Title Description

U_SIEMENS Siemens Scholarship FTF with gpa greater than or equal to a given gpa sat or act greater than or equal to given scores, for a given term.

U_SMULLIN Smullin Scholarship FTF with HUM,DNO,MOD,TRI,SHA,SIS,TEH,LAS,BUT origins, gpa greater than or equal to a given gpa for a given term.

Report Category: I-SECTIONS
Job Name Title Description

U_EXT_APDB Extension APDB reports Extenion sections and summary enrollments for APDB reporting

U_REGTIME Registration Times Registration Times

U_SECTAUDITS_APDB Section Audits for APDB Section Audits for APDB preparation

U_SECTNONGE Compare Seats Offered-NonGE Compare the number of sections and the total number of seats offered for Non-GE couse categories for 2 specific terms.

U_SECTSTATS Sections Statistics Various sections offering and enrollment stats for comparison.

U_SUBJ_CONTACTS Subject Area Contact Info List of contacts for class schedule print

Report Category: I-STUDENTS
Job Name Title Description

U_IV_NSE_ADMITS IV, NSE Admits List of students with ratecode of IV, IVCON, NSAIT, NSAIY, NSBIT, NSBIY

U_ADDRESSCK Address To & From Date Check List of students with To Date Less Than From Date

U_ADMIT_STATS_BY_MAJOR Number of Admits by Major Number of admits for a given major grouping and term.

U_ADMITDECTEST Admitted Students & Test Score List of admits and test scores with decision codes of A, P, PE, PC, SE, HG, GP for a given term.

U_ADMSTUQUST Admitted Stu Qustetion Numbs Totals for letter type of ADASQ, ADASQ with contact code of ASQ, ADASQNO, ADASQNO with contact code of ASQ and ADASQ & ADASQNO.

U_ADMUGMAJMAIL Undergrad Admits Admitted undergrads for a given appliation term and given major

U_ADVPLACECNTS Advance Placement Counts Number of Advance placement students here at census for a given term.

U_ALLCALVETS California Vets Vets with rate codes of CALV, VCALV, NCVET, NCALV

U_ALUMNIFRAMES Alumni Frames Promo Text file of current awarded or sought graduates for import into excel.

U_AMPENR AMP Program List and text file for labels of students with AMP miniority for a given term and crn list.

U_ANIMALRESRCH PB Stus in Animal Research? Labels of Post Bach Students possibly involved in Animal Research

U_APPACTS App Interested in an Activity List of Applicants interested in a given activity code for a given term.

U_APPLAB60NON Over 60s Appls Label/List Generates List with option of labels to all Over 60s participants during the last year in order to send them applications.

U_APPS60 Apps With ActCode of 60 List of applicants with activity code of 60 for a given term.

U_APPS_ADDR_BY_MAJOR Applicants and Address List of applicants with a given term, major grouping and recruitment level

U_ARTREGTKT Art Reg Ticket Labels Labels for mailing of Art registration tickets.

U_ASB_INSURANCE ASB Health Insurance Mailing Generate CSV file of new and continuing students for ASB health insurance mailing

U_ATHGPALOW Athletes with low GPA return data file of currently enrolled athletes with GPA < 2.0 who have been enrolled for 2 terms

U_BASISADMITCNTS Basis of Admission Counts Counts for BOA by term, includes admit to enr yield

U_BYCONTCODE Data by Contact Code Data on prospects, applicants and enrolled students by contact code.

U_CALVETACTVLATER Cal Vet Fee Waiver List Active of Cal Vets in Fee Waiver for a Given Term

U_CAREER_DAY NRS Career Day Labels for students for NRS Career Day.

U_CENRHOLD Hold Status of Students Lists of students with the given hold for the given term.

U_CLEARHOUSE Audits for Clearinghouse Three audit scripts form clearinghouse data. Enrolled without address, enrolled without campus code or enrolled/withdrawn and listed as concurrently on leave.

U_CLEARY Labels of Clery Act Mailing Labels to mail out crime stats, in complicance of the Clery Act

U_COACHES-INTERESTS List of Interests for Coaches List of Interests with sport code activty as an interest for a given term. This script generates lists for specific coaches and ActCodes.

U_COACHES-RECRUITS List of Apps for Coaches List of Applicants with sport code activty as an interest for a given term. This script generates lists for specific coaches and ActCodes.

U_COMPAPPS Completed Apps List List of students by reclev for a given term, whos application is complete

U_COMPTRANS Complimentary Transcripts List of students qualifing for a complimentary transcript.

U_CONCRED Currently Enrolled Cond Creds List of currently enrolled conditionally classified credentials

U_CONFIDENTIAL Students with Confidentiality Email a CSV file of all students with the confidentiality flag set.

U_COUNSELORPACK Counselor Packet Labels Labels of Califorina High Schools in order by zip

U_CRED_PENDING Credential apps needing degree Credential apps with an HG decision, including those that may be PE now.

U_CRED_SUM_MAIL Credential Summer Mailing Three lists of students possibly interested in taking summer Education courses.

U_CREDCODE_AUDIT Audit of ERS Cred Coding Lists to check credential coding in ERS. Must be run after ERS table populated for census.

U_CRTRANSFERS CR Transfers to HSU List of CR tranfers to HSU for a given academic year.

U_CSU_FUTSCHOLAR CSU Future Scholars Generate CSV files of applicants who are first-generation college students

U_DISCIPLINE Disciplinary Suspension List List of students with disciplinary suspension comments on their transcripts.

U_DOUBLE_MAJ_LIST Second Major by Deg Objective List of students for a given degree objective with a double/second major.

U_ENMISS Prepare for ENMISS emails Create reports and email merge files about registration holds due to missing checklist items.

U_ENMISSPAP generate ENMISSPAP letters Create mailmerge file to send letters about registration holds due to missing checklist items

U_ENR_PREV_PRE Enrolled Preview Attendies Students that attended the previous spring preview (PRE contact code) and are currently enrolled. Includes contact information. Used to invit the students to assit with next Spring Preview.

U_ENROLLED_APPS Enrolled Apps Lists Generates 2 reports (matric FTF and not-FTF) admits registered at some point. Used to verify student file locations.

U_ENRWLEAVEBYMAJ Enrolled, Withdrawn, On-leave List of students Enrolled, Withdrawn, On-leave for a given term and major

U_ENRWLEAVEBYMAJR Major Change List List of Enrolled, Withdrawn, On-Leave for a given major. Used when major name change occurs.

U_EOPADMITS All Admits With HOP Code List of all admits for a given application term with HOP Code if Applicable

U_EVHOLDS Enrlld, On-Leave or Withdrawn With EV code and 'AW','WB','WA','WS' status.

U_EXCEPTIONS Roster of Exception Admissions List of students with exception admissions for a given application term.

U_FEEBUD Fee Waiver Budget Progs List of Fee Waiver Budget Programs between given terms

U_FEEWAIVERLABS Fee Waiver Labels Labels for enrolled or not enrolled, FFWD1, FFWD2 or NSBF1 OR SFWM

U_FFWD Students With Rate Code ffwd List of students with ffwd rate code for a given term.

U_FFWDAPPROVE List of Enrolled FFWDs List of enrolled students with FFWD rate code for a given term.

U_FOREIGNW Foreign Students Receiving Ws Email a list of foreign students who received W grades

U_FOREIGNADM Admitted Foreign Students List of Foreign Students with address for specified term

U_FOREIGNSTUDS Lists of Info On Foreign Stus emails 5 reports about foreign students, one degree report, and a CSV file

U_FORREGUNITS Foreign Stus Registered Units Gives list of students for given term with total units

U_FRESH_ATH Freshman Athletes for AY List of Freshmen Athletes for a given academic year.

U_FTF_ADHOLD FTF with AD Hold List of FTF with AD Hold.

U_FTFAPPSORIGIN Number of FTF Apps By Origin Number of FTF apps by origin with number of which enrolled. Option for minimum number of apps.

U_FTFRECRUITS Local FTF Recruits List of local first time freshman prospects for a given term.

U_GENMMENROLLED Generate the enrolled students Check for printing, backup, and generate the enrolled students merge file

U_GRADSFUTUGUNITS Graduates with Future UG Units List of students who have graduated but have UG units in future terms

U_GRADU_CAND_ADDS Graduates After Inital Approve List of students applying for graduation after inital ist of students applying for graduation after inital

U_HOPADMITS All Admits With HOP Code List of all admits for a given application term with HOP code if applicable.

U_HSCON Students with HSCON Rate List of Students with HSCON rate for a given term.

U_HSCONMAIL HS Concurrent Mail List Tab-delimmited file of HSCON enrolled for a given term. Inserts HSCONC type letter into mail table.

U_IMPACT Enrollment Stats - Impacted Enrollement stats for a given term, and future fall terms, and given major.

U_INACTIVE_GRADS Inactive masters students Inactive masters seeking students as of a given term

U_INTERNATAPPS International Student Apps List of Internation Student Applicants for a given term.

U_INTNONIMM Non-Immigrant Aliens List of enrolled students, excluding citizenship codes J,F,I,Y and R. Includes F locations. For a given term.

U_INTQTYBYCNTRY Counts of HSU Internationals Number of enrolled students by term and level who and international

U_LLP_AUDIT Coded as FIG not in FIG Course List of students codes as a FIG or LLP but did not take the FIG or LLP Course

U_MASTERAPPS_BY_RES Masters Yields By Residency Counts of Applied, Admitted, Enrolled and Yield by Major and Residency for a given term. Includes a summary of International & Foreign.

U_MASTERS_ONLEAVE Masters Seekers On-Leave List of masters seeking students for a given term.

U_MASTERSUNITS Masters Seekers:More Than 14 Number of students and corresponding units (at least 14 units) for a given term.

U_MILITARY Military Data Extract Tab delimited file of student data requested by military.

U_MSE Mid-Semester Evaluation generates reports sent to departments, email notification to students or full list of all students in jeopardy

U_NEWSTULABELS Address/Folder Labels Run AFTER advisors are assigned. Prints labels and corresponding report with rate codes and student type codes for selected new students with three group options.

U_NONRESCHGTORES Students Now Residents Students that were not residents last term, but are now residents this term.

U_NONRESLISTS Non-Resident Aliens List of non-resident aliens for a given term. Option for enrolled or registered.

U_NOPAYLIST Non-Payment List w/Phone Num List of students for a given term that are on the non-payment list.

U_NOREG UG not yet registered File of continuing UG not yet registered for next term

U_NSE_APPS List of NSE Applicants List of NSE applicants for a given term

U_PARENTFUND Parent Fund - Fundraising Current Term roster and labels (mailing and office use) of all UG, for a given age.

U_PDECENRL Enrolled Admits w/ P, PE or PF List of Currently Enrolled Students with Decision Code of P, PE or PF

U_PRES_SCHOLARSHIP Presidental Scholarship List of students qualified for Presidental Scholarship

U_PRESIDENTS_EOP OBSOLETE! use STUCOMM List of EOP Presidetnal Scholars at the end of a given term. Run after grades for given term.

U_PROS_BY_CC Community College Prospects List of students for a given like community college

U_PROS_BY_HS Prospect By Given High School List of Prospects at a given High School for a given application term. Used for Fac taking an extra day on existing travel for recruitment.

U_PROVADMITS Provision admits Generate a data file of provisional admits: P,PE,HG,PF,PR; UG, 2B, and UN only

U_PROVISIONAL Provisional Admission Report Generates a list of provisional decisions that were posted either on the day before or up to the time of the report running. This depends on the parameters entered.

U_REGERROR Error F in Reg Report List of Students with F error in reg table.

U_REGTIMES Registration times and PINs Return a CSV file of registration times for changed grad date or LV/WD students

U_REMED-NOCLASS Remediation report List of remedial students not enrolled in required classes

U_REMEDIAL_FAIL Stus Who Failed Remedial Crseq List of students who have failed remedial classes taken in a given term. Students are listed by their matric terms.

U_RESTAT Recruitment Statistics Various scripts containing recruitemnt stats

U_RW-NEWSLETTER SASOP Newletter List and labels of student enrolled for a given term not having ethnic code of 7,8,9,D.

U_SBASISSTU S Basis, GE Breadth & Act Code S Basis Students with Math, Engl, Spee, Crit scores and Activity Code

U_SDRCRISK SDRC Students In Jeopardy List of SDRC students on probation, DQed or with GPA < 2.0. Current academic standing for given term.

U_SEEKSECBACC Student Seeking Second Bach List of Students seeking a second bachelors

U_SFWDAPPROVE Students With Rate Code SFWD1 List of students with rate code SFWD1 for a given term.

U_SFWMAAPPROVE Students with SFWM Rate Code List of students with SFWM rate code for a given term.

U_SFWNMAPPROVE Students with SFWNM Rate Code List of students for a given term with the SFWNM Rate Code.

U_SIXTIESCENR Sixties by Term and Rate List of Sixties Students for a given term and a given rate

U_SIXTIESLUNCHEON Labels/List, Sixites Luncheon Labels and List with option of just list for current term Sixties studetns.

U_SOTC Summary of Transferable Credit Generates summary of transferable credit by list (MAIL, EOP, MAJOR, FOOTBALL) for a given term. Or a single report by entering SSN of a student.

U_STUCOMM Communication to Students Inserts records into SUAMAIL, creates data file and optional labels. Additional Documentation

U_SUMFADPRE Preview Data List and counts of inq, apps, admits and enrs with PRE, SUM contact codes or FAD activity code

U_TRANS_NO_UNITS Transfers Without Units Transfer students enrolled for a given term and level, who are without units.

U_TRANSCRIPT Transcipts for Students by SSN Transcripts for a given student by ssn.

U_TRANSCRIPTS All Transcripts All Transcripts

U_UNDEC_ENRWLEAVE Undeclared Advising Enrolled, Withdrawn, On-leave students with Advisor. By term, level with gpa and status.

U_UNDECGRADSTU Undeclared GR Level Students Labels of 000000 GR level, not 60s or on leave.

U_VET4GRADES Grades for Code 4 Vets List of Code 4 Veterans with Grades

U_VETCADDRESS Vet Current Address Generates List of Current Veterans Address

U_VETCERT Veterans Cert/Enroll Veternams Certification/Enrollment Report for a Specific Term.

U_VETCERTCODE Vets With Option of Vetcode List of Vets with a given Vetcode for a given term.

U_VETDEGSTAT Veterans Degree Status List of Degrees awarded to vets in the last 7 days

U_VETDENY Denied Veterans Report Generate CSV file of UG veterans who have been denied admission

U_VETGRADES Veterans Grades Status Vets Certification and Outstanding RD, SP or I Grades for specific term

U_VETGRADS1 Veteran Graduation Report List of Veterans Graduating in given Term

U_VETREG2A Vet Schedule Changes Veterans Schedule for Specific Term since last time job ran.

U_VETREGALL Class Schedule of All Vets List of vets with class schedule, and class information.

U_VETS Veteran files for VUB Produce CSV files of vets who graduated in the last 5 years or are currently enrolled

U_VETS-NOMILITARY Vets w/ no MILSRV List of Vets with no MILSRV instutuion in transfer work.

U_VETS_CONCURRENT Vets With Vetcode A, B List of Concurrent Vets

U_VETS_PROBATION Vets w/GPA Between 1.94 & 1.99 List of Vets with GPA >= 1.94 and GPA <= 1.99 for a given term. Gives most current overall GPA

U_YIELD_BY_EVENT Yield & Conv by Event Yield and conversion data on PRE and SUM events.

U_YIELD_BY_MAJOR Fall Yld & Conv by Major Fall Yields and conversion rates by major between two given terms and given reclev.

U_YIELD_BY_ORIGIN Fall Yld & Conv by Origin Fall Yields and conversion rates by origin between two given terms and given reclev.

U_YIELDHSCONTOENR Yields-High School Concurrent various yeilds for HSCON for given terms


Report Category: I-APPLICANTS
Job Name	Title	Description
U_ADAPPT	Admissions Appointments	Generate and email a report of recent admission appointments
U_APPFILE	Application File	Generate a CSV file of applicants matching specific characteristics.
U_HOOPELIG	Set HOOP eligibility date	Set the HOOP eligibility cutoff date for admits and tests
U_PROVET	Recently admitted veterans	generate PROVET merge file of recently admitted veterans
U_WUE	WUE financial aid applicants	Produce a CSV file of financial aid applicants with a WUE rate code

Report Category: I-CATALOG
Job Name	Title	Description
U_CATAUDITS	Catalog Audit Reports	Various Catalog Audits for a given term.
U_CATPREREQ_ALL	Course Prerequisites Detail	Course prerequisites report with all level details as entered in Banner form
U_CMSHR_UPDATE_COURSES	Export courses for CMS HR	Export New, Changed, and Inactivated courses for CMS HR faculty workload module
U_CRSEHIST	Course modification history	For a given course, list history of all modifications to all parts of the course
U_MSFAUDITS	Collection of MSF fee audits	Various MSF fee audits for catalog and schedule
U_SCRCAT_PRINT	Master catalog report print	Print master catalog report at computer center on wide paper
U_SOJSCH9	Populate Sched. w/ prereq/test	Sends e-mail transmittal to jcontrol to update class schedule prerequsites based on the catalog. Run after schedule roll and wheneve. Run after schedule roll, and whenever the catalog audits indicate.
U_SOJSCH9_ATTR	Pop. Schd w/ Catalog Deg Attr	Sends e-mail transmittal to jcontrol to run job to populate class schedule with catalog degree attributes. Run after schedule roll and whenever catalog audits indicate.
U_SUBJECTS_ACTIVE	Active Subject Codes	Active Subject Codes with Dept and Coll Links for a given term.

Report Category: I-DEGREES
Job Name	Title	Description
U_DEGCOMM	Degree Candidate Communication	Generalized job to help communicate with people receiving degrees. Additional Documentation
U_DEGLET	Degree granted letters	generate DEGLET merge file for recently granted bachelors and masters degrees
U_DEGPENDMON	Degree Seekers - Month	Degree Seekers by a given month.
U_DEGR-ACADYEAR	Academic Year Degree Rpts	Graduation stats for the academic year
U_DEGR-CLEARING	Degree Clearing Reports	Runs reports to clear degrees
U_DEGR-FINAL	Final Degree Clearing	Final degree clearing report set
U_DEGR-HONORS	Degrees with Honors	List of degrees with honors
U_DEGR-PRELIMINARY	Preliminary Degree Clearning	Report sets for Preliminary Degree Clearing
U_DEGR-VALIDATION	Validation for UG, 2B & GR	Validation list
U_DEGSEEKMAJ	Degree Seekers - Major	List of Degree Seekers with a given major.
U_DEGSTATS	Degree Statistics	Statistics of degree status of A and D
U_DIPHOLDS	Diploma Holds Report	Generate a list of outstanding diploma holds without any other hold on file.
U_DIPLOMA_ORDER	End of Semester Diploma Order	SPACMNT list, Diploma mailing labels, FinAid holds list and labels
U_DIPLOMAS	Diplomas	Tab delimited file produced to import into Excel, merge with Word template and print diplomas
U_ERSD	Request an ERSD job get run	SHJERD9 transmittal form (sends email to jcontrol)
U_GRADDATES	Grad Date Audit	Audit to find incorrect graduation dates
U_GRADFIX	Fix graduation dates	SHPDGM9 Transmittal form (sends email to jcontrol)

Report Category: I-DIPLOMAS
Job Name	Title	Description
U_CHAPPELL	Chappell Photography	List of current year graduates (SO, A) for photos taken at graduation.
U_COMMENC_BOOK	List for Commencement Book	runs 9 jobs to generate lists for commencement book

Report Category: I-FACULTY
Job Name	Title	Description
U_ADVISOR	Advisor list	list of current advisors suitable for email merge
U_FACASSIGN_DET	Assigned Time w/ CSV file	Detailed assigned time report and CSV file
U_FACAUDITS	Various Faculty Audits	fachomeless, facbadcoll, bacbaddept, faccolldept, facover100, fac)tbs, facctgry, facctgry_mismatch, facnotype, facmissing_con, faccontracts, facconchk, facadvchk, facnistcode
U_FACBYTYPE	Selected Instructors data	comma separated data file of instructors selected by type (Lect, Prof, etc.) - see notes
U_INSTRUCTOR_HISTORY	Summary of Insructor Appts	Summary of instructor appointments by term
U_MAJADVIS	List of Advisors	List of advisors and advisees for a given term and major

Report Category: I-FISCAL
Job Name	Title	Description
U_RECONCILE	Reconcilation Reports	Group of reports run depending on parameter entered.

Report Category: I-JOBS
Job Name	Title	Description
U_RESEND	Resend	Re-emails the .lis file for a given job name. Can be used for Transcripts.

Report Category: I-MISC
Job Name	Title	Description
U_NOCOMM	No communication sent	Remove records from SUAMAIL after a PRO/STU/DEGCOMM job is run

Report Category: I-PROSPECTS
Job Name	Title	Description
U_INTERNAT_STATS	International Stats-Recruit	Stats on international students - inq, app, enr and degree data.
U_PROCOMM	Communication to Prospects	Inserts records into SUAMAIL, creates data file and optional labels. Additional Documentation
U_PROVISIT	Letters for Recruiting Visit	Generate mailmerge file to prior to a recruiting visit defined on SRASRCE.

Report Category: I-REGISTRAR
Job Name	Title	Description
U_EPR_OPENING	EPR Workbook Data	Data for EPR Workbook - Early EPR submission to Chancellor's Office
U_FTEAFTER	FTE Generated After Census	Tab delimited file of Students with course and reg data who registered after census for import into Excel.
U_REGISTRARCNTS	Counts of Processed Items	Counts of processed items for given time constraints.

Report Category: I-ROOMS
Job Name	Title	Description
U_ROOMDIR_ALL	Master Room Directory Reports	Runs Building inventory, Room attributes, Unrestricted Classrooms, Restricted Classrooms, All Non-Classrooms reports.

Report Category: I-SCHOLARSHIP
Job Name	Title	Description
U_SIEMENS	Siemens Scholarship	FTF with gpa greater than or equal to a given gpa sat or act greater than or equal to given scores, for a given term.
U_SMULLIN	Smullin Scholarship	FTF with HUM,DNO,MOD,TRI,SHA,SIS,TEH,LAS,BUT origins, gpa greater than or equal to a given gpa for a given term.

Report Category: I-SECTIONS
Job Name	Title	Description
U_EXT_APDB	Extension APDB reports	Extenion sections and summary enrollments for APDB reporting
U_REGTIME	Registration Times	Registration Times
U_SECTAUDITS_APDB	Section Audits for APDB	Section Audits for APDB preparation
U_SECTNONGE	Compare Seats Offered-NonGE	Compare the number of sections and the total number of seats offered for Non-GE couse categories for 2 specific terms.
U_SECTSTATS	Sections Statistics	Various sections offering and enrollment stats for comparison.
U_SUBJ_CONTACTS	Subject Area Contact Info	List of contacts for class schedule print

Report Category: I-STUDENTS
Job Name	Title	Description
U_IV_NSE_ADMITS	IV, NSE Admits	List of students with ratecode of IV, IVCON, NSAIT, NSAIY, NSBIT, NSBIY
U_ADDRESSCK	Address To & From Date Check	List of students with To Date Less Than From Date
U_ADMIT_STATS_BY_MAJOR	Number of Admits by Major	Number of admits for a given major grouping and term.
U_ADMITDECTEST	Admitted Students & Test Score	List of admits and test scores with decision codes of A, P, PE, PC, SE, HG, GP for a given term.
U_ADMSTUQUST	Admitted Stu Qustetion Numbs	Totals for letter type of ADASQ, ADASQ with contact code of ASQ, ADASQNO, ADASQNO with contact code of ASQ and ADASQ & ADASQNO.
U_ADMUGMAJMAIL	Undergrad Admits	Admitted undergrads for a given appliation term and given major
U_ADVPLACECNTS	Advance Placement Counts	Number of Advance placement students here at census for a given term.
U_ALLCALVETS	California Vets	Vets with rate codes of CALV, VCALV, NCVET, NCALV
U_ALUMNIFRAMES	Alumni Frames Promo	Text file of current awarded or sought graduates for import into excel.
U_AMPENR	AMP Program	List and text file for labels of students with AMP miniority for a given term and crn list.
U_ANIMALRESRCH	PB Stus in Animal Research?	Labels of Post Bach Students possibly involved in Animal Research
U_APPACTS	App Interested in an Activity	List of Applicants interested in a given activity code for a given term.
U_APPLAB60NON	Over 60s Appls Label/List	Generates List with option of labels to all Over 60s participants during the last year in order to send them applications.
U_APPS60	Apps With ActCode of 60	List of applicants with activity code of 60 for a given term.
U_APPS_ADDR_BY_MAJOR	Applicants and Address	List of applicants with a given term, major grouping and recruitment level
U_ARTREGTKT	Art Reg Ticket Labels	Labels for mailing of Art registration tickets.
U_ASB_INSURANCE	ASB Health Insurance Mailing	Generate CSV file of new and continuing students for ASB health insurance mailing
U_ATHGPALOW	Athletes with low GPA	return data file of currently enrolled athletes with GPA < 2.0 who have been enrolled for 2 terms
U_BASISADMITCNTS	Basis of Admission Counts	Counts for BOA by term, includes admit to enr yield
U_BYCONTCODE	Data by Contact Code	Data on prospects, applicants and enrolled students by contact code.
U_CALVETACTVLATER	Cal Vet Fee Waiver	List Active of Cal Vets in Fee Waiver for a Given Term
U_CAREER_DAY	NRS Career Day	Labels for students for NRS Career Day.
U_CENRHOLD	Hold Status of Students	Lists of students with the given hold for the given term.
U_CLEARHOUSE	Audits for Clearinghouse	Three audit scripts form clearinghouse data. Enrolled without address, enrolled without campus code or enrolled/withdrawn and listed as concurrently on leave.
U_CLEARY	Labels of Clery Act Mailing	Labels to mail out crime stats, in complicance of the Clery Act
U_COACHES-INTERESTS	List of Interests for Coaches	List of Interests with sport code activty as an interest for a given term. This script generates lists for specific coaches and ActCodes.
U_COACHES-RECRUITS	List of Apps for Coaches	List of Applicants with sport code activty as an interest for a given term. This script generates lists for specific coaches and ActCodes.
U_COMPAPPS	Completed Apps List	List of students by reclev for a given term, whos application is complete
U_COMPTRANS	Complimentary Transcripts	List of students qualifing for a complimentary transcript.
U_CONCRED	Currently Enrolled Cond Creds	List of currently enrolled conditionally classified credentials
U_CONFIDENTIAL	Students with Confidentiality	Email a CSV file of all students with the confidentiality flag set.
U_COUNSELORPACK	Counselor Packet Labels	Labels of Califorina High Schools in order by zip
U_CRED_PENDING	Credential apps needing degree	Credential apps with an HG decision, including those that may be PE now.
U_CRED_SUM_MAIL	Credential Summer Mailing	Three lists of students possibly interested in taking summer Education courses.
U_CREDCODE_AUDIT	Audit of ERS Cred Coding	Lists to check credential coding in ERS. Must be run after ERS table populated for census.
U_CRTRANSFERS	CR Transfers to HSU	List of CR tranfers to HSU for a given academic year.
U_CSU_FUTSCHOLAR	CSU Future Scholars	Generate CSV files of applicants who are first-generation college students
U_DISCIPLINE	Disciplinary Suspension List	List of students with disciplinary suspension comments on their transcripts.
U_DOUBLE_MAJ_LIST	Second Major by Deg Objective	List of students for a given degree objective with a double/second major.
U_ENMISS	Prepare for ENMISS emails	Create reports and email merge files about registration holds due to missing checklist items.
U_ENMISSPAP	generate ENMISSPAP letters	Create mailmerge file to send letters about registration holds due to missing checklist items
U_ENR_PREV_PRE	Enrolled Preview Attendies	Students that attended the previous spring preview (PRE contact code) and are currently enrolled. Includes contact information. Used to invit the students to assit with next Spring Preview.
U_ENROLLED_APPS	Enrolled Apps Lists	Generates 2 reports (matric FTF and not-FTF) admits registered at some point. Used to verify student file locations.
U_ENRWLEAVEBYMAJ	Enrolled, Withdrawn, On-leave	List of students Enrolled, Withdrawn, On-leave for a given term and major
U_ENRWLEAVEBYMAJR	Major Change List	List of Enrolled, Withdrawn, On-Leave for a given major. Used when major name change occurs.
U_EOPADMITS	All Admits With HOP Code	List of all admits for a given application term with HOP Code if Applicable
U_EVHOLDS	Enrlld, On-Leave or Withdrawn	With EV code and 'AW','WB','WA','WS' status.
U_EXCEPTIONS	Roster of Exception Admissions	List of students with exception admissions for a given application term.
U_FEEBUD	Fee Waiver Budget Progs	List of Fee Waiver Budget Programs between given terms
U_FEEWAIVERLABS	Fee Waiver Labels	Labels for enrolled or not enrolled, FFWD1, FFWD2 or NSBF1 OR SFWM
U_FFWD	Students With Rate Code ffwd	List of students with ffwd rate code for a given term.
U_FFWDAPPROVE	List of Enrolled FFWDs	List of enrolled students with FFWD rate code for a given term.
U_FOREIGNW	Foreign Students Receiving Ws	Email a list of foreign students who received W grades
U_FOREIGNADM	Admitted Foreign Students	List of Foreign Students with address for specified term
U_FOREIGNSTUDS	Lists of Info On Foreign Stus	emails 5 reports about foreign students, one degree report, and a CSV file
U_FORREGUNITS	Foreign Stus Registered Units	Gives list of students for given term with total units
U_FRESH_ATH	Freshman Athletes for AY	List of Freshmen Athletes for a given academic year.
U_FTF_ADHOLD	FTF with AD Hold	List of FTF with AD Hold.
U_FTFAPPSORIGIN	Number of FTF Apps By Origin	Number of FTF apps by origin with number of which enrolled. Option for minimum number of apps.
U_FTFRECRUITS	Local FTF Recruits	List of local first time freshman prospects for a given term.
U_GENMMENROLLED	Generate the enrolled students	Check for printing, backup, and generate the enrolled students merge file
U_GRADSFUTUGUNITS	Graduates with Future UG Units	List of students who have graduated but have UG units in future terms
U_GRADU_CAND_ADDS	Graduates After Inital Approve	List of students applying for graduation after inital ist of students applying for graduation after inital
U_HOPADMITS	All Admits With HOP Code	List of all admits for a given application term with HOP code if applicable.
U_HSCON	Students with HSCON Rate	List of Students with HSCON rate for a given term.
U_HSCONMAIL	HS Concurrent Mail List	Tab-delimmited file of HSCON enrolled for a given term. Inserts HSCONC type letter into mail table.
U_IMPACT	Enrollment Stats - Impacted	Enrollement stats for a given term, and future fall terms, and given major.
U_INACTIVE_GRADS	Inactive masters students	Inactive masters seeking students as of a given term
U_INTERNATAPPS	International Student Apps	List of Internation Student Applicants for a given term.
U_INTNONIMM	Non-Immigrant Aliens	List of enrolled students, excluding citizenship codes J,F,I,Y and R. Includes F locations. For a given term.
U_INTQTYBYCNTRY	Counts of HSU Internationals	Number of enrolled students by term and level who and international
U_LLP_AUDIT	Coded as FIG not in FIG Course	List of students codes as a FIG or LLP but did not take the FIG or LLP Course
U_MASTERAPPS_BY_RES	Masters Yields By Residency	Counts of Applied, Admitted, Enrolled and Yield by Major and Residency for a given term. Includes a summary of International & Foreign.
U_MASTERS_ONLEAVE	Masters Seekers On-Leave	List of masters seeking students for a given term.
U_MASTERSUNITS	Masters Seekers:More Than 14	Number of students and corresponding units (at least 14 units) for a given term.
U_MILITARY	Military Data Extract	Tab delimited file of student data requested by military.
U_MSE	Mid-Semester Evaluation	generates reports sent to departments, email notification to students or full list of all students in jeopardy
U_NEWSTULABELS	Address/Folder Labels	Run AFTER advisors are assigned. Prints labels and corresponding report with rate codes and student type codes for selected new students with three group options.
U_NONRESCHGTORES	Students Now Residents	Students that were not residents last term, but are now residents this term.
U_NONRESLISTS	Non-Resident Aliens	List of non-resident aliens for a given term. Option for enrolled or registered.
U_NOPAYLIST	Non-Payment List w/Phone Num	List of students for a given term that are on the non-payment list.
U_NOREG	UG not yet registered	File of continuing UG not yet registered for next term
U_NSE_APPS	List of NSE Applicants	List of NSE applicants for a given term
U_PARENTFUND	Parent Fund - Fundraising	Current Term roster and labels (mailing and office use) of all UG, for a given age.
U_PDECENRL	Enrolled Admits w/ P, PE or PF	List of Currently Enrolled Students with Decision Code of P, PE or PF
U_PRES_SCHOLARSHIP	Presidental Scholarship	List of students qualified for Presidental Scholarship
U_PRESIDENTS_EOP	OBSOLETE! use STUCOMM	List of EOP Presidetnal Scholars at the end of a given term. Run after grades for given term.
U_PROS_BY_CC	Community College Prospects	List of students for a given like community college
U_PROS_BY_HS	Prospect By Given High School	List of Prospects at a given High School for a given application term. Used for Fac taking an extra day on existing travel for recruitment.
U_PROVADMITS	Provision admits	Generate a data file of provisional admits: P,PE,HG,PF,PR; UG, 2B, and UN only
U_PROVISIONAL	Provisional Admission Report	Generates a list of provisional decisions that were posted either on the day before or up to the time of the report running. This depends on the parameters entered.
U_REGERROR	Error F in Reg Report	List of Students with F error in reg table.
U_REGTIMES	Registration times and PINs	Return a CSV file of registration times for changed grad date or LV/WD students
U_REMED-NOCLASS	Remediation report	List of remedial students not enrolled in required classes
U_REMEDIAL_FAIL	Stus Who Failed Remedial Crseq	List of students who have failed remedial classes taken in a given term. Students are listed by their matric terms.
U_RESTAT	Recruitment Statistics	Various scripts containing recruitemnt stats
U_RW-NEWSLETTER	SASOP Newletter	List and labels of student enrolled for a given term not having ethnic code of 7,8,9,D.
U_SBASISSTU	S Basis, GE Breadth & Act Code	S Basis Students with Math, Engl, Spee, Crit scores and Activity Code
U_SDRCRISK	SDRC Students In Jeopardy	List of SDRC students on probation, DQed or with GPA < 2.0. Current academic standing for given term.
U_SEEKSECBACC	Student Seeking Second Bach	List of Students seeking a second bachelors
U_SFWDAPPROVE	Students With Rate Code SFWD1	List of students with rate code SFWD1 for a given term.
U_SFWMAAPPROVE	Students with SFWM Rate Code	List of students with SFWM rate code for a given term.
U_SFWNMAPPROVE	Students with SFWNM Rate Code	List of students for a given term with the SFWNM Rate Code.
U_SIXTIESCENR	Sixties by Term and Rate	List of Sixties Students for a given term and a given rate
U_SIXTIESLUNCHEON	Labels/List, Sixites Luncheon	Labels and List with option of just list for current term Sixties studetns.
U_SOTC	Summary of Transferable Credit	Generates summary of transferable credit by list (MAIL, EOP, MAJOR, FOOTBALL) for a given term. Or a single report by entering SSN of a student.
U_STUCOMM	Communication to Students	Inserts records into SUAMAIL, creates data file and optional labels. Additional Documentation
U_SUMFADPRE	Preview Data	List and counts of inq, apps, admits and enrs with PRE, SUM contact codes or FAD activity code
U_TRANS_NO_UNITS	Transfers Without Units	Transfer students enrolled for a given term and level, who are without units.
U_TRANSCRIPT	Transcipts for Students by SSN	Transcripts for a given student by ssn.
U_TRANSCRIPTS	All Transcripts	All Transcripts
U_UNDEC_ENRWLEAVE	Undeclared Advising	Enrolled, Withdrawn, On-leave students with Advisor. By term, level with gpa and status.
U_UNDECGRADSTU	Undeclared GR Level Students	Labels of 000000 GR level, not 60s or on leave.
U_VET4GRADES	Grades for Code 4 Vets	List of Code 4 Veterans with Grades
U_VETCADDRESS	Vet Current Address	Generates List of Current Veterans Address
U_VETCERT	Veterans Cert/Enroll	Veternams Certification/Enrollment Report for a Specific Term.
U_VETCERTCODE	Vets With Option of Vetcode	List of Vets with a given Vetcode for a given term.
U_VETDEGSTAT	Veterans Degree Status	List of Degrees awarded to vets in the last 7 days
U_VETDENY	Denied Veterans Report	Generate CSV file of UG veterans who have been denied admission
U_VETGRADES	Veterans Grades Status	Vets Certification and Outstanding RD, SP or I Grades for specific term
U_VETGRADS1	Veteran Graduation Report	List of Veterans Graduating in given Term
U_VETREG2A	Vet Schedule Changes	Veterans Schedule for Specific Term since last time job ran.
U_VETREGALL	Class Schedule of All Vets	List of vets with class schedule, and class information.
U_VETS	Veteran files for VUB	Produce CSV files of vets who graduated in the last 5 years or are currently enrolled
U_VETS-NOMILITARY	Vets w/ no MILSRV	List of Vets with no MILSRV instutuion in transfer work.
U_VETS_CONCURRENT	Vets With Vetcode A, B	List of Concurrent Vets
U_VETS_PROBATION	Vets w/GPA Between 1.94 & 1.99	List of Vets with GPA >= 1.94 and GPA <= 1.99 for a given term. Gives most current overall GPA
U_YIELD_BY_EVENT	Yield & Conv by Event	Yield and conversion data on PRE and SUM events.
U_YIELD_BY_MAJOR	Fall Yld & Conv by Major	Fall Yields and conversion rates by major between two given terms and given reclev.
U_YIELD_BY_ORIGIN	Fall Yld & Conv by Origin	Fall Yields and conversion rates by origin between two given terms and given reclev.
U_YIELDHSCONTOENR	Yields-High School Concurrent	various yeilds for HSCON for given terms

;

Other Processes


sojsch9 - Process to populate Schedule prereq/test requirements data
          from catalog.

    This process should be requested after a schedule roll, or whenever
    changes occur in the catalog prereq or test scores data.
    OEM or Undergraduate Studies staff may request this job by sending
    the following information to Job Control (jcontrol@laurel).

    -----------
    Job Name:  SOJSCH9

    Parameter:  200020   (Class schedule term code)

    Run time:  Time of day to run  (request by noon for same day run)
               NOTE:  They can also handle immediate job needs, but you
                      should call (x6111) in addition to sending email.
    -----------



sojapd9 - Extract the Section and FAculty data from Banner for export
          to the Chancellor's Office computer for APDB processing.
          This script extracts Main campus section sand faculty.

Parameter: Term



sojapd9ee - For Extension APDB reporting
            Extract only the Section data for Extension (sAPDB) reporting

Parameter: Term

Last updated on: 20-NOV-09