General USUB Jobs Index


USUB jobs may be submitted from within Banner using the form GJAPCTL. You can see the parameters for any job by clicking on its name. Please note that every job name begins with the letter U followed by a single underscore character.

Report Category: APPLICANTS
Job NameTitleDescription
U_COACHES Coaches Reports Emailed reports of prospects and applicants interested in athletics
Report Category: CATALOG
Job NameTitleDescription
U_CATEQVLIST Equivalent Courses Current catalog courses which have equivalent courses.
U_CATPREREQ Courses with Prerequisites Report of courses, titles, and prerequisites for all courses that have at least 1 prerequisite.
U_CATRES Catalog Reg Restrictions Catalog based registration restrictions for Class, Level, Major, Campus, College.
U_CATSMRY Course Catalog Summary Basic Course info for active and suspended courses as of a given term.
U_CATWTUS Course Modes, Units & Est. WTU Show catalog mode, units and WTU (workload).
U_MSFAPRV Approved MSF Course Fees Approved MSF course fees in Banner catalog.
U_SCRCAT Master Catalog report - PDF Master catalog report with all course details - emails a PDF file
Report Category: CODES
Job NameTitleDescription
U_BLOCK_CODES Report existing BLOCK codes Report existing block codes used for scheduling FIG/TRIG classes and students.
U_DEPTCODES Current Depts by Coll & Dist List current department codes by colleges sorted by the indicated distribution dept.
U_MAJRCODES Current Major Codes List current major codes sorted by college and department.
U_SUBJCODES Current Subjs by Coll & Dept List current subject codes sorted by college and department.
U_TESTCODES List of Valid Test Codes List of vaild test codes
Report Category: DEGREES
Job NameTitleDescription
U_GRADSBYMAJ Graduates by major Generate a file of information about graduates for specified majors
Report Category: FACULTY
Job NameTitleDescription
U_FAC_CLASSES Enrolled Class Sects Assigned Report of class sections and census enrollments by instructor for a given department. Only shows classes with enrollment. Use for FAD review.
U_FAC_CLASSES_ALL ALL Classes Assigned to Intrs Report of class sections and census enrollments by instructor for a given department. Includes sections with no enrollment.
U_FAC_CLASSES_HIST Multi-Term Instructor Classes Class sections and census enrollments by instructor for multiple terms.
U_FAC_CLASSES_PLAN Instrs, classes, locations Report classes and meeting times/locations by instructor and dept.
U_FACAPPTS All Instructor Appts by Dept Report of all instructors/advisors info and portion of time base in each department. Use for FAD review.
U_FACAPPTS_ALL Instructor Appts by Person Report of all instructors/advisors info by person, includes portion of time base.
U_FACASSIGN_HIST Multi-term Assigned Time Multi-term history of faculty assigned time.
U_FACASSIGN_TIME Assigned/Release Time Faculty with assigned time or administrative appointment. Use for APDB/FAD review.
U_FACFERP All FERP Faculty All FERP faculty for a given term. Shows if teaching classes during the term or not.
U_GE_INSTRUCTORS GE Instructors By Area Comma seperated file with instructors teaching GE Area courses by GE Area. Contains Contact information.
Report Category: JOBS
Job NameTitleDescription
U_MYQJOBS Your Jobs in the Queue List of jobs you have set up to run repeatly from banner forms
U_UNSUB Remove a job from the User Que unsubmit a job from the user queue
Report Category: ROOMS
Job NameTitleDescription
U_EVENTDAY Events Scheduled for One Day For a given day, gives events info sorted by building and room.
U_EVENTNUM Summary of Dates, Time & Loc Summary of the meetings info for a specified event.
U_EVENTTERM Events for a Term All Events scheduled within a term
U_EVENTWEEK Events Scheduled for a Week For a given week, gives events sorted by building and room.
U_FUTUREEVENTS Future Events Events that happen after the end of the semester.
U_ROOMDATE Scheduled Events & Classes For a given date range, print all scheduled events and classes.
U_ROOMDAY Room Schedule for One Day For a given day shows events and classes info sorted by building and room.
U_ROOMDIR Room Directory Directory of rooms that are active for a given term.
U_ROOMTERM Room Schedule for a Term Events and Classes info sorted by building and room.
U_ROOMWEEK Events & Classes for a Week Shows all scheduled events and classes sorted by building and room for a given week.
U_S25ROOMS Eligible Schedule-25 Rooms Rooms, descriptions, attributes and Schd-25 partitions.
U_TIMEPRIME Prime Time After Scheduling Runs timeprime & timeprimeall AFTER room scheduling is complete for the term.
U_TIMEPRIME_PRE_S25 Prime Time Before Schedule 25 runs timeprime_pre_s25 and timeprimeall_pre_s25 AFTER initial schedule build but Before Schedule-25.
Report Category: SECTIONS
Job NameTitleDescription
U_CANCELLED Cancelled or Inactive Sections Cancelled or Inactive Sections which have Meeting rooms or Enrollments.
U_COURSE_ENROLLMENTS Historical Course Enrollments Historical Census Course Enrollments by Academic Year
U_DELIVERY Alternate class delivery Class meeting delivery method for non face-to-face instruction (Synchronous/Asynchronous)
U_ENRL_OVERCAP Enrollments over room capacity Class section enrollments or limits exceeding room capacity
U_ENROLL1 Class Sections Enrollment Class sections enrollment report with college & dept select options. Includes EE concurrent students in enrollment counts.
U_ENROLL2 Class Sections Enrollment Class sections enrollment report. Same as enroll1 but with additional detail on student classification.
U_ENROLL3 Class Sections Enrollemnt Class sections enrollment report with college & dept select options. Includes EE concurrent students in enrollment counts. Same as enroll1 except shows credits and scus.
U_ENROLL_REVIEW Sect. Enrollment: Total&Census Class Sections Enrollment with Total and Census Figures
U_ENROLL_REVIEW_SMRY FTES Summary: Subj & College FTES Summary by Subject Area with College totals. Given in Gross and Census totals.
U_ENROLL_TOTALS Enrolled Sections with Summary Shows Enrollment and SCUs Summary which will be counted at census.
U_FIGSECTS FIG/TRIG sections FIG/TRIG sections grouped with companion non-FIG/TRIG sections for enrollment management
U_GRADEDIST Grade distribution Report Distribution of grades awarded by Course (Report and CSV data file provided)
U_HIGHFAIL High Failure Classes Classes which have high failure rates - Univ-wide comparisons and departmental versions
U_LOWENRL_CUSTOM Low Enrolled Sections - Custom Using custom enrollment criteria, list low enrollment sections for review
U_LOWENROLL Low Enrollment Class Sections Using CSU criteria, list low enrollment sections for review
U_MAXENR_CHECK Class Sects w/ High Enrollment 3 historical years of actual enrollments, show sections that are likely to be scheduled by Schd25 that have an enrollment limit significantly greater than prior enrollments.
U_MSFSECT Sections with MSF Class Sections with MSF
U_NOINSTRALL ALL Sect: No Instructor ALL Class Sections (except Seq=0) Without Primary Instructors.
U_NOINSTRENRL Enrolled Sect: No Instructors ENROLLED Class Sections (except Seq=0) Without Primary Instructors.
U_OFF_MODULE Class Meetings OFF Module Schedule-25 Class meetings not following modules in STVMEET
U_ROOM_SEARCH Search for underused rooms Find underutilized rooms according to section enrollment and room minimum room capacity needed
U_ROOMSWAP Find Potential Room Swaps Find Classes meeting same days, time intervals with sufficient capacity for CRN enrollment.
U_S25PROFILES Schedule-25 by Department List Schedule-25 Department profiles by College.
U_SCHD_BYDAYS Class Meeting by Day of Week List class section meeting days, times and locations for all active sections. Maximum and current enrollment figures are shown. Room capacity is also shown.
U_SCHDRES Current Schedule Restrictions Registration Restriction for all Class Sections showing Class, Level, Major, Campus and College Restrictions.
U_SECT_COMPARE Compare Section Offerings Term to term comparison of number of sections and seats offered. Also shows historical and current enrollments.
U_SECT_PTRM Enrollments by part-of-term Class enrollments, instructors, and meeting dates by part-of-term
U_SECTATTR Schd-25 sections w/ attributes Schd-25 Class Sections with Attributes.
U_SECTAUDITS Sections Audit Reports Various Section Audits for a given term
U_SECTAUDITS_CENSUS Section Audits - Census Section audits most critical to resolve at census
U_SECTDATA Class section CSV data file Class section data provided in a CSV file format for sorting, grouping, or other analysis
U_SECTENRL_DCG Enrollment for DCG sections Class enrollments for DCG sections
U_SECTENROLL Class Sections Enrollment Class enrollments showing max, enrolled, location, room cap. and FTES totals
U_SECTENROLL_FULL Class Enrollment Class enrollments including official census counts. Report output sent to requestor as PDF file.
U_SECTGE Compare 2 terms GE Offerings Compare number of sections and seats offered by GE course categories between two terms. 3 reports: sectge_todate, sectge_fig, sectge_mgmt
U_SECTIONS Complete Class Sections Report Complete class sections report with all details for given parameters.
U_SECTREVIEW Class Sections Review Review details of class sections, including instructors, locations and modes.
U_SECTS4DEPTS Class Section Report sections report in PDF format
U_SERV_LEARN Service Learning Classes Community Service Learning class sections
Report Category: STUDENT
Job NameTitleDescription
U_BULKMAIL Bulk email dataset generate CSV file of student email addresses for a particular major/department/subject
U_EOPDATA EOP data files generate CSV files for EOP
U_FAJOBCSV Finaid CSV file generate a data file of students from a financial aid population selection
U_FINDID Find Banner data find all Banner data associate with a student ID - used for duplicate ID resolution
U_ODD On Demand Data Generate a CSV file from the data warehouse about a partiuclar population
Report Category: STUDENTS
Job NameTitleDescription
U_X693 X693 enrollment generate a CSV file of students enrolled in EE graduate continuing enrollment unit
U_ADMITSBYMAJ All Admits for a Given Major file of active term-specific admits in specific majors - not for sending letter!
U_ADVISOR_AUDIT Advisor audit reports Reports of advisors who are inactive or in the wrong department
U_ADVISEE Advisee lists Email CSV files of advisees to departments and advisors
U_APP_STATS_BY_MAJOR Appliation Numbers Applications Numbers for a given term and given major.
U_APPROSNEWFRESH New Freshman Applicants Roster List of New Freshman Applicants with ethnic codes of 7,8,9 or D for a given term.
U_APROSTER Application Roster This job will create application rosters.
U_ATHAPPS Athletic Application Roster Students by Sport with level, gpa, sat, application status and decision date
U_ATHFUND Athletic Fund Raising Labels for athletic fund raising. Current term only.
U_ATHLETERATES Enrolled, Athleterates List of athletes with rates codes enrolled between two terms.
U_BIOATHLETES Biology Athletes Biology majors, attended at least two semesters, who are athletes in the given Academic Year.
U_CCRECEPT Creating Community Receptions Labels for Creating Community Reception.
U_CHEMLAB Chemistry Lab data file Email a tab-delimited datafile of chemistry lab students for this term.
U_CLASSROSTER1 Class Roster - Contact Class roster containing names, addresses and phone numbers of students enrolled in particular course
U_CRNLABELS Labels By CRN and Term generates labels for a given CRN and Term
U_ENMA English Masters rosters Generate CSV files of English Masters student enrollment
U_ENROLLED Enrolled Students generate a CSV file of enrolled student names for a particular term
U_EOPFOLLOWUP EOP Outreach Follow-up Report List of applicants from specific counties with EOP codes.
U_ETHPROSPECTS Ethnic Prospects email a CSV data file of information about ethnic prospects
U_FOREIGN Foreign Student Data internal Generate CSV file of data related to reg-eligible foreign students
U_GEOGHONORS Geography Class GPA List of students and GPA by Class for Gamma Theta Upsilon and William L. Squire Scholarship.
U_GRAD_EQTY_FELLOWSHIP Graduate Equity Fellowship generates CSV files of masters students and apps who are ethnic or women in majors with more men
U_GRADSTULIST Grads List and Labels List and labels of current grad students with ssn and address.
U_GWPTBAD GWPT Scores List of student GWPT scores between two given dates.
U_HOOPENROL Enrollment status of HOOP Enrollment status for HOOP participants
U_HUMB_WK_CARDS Humboldt Weekend Postcards ENR Labels for Humboldt Weekend Postcards. Parent address for enrolled students.
U_INSTEQT_TITLE3 Title 3 & 5 Eligibility Counts for Instutional Equity for TitleIII and TitleIV Application Status
U_LEADERSHIP_MINORS Leadership Minors Students with possible minor in Leadership and Students who recieive a minor in Leadership.
U_LOW_UNITS_SPRT Athletes w/ less than 12 Units Student-Athletes that drop below the 12 unit mark.
U_MAJ_ORIG_ENR Major, Origin Count for Enroll Counts of enrolled students for a given department by major, origin and lev between given terms.
U_MAJADMITS New admits for a major Return a data file of new admits for the major given since the last time run; used for sending a letter.
U_MBAPROBATION MBA Students on Probation List of MBA students on Academic Probation
U_IPEDS-GRS NCAA IPEDS-GRS report generate enrollment and graduation reports needed for IPEDS-GRS and NCAA reporting
U_NCAA NCAA Reporting Data generates and emails a report that can be used to enter NCAA grad rates and enrollment data
U_NCAAETHNIC NCAA Ethnicity By Sport Title 9 NCAA Ethnicity Count By Sport
U_NCAARPT List for NCAA Report List of Students with SSN and sport. Having been in 2 or more sports in an academic year.
U_NS_SURVEY NS Student/Degree Survey data Produce files for College of NS surveys
U_OVER60 Over 60 program participants generate a CSV file of Over60 program students
U_PARENT_NEWS Labels for Parent Newsletter Labels of admitted hop students or enrolled students 23 and under for a given term.
U_PHIKAPP Phi Kappa Phi Students eligible to participate in Phi Kappa Phi
U_POWWOWGRADLIST Pow Wow List List of prospective graduates for a given Academic Year, with ethnic code of 1.
U_PROBATION data on probation students stucomm data for all students not in good academic standing
U_PROS_BY_ZIP Prospects in Zip Range Prospects for a given HSU College, zip code range and given term. Option for Admits or Inquiries.
U_RDGRADES RD grade report List of outstanding RD grades.
U_REG-EXTEND Students in EE Lev Courses List of students in EE level courses. File sent as txt attachment.
U_SFFEEWAIVE Staff Faculty Fee Waiver Reg Generate data file of registration activity by staff, faculty, and dependent fee waiver students
U_SPORTGPA Team GPAs Athletic team GPAs
U_STU_BY_ACTCODE Students by Activity Code List of students for a given term and a given activity code
U_STUBYMAJ Currently Enrolled Stus By Maj List of students currently enrolled in a given major grouping. Choice of Primary with GPA or Primary and Secondary roster.
U_STUBYMINOR Students Designated With Minor Students designated with a minor for a given minor code and term.
U_VISITS Visits to Campus Reports on Campus Visits by recruits and their interests.
U_XISIGMACLUB List for Forestry xi sigma List of Forestry students for the xi sigma club.

-

Other Processes


Last updated on: 23-NOV-09