Reporting View Target: PREVIOUS_EDUCATION

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Common Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: PREVIOUS_EDUCATION_ATTENDANCE

Description Contains all transfer records and their associated attendance periods
Key & Frequency One row per entity per institution per attendance period
Recommended Search Columns PERSON_UID, INSTITUTION, POST_SECONDARY_DEGREE
POST_SECONDARY_MAJOR1, POST_SECONDARY_DEGREE, PERSON_UID

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column

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

MSKFUNC.F_GET_DEGREE_IND

ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

ATTEND_PERIOD_FROM_DATE Attend Period From Date Previous education first date of attendance for attendance period. DATE
SHRTRAM
SORDEGR

SHRTRAM_ATTN_BEGIN_DATE
SORDEGR_ATTEND_FROM

ATTEND_PERIOD_TO_DATE Attend Period To Date Previous education last date of attendance for attendance period.. DATE
SHRTRAM
SORDEGR

SHRTRAM_ATTN_END_DATE
SORDEGR_ATTEND_TO

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

SORDEGR_COLL_CODE

COLLEGE_DESC College Description Description of the college code associated with the post secondary institution. VARCHAR2(255)
STVCOLL

STVCOLL_DESC

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

SORHSCH_COLL_PREP_IND

EDUCATION_ACTIVITY_DATE Education Activity Date Identifies the last date this record was created or updated. DATE
SHRTRAM
SHRTRIT
SORHSCH
SORPCOL

SHRTRAM_ACTIVITY_DATE
SHRTRIT_ACTIVITY_DATE
SORHSCH_ACTIVITY_DATE
SORPCOL_ACTIVITY_DATE

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

SORDEGR_EGOL_CODE

EDUCATION_GOAL_DESC Educational Goal Description Educational goal description. VARCHAR2(255)
STVEGOL

STVEGOL_DESC

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

MGKFUNC.F_GET_PERSON_INFO

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

SHRTRIT_SBGI_CODE
SORHSCH_SBGI_CODE
SORPCOL_SBGI_CODE

INSTITUTION_DESC Institution Description Source/background institution name. VARCHAR2(255)
STVSBGI

STVSBGI_DESC

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

GOKODSF.F_GET_DESC

INSTITUTION_TYPE_DESC Institution Type Description Source/background institution type identified as either a secondary or post-secondary school. VARCHAR2(255)
CONSTANT
CONSTANT

COLLEGE
HIGH SCHOOL

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)
NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)
NA

NA

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

MGKFUNC.F_GET_PERSON_INFO

OFFICIAL_TRANSCRIPT_IND Official Transcript Indicator Indicates whether the transcript was an official transcript. VARCHAR2(1)
SHRTRIT
SORPCOL

SHRTRIT_OFFICIAL_TRANS_IND
SORPCOL_OFFICIAL_TRANS

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

SORHSCH_PERCENTILE

PERSON_UID Person UID System generated, unique, internal identification number assigned to this person. NUMBER
SHRTRIT
SORHSCH
SORPCOL

SHRTRIT_PIDM
SORHSCH_PIDM
SORPCOL_PIDM

POST_SECONDARY_DEGREE Post Secondary Degree First degree date associated with post secondary institution. VARCHAR2(63)
SHRTRAM
SORDEGR

SHRTRAM_DEGC_CODE
SORDEGR_DEGC_CODE

POST_SECONDARY_DEGREE_DATE Post Secondary Degree Date First degree date associated with post secondary institution. DATE
SORDEGR

SORDEGR_DEGC_DATE

POST_SECONDARY_DEGREE_DESC Post Secondary Degree Description 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 Post Secondary Degree Sequence First degree sequence associated with post secondary institution. NUMBER
SORDEGR

SORDEGR_DEGR_SEQ_NO

POST_SECONDARY_DEGREE_YEAR Post Secondary Degree Year First degree year associated with post secondary institution. VARCHAR2(63)
SORDEGR

SORDEGR_DEGC_YEAR

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

SORDEGR_HONR_CODE

POST_SECONDARY_HONORS_DESC Post Secondary Honors Description Previous institution honors description. VARCHAR2(255)
STVHONR

STVHONR_DESC

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

SOKODSF.F_GET_SORMAJR_DATA

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

SOKODSF.F_GET_SORMAJR_DATA

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

SOKODSF.F_GET_SORMAJR_DATA

POST_SECONDARY_MAJOR_DESC1 Post Secondary Major Description 1 First major code description associated with the post secondary institution. VARCHAR2(255)
FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

POST_SECONDARY_MAJOR_DESC2 Post Secondary Major Description 2 Second major code description associated with the post secondary institution. VARCHAR2(255)
FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

POST_SECONDARY_MAJOR_DESC3 Post Secondary Major Description 3 Third major code description associated with the post secondary institution. VARCHAR2(255)
FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

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

NA

PROGRAM_CLASSIFICATION1 Program Classification 1 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 Program Classification 1 Description 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 Program Classification 2 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 Program Classification 2 Description 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 Program Classification 3 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 Program Classification 3 Description 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

SCHOOL_GPA School GPA - Grade Point Average or Average Person's secondary or post secondary school average or GPA. VARCHAR2(63)
SORDEGR
SORHSCH

SORDEGR_GPA_TRANSFERRED
SORHSCH_GPA

SCHOOL_RANK School Rank Person's institution class rank. NUMBER
SORHSCH

SORHSCH_CLASS_RANK

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

SORHSCH_CLASS_SIZE

SECONDARY_DIPLOMA 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 Diploma Description Secondary school diploma description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

SECONDARY_SCHOOL_GRAD_DATE Secondary School Graduate Date Person's graduation date from the secondary institution. DATE
SORHSCH

SORHSCH_GRADUATION_DATE

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

SHRTRAM_SEQ_NO

TRANSCRIPT_RECEIVED_DATE Transcript Received Date Date an academic transcript was received. DATE
SHRTRIT
SORHSCH
SORPCOL

SHRTRIT_TRANS_DATE_RCVD
SORHSCH_TRANS_RECV_DATE
SORPCOL_TRANS_RECV_DATE

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

NVL(SHRTRAM_ACCEPTANCE_DATE, SORPCOL_TRANS_REV_DATE)

TRANSFER_CREDITS_ATTENDANCE Transfer Credits Attendance Number of transfer credits received from the previous post secondary institution for the attendance period. NUMBER
FUNCTION

SOKODSF.F_CALC_TRANSFER_CREDITS

Ver: 9.0

Description	Contains all transfer records and their associated attendance periods
Key & Frequency	One row per entity per institution per attendance period
Recommended Search Columns	PERSON_UID, INSTITUTION, POST_SECONDARY_DEGREE POST_SECONDARY_MAJOR1, POST_SECONDARY_DEGREE, PERSON_UID

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ADDITIONAL_DEGREE_IND	Additional Degree Indicator	Indicates if there are more than 1 degrees.	VARCHAR2(1)	FUNCTION	MSKFUNC.F_GET_DEGREE_IND
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
ATTEND_PERIOD_FROM_DATE	Attend Period From Date	Previous education first date of attendance for attendance period.	DATE	SHRTRAM SORDEGR	SHRTRAM_ATTN_BEGIN_DATE SORDEGR_ATTEND_FROM
ATTEND_PERIOD_TO_DATE	Attend Period To Date	Previous education last date of attendance for attendance period..	DATE	SHRTRAM SORDEGR	SHRTRAM_ATTN_END_DATE SORDEGR_ATTEND_TO
COLLEGE	College	Identifies the college code associated with the post secondary institution.	VARCHAR2(63)	SORDEGR	SORDEGR_COLL_CODE
COLLEGE_DESC	College Description	Description of the college code associated with the post secondary institution.	VARCHAR2(255)	STVCOLL	STVCOLL_DESC
COLLEGE_PREP	College Prep	Indicates whether the prospect/applicant's secondary school program was college preparatory.	VARCHAR2(1)	SORHSCH	SORHSCH_COLL_PREP_IND
EDUCATION_ACTIVITY_DATE	Education Activity Date	Identifies the last date this record was created or updated.	DATE	SHRTRAM SHRTRIT SORHSCH SORPCOL	SHRTRAM_ACTIVITY_DATE SHRTRIT_ACTIVITY_DATE SORHSCH_ACTIVITY_DATE SORPCOL_ACTIVITY_DATE
EDUCATION_GOAL	Education Goal	Recorded education goal from the secondary or post secondary institution.	VARCHAR2(63)	SORDEGR	SORDEGR_EGOL_CODE
EDUCATION_GOAL_DESC	Educational Goal Description	Educational goal description.	VARCHAR2(255)	STVEGOL	STVEGOL_DESC
ID	ID	Person's or organization's current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
INSTITUTION	Institution	Source/ background institution code for the high school or prior college.	VARCHAR2(63)	SHRTRIT SORHSCH SORPCOL	SHRTRIT_SBGI_CODE SORHSCH_SBGI_CODE SORPCOL_SBGI_CODE
INSTITUTION_DESC	Institution Description	Source/background institution name.	VARCHAR2(255)	STVSBGI	STVSBGI_DESC
INSTITUTION_TYPE	Institution Type	Identifies a type for the source/background institution to be used for reporting.	VARCHAR2(1)	FUNCTION	GOKODSF.F_GET_DESC
INSTITUTION_TYPE_DESC	Institution Type Description	Source/background institution type identified as either a secondary or post-secondary school.	VARCHAR2(255)	CONSTANT CONSTANT	COLLEGE HIGH SCHOOL
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
OFFICIAL_TRANSCRIPT_IND	Official Transcript Indicator	Indicates whether the transcript was an official transcript.	VARCHAR2(1)	SHRTRIT SORPCOL	SHRTRIT_OFFICIAL_TRANS_IND SORPCOL_OFFICIAL_TRANS
PERCENTILE	Percentile	Person's class percentile as related to class rank and size.	NUMBER	SORHSCH	SORHSCH_PERCENTILE
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SHRTRIT SORHSCH SORPCOL	SHRTRIT_PIDM SORHSCH_PIDM SORPCOL_PIDM
POST_SECONDARY_DEGREE	Post Secondary Degree	First degree date associated with post secondary institution.	VARCHAR2(63)	SHRTRAM SORDEGR	SHRTRAM_DEGC_CODE SORDEGR_DEGC_CODE
POST_SECONDARY_DEGREE_DATE	Post Secondary Degree Date	First degree date associated with post secondary institution.	DATE	SORDEGR	SORDEGR_DEGC_DATE
POST_SECONDARY_DEGREE_DESC	Post Secondary Degree Description	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	Post Secondary Degree Sequence	First degree sequence associated with post secondary institution.	NUMBER	SORDEGR	SORDEGR_DEGR_SEQ_NO
POST_SECONDARY_DEGREE_YEAR	Post Secondary Degree Year	First degree year associated with post secondary institution.	VARCHAR2(63)	SORDEGR	SORDEGR_DEGC_YEAR
POST_SECONDARY_HONORS	Post Secondary Honors	Previous institution award honors earned and recorded for the person.	VARCHAR2(63)	SORDEGR	SORDEGR_HONR_CODE
POST_SECONDARY_HONORS_DESC	Post Secondary Honors Description	Previous institution honors description.	VARCHAR2(255)	STVHONR	STVHONR_DESC
POST_SECONDARY_MAJOR1	Post Secondary Major 1	First major code associated with the post secondary institution.	VARCHAR2(63)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
POST_SECONDARY_MAJOR2	Post Secondary Major 2	Second major code associated with the post secondary institution.	VARCHAR2(63)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
POST_SECONDARY_MAJOR3	Post Secondary Major 3	Third major code associated with the post secondary institution.	VARCHAR2(63)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
POST_SECONDARY_MAJOR_DESC1	Post Secondary Major Description 1	First major code description associated with the post secondary institution.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
POST_SECONDARY_MAJOR_DESC2	Post Secondary Major Description 2	Second major code description associated with the post secondary institution.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
POST_SECONDARY_MAJOR_DESC3	Post Secondary Major Description 3	Third major code description associated with the post secondary institution.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
PROGRAM_CLASSIFICATION1	Program Classification 1	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	Program Classification 1 Description	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	Program Classification 2	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	Program Classification 2 Description	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	Program Classification 3	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	Program Classification 3 Description	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
SCHOOL_GPA	School GPA - Grade Point Average or Average	Person's secondary or post secondary school average or GPA.	VARCHAR2(63)	SORDEGR SORHSCH	SORDEGR_GPA_TRANSFERRED SORHSCH_GPA
SCHOOL_RANK	School Rank	Person's institution class rank.	NUMBER	SORHSCH	SORHSCH_CLASS_RANK
SCHOOL_SIZE	School Size	Size of the person's institution graduating class.	NUMBER	SORHSCH	SORHSCH_CLASS_SIZE
SECONDARY_DIPLOMA	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 Diploma Description	Secondary school diploma description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
SECONDARY_SCHOOL_GRAD_DATE	Secondary School Graduate Date	Person's graduation date from the secondary institution.	DATE	SORHSCH	SORHSCH_GRADUATION_DATE
SEQUENCE_NUMBER	Sequence Number	Sequence number of the attendance period from the transfer institution.	NUMBER	SHRTRAM	SHRTRAM_SEQ_NO
TRANSCRIPT_RECEIVED_DATE	Transcript Received Date	Date an academic transcript was received.	DATE	SHRTRIT SORHSCH SORPCOL	SHRTRIT_TRANS_DATE_RCVD SORHSCH_TRANS_RECV_DATE SORPCOL_TRANS_RECV_DATE
TRANSCRIPT_REVIEWED_DATE	Transcript Reviewed Date	Date an academic transcript was reviewed by the institution.	DATE	CALCULATION	NVL(SHRTRAM_ACCEPTANCE_DATE, SORPCOL_TRANS_REV_DATE)
TRANSFER_CREDITS_ATTENDANCE	Transfer Credits Attendance	Number of transfer credits received from the previous post secondary institution for the attendance period.	NUMBER	FUNCTION	SOKODSF.F_CALC_TRANSFER_CREDITS