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

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ADDITIONAL_DEGREE_IND Indicates if there are more than 1 degrees.    

FUNCTION

MSKFUNC.F_GET_DEGREE_IND

 
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
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.    

SORDEGR

SORDEGR_ATTEND_FROM

 
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.    

SORDEGR

SORDEGR_ATTEND_TO

 
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.    

STVDEGC

STVDEGC_ACAT_CODE

 
AWARD_CATEGORY_DESC Award category description.    

FUNCTION

GOKODSF.F_GET_DESC

 
COLLEGE Identifies the college code associated with the post secondary institution.    

SORDEGR

SORDEGR_COLL_CODE

 
COLLEGE_DESC Identifies the description of the college code.    

STVCOLL

STVCOLL_DESC

 
COLLEGE_PREP Indicates whether the prospect/applicant's secondary school program was college preparatory.    

SORHSCH

SORHSCH_COLL_PREP_IND

 
EDUCATION_ACTIVITY_DATE Date record was inserted or updated.    

SHRTRAM

SHRTRAM

SHRTRIT

SORHSCH

SORPCOL

SHRTRAM_ACTIVITY_DATE

SHRTRAM_ACTIVITY_DATE

SHRTRIT_ACTIVITY_DATE

SORHSCH_ACTIVITY_DATE

SORPCOL_ACTIVITY_DATE

 
EDUCATION_GOAL Recorded education goal from the secondary or post secondary institution.    

SORDEGR

SORDEGR_EGOL_CODE

 
EDUCATION_GOAL_DESC Educational goal description.    

STVEGOL

STVEGOL_DESC

 
ID Person's or organization's current identification number.    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

 
INSTITUTION Source/ background institution code for the high school or prior college.    

SHRTRIT

SHRTRIT_SBGI_CODE

 
INSTITUTION_DESC Source/background institution name.    

STVSBGI

STVSBGI_DESC

 
INSTITUTION_TYPE Identifies a type for the source/background institution to be used for reporting.    

STVSBGI

STVSBGI_TYPE_IND

 
INSTITUTION_TYPE_DESC Source/background institution name.    

CONSTANT

CONSTANT

'COLLEGE'

'HIGHSCHOOL'

 
MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

 
OFFICIAL_TRANSCRIPT_IND Indicates whether the transcript was an official transcript.    

SHRTRIT

SHRTRIT_OFFICIAL_TRANS_IND

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

SORHSCH

SORHSCH_PERCENTILE

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

SHRTRIT

SHRTRIT_PIDM

 
POST_SECONDARY_DEGREE First degree code associated with prior college.    

SORDEGR

SORDEGR_DEGC_CODE

 
POST_SECONDARY_DEGREE_DATE First degree date associated with post secondary institution.    

SORDEGR

SORDEGR_DEGC_DATE

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

STVDEGC

STVDEGC_DESC

 
POST_SECONDARY_DEGREE_SEQUENCE First degree sequence associated with post secondary institution.    

SORDEGR

SORDEGR_DEGR_SEQ_NO

 
POST_SECONDARY_DEGREE_YEAR First degree year associated with post secondary institution.    

SORDEGR

SORDEGR_DEGC_YEAR

 
POST_SECONDARY_HONORS Previous institution award honors earned and recorded for the person.    

SORDEGR

SORDEGR_HONR_CODE

 
POST_SECONDARY_HONORS_DESC Previous institution honors description.    

STVHONR

STVHONR_DESC

 
POST_SECONDARY_MAJOR1 First major code associated with the post secondary institution.    

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

 
POST_SECONDARY_MAJOR2 Second major code associated with the post secondary institution.    

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

 
POST_SECONDARY_MAJOR3 Third major code associated with the post secondary institution.    

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

 
POST_SECONDARY_MAJOR_DESC1 First major code description associated with the post secondary institution.    

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

 
POST_SECONDARY_MAJOR_DESC2 Second major code description associated with the post secondary institution.    

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

 
POST_SECONDARY_MAJOR_DESC3 Third major code description associated with the post secondary institution.    

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

 
PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

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

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

 
PROGRAM_CLASSIFICATION1_DESC Classification of Institutional Programs (CIP) code for the first major code associated with the post secondary institution.    

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

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

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

 
PROGRAM_CLASSIFICATION2_DESC Classification of Institutional Programs (CIP) code for the second major code associated with the post secondary institution.    

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

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

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

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

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

 
SCHOOL_GPA Person's post secondary institution average or GPA.    

SORDEGR

SORHSCH

SORDEGR_GPA_TRANSFERRED

SORHSCH_GPA

 
SCHOOL_RANK Person's institution class rank.    

SORHSCH

SORHSCH_CLASS_RANK

 
SCHOOL_SIZE Size of the person's institution graduating class.    

SORHSCH

SORHSCH_CLASS_SIZE

 
SECONDARY_DIPLOMA Person's secondary institution diploma type. For example, college preparatory, vocational, general, etc.    

SORHSCH

SORHSCH_DPLM_CODE

 
SECONDARY_DIPLOMA_DESC Secondary school diploma description.    

FUNCTION

GOKODSF.F_GET_DESC

 
SECONDARY_SCHOOL_GRAD_DATE Person's graduation date from the secondary institution.    

SORHSCH

SORHSCH_GRADUATION_DATE

 
TOTAL_TRANSFER_CREDITS Number of transfer credits received from the previous post secondary institution.    

FUNCTION

SOKODSF.F_CALC_TRANSFER_CREDITS

 
TRANSCRIPT_RECEIVED_DATE Date an academic transcript was received.    

SHRTRIT

SHRTRIT_TRANS_DATE_RCVD

 
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.    

FUNCTION

F_GET_DATE_PREV_EDUCATION

 


Ver: 8.3