Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

 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
maxLevel3

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

Hnr Cde

Registrars Reports - Graduation Status

Cert Lvl

Registrars Reports - Graduation Status

CL CD

Registrars Reports - Graduation Status

Registrars Reports - Graduation Status

Registrars Reports - Graduation Status

Conc1

Registrars Reports - Graduation Status

Mnr 1

Mnr 2

Registrars Reports - Graduation Status

 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

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

Hnr Cde

Registrars Reports - Graduation Status

Cert Lvl

Registrars Reports - Graduation Status

Registrars Reports - Graduation Status

Registrars Reports - Graduation StatusTerm

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


 

Anchor
Report Elements Glossary
Report Elements Glossary

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

 

CampusCampusshrdgmrshrdgmr_camp_code and

stvcamp-> stvcamp_desc

College Degree Status Degree Level GPA Term Cohort Student Name Student ID Address City-State-Zip Degree Code Degree Date SEQ No Honor Code Tchr Y/N  >swrtchrCode Cert Area  >shrdgmrMajor Code 1 Major Code 1>shrdgmrmajr_1 Major 1. First major associated with the degree.Major Code 2 Major Code 2shrdgmr>shrdgmrmajr_1_2 Major 2 Secondary. Second major for the secondary curriculum associated with the degree. USF COMMENTS - Degree Major Code 2. Second Major associated with the degree.F Conc 1

Banner->shrdgmr->shrdgmr_majr_code_conc_1

shrdgmr->shrdgmr_majr_code_conc_1_2

conc__3 Concentration First concentration the Conc

Degree Concentration Code 2. Second concentration associated with the degree.

Degree Concentration Code 3. Third concentration associated with the degree.

Conc Conc conc_121

shrdgmr->shrdgmr_majr_code_conc_2_122

shrdgmr->shrdgmr_majr_code_conc_123

 shrdgmr_majr_code_minr_1_2 

Degree Minor Code 2. Second minor associated with the degree.

>  shrdgmr 1 Secondary First for the secondary curriculum USF COMMENTS - Degree minor Code 3. Third minor associated with the degree.IM Grades  
Element

Source

(System->Table->COLUMN)

DescriptionFrequency of Update

Address

Anchor

Campus

Address
Address

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.

 
Anchor
CollegeCollege

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. 
Anchor
Degree StatusDegree StatusBanner-> shrdgmr->shrdgmr_degs_codeDegree Status Code. Status of students degree, for example sought, awarded, etc. 
Anchor
Degree LevelDegree LevelBanner->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 
Anchor
GPAGPABanner-> shrlgpa->shrlgpa_gpaGPA for the level. Calculated by dividing GPA hours for the level into Quality points for the level. 
Anchor
TermTermBanner-> shrdgmr->shrdgmr_term_code_gradTerm in which the student graduates. 
Anchor
CohortCohortBanner-> sgrchrt->sgrchrt_chrt_codeCohort Code. 
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) 
Anchor
Student IDStudent IDBanner-> dpriden->spriden_idThis field defines the identification number used to access person on-line. 
Anchor
AddressAddress

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 
Anchor
City-State-ZipCity-State-Zip

Banner->  spraddr-> spraddr_city || spraddr_stat_code || spraddr_zip and

shbdipl_city || shbdipl_stat_code || shbdipl_zip

City/State/Zip of student 
Anchor
Degree CodeDegree CodeBanner-> shrdgmr-> shrdgmr_degc_codeDegree Code. Students degree code (BS, BA, etc.). 
Anchor
Degree DateDegree DateBanner-> shrdgmr->shrdgmr_grad_date  Graduation Date. Graduation date of student. 
Anchor
SEQ NoSEQ NoBanner-> shrdgmr->shrdgmr_seq_noDegree Sequence Number. Number assigned to each degree student has. 
Anchor
Honor CodeHonor CodeBanner-> shrdgih->shrdgih_honr_codeInstitutional Honor Code. Institutional honor for a student.Values include C,D, M and S 
Anchor
Tchr Y/NTchr Y/NBanner->  swrtchr->swrtchr_tcct_codeCode corresponding to type of certification

spraddr_city || spraddr_stat_code || spraddr_zip and

shbdipl_city || shbdipl_stat_code || shbdipl_zip

Address of student.Real Time

C1_Maj_1

Anchor
C1_Maj_1
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

Anchor
C1_Maj_2
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

Anchor
C1_M1_Conc1
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

Anchor
C1_M1_Conc2
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

Anchor
C1_M1_Conc3
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

Anchor
C1_M1_Mnr1
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

Anchor
C1_M1_Mnr2
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

Anchor
C1_M2_Conc1
C1_M2_Conc1

Banner-> shrdgmr->

shrdgmr_majr_code_conc_121

Concentration Code 1 on Major 2, Curriculum 1 Code.Real Time
C1_M2_Conc2
Anchor
C1_M2_Conc2
C1_M2_Conc2

Banner-> shrdgmr->

shrdgmr_majr_code_conc_122

Concentration Code 2 on Major 2, Curriculum 1.Real Time
C1_M2_Conc3
Anchor
C1_M2_Conc3
C1_M2_Conc3

Banner-> shrdgmr->

shrdgmr_majr_code_conc_123

Concentration Code 3 on Major 2, Curriculum 1.Real Time
C1_M2_Mnr1
Anchor
C1_M2_Mnr1
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

Anchor
C2_Maj_3
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

Anchor
C2_M3_Conc1
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
Anchor
C2_M3_Conc2
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
Anchor
C2_M3_Conc3
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
Anchor
C2_M3_Mnr1
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

Anchor
Campus
Campus

Banner->shrdgmr->shrdgmr_camp_code and

stvcamp-> stvcamp_desc

Degree Campus Code. Campus offering the degree.

Real Time

Cert Area

Anchor
Cert Area
Cert Area

Banner-> swrtchr->swrtchr_tcac_codeThe code corresponding to the area in which student is certifiedReal Time

Cert Level

Anchor
Cert Level
Cert Level

Banner-> swrtchr-
>swrtchr_tclc_code
The code for the level in which the student has been certified
 
Anchor
Cert AreaCert AreaBanner-> swrtchr->swrtchr_tcac_codeCode corresponding to the area student is certified
.Real Time

CL CD

Anchor
CL CD
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

Anchor
Cohort
Cohort

Banner-> sgrchrt->sgrchrt_chrt_codeThe student's Cohort Code.Real Time

College

Anchor
College
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

Anchor
College 1
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

Anchor
College 2
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

Anchor
Conc 1
Conc 1

Banner->shrdgmr->shrdgmr_majr_code_conc_1

 

Degree Concentration Code 1. First concentration associated with the degree.

Real Time
Conc 2
Anchor
Conc 2
Conc 2

Banner-> shrdgmr->shrdgmr_majr_code_conc_121

 

Concentration Code 1 on Major 2, Curriculum 1 Code.

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

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, and G are based on logic combining the two source column values.Real Time

Degree Level Group

Anchor
Degree Level Group
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

Anchor

Major Code 1

Degree Status
Degree Status

Banner-> shrdgmr-
>shrdgmr_
degs_code
Degree
Status Code
 
Anchor
Major Code 2
. This is the status of student's degree, such as sought or awarded.Real Time

F

Anchor
F
F

Banner->
shrdmgr-
>shrdgmr_
degs_code
Degree
Status Code
 
Anchor
FFBanner-> shrdmgr->shrdgmr_degs_codeDegree Status Code. Status of students degree, for example sought, awarded, etc. 
Anchor
Conc 1Conc 1
. Status of the student's degree, e.g., sought or awarded.Real Time

GPA

Anchor
GPA
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

Anchor
Honor Code
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

Anchor
IM Grades
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

Anchor
Major Code 1
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
Anchor
Major Code 2
Major Code 2
Banner-> shrdgmr->shrdgmr_majr_code_

Concentration Code 1 on Major 2, Curriculum 1 Code

Concentration Code 2 on Major 2, Curriculum 1

 Concentration Code 3 on Major 2, Curriculum 1

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
Anchor
Minor 1
Minor 1

Banner-> shrdgmr->  shrdgmr_majr_code_minr_1

 

Degree Minor Code 1. First minor associated with the degree.

 

Real Time
Minor 2
Anchor
Minor 2
Minor 2

Banner-> shrdgmr-

> shrdgmr_majr_code_minr_1_2

Degree Minor Code
2.
Second minor
associated with the degree.
 
Anchor
IM GradesIM GradesBanner function wf_has_im_grades_db(shrdgmr_pidm)Displays 'Missing or Incomplete Grades* if function returns 'Y'
Real Time

Report Run Date

Anchor
Report Run Date
Report Run Date


Date and time that the report data was refreshed from source.Real Time

SEQ No

Anchor
SEQ No
SEQ No

Banner-> shrdgmr->shrdgmr_seq_noDegree Sequence Number. The number assigned to each degree the student has.Real Time

Student ID

Anchor
Student ID
Student ID

Banner-> dpriden->spriden_idThe student's university identification number. Real Time
Student Name
Anchor
Student Name
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

Anchor
Tchr Y/N
Tchr Y/N

Banner->  swrtchr->swrtchr_tcct_codeThe code corresponding to the type of certification.Real Time

Term

Anchor
Term
Term

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

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

...