Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Common Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: PREVIOUS_EDUCATION

Description Contains the data related to all secondary and post-secondary institutions a person has attended. The data will be a single row per institution attended with the earliest start and latest end date if attended more than one time and the highest degree awarded or the latest degree sought. Use the PREVIOUS_DEGREE or PREVIOUS_EDUCATION_ATTENDANCE if you need to report all data recorded for this person and institution. This data will pull together data from multiple source database tables. This data may be used as admission criteria or when predicting success factors.
Key & Frequency One row per person per institution.
Recommended Search Columns PERSON_UID, INSTITUTION, POST_SECONDARY_DEGREE
POST_SECONDARY_MAJOR1, POST_SECONDARY_DEGREE, PERSON_UID

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ADDITIONAL_DEGREE_IND Additional Degree Indicator Indicates if there are more than 1 degrees. VARCHAR2(1)  

FUNCTION

MSKFUNC.F_GET_DEGREE_IND

ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)  

NA

NA

ATTEND_FROM_DATE Attend From Date Previous education first date of attendance. When there are multiple attendance periods for the same transfer institution, this reporting view will retrieve the earliest attend from date. DATE  

SORDEGR

SORDEGR_ATTEND_FROM

ATTEND_TO_DATE Attend To Date Previous education last date of attendance. When there are multiple attendance periods for the same transfer institution, this reporting view will retrieve the latest attend to date. DATE  

SORDEGR

SORDEGR_ATTEND_TO

AWARD_CATEGORY Award Category Award category associated with the outcome, degree or award. Category used to group outcomes for reporting similar awards together. For example, less than two year, two year and four year awards. VARCHAR2(63)  

STVDEGC

STVDEGC_ACAT_CODE

AWARD_CATEGORY_DESC Award Category Description Award category description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

COLLEGE College Identifies the college code associated with the post secondary institution. VARCHAR2(63)  

SORDEGR

SORDEGR_COLL_CODE

COLLEGE_DESC College Description Identifies the description of the college code. VARCHAR2(255)  

STVCOLL

STVCOLL_DESC

COLLEGE_PREP College Prep Indicates whether the prospect/applicant's secondary school program was college preparatory. VARCHAR2(1)  

SORHSCH

SORHSCH_COLL_PREP_IND

EDUCATION_ACTIVITY_DATE Education Activity Date Date record was inserted or updated. DATE  

SHRTRAM

SHRTRIT

SORHSCH

SORPCOL

SHRTRAM_ACTIVITY_DATE

SHRTRIT_ACTIVITY_DATE

SORHSCH_ACTIVITY_DATE

SORPCOL_ACTIVITY_DATE

EDUCATION_DATA_ORIGIN Education Data Origin Source system that created or updated the row VARCHAR2(63)  

SORHSCH

SORPCOL

SORHSCH_DATA_ORIGIN

SORPCOL_DATA_ORIGIN

EDUCATION_GOAL Education Goal Recorded education goal from the secondary or post secondary institution. VARCHAR2(63)  

SORDEGR

SORDEGR_EGOL_CODE

EDUCATION_GOAL_DESC Education Goal Description Educational goal description. VARCHAR2(255)  

STVEGOL

STVEGOL_DESC

EDUCATION_USER_ID Education User ID User who inserted or last updated the data. VARCHAR2(63)  

SORHSCH

SORPCOL

SORHSCH_USER_ID

SORPCOL_USER_ID

ID ID Person's or organization's current identification number. VARCHAR2(63)  

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

INSTITUTION Institution Source/ background institution code for the high school or prior college. VARCHAR2(63)  

SHRTRIT

SHRTRIT_SBGI_CODE

INSTITUTION_DESC Institution Description Source/background institution name. VARCHAR2(255)  

STVSBGI

STVSBGI_DESC

INSTITUTION_TYPE Institution Type Identifies a type for the source/background institution to be used for reporting. VARCHAR2(1)  

STVSBGI

STVSBGI_TYPE_IND

INSTITUTION_TYPE_DESC Institution Type Description Source/background institution name. VARCHAR2(255)  

CONSTANT

CONSTANT

'COLLEGE'

'HIGHSCHOOL'

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)  

NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)  

NA

NA

NAME Name Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)  

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

OFFICIAL_TRANSCRIPT_IND Official Transcript Indicator Indicates whether the transcript was an official transcript. VARCHAR2(1)  

SHRTRIT

SHRTRIT_OFFICIAL_TRANS_IND

PERCENTILE Percentile Person's class percentile as related to class rank and size. NUMBER  

SORHSCH

SORHSCH_PERCENTILE

PERSON_UID Person UID System generated, unique, internal identification number assigned to this person. NUMBER  

SORHSCH

SORPCOL

SORHSCH_PIDM

SORPCOL_PIDM

POST_SECONDARY_DEGREE Post Secondary Degree First degree code associated with prior college. VARCHAR2(63)  

SORDEGR

SORDEGR_DEGC_CODE

POST_SECONDARY_DEGREE_DATE Post Secondary Degree Date First degree date associated with post secondary institution. DATE  

SORDEGR

SORDEGR_DEGC_DATE

POST_SECONDARY_DEGREE_DESC Post Secondary Degree Description Degree (e.g., bachelor of business administration, master of arts, juris doctor, etc.) associated with the degree code. VARCHAR2(255)  

STVDEGC

STVDEGC_DESC

POST_SECONDARY_DEGREE_SEQUENCE Post Secondary Degree Sequence First degree sequence associated with post secondary institution. NUMBER  

SORDEGR

SORDEGR_DEGR_SEQ_NO

POST_SECONDARY_DEGREE_YEAR Post Secondary Degree Year First degree year associated with post secondary institution. VARCHAR2(63)  

SORDEGR

SORDEGR_DEGC_YEAR

POST_SECONDARY_HONORS Post Secondary Honors Previous institution award honors earned and recorded for the person. VARCHAR2(63)  

SORDEGR

SORDEGR_HONR_CODE

POST_SECONDARY_HONORS_DESC Post Secondary Honors Description Previous institution honors description. VARCHAR2(255)  

STVHONR

STVHONR_DESC

POST_SECONDARY_MAJOR1 Post Secondary Major 1 First major code associated with the post secondary institution. VARCHAR2(63)  

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

POST_SECONDARY_MAJOR2 Post Secondary Major 2 Second major code associated with the post secondary institution. VARCHAR2(63)  

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

POST_SECONDARY_MAJOR3 Post Secondary Major 3 Third major code associated with the post secondary institution. VARCHAR2(63)  

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

POST_SECONDARY_MAJOR_DESC1 Post Secondary Major Description 1 First major code description associated with the post secondary institution. VARCHAR2(255)  

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

POST_SECONDARY_MAJOR_DESC2 Post Secondary Major Description 2 Second major code description associated with the post secondary institution. VARCHAR2(255)  

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

POST_SECONDARY_MAJOR_DESC3 Post Secondary Major Description 3 Third major code description associated with the post secondary institution. VARCHAR2(255)  

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)  

NA

NA

PROGRAM_CLASSIFICATION1 Program Classification 1 Classification of Institutional Programs (CIP) code of the first major code associated with the post secondary institution. VARCHAR2(63)  

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

PROGRAM_CLASSIFICATION1_DESC Program Classification 1 Description Classification of Institutional Programs (CIP) code for the first major code associated with the post secondary institution. VARCHAR2(255)  

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

PROGRAM_CLASSIFICATION2 Program Classification 2 Classification of Institutional Programs (CIP) code of the second major code associated with the post secondary institution. VARCHAR2(63)  

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

PROGRAM_CLASSIFICATION2_DESC Program Classification 2 Description Classification of Institutional Programs (CIP) code for the second major code associated with the post secondary institution. VARCHAR2(255)  

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

PROGRAM_CLASSIFICATION3 Program Classification 3 Classification of Institutional Programs (CIP) code of the third major code associated with the post secondary institution. VARCHAR2(63)  

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

PROGRAM_CLASSIFICATION3_DESC Program Classification 3 Description Classification of Institutional Programs (CIP) code description for the third major code associated with the post secondary institution. VARCHAR2(255)  

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

REQUIREMENT Requirement Document or checklist item that is satisfied by entry of this information. VARCHAR2(63)  

SORHSCH

SORPCOL

SORHSCH_ADMR_CODE

SORPCOL_ADMR_CODE

REQUIREMENT_DESC Requirement Description Requirement description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

SCHOOL_GPA School GPA - Grade Point Average or Average Person's post secondary institution average or GPA. VARCHAR2(63)  

SORDEGR

SORHSCH

SORDEGR_GPA_TRANSFERRED

SORHSCH_GPA

SCHOOL_RANK School Rank Person's institution class rank. NUMBER  

SORHSCH

SORHSCH_CLASS_RANK

SCHOOL_SIZE School Size Size of the person's institution graduating class. NUMBER  

SORHSCH

SORHSCH_CLASS_SIZE

SECONDARY_DIPLOMA Secondary Diploma Person's secondary institution diploma type. For example, college preparatory, vocational, general, etc. VARCHAR2(63)  

SORHSCH

SORHSCH_DPLM_CODE

SECONDARY_DIPLOMA_DESC Secondary Diploma Description Secondary school diploma description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

SECONDARY_SCHOOL_GRAD_DATE Secondary School Graduate Date Person's graduation date from the secondary institution. DATE  

SORHSCH

SORHSCH_GRADUATION_DATE

TOTAL_TRANSFER_CREDITS Total Transfer Credits Number of transfer credits received from the previous post secondary institution. NUMBER  

FUNCTION

SOKODSF.F_CALC_TRANSFER_CREDITS

TRANSCRIPT_RECEIVED_DATE Transcript Received Date Date an academic transcript was received. DATE  

SHRTRIT

SHRTRIT_TRANS_DATE_RCVD

TRANSCRIPT_REVIEWED_DATE Transcript Reviewed Date Date an academic transcript was reviewed by the institution. This may be entered either under the prior college record or on the transfer course record so a function is used to determine the date the work at the previous post secondary institution was reviewed or credit awarded. DATE  

FUNCTION

F_GET_DATE_PREV_EDUCATION



Ver: 9.0