Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
(Banner EDW Source Report)
Common Reporting View Reports

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 descending Attendance To Date, then Transacript Received Date with nulls last.
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 Administrative-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_AWARD_CATEGORY_1 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

PS_AWARD_CATEGORY_2 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

PS_AWARD_CATEGORY_3 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

PS_AWARD_CATEGORY_DESC_1 Description of the award category. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PS_AWARD_CATEGORY_DESC_2 Description of the award category. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PS_AWARD_CATEGORY_DESC_3 Description of the award category. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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: 9.1