Versions Compared

Key

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

 Registrar's Reports

...

Degree Level

GPA

Degree Level Group

Report Elements

Student Name

Student ID

Address

...

TCHR Y/N

CERT LVL

CERT AREA

CL CD

MAJR CODE 1

MAJR CODE 2

F

CONC 1

...

Degree Status Code

Degree Level Code

GPA

Report Elements

Student Name

Student ID

Address

...

CampusCampusshrdgmrshrdgmr_camp_code and

stvcamp-> stvcamp_desc

Degree Campus Code. Campus offering the College College>shrdgmrcoll andstvcoll->stvcolldesc College 1. College offering Specifies the college of first and second majorsDegree Status Degree Status>shrdgmrdegs Status . Status of students degree, for example sought, awarded, etc.Degree Level Degree Level>shrdgmr_levl_code and

AND stvdegc->stvdegc_acat_code

GPA Term TermshrdgmrtermgradTerm in which the student graduates TimeCohort Cohort sgrchrtsgrchrtchrtCohort CodeStudent Name Student Name shbdipl->shbdipl_name andspridenspridenlast_name || spriden_first_name || spriden_miStudent ID Address Degree Code Degree Code shrdgmrdegc. Students degree code (BS, BA, etc.)Degree Date Degree Date_grad_date  Graduation Date. Graduation date of studentSEQ No SEQ No>shrdgmr_seq_noDegree Sequence Number. Number assigned to each degree student hasHonor Code Honor CodeshrdgihshrdgihhonrTchr Y/N Code corresponding to type of certification Level Level Level>swrtchrtclcCode for level the student has been Area Area Area>swrtchrtcacCode corresponding to the area student is certified>shrdgmr.College 1 1 1> shrdgmDegree Level Group Major Code Major Code Major Code shrdgmr>shrdgmrmajr Major First major associated with the degreeMajor Code Major Code Major Code majr1_ Major 2 Second major for the secondary curriculum associated with the Degree Major Code 2. Second Major associated with the degree.F Degree Status Code. Status of students degree, for example sought, awarded, etcMinor 1 Minor 1>  shrdgmrmajr_minr_1

 

Minor 2 Minor 2> shrdgmrmajr_code_minr_1_2Degree Minor Code 2. Second minor associated with the degree.IM Grades C1_Maj_1 C1_M1_Conc1 C1_M1_Conc2 C1_M1_Conc3 C1_M1_Mnr1 C1_M1_Mnr2 C1_Maj_2

Banner-> shrdgmr->

shrdgmr Secondary Second C1_M2_Conc1 C1_M2_Conc1shrdgmrconc_121C1_M2_Conc2 C1_M2_Conc3 C1_M2_Conc3>shrdgmrconc_123C1_M2_Mnr1

Banner-> shrdgmr->

shrdgmr_majr_code_minr_ 1 Secondary. First minor for the secondary curriculum associated with the degree. USF COMMENTS - Degree minor Code 3. Third College 2 Degree college code Secondary. Secondary college offering the degree. USF COMMENTS - Specifies the college of third majorC2_Maj_3 C2_Maj_3>shrdgmrmajrcode_2 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 degreeC2_M3_Conc1 C2_M3_Conc1shrdgmr>

shrdgmr_majr_code_conc_2

Degree Concentration Code 1 Secondary. First concentration for the secondary curriculum associated with the degreeC2_M3_Conc2 C2_M3_Conc2shrdgmrshrdgmrmajr_code_conc_2_2C2_M3_Conc3 C2_M3_Mnr1 C2_M3_Mnr1>shrdgmrmajrminr_2Report Run Date Date that the report data was refreshed from source
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->

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

College

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

Degree Status

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

Degree Level

C1_M1_Conc2
C1_M1_Conc2

Banner-> shrdgmr-

Values of A,B,C,D,E, F based on logic combining the two source column valuesReal Time
Anchor
GPAGPABanner-> shrlgpa->shrlgpa_gpaGPA for the level. Calculated by dividing GPA hours for the level into Quality points for the level.Real Time
Anchor
Term

 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

Cohort

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

Student Name

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_

Student full Name ( based on logic combining the two source column values)Real Time
Anchor
Student IDStudent IDBanner-> dpriden->spriden_idThis field defines the identification number used to access person on-line.Real Time
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 studentReal Time
Anchor
Degree Code

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
Degree Date
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
SEQ No
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
Honor Code
C2_M3_Mnr1
C2_M3_Mnr1

Banner->

shrdgmr->

shrdgmr_

majr_code

Institutional Honor Code. Institutional honor for a student.Values include C,D, M and SReal Time
Anchor
Tchr Y/NTchr Y/NBanner->  swrtchr->swrtchr_tcct_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_code
The 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.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
Anchor
Degree Level GroupDegree Level Group

Banner-> stvdegc->stvdegc_acat_code and

shrdgmr->shrdgmr_levl_code

Values of A,B,C,D,E, F based on logic combining the two source column valuesReal 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 -
Real Time
Anchor
FFBanner-> shrdmgr->shrdgmr_degs_code
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
Minor 1
Degree Code
Degree Code
Banner-> shrdgmr-
> shrdgmr_
degc_code

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

 

Real Time
Anchor
Minor 2
The 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

IM GradesIM GradesBanner function wf_has_im_grades_db(shrdgmr_pidm)Displays 'Missing or Incomplete Grades* if function returns 'Y'Real Time
Anchor
C1_Maj_1C1_Maj_1Banner-> shrdgmr-> shrdgmr_majr_code_1 Real Time
Anchor
C1_M1_Conc1C1_M1_Conc1

Banner-> shrdgmr->

  shrdgmr_majr_code_conc_1

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

 

Real Time
Anchor
C1_M1_Conc2C1_M1_Conc2

Banner-> shrdgmr-> 

 shrdgmr_majr_code_conc_1_2

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

 

Real Time
Anchor
C1_M1_Conc3C1_M1_Conc3

Banner-> shrdgmr->

  shrdgmr_majr_code_conc_1_3

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

Real Time
Anchor
C1_M1_Mnr1C1_M1_Mnr1

Banner-> shrdgmr->

 shrdgmr_majr_code_minr_1

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

Banner-> shrdgmr->

 shrdgmr_majr_code_minr_1_2

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

Real Time
Anchor
C1_Maj_2C1_Maj_2

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
Degree Status
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

Anchor
F
F

Banner-> shrdmgr->shrdgmr_degs_codeDegree Status Code. 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_1Degree 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_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
C1_M2_Conc1
Minor 1
Minor 1

Banner-> shrdgmr->

 shrdgmr_majr_code_

Concentration Code 1 on Major 2, Curriculum 1 CodeReal Time
Anchor
C1_M2_Conc2C1_M2_Conc2

Banner-> shrdgmr->

shrdgmr_majr_code_conc_122

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

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_

Concentration Code 3 on Major 2, Curriculum 1Real Time
Anchor
C1_M2_Mnr1C1_M2_Mnr1

minr_1_2

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

Report Run Date

Anchor

College 2College 2

Banner-> shrdgmr->

shrdgmr_coll_code_2

Report Run Date
Report Run Date


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

SEQ No

Anchor

C2_Maj_3

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

C2_M3_Conc1

Student ID
Student ID

Banner->
dpriden-
>spriden_idThe student's university identification number. Real Time
Student Name
Anchor
C2_M3_Conc2
Student Name
Student Name

Banner-> shbdipl->shbdipl_name and

Banner->

spriden->

spriden_

Degree Concentration Code 2 Secondary. Second concentration for the secondary curriculum associated with the degree.Real Time
Anchor
C2_M3_Conc3C2_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
Anchor
C2_M3_Mnr1

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_
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
Anchor
Report Run DateReport Run Date gradThe term in which the student graduates.Real Time

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

...