Registrars reports Registrar's Reports
The registrar's reports display graduation status information of students from Banner tables for USF students. The data pull directly from Banner tables and show results in real time.
| Table of Contents | ||
|---|---|---|
|
Report Elements Glossary Table
...
Report : RO Graduation Status Report |
|---|
The RO Graduation Status Report is a listing of students who have applied for graduation with the Office of the Registrar and displays the student's expected degree date in the table. Additional details in the table include student name, address, degree code, major, and GPA.
Tab 1: Graduation Status Report
Filters
Registrars Reports - Graduation Status
Registrars Reports - Graduation Status
Registrars Reports - Graduation Status
Registrars Reports - Graduation Status
Registrars Reports - Graduation Status
Registrars Reports - Graduation Status
Registrars Reports - Graduation Status
Registrars Reports - Graduation Status
Report Elements
Registrars Reports - Graduation Status
Registrars Reports - Graduation Status
Registrars Reports - Graduation Status
Registrars Reports - Graduation Status
Registrars Reports - Graduation Status
Registrars Reports - Graduation Status
Registrars Reports - Graduation Status
CL CD
Registrars Reports - Graduation Status
Registrars Reports - Graduation Status
Registrars Reports - Graduation Status
Registrars Reports - Graduation Status
Registrars Reports - Graduation Status
Report Elements
...
Report : RO Graduation Status Listing by Minor |
|---|
...
The RO Graduation Status Listing by Minor is a table showing students who have applied for graduation with the Office of the Registrar and have at least one minor. Additional details in the table include student name, address, degree code, major, minor, concentrations, and GPA.
Tab 1: Graduation Status Listing by Minor
Filters
Registrars Reports - Graduation Status
Registrars Reports - Graduation Status
Registrars Reports - Graduation Status
Registrars Reports - Graduation Status
Registrars Reports - Graduation Status
Registrars Reports - Graduation Status
Registrars Reports - Graduation Status
Report Elements
Registrars Reports - Graduation Status
Registrars Reports - Graduation Status
Registrars Reports - Graduation Status
Registrars Reports - Graduation Status
Registrars Reports - Graduation Status
Registrars Reports - Graduation Status
Registrars Reports - Graduation Status
Registrars Reports - Graduation Status
Registrars Reports - Graduation Status
Registrars Reports - Graduation Status
Registrars Reports - Graduation StatusTerm
Report Elements
| Anchor | ||||
|---|---|---|---|---|
|
The table below lists all the elements used in the Reports.
| Element | Source (System->Table->COLUMN) | Description | Frequency of Update | ||||||
|---|---|---|---|---|---|---|---|---|---|
Address
| Campus | Campus||||||||
| Banner-> shbdipl-shbdipl_street1 || shbdipl_street2 or spraddr->spraddr_street_line1 || spraddr_street_line2 concatenated with Banner-> | ||||||||
spraddr-> | Degree Campus Code. Campus offering the degree. | College | |||||||
| Anchor | College | College | Banner->shrdgmr-> shrdgmr_coll_code_1 and stvcoll->stvcoll_desc | Degree Status | |||||
| Anchor | Degree Status | Degree Status | Banner-> shrdgmr_degs_code | Degree Level | |||||
| Anchor | Degree Level | Degree Level | Banner->shrdgmr->shrdgmr_levl_code and AND stvdegc->stvdegc_acat_code | Values of A,B,C,D,E, F based on logic combining the two source column values | GPA | ||||
| Anchor | GPA | GPA | Banner-> shrlgpa->shrlgpa_gpa | GPA for the level. Calculated by dividing GPA hours for the level into Quality points for the level. | Term | ||||
| Anchor | Term | Term | Banner-> shrdgmr_term_code_grad | Cohort | |||||
| Anchor | Cohort | Cohort | Banner-> sgrchrt->sgrchrt_chrt_code | Student Name | |||||
| Anchor | Student Name | Student Name | Banner-> shbdipl->shbdipl_name and Banner-> spriden->spriden_last_name || spriden_first_name || spriden_mi | Student full Name ( based on logic combining the two source column values) | Student ID | ||||
| Anchor | Student ID | Student ID | Banner-> spriden_id student_id | This field defines the identification number used to access person on-line. | Address | ||||
| Anchor | Address | Address | Banner-> shbdipl-shbdipl_street1 || shbdipl_street2 or spraddr->spraddr_street_line1 || spraddr_street_line2 concatenated with Banner-> spraddr-> spraddr_city || spraddr_stat_code || spraddr_zip and shbdipl_city || shbdipl_stat_code || shbdipl_zip | Address of student | City-State-Zip | ||||
| Anchor | City-State-Zip | City-State-Zip | Banner-> spraddr-> spraddr_city || spraddr_stat_code || spraddr_zip and shbdipl_city || shbdipl_stat_code || shbdipl_zip | City/State/Zip of student | Degree Code | ||||
| Anchor | Degree Code | Degree Code | Banner-> shrdgmr-> shrdgmr_degc_code | Degree Code. Students degree code (BS, BA, etc.). | Degree Date | ||||
| Anchor | Degree Date | Degree Date | Banner-> shrdgmr->shrdgmr_grad_date | Graduation Date. Graduation date of student. | SEQ No | ||||
| Anchor | SEQ No | SEQ No | Banner-> shrdgmr->shrdgmr_seq_no | Degree Sequence Number. Number assigned to each degree student has. | Honor Code | ||||
| Anchor | Honor Code | Honor Code | Banner-> shrdgih->shrdgih_honr_code | Tchr Y/N | |||||
| Anchor | Tchr Y/N | Tchr Y/N | Banner-> swrtchr->swrtchr_tcct_code | ||||||
spraddr_city || spraddr_stat_code || spraddr_zip and shbdipl_city || shbdipl_stat_code || shbdipl_zip | Address of student. | Real Time | |||||||
C1_Maj_1
| Banner-> shrdgmr-> shrdgmr_majr_code_1 | Degree Major Code 1. Student's first major associated with his or her degree. | Real Time | ||||||
C1_Maj_2
| Banner-> shrdgmr-> shrdgmr_majr_code_1_2 | Degree Major Code 2 Secondary. Second major for the secondary curriculum associated with the degree. USF COMMENTS - Degree Major Code 2. Second Major associated with the degree. | Real Time | ||||||
C1_M1_Conc1
| Banner-> shrdgmr-> shrdgmr_majr_code_conc_1 | Degree Concentration Code 1. First concentration associated with the degree.
| Real Time | ||||||
C1_M1_Conc2
| Banner-> shrdgmr-> shrdgmr_majr_code_conc_1_2 | Degree Concentration Code 2. Second concentration associated with the degree.
| Real Time | ||||||
C1_M1_Conc3
| Banner-> shrdgmr-> shrdgmr_majr_code_conc_1_3 | Degree Concentration Code 3. Third concentration associated with the degree. | Real Time | ||||||
C1_M1_Mnr1
| Banner-> shrdgmr-> shrdgmr_majr_code_minr_1 | Degree Minor Code 1. First minor associated with the degree. | Real Time | ||||||
C1_M1_Mnr2
| Banner-> shrdgmr-> shrdgmr_majr_code_minr_1_2 | Degree Minor Code 2. Second minor associated with the degree. | Real Time | ||||||
C1_M2_Conc1
| Banner-> shrdgmr-> shrdgmr_majr_code_conc_121 | Concentration Code 1 on Major 2, Curriculum 1 Code. | Real Time | ||||||
C1_M2_Conc2
| Banner-> shrdgmr-> shrdgmr_majr_code_conc_122 | Concentration Code 2 on Major 2, Curriculum 1. | Real Time | ||||||
C1_M2_Conc3
| Banner-> shrdgmr-> shrdgmr_majr_code_conc_123 | Concentration Code 3 on Major 2, Curriculum 1. | Real Time | ||||||
C1_M2_Mnr1
| Banner-> shrdgmr-> shrdgmr_majr_code_minr_2 | Degree Minor Code 1 Secondary. First minor for the secondary curriculum associated with the degree. USF COMMENTS - Degree minor Code 3. Third minor associated with the degree. | Real Time | ||||||
C2_Maj_3
| Banner-> shrdgmr-> shrdgmr_majr_code_2 | Degree Major Code 1 Secondary. First major for the secondary curriculum associated with the degree. USF COMMENTS - Degree Major Code 3. Third major associated with the degree. | Real Time | ||||||
C2_M3_Conc1
| Banner-> shrdgmr-> shrdgmr_majr_code_conc_2 | Degree Concentration Code 1 Secondary. First concentration for the secondary curriculum associated with the degree. | Real Time | ||||||
C2_M3_Conc2
| Banner-> shrdgmr-> shrdgmr_majr_code_conc_2_2 | Degree Concentration Code 2 Secondary. Second concentration for the secondary curriculum associated with the degree. | Real Time | ||||||
C2_M3_Conc3
| Banner-> shrdgmr-> shrdgmr_majr_code_conc_2_3 | Degree Concentration Code 3 Secondary. Third concentration for the secondary curriculum associated with the degree. | Real Time | ||||||
C2_M3_Mnr1
| Banner-> shrdgmr-> shrdgmr_majr_code_minr_2 | Degree Minor Code 1 Secondary. First minor for the secondary curriculum associated with the degree. USF COMMENTS - Degree minor Code 3. Third minor associated with the degree. | Real Time | ||||||
Campus
| Banner->shrdgmr->shrdgmr_camp_code and stvcamp-> stvcamp_desc | Degree Campus Code. Campus offering the degree. | Real Time | ||||||
Cert Area
| Banner-> swrtchr->swrtchr_tcac_code | The code corresponding to the area in which student is certified | Real Time | ||||||
Cert Level
| Banner-> swrtchr- | ||||||||
| >swrtchr_tclc_code | Cert Area | ||||||||
| The code for the level in which the student has been certified. | Real Time | ||||||||
CL CD
| Cert Area | ||||||||
| Banner-> | College 1 | |||||||
| shrdgm->shrdgmr_coll_code_1 | Degree College Code 1. College offering the degree. USF COMMENTS - Specifies the college of first and second majors. | Real Time | |||||||
Cohort
| Banner-> sgrchrt->sgrchrt_chrt_code | The student's Cohort Code. | Real Time | ||||||
College
| |||||||||
| |||||||||
Banner- | |||||||||
>shrdgmr-> shrdgmr_coll_code_1 and stvcoll->stvcoll_desc | Degree College Code 1. College offering the degree. USF COMMENTS - Specifies the college of first and second majors. | ||||||||
| Real Time | |||||||||
College 1
| Degree Level Group | ||||||||
| Banner-> | ||||||||
| shrdgm- | |||||||||
| >shrdgmr_ | |||||||||
| coll_code_1 | Degree College Code 1. College offering the degree. USF COMMENTS - Specifies the college of first and second majors. | Real Time | |||||||
College 2
| Banner-> shrdgmr- | ||||||||
> shrdgmr_ | |||||||||
coll_code | Major Code | ||||||||
_2 | Degree College Code Secondary. Secondary college offering the degree. USF COMMENTS - Specifies the college of third major. | Real Time | |||||||
Conc 1
| |||||||||
| |||||||||
| Banner- | ||||||||
>shrdgmr- | |||||||||
>shrdgmr_majr_code_conc_1
| Degree | ||||||||
Concentration Code 1. First | |||||||||
concentration associated with the degree. | |||||||||
| Real Time | |||||||||
Conc 2
| |||||||||
| |||||||||
| Banner-> shrdgmr- | ||||||||
>shrdgmr_majr_code_conc_121
| Concentration Code 1 | F | |||||||
| Anchor | F | F||||||||
on Major 2, Curriculum 1 Code. | Real Time | ||||||||
Degree Code
| Banner-> shrdgmr-> shrdgmr_degc_code | The student's degree code, such as BS or BA. | Real Time | ||||||
Degree Date
| Banner-> | ||||||||
| shrdgmr->shrdgmr_ | |||||||||
| grad_ | Conc 1 | ||||||||
| date | The graduation date of student. | Real Time | |||||||
Degree Level
| Conc 1 | ||||||||
| Banner->shrdgmr->shrdgmr_ | ||||||||
| levl_code and AND stvdegc->stvdegc_acat_code | Values of A,B,C,D,E, and G are based on logic combining the two source column values. | Real Time | |||||||
Degree Level Group
| Banner-> stvdegc->stvdegc_acat_code and shrdgmr->shrdgmr_ | ||||||||
levl_code | Values of A,B,C,D,E, and F based on logic combining the two source column values. | Real Time | |||||||
Degree Status
| Banner-> shrdgmr->shrdgmr_ | Conc 2 | |||||||
| Anchor | Conc 2 | Conc 2 | |||||||
| degs_code | Degree Status Code. This is the status of student's degree, such as sought or awarded. | Real Time | |||||||
F
| Banner-> shrdmgr->shrdgmr_degs_code | Degree Status Code. Status of the student's degree, e.g., sought or awarded. | Real Time | ||||||
GPA
| Banner-> shrlgpa->shrlgpa_gpa | GPA for the level. This value is calculated by dividing GPA hours for the level into quality points for the level. | Real Time | ||||||
Honor Code
| Banner-> shrdgih->shrdgih_honr_code | Institutional Honor Code. Institutional honor for a student. Values include C, D, M, and S. | Real Time | ||||||
IM Grades
| Banner function wf_has_im_grades_db(shrdgmr_pidm) | Displays "Missing or Incomplete Grades" if function returns "Y". | Real Time | ||||||
Major Code 1
| Banner-> shrdgmr->shrdgmr_majr_code_ | ||||||||
| 1 | Degree Major Code 1. Student's first major associated with his or her degree. | Real Time | |||||||
Major Code 2
| Banner-> shrdgmr->shrdgmr_majr_code_ | ||||||||
| 1_ | |||||||||
| 2 | Degree Major Code 2. Student's second major for the secondary curriculum associated with the degree. USF COMMENTS - Degree Major Code 2. Second Major associated with the degree. | Real Time | |||||||
Minor 1
| Banner-> shrdgmr-> shrdgmr_majr_code_minr_1 | ||||||||
| Degree Minor Code 1. First minor associated with the degree.
| ||||||||
| Real Time | |||||||||
Minor 2
| Banner-> shrdgmr- | ||||||||
> shrdgmr_majr_code_minr_1_2 | IM Grades | ||||||||
| Anchor | IM Grades | IM Grades | Banner function wf_has_im_grades_db(shrdgmr_pidm) | Displays 'Missing or Incomplete Grades* if function returns 'Y'||||||
| Degree Minor Code 2. Second minor associated with the degree. | Real Time | ||||||||
Report Run Date | Date and time that the report data was refreshed from source. | Real Time | |||||||
SEQ No
| Banner-> shrdgmr->shrdgmr_seq_no | Degree Sequence Number. The number assigned to each degree the student has. | Real Time | ||||||
Student ID
| Banner-> dpriden->spriden_id | The student's university identification number. | Real Time | ||||||
Student Name
| Banner-> shbdipl->shbdipl_name and Banner-> spriden->spriden_last_name || spriden_first_name || spriden_mi | Student's full name (based on logic combining the student's first, last, and middle names) | Real Time | ||||||
Tchr Y/N
| Banner-> swrtchr->swrtchr_tcct_code | The code corresponding to the type of certification. | Real Time | ||||||
Term
| Banner-> shrdgmr->shrdgmr_term_code_grad | The term in which the student graduates. | Real Time |
...