Registrar's Reports - Graduation Status

 Registrar's Reports

 The registrar's reports display graduation status information for USF students. The data pull directly from Banner tables and show results in real time.

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 

Term

Cohort

Campus

College

Degree Status

Degree Level

GPA

Degree Level Group

Report Elements

Student Name

Student ID

Address

Degree Code

Degree Date

SEQ NO 

HONOR CODE

TCHR Y/N

CERT LVL

CERT AREA

CL CD

MAJR CODE 1

MAJR CODE 2

F

CONC 1

CONC 2

MINR 1

MINR 2

IM GRADES

Report Run Date


 

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 

Term

Cohort

Campus

College

Degree Status Code

Degree Level Code

GPA

Report Elements

Student Name

Student ID

Address

Degree Code

Degree Date

Seq no

Hnr Cde

TCHR Y/N

Cert Lvl

Cert Area

IM Grades

College 1

C1_Maj_1 

C1_M1_Conc1

C1_M1_Conc2 

C1_M1_Conc3

C1_M1_Mnr1 

C1_M1_Mnr2

C1_Maj_2 

C1_M2_Conc1 

C1_M2_Conc2

C1_M2_Conc3 

C1_M2_Mnr1

College 2 

C2_Maj_3

C2_M3_Conc1 

C2_M3_Conc2

Report Run Date


 

The table below lists all the elements used in the Reports.

 

Element

Source

(System->Table->COLUMN)

DescriptionFrequency of Update

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.Real Time

C1_Maj_1

Banner-> shrdgmr-> shrdgmr_majr_code_1Degree 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_codeThe code corresponding to the area in which student is certifiedReal Time

Cert Level

Banner-> swrtchr->swrtchr_tclc_codeThe code for the level in which the student has been certified.Real Time

CL CD

Banner-> shrdgm->shrdgmr_coll_code_1Degree College Code 1. College offering the degree. USF COMMENTS - Specifies the college of first and second majors.Real Time

Cohort

Banner-> sgrchrt->sgrchrt_chrt_codeThe 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

Banner-> shrdgm->shrdgmr_coll_code_1Degree 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_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 on Major 2, Curriculum 1 Code.

Real Time
Degree Code Banner-> shrdgmr-> shrdgmr_degc_codeThe student's degree code, such as BS or BA.Real Time
Degree Date Banner-> shrdgmr->shrdgmr_grad_date  The graduation date of student.Real Time

Degree Level

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_degs_codeDegree Status Code. This is the status of student's degree, such as sought or awarded.Real Time

F

Banner-> shrdmgr->shrdgmr_degs_codeDegree Status Code. Status of the student's degree, e.g., sought or awarded.Real Time

GPA

Banner-> shrlgpa->shrlgpa_gpaGPA 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_codeInstitutional 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_1Degree Major Code 1. Student's first major associated with his or her degree.Real Time
Major Code 2 Banner-> shrdgmr->shrdgmr_majr_code_1_2Degree 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

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_noDegree Sequence Number. The number assigned to each degree the student has.Real Time

Student ID

Banner-> dpriden->spriden_idThe 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_codeThe code corresponding to the type of certification.Real Time

Term

Banner-> shrdgmr->shrdgmr_term_code_gradThe term in which the student graduates.Real Time