RETURN TO REPORTING VIEW REPORTS LIST
(EDW Source Report)
Common Reporting View Reports

SGHE 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

Target Column Business Definition Database Data Type Source Name Source Column
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 Previous education first date of attendance. DATE

SORDEGR

SORDEGR_ATTEND_FROM

ATTEND_TO_DATE Previous education last date of attendance. DATE

SORDEGR

SORDEGR_ATTEND_TO

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

SORDEGR

SORDEGR_COLL_CODE

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

STVCOLL

STVCOLL_DESC

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

SORHSCH

SORHSCH_COLL_PREP_IND

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_GOAL Recorded education goal from the secondary or post secondary institution. VARCHAR2(63)

NA

NA

EDUCATION_GOAL_DESC Educational goal description. VARCHAR2(255)

NA

NA

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

SORHSCH

SORPCOL

SORHSCH_SBGI_CODE

SORPCOL_SBGI_CODE

INSTITUTION_DESC Source/background institution name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

STVSBGI

STVSBGI_TYPE_IND

INSTITUTION_TYPE_DESC Source/background institution name. VARCHAR2(255)

CONSTANT

'COLLEGE'

'HIGHSCHOOL'

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

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

SORPCOL

SORPCOL_OFFICIAL_TRANS

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

SORHSCH

SORHSCH_PERCENTILE

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

SORHSCH

SORPCOL

SORHSCH_PIDM

SORPCOL_PIDM

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

SORDEGR

SORDEGR_DEGC_CODE

POST_SECONDARY_DEGREE_DATE First degree date associated with post secondary institution. DATE

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. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

POST_SECONDARY_DEGREE_SEQUENCE First degree sequence associated with post secondary institution. NUMBER

SORDEGR

SORDEGR_DEGR_SEQ_NO

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

SORDEGR

SORDEGR_DEGC_YEAR

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

NA

NA

POST_SECONDARY_HONORS_DESC Previous institution honors description. VARCHAR2(255)

NA

NA

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

SORMAJR

SORMAJR_MAJR_CODE_MAJOR

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

SORMAJR

SORMAJR_MAJR_CODE_MAJOR

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

SORMAJR

SORMAJR_MAJR_CODE_MAJOR

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

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

NA

NA

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

NA

NA

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

NA

NA

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

NA

NA

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

NA

NA

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

NA

NA

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

SORDEGR

SORHSCH

SORDEGR_GPA_TRANSFERRED

SORHSCH_GPA

SCHOOL_RANK Person's institution class rank. NUMBER

SORHSCH

SORHSCH_CLASS_RANK

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

SORHSCH

SORHSCH_CLASS_SIZE

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 school diploma description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SORHSCH

SORHSCH_GRADUATION_DATE

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

FUNCTION

SOKODSF.F_CALC_TRANSFER_CREDITS

TRANSCRIPT_RECEIVED_DATE Date an academic transcript was received. DATE

SORHSCH

SORPCOL

SORHSCH_TRANS_RECV_DATE

SORPCOL_TRANS_RECV_DATE

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

SORPCOL

SORPCOL_TRANS_REV_DATE



Ver: 3.1