Composite View Target: AS_PREVIOUS_EDUCATION

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Common Composite View Reports

SGHE Banner 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
SHRTRAM

SHRTRAM_ATTN_BEGIN_DATE

ATTEND_TO_DATE Previous education last date of attendance. DATE
SHRTRAM

SHRTRAM_ATTN_END_DATE

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

SORDEGR_COLL_CODE

COLLEGE_DESC Identifies the college code description associated with the post secondary institution. VARCHAR2(30)
STVCOLL

STVCOLL_DESC

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_ACTIVITY_DATE Identifies the last date this record was created or updated. DATE
SHRTRAM
SHRTRIT
SORPCOL

SHRTRAM_ACTIVITY_DATE
SHRTRIT_ACTIVITY_DATE
SORPCOL_ACTIVITY_DATE

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

SORDEGR_EGOL_CODE

EDUCATION_GOAL_DESC Educational goal description. VARCHAR2(30)
STVEGOL

STVEGOL_DESC

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

SHRTRIT_SBGI_CODE

INSTITUTION_DESC Source/background institution name. VARCHAR2(30)
STVSBGI

STVSBGI_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)
SHRTRIT

SHRTRIT_OFFICIAL_TRANS_IND

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)
SHRTRIT

SHRTRIT_PIDM

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

SHRTRAM_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)
STVDEGC

STVDEGC_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)
SORDEGR

SORDEGR_HONR_CODE

POST_SECONDARY_HONORS_DESC Previous institution honors description. VARCHAR2(30)
STVHONR

STVHONR_DESC

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

SOKODSF.F_GET_SORMAJR_DATA

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

SOKODSF.F_GET_SORMAJR_DATA

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

SOKODSF.F_GET_SORMAJR_DATA

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

SOKODSF.F_GET_SORMAJR_DATA

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

SOKODSF.F_GET_SORMAJR_DATA

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

SOKODSF.F_GET_SORMAJR_DATA

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)
FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

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)
FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

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)
FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

PROGRAM_CLASSIFICATION_DESC1 Program classification description. VARCHAR2(80)
FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

PROGRAM_CLASSIFICATION_DESC2 Program classification description. VARCHAR2(80)
FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

PROGRAM_CLASSIFICATION_DESC3 Program classification description. VARCHAR2(80)
FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

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

SEQUENCE_NUMBER Sequence number of the attendance period from the transfer institution. NUMBER
SHRTRAM

SHRTRAM_SEQ_NO

SOURCE_FLAG Identifies which source view this records comes from, P for AS_PREVIOUS_EDUCATION_PCOL and H for AS_PREVIOUS_EDUCATION_HSCH. It is used in relation to the OWB mappings. VARCHAR2(1)
CONSTANT

'P'

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
SHRTRIT

SHRTRIT_TRANS_DATE_RCVD

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

SHRTRAM_ACCEPTANCE_DATE

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

NA

Ver: 8.1

Target Column	Business Definition	Database Data Type	Source Name	Source Column
ATTEND_FROM_DATE	Previous education first date of attendance.	DATE	SHRTRAM	SHRTRAM_ATTN_BEGIN_DATE
ATTEND_TO_DATE	Previous education last date of attendance.	DATE	SHRTRAM	SHRTRAM_ATTN_END_DATE
COLLEGE	Identifies the college code associated with the post secondary institution.	VARCHAR2(2)	SORDEGR	SORDEGR_COLL_CODE
COLLEGE_DESC	Identifies the college code description associated with the post secondary institution.	VARCHAR2(30)	STVCOLL	STVCOLL_DESC
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_ACTIVITY_DATE	Identifies the last date this record was created or updated.	DATE	SHRTRAM SHRTRIT SORPCOL	SHRTRAM_ACTIVITY_DATE SHRTRIT_ACTIVITY_DATE SORPCOL_ACTIVITY_DATE
EDUCATION_GOAL	Recorded education goal from the secondary or post secondary institution.	VARCHAR2(2)	SORDEGR	SORDEGR_EGOL_CODE
EDUCATION_GOAL_DESC	Educational goal description.	VARCHAR2(30)	STVEGOL	STVEGOL_DESC
INSTITUTION	Source/background institution code for the prior college.	VARCHAR2(6)	SHRTRIT	SHRTRIT_SBGI_CODE
INSTITUTION_DESC	Source/background institution name.	VARCHAR2(30)	STVSBGI	STVSBGI_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)	SHRTRIT	SHRTRIT_OFFICIAL_TRANS_IND
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)	SHRTRIT	SHRTRIT_PIDM
POST_SECONDARY_DEGREE	First degree code associated with prior college.	VARCHAR2(6)	SHRTRAM	SHRTRAM_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)	STVDEGC	STVDEGC_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)	SORDEGR	SORDEGR_HONR_CODE
POST_SECONDARY_HONORS_DESC	Previous institution honors description.	VARCHAR2(30)	STVHONR	STVHONR_DESC
POST_SECONDARY_MAJOR1	First major code associated with the post secondary institution.	VARCHAR2(4)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
POST_SECONDARY_MAJOR2	Second major code associated with the post secondary institution.	VARCHAR2(4)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
POST_SECONDARY_MAJOR3	Third major code associated with the post secondary institution.	VARCHAR2(4)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
POST_SECONDARY_MAJOR_DESC1	First major code description associated with the post secondary institution.	VARCHAR2(30)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
POST_SECONDARY_MAJOR_DESC2	Second major code description associated with the post secondary institution.	VARCHAR2(30)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
POST_SECONDARY_MAJOR_DESC3	Third major code description associated with the post secondary institution.	VARCHAR2(30)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
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)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
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)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
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)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
PROGRAM_CLASSIFICATION_DESC1	Program classification description.	VARCHAR2(80)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
PROGRAM_CLASSIFICATION_DESC2	Program classification description.	VARCHAR2(80)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
PROGRAM_CLASSIFICATION_DESC3	Program classification description.	VARCHAR2(80)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
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
SEQUENCE_NUMBER	Sequence number of the attendance period from the transfer institution.	NUMBER	SHRTRAM	SHRTRAM_SEQ_NO
SOURCE_FLAG	Identifies which source view this records comes from, P for AS_PREVIOUS_EDUCATION_PCOL and H for AS_PREVIOUS_EDUCATION_HSCH. It is used in relation to the OWB mappings.	VARCHAR2(1)	CONSTANT	'P'
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	SHRTRIT	SHRTRIT_TRANS_DATE_RCVD
TRANSCRIPT_REVIEWED_DATE	Date an academic transcript was reviewed by the institution.	DATE	SHRTRAM	SHRTRAM_ACCEPTANCE_DATE
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA