RETURN TO COMPOSITE VIEW REPORTS LIST
Common Composite View Reports

SGHE Operational Data Store
Composite View Target: AS_PREVIOUS_EDUCATION_PCOL

Description Source composite view contains information on post secondary institutions the person attended.

Target Column Business Definition Database Data Type Source Name Source Column
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_PREP This field indicates whether the prospect/applicant high school program was college prep. VARCHAR2(1)

NA

NA

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

EDUCATION_GOAL Recorded education goal from the secondary or post secondary institution. VARCHAR2(2)

NA

NA

EDUCATION_GOAL_DESC Educational goal description. VARCHAR2(30)

NA

NA

INSTITUTION Source/background institution code for the prior college. VARCHAR2(6)

SORPCOL

SORPCOL_SBGI_CODE

INSTITUTION_DESC Source/background institution name. VARCHAR2(30)

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 This field specifies the source/background institution type. VARCHAR2(30)

CONSTANT

'COLLEGE'

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

NA

NA

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

NA

NA

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

NA

NA

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

SORPCOL

SORPCOL_PIDM

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

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(30)

FUNCTION

GOKODSF.F_GET_DESC

POST_SECONDARY_DEGREE_SEQUENCE First degree sequence associated with post secondary institution. NUMBER(2)

SORDEGR

SORDEGR_DEGR_SEQ_NO

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

SORDEGR

SORDEGR_DEGC_YEAR

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

NA

NA

POST_SECONDARY_HONORS_DESC Previous institution honors description. VARCHAR2(30)

NA

NA

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

SORMAJR

SORMAJR_MAJR_CODE_MAJOR

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

SORMAJR

SORMAJR_MAJR_CODE_MAJOR

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

SORMAJR

SORMAJR_MAJR_CODE_MAJOR

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

PROGRAM_CLASSIFICATION1 Program classification associated with the major subject area of study for this outcome. Classification of Institutional Programs (CIP) codes used for reporting outcomes to the federal government. VARCHAR2(6)

STVMAJR

STVMAJR_CIPC_CODE

PROGRAM_CLASSIFICATION2 Program classification associated with the major subject area of study for this outcome. Classification of Institutional Programs (CIP) codes used for reporting outcomes to the federal government. VARCHAR2(6)

STVMAJR

STVMAJR_CIPC_CODE

PROGRAM_CLASSIFICATION3 Program classification associated with the major subject area of study for this outcome. Classification of Institutional Programs (CIP) codes used for reporting outcomes to the federal government. VARCHAR2(6)

STVMAJR

STVMAJR_CIPC_CODE

PROGRAM_CLASSIFICATION_DESC1 Program classification description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

PROGRAM_CLASSIFICATION_DESC2 Program classification description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

PROGRAM_CLASSIFICATION_DESC3 Program classification description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

SORDEGR

SORDEGR_GPA_TRANSFERRED

SCHOOL_RANK Person's institution class rank. NUMBER

NA

NA

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

NA

NA

SECONDARY_DIPLOMA This field indicates the persons most secondary institution diploma type, i.e., college prep. VARCHAR2(6)

NA

NA

SECONDARY_DIPLOMA_DESC This field specifies the diploma type (e.g. college preparatory, general education) associated with the diploma type code. VARCHAR2(30)

NA

NA

SECONDARY_SCHOOL_GRAD_DATE Not a valid column for any post secondary school input to the ODS tables. DATE

NA

NA

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

SORPCOL

SORPCOL_TRANS_RECV_DATE

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

SORPCOL

SORPCOL_TRANS_REV_DATE

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

NA

NA



Ver: 3.1