Reporting View Target: PREVIOUS

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

Description Contains the data related to all secondary and post-secondary institutions a person has attended. The data will be a single row per institution attended with the earliest start and latest end date if attended more than one time and the highest degree awarded or the latest degree sought. Use the PREVIOUS_DEGREE or PREVIOUS_EDUCATION_ATTENDANCE if you need to report all data recorded for this person and institution. This data will pull together data from multiple source database tables. 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

ADDITIONAL_DEGREE_IND Indicates if there are more than 1 degrees. VARCHAR2(1)
FUNCTION

MSKFUNC.F_GET_DEGREE_IND

ADMINISTRATIVE_GROUP Administrative-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. When there are multiple attendance periods for the same transfer institution, this reporting view will retrieve the earliest attend from date. DATE
SORDEGR

SORDEGR_ATTEND_FROM

ATTEND_TO_DATE Previous education last date of attendance. When there are multiple attendance periods for the same transfer institution, this reporting view will retrieve the latest attend to date. DATE
SORDEGR

SORDEGR_ATTEND_TO

AWARD_CATEGORY Government reporting category that groups awards and degrees together to count students. For example, Less than 2 yr, 2 yr, Bachelor, etc. VARCHAR2(63)
STVDEGC

STVDEGC_ACAT_CODE

AWARD_CATEGORY_DESC Award category description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

COLLEGE First level of the institution organization structure that owns the student or the academic instruction for a student course. 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_DATA_ORIGIN Source system that created or updated the row VARCHAR2(63)
SORHSCH
SORPCOL

SORHSCH_DATA_ORIGIN
SORPCOL_DATA_ORIGIN

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

SORDEGR_EGOL_CODE

EDUCATION_GOAL_DESC Educational goal description. VARCHAR2(255)
STVEGOL

STVEGOL_DESC

EDUCATION_USER_ID User who inserted or last updated the data. VARCHAR2(63)
SORHSCH
SORPCOL

SORHSCH_USER_ID
SORPCOL_USER_ID

ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

SHRTRIT_SBGI_CODE

INSTITUTION_DESC Source/background institution name. VARCHAR2(255)
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 Source/background institution name. VARCHAR2(255)
CONSTANT
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(255)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

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

SORDEGR_HONR_CODE

POST_SECONDARY_HONORS_DESC Previous institution honors description. VARCHAR2(255)
STVHONR

STVHONR_DESC

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

SOKODSF.F_GET_SORMAJR_DATA

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

SOKODSF.F_GET_SORMAJR_DATA

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

SOKODSF.F_GET_SORMAJR_DATA

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

SOKODSF.F_GET_SORMAJR_DATA

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

SOKODSF.F_GET_SORMAJR_DATA

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

SOKODSF.F_GET_SORMAJR_DATA

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

SOKODSF.F_GET_SORMAJR_DATA

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

SOKODSF.F_GET_SORMAJR_DATA

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

SOKODSF.F_GET_SORMAJR_DATA

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

SOKODSF.F_GET_SORMAJR_DATA

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

SOKODSF.F_GET_SORMAJR_DATA

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

SOKODSF.F_GET_SORMAJR_DATA

REQUIREMENT Document or checklist item that is satisfied by entry of this information. VARCHAR2(63)
SORHSCH
SORPCOL

SORHSCH_ADMR_CODE
SORPCOL_ADMR_CODE

REQUIREMENT_DESC Requirement description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

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
SHRTRIT

SHRTRIT_TRANS_DATE_RCVD

TRANSCRIPT_REVIEWED_DATE Date an academic transcript was reviewed by the institution. This may be entered either under the prior college record or on the transfer course record so a function is used to determine the date the work at the previous post secondary institution was reviewed or credit awarded. DATE
FUNCTION

F_GET_DATE_PREV_EDUCATION

Ver: 9.1

Description	Contains the data related to all secondary and post-secondary institutions a person has attended. The data will be a single row per institution attended with the earliest start and latest end date if attended more than one time and the highest degree awarded or the latest degree sought. Use the PREVIOUS_DEGREE or PREVIOUS_EDUCATION_ATTENDANCE if you need to report all data recorded for this person and institution. This data will pull together data from multiple source database tables. 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
ADDITIONAL_DEGREE_IND	Indicates if there are more than 1 degrees.	VARCHAR2(1)	FUNCTION	MSKFUNC.F_GET_DEGREE_IND
ADMINISTRATIVE_GROUP	Administrative-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. When there are multiple attendance periods for the same transfer institution, this reporting view will retrieve the earliest attend from date.	DATE	SORDEGR	SORDEGR_ATTEND_FROM
ATTEND_TO_DATE	Previous education last date of attendance. When there are multiple attendance periods for the same transfer institution, this reporting view will retrieve the latest attend to date.	DATE	SORDEGR	SORDEGR_ATTEND_TO
AWARD_CATEGORY	Government reporting category that groups awards and degrees together to count students. For example, Less than 2 yr, 2 yr, Bachelor, etc.	VARCHAR2(63)	STVDEGC	STVDEGC_ACAT_CODE
AWARD_CATEGORY_DESC	Award category description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
COLLEGE	First level of the institution organization structure that owns the student or the academic instruction for a student course.	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_DATA_ORIGIN	Source system that created or updated the row	VARCHAR2(63)	SORHSCH SORPCOL	SORHSCH_DATA_ORIGIN SORPCOL_DATA_ORIGIN
EDUCATION_GOAL	Recorded education goal from the secondary or post secondary institution.	VARCHAR2(63)	SORDEGR	SORDEGR_EGOL_CODE
EDUCATION_GOAL_DESC	Educational goal description.	VARCHAR2(255)	STVEGOL	STVEGOL_DESC
EDUCATION_USER_ID	User who inserted or last updated the data.	VARCHAR2(63)	SORHSCH SORPCOL	SORHSCH_USER_ID SORPCOL_USER_ID
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
INSTITUTION	Source/ background institution code for the high school or prior college.	VARCHAR2(63)	SHRTRIT	SHRTRIT_SBGI_CODE
INSTITUTION_DESC	Source/background institution name.	VARCHAR2(255)	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	Source/background institution name.	VARCHAR2(255)	CONSTANT 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(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
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	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)	STVDEGC	STVDEGC_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)	SORDEGR	SORDEGR_HONR_CODE
POST_SECONDARY_HONORS_DESC	Previous institution honors description.	VARCHAR2(255)	STVHONR	STVHONR_DESC
POST_SECONDARY_MAJOR1	First major code associated with the post secondary institution.	VARCHAR2(63)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
POST_SECONDARY_MAJOR2	Second major code associated with the post secondary institution.	VARCHAR2(63)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
POST_SECONDARY_MAJOR3	Third major code associated with the post secondary institution.	VARCHAR2(63)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
POST_SECONDARY_MAJOR_DESC1	First major code description associated with the post secondary institution.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
POST_SECONDARY_MAJOR_DESC2	Second major code description associated with the post secondary institution.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
POST_SECONDARY_MAJOR_DESC3	Third major code description associated with the post secondary institution.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
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)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
PROGRAM_CLASSIFICATION1_DESC	Classification of Institutional Programs (CIP) code for the first major code associated with the post secondary institution.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
PROGRAM_CLASSIFICATION2	Classification of Institutional Programs (CIP) code of the second major code associated with the post secondary institution.	VARCHAR2(63)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
PROGRAM_CLASSIFICATION2_DESC	Classification of Institutional Programs (CIP) code for the second major code associated with the post secondary institution.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
PROGRAM_CLASSIFICATION3	Classification of Institutional Programs (CIP) code of the third major code associated with the post secondary institution.	VARCHAR2(63)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
PROGRAM_CLASSIFICATION3_DESC	Classification of Institutional Programs (CIP) code description for the third major code associated with the post secondary institution.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
REQUIREMENT	Document or checklist item that is satisfied by entry of this information.	VARCHAR2(63)	SORHSCH SORPCOL	SORHSCH_ADMR_CODE SORPCOL_ADMR_CODE
REQUIREMENT_DESC	Requirement description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
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	SHRTRIT	SHRTRIT_TRANS_DATE_RCVD
TRANSCRIPT_REVIEWED_DATE	Date an academic transcript was reviewed by the institution. This may be entered either under the prior college record or on the transfer course record so a function is used to determine the date the work at the previous post secondary institution was reviewed or credit awarded.	DATE	FUNCTION	F_GET_DATE_PREV_EDUCATION