Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Common Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: PREVIOUS_EDUCATION_SLOT

Description Uses data from the PREVIOUS_EDUCATION view, displays up to 3 sets of data pertaining to previous education in order of ascending degree date.
Key & Frequency One row per person.
Recommended Search Columns PERSON_UID
ACTIVITY_DATE

Target Column Business Definition Database Data Type Source Name Source Column
ACTIVITY_DATE Date record was inserted or updated DATE

NA

SYSDATE

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

NA

NA

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

NA

NA

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

NA

NA

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

SORHSCH

SORPCOL

SORHSCH_PIDM

SORPCOL_PIDM

POST_SECONDARY_COLLEGE_1 Identifies the first college code associated with the post secondary institution. VARCHAR2(63)

SORDEGR

SORDEGR_COLL_CODE

POST_SECONDARY_COLLEGE_2 Identifies the second college code associated with the post secondary institution. VARCHAR2(63)

SORDEGR

SORDEGR_COLL_CODE

POST_SECONDARY_COLLEGE_3 Identifies the third college code associated with the post secondary institution. VARCHAR2(63)

SORDEGR

SORDEGR_COLL_CODE

POST_SECONDARY_COLLEGE_DESC_1 Identifies the description of the first college code associated with the post secondary institution. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

POST_SECONDARY_COLLEGE_DESC_2 Identifies the description of the second college code associated with the post secondary institution. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

POST_SECONDARY_COLLEGE_DESC_3 Identifies the description of the third college code associated with the post secondary institution. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

POST_SECONDARY_DEGREE_1 First degree code associated with prior college. VARCHAR2(63)

SORDEGR

SORDEGR_DEGC_CODE

POST_SECONDARY_DEGREE_2 First degree code associated with prior college. VARCHAR2(63)

SORDEGR

SORDEGR_DEGC_CODE

POST_SECONDARY_DEGREE_3 First degree code associated with prior college. VARCHAR2(63)

SORDEGR

SORDEGR_DEGC_CODE

POST_SECONDARY_DEGREE_DATE_1 First degree date associated with post secondary institution. DATE

SORDEGR

SORDEGR_DEGC_DATE

POST_SECONDARY_DEGREE_DATE_2 First degree date associated with post secondary institution. DATE

SORDEGR

SORDEGR_DEGC_DATE

POST_SECONDARY_DEGREE_DATE_3 First degree date associated with post secondary institution. DATE

SORDEGR

SORDEGR_DEGC_DATE

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

POST_SECONDARY_DEGREE_SEQ_1 First degree sequence associated with post secondary institution. NUMBER

SORDEGR

SORDEGR_DEGR_SEQ_NO

POST_SECONDARY_DEGREE_SEQ_2 First degree sequence associated with post secondary institution. NUMBER

SORDEGR

SORDEGR_DEGR_SEQ_NO

POST_SECONDARY_DEGREE_SEQ_3 First degree sequence associated with post secondary institution. NUMBER

SORDEGR

SORDEGR_DEGR_SEQ_NO

POST_SECONDARY_DEGREE_YEAR_1 First degree year associated with post secondary institution. VARCHAR2(63)

SORDEGR

SORDEGR_DEGC_YEAR

POST_SECONDARY_DEGREE_YEAR_2 First degree year associated with post secondary institution. VARCHAR2(63)

SORDEGR

SORDEGR_DEGC_YEAR

POST_SECONDARY_DEGREE_YEAR_3 First degree year associated with post secondary institution. VARCHAR2(63)

SORDEGR

SORDEGR_DEGC_YEAR

POST_SECONDARY_HONORS_1 Identifies the first honor code associated with the post secondary institution. VARCHAR2(63)

SORDEGR

SORDEGR_HONR_CODE

POST_SECONDARY_HONORS_2 Identifies the second honor code associated with the post secondary institution. VARCHAR2(63)

SORDEGR

SORDEGR_HONR_CODE

POST_SECONDARY_HONORS_3 Identifies the third honor code associated with the post secondary institution. VARCHAR2(63)

SORDEGR

SORDEGR_HONR_CODE

POST_SECONDARY_HONORS_DESC_1 Identifies the description of the first honor code associated with the post secondary institution. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

POST_SECONDARY_HONORS_DESC_2 Identifies the description of the second honor code associated with the post secondary institution. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

POST_SECONDARY_HONORS_DESC_3 Identifies the description of the third honor code associated with the post secondary institution. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

POST_SECONDARY_MAJOR1_1 First major code associated with the post secondary institution. VARCHAR2(63)

SORMAJR

SORMAJR_MAJR_CODE_MAJOR

POST_SECONDARY_MAJOR1_2 First major code associated with the post secondary institution. VARCHAR2(63)

SORMAJR

SORMAJR_MAJR_CODE_MAJOR

POST_SECONDARY_MAJOR1_3 First major code associated with the post secondary institution. VARCHAR2(63)

SORMAJR

SORMAJR_MAJR_CODE_MAJOR

POST_SECONDARY_MAJOR1_DESC_1 First major code description associated with the post secondary institution. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

POST_SECONDARY_MAJOR1_DESC_2 First major code description associated with the post secondary institution. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

POST_SECONDARY_MAJOR1_DESC_3 First major code description associated with the post secondary institution. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

POST_SECONDARY_MAJOR2_1 Second major code associated with the post secondary institution. VARCHAR2(63)

SORMAJR

SORMAJR_MAJR_CODE_MAJOR

POST_SECONDARY_MAJOR2_2 Second major code associated with the post secondary institution. VARCHAR2(63)

SORMAJR

SORMAJR_MAJR_CODE_MAJOR

POST_SECONDARY_MAJOR2_3 Second major code associated with the post secondary institution. VARCHAR2(63)

SORMAJR

SORMAJR_MAJR_CODE_MAJOR

POST_SECONDARY_MAJOR2_DESC_1 Second major code description associated with the post secondary institution. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

POST_SECONDARY_MAJOR2_DESC_2 Second major code description associated with the post secondary institution. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

POST_SECONDARY_MAJOR2_DESC_3 Second major code description associated with the post secondary institution. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

POST_SECONDARY_MAJOR3_1 Third major code associated with the post secondary institution. VARCHAR2(63)

SORMAJR

SORMAJR_MAJR_CODE_MAJOR

POST_SECONDARY_MAJOR3_2 Third major code associated with the post secondary institution. VARCHAR2(63)

SORMAJR

SORMAJR_MAJR_CODE_MAJOR

POST_SECONDARY_MAJOR3_3 Third major code associated with the post secondary institution. VARCHAR2(63)

SORMAJR

SORMAJR_MAJR_CODE_MAJOR

POST_SECONDARY_MAJOR3_DESC_1 Third major code description associated with the post secondary institution. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

POST_SECONDARY_MAJOR3_DESC_2 Third major code description associated with the post secondary institution. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

POST_SECONDARY_MAJOR3_DESC_3 Third major code description associated with the post secondary institution. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SORHSCH

SORPCOL

SORHSCH_SBGI_CODE

SORPCOL_SBGI_CODE

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

SORHSCH

SORPCOL

SORHSCH_SBGI_CODE

SORPCOL_SBGI_CODE

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

SORHSCH

SORPCOL

SORHSCH_SBGI_CODE

SORPCOL_SBGI_CODE

POST_SECONDARY_SCHOOL_DESC_1 Source/background institution name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

POST_SECONDARY_SCHOOL_DESC_2 Source/background institution name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

POST_SECONDARY_SCHOOL_DESC_3 Source/background institution name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

SOKODSF.F_CALC_TRANSFER_CREDITS

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

FUNCTION

SOKODSF.F_CALC_TRANSFER_CREDITS

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

FUNCTION

SOKODSF.F_CALC_TRANSFER_CREDITS

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

NA

NA

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

NA

NA

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

NA

NA

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

NA

NA

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

NA

NA

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

NA

NA

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

NA

NA

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

NA

NA

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

NA

NA

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

NA

NA

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

NA

NA

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

NA

NA

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

NA

NA

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

NA

NA

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

NA

NA

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

NA

NA

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

NA

NA

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

NA

NA

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

NA

NA

PS_ATTEND_FROM_DATE_1 Previous education first date of attendance. DATE

SORDEGR

SORDEGR_ATTEND_FROM

PS_ATTEND_FROM_DATE_2 Previous education first date of attendance. DATE

SORDEGR

SORDEGR_ATTEND_FROM

PS_ATTEND_FROM_DATE_3 Previous education first date of attendance. DATE

SORDEGR

SORDEGR_ATTEND_FROM

PS_ATTEND_TO_DATE_1 Previous education last date of attendance. DATE

SORDEGR

SORDEGR_ATTEND_TO

PS_ATTEND_TO_DATE_2 Previous education last date of attendance. DATE

SORDEGR

SORDEGR_ATTEND_TO

PS_ATTEND_TO_DATE_3 Previous education last date of attendance. DATE

SORDEGR

SORDEGR_ATTEND_TO

PS_EDUCATION_GOAL_1 Identifies the first education goal associated with the post secondary institution. VARCHAR2(63)

SORDEGR

SORDEGR_EGOL_CODE

PS_EDUCATION_GOAL_2 Identifies the second education goal associated with the post secondary institution. VARCHAR2(63)

SORDEGR

SORDEGR_EGOL_CODE

PS_EDUCATION_GOAL_3 Identifies the third education goal associated with the post secondary institution. VARCHAR2(63)

SORDEGR

SORDEGR_EGOL_CODE

PS_EDUCATION_GOAL_DESC_1 Identifies the description of the first education goal associated with the post secondary institution. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PS_EDUCATION_GOAL_DESC_2 Identifies the description of the second education goal associated with the post secondary institution. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PS_EDUCATION_GOAL_DESC_3 Identifies the description of the third education goal associated with the post secondary institution. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PS_OFFICIAL_TRANSCRIPT_IND_1 Indicates whether the transcript was an official transcript. VARCHAR2(1)

SORPCOL

SORPCOL_OFFICIAL_TRANS

PS_OFFICIAL_TRANSCRIPT_IND_2 Indicates whether the transcript was an official transcript. VARCHAR2(1)

SORPCOL

SORPCOL_OFFICIAL_TRANS

PS_OFFICIAL_TRANSCRIPT_IND_3 Indicates whether the transcript was an official transcript. VARCHAR2(1)

SORPCOL

SORPCOL_OFFICIAL_TRANS

PS_SCHOOL_GPA_1 Person's post secondary institution average or GPA. VARCHAR2(63)

SORDEGR

SORHSCH

SORDEGR_GPA_TRANSFERRED

SORHSCH_GPA

PS_SCHOOL_GPA_2 Person's post secondary institution average or GPA. VARCHAR2(63)

SORDEGR

SORHSCH

SORDEGR_GPA_TRANSFERRED

SORHSCH_GPA

PS_SCHOOL_GPA_3 Person's post secondary institution average or GPA. VARCHAR2(63)

SORDEGR

SORHSCH

SORDEGR_GPA_TRANSFERRED

SORHSCH_GPA

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

SORHSCH

SORHSCH_PERCENTILE

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

SORHSCH

SORHSCH_PERCENTILE

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

SORHSCH

SORHSCH_PERCENTILE

PS_SCHOOL_RANK_1 Person's institution class rank. NUMBER

SORHSCH

SORHSCH_CLASS_RANK

PS_SCHOOL_RANK_2 Person's institution class rank. NUMBER

SORHSCH

SORHSCH_CLASS_RANK

PS_SCHOOL_RANK_3 Person's institution class rank. NUMBER

SORHSCH

SORHSCH_CLASS_RANK

PS_SCHOOL_SIZE_1 Size of the person's institution graduating class. NUMBER

SORHSCH

SORHSCH_CLASS_SIZE

PS_SCHOOL_SIZE_2 Size of the person's institution graduating class. NUMBER

SORHSCH

SORHSCH_CLASS_SIZE

PS_SCHOOL_SIZE_3 Size of the person's institution graduating class. NUMBER

SORHSCH

SORHSCH_CLASS_SIZE

PS_TRANSCRIPT_RECEIVED_DATE_1 Date an academic transcript was received. DATE

SORHSCH

SORPCOL

SORHSCH_TRANS_RECV_DATE

SORPCOL_TRANS_RECV_DATE

PS_TRANSCRIPT_RECEIVED_DATE_2 Date an academic transcript was received. DATE

SORHSCH

SORPCOL

SORHSCH_TRANS_RECV_DATE

SORPCOL_TRANS_RECV_DATE

PS_TRANSCRIPT_RECEIVED_DATE_3 Date an academic transcript was received. DATE

SORHSCH

SORPCOL

SORHSCH_TRANS_RECV_DATE

SORPCOL_TRANS_RECV_DATE

PS_TRANSCRIPT_REVIEWED_DATE_1 Date the academic transcript was reviewed. DATE

SORPCOL

SORPCOL_TRANS_REV_DATE

PS_TRANSCRIPT_REVIEWED_DATE_2 Date the academic transcript was reviewed. DATE

SORPCOL

SORPCOL_TRANS_REV_DATE

PS_TRANSCRIPT_REVIEWED_DATE_3 Date the academic transcript was reviewed. DATE

SORPCOL

SORPCOL_TRANS_REV_DATE

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

SORHSCH

SORPCOL

SORHSCH_SBGI_CODE

SORPCOL_SBGI_CODE

SECONDARY_SCHOOL_NAME Source/background institution name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SS_ATTEND_FROM_DATE Previous education first date of attendance. DATE

SORDEGR

SORDEGR_ATTEND_FROM

SS_ATTEND_TO_DATE Previous education last date of attendance. DATE

SORDEGR

SORDEGR_ATTEND_TO

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

SORHSCH

SORHSCH_DPLM_CODE

SS_DIPLOMA_DESC Secondary school diploma description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SS_GRAD_DATE Person's graduation date from the secondary institution. DATE

SORHSCH

SORHSCH_GRADUATION_DATE

SS_OFFICIAL_TRANSCRIPT_IND Indicates whether the transcript was an official transcript. VARCHAR2(1)

SORPCOL

SORPCOL_OFFICIAL_TRANS

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

SORHSCH

SORHSCH_PERCENTILE

SS_SCHOOL_GPA Person's post secondary institution average or GPA. VARCHAR2(63)

SORDEGR

SORHSCH

SORDEGR_GPA_TRANSFERRED

SORHSCH_GPA

SS_SCHOOL_RANK Person's institution class rank. NUMBER

SORHSCH

SORHSCH_CLASS_RANK

SS_SCHOOL_SIZE Size of the person's institution graduating class. NUMBER

SORHSCH

SORHSCH_CLASS_SIZE

SS_TRANSCRIPT_RECEIVED_DATE Date an academic transcript was received. DATE

SORHSCH

SORPCOL

SORHSCH_TRANS_RECV_DATE

SORPCOL_TRANS_RECV_DATE

SS_TRANSCRIPT_REVIEWED_DATE Date an academic transcript was reviewed by the institution. DATE

SORPCOL

SORPCOL_TRANS_REV_DATE



Ver: 8.0