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

Banner Operational Data Store
Reporting View Target: PREVIOUS_EDUCATION_ATTENDANCE

Description Contains all transfer records and their associated attendance periods. There will be multiple records for a person and institution if more than one attendance start and end was recorded.
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 Definition Database Data Type Source Name Source Column Local Source Local Target
ADDITIONAL_DEGREE_IND Indicates if there are more than 1 degrees. VARCHAR2(1)

FUNCTION

MSKFUNC.F_GET_DEGREE_IND

NO

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

NA

NA

NO

NO
ATTEND_PERIOD_FROM_DATE Previous education first date of attendance for attendance period. DATE

SHRTRAM

SORDEGR

SHRTRAM_ATTN_BEGIN_DATE

SORDEGR_ATTEND_FROM

NO

NO

NO
ATTEND_PERIOD_TO_DATE Previous education last date of attendance for attendance period.. DATE

SHRTRAM

SORDEGR

SHRTRAM_ATTN_END_DATE

SORDEGR_ATTEND_TO

NO

NO

NO
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

NO

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

STVCOLL

STVCOLL_DESC

NO

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

SORHSCH

SORHSCH_COLL_PREP_IND

NO

NO
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

NO

NO

NO

NO

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

SORDEGR

SORDEGR_EGOL_CODE

NO

NO
EDUCATION_GOAL_DESC Educational goal description. VARCHAR2(255)

STVEGOL

STVEGOL_DESC

NO

NO
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

NO

NO
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

NO

NO

NO

NO
INSTITUTION_DESC Source/background institution name. VARCHAR2(255)

STVSBGI

STVSBGI_DESC

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

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

CONSTANT

CONSTANT

COLLEGE

HIGH SCHOOL

NO

NO

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

NA

NA

NO

NO
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

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

SHRTRIT

SORPCOL

SHRTRIT_OFFICIAL_TRANS_IND

SORPCOL_OFFICIAL_TRANS

NO

NO

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

SORHSCH

SORHSCH_PERCENTILE

NO

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

SHRTRIT

SORHSCH

SORPCOL

SHRTRIT_PIDM

SORHSCH_PIDM

SORPCOL_PIDM

NO

NO

NO

NO
POST_SECONDARY_DEGREE First degree date associated with post secondary institution. VARCHAR2(63)

SHRTRAM

SORDEGR

SHRTRAM_DEGC_CODE

SORDEGR_DEGC_CODE

NO

NO

NO
POST_SECONDARY_DEGREE_DATE First degree date associated with post secondary institution. DATE

SORDEGR

SORDEGR_DEGC_DATE

NO

NO
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

NO

NO
POST_SECONDARY_DEGREE_SEQUENCE First degree sequence associated with post secondary institution. NUMBER

SORDEGR

SORDEGR_DEGR_SEQ_NO

NO

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

SORDEGR

SORDEGR_DEGC_YEAR

NO

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

SORDEGR

SORDEGR_HONR_CODE

NO

NO
POST_SECONDARY_HONORS_DESC Previous institution honors description. VARCHAR2(255)

STVHONR

STVHONR_DESC

NO

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

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

NO

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

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

NO

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

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

NO

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

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

NO

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

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

NO

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

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

NO

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

NA

NA

NO

NO
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

NO

NO
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

NO

NO
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

NO

NO
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

NO

NO
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

NO

NO
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

NO

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

SORDEGR

SORHSCH

SORDEGR_GPA_TRANSFERRED

SORHSCH_GPA

NO

NO

NO
SCHOOL_RANK Person's institution class rank. NUMBER

SORHSCH

SORHSCH_CLASS_RANK

NO

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

SORHSCH

SORHSCH_CLASS_SIZE

NO

NO
SECONDARY_DIPLOMA Person's secondary institution diploma type. For example, college preparatory, vocational, general, etc. VARCHAR2(63)

SORHSCH

SORHSCH_DPLM_CODE

NO

NO
SECONDARY_DIPLOMA_DESC Secondary school diploma description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

SORHSCH

SORHSCH_GRADUATION_DATE

NO

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

SHRTRAM

SHRTRAM_SEQ_NO

NO

NO
TRANSCRIPT_RECEIVED_DATE Date an academic transcript was received. DATE

CALCULATION

SORHSCH

NVL (SHRTRIT_TRANS_DATE_RCVD, SORPCOL_TRANS_RECV_DATE)

SORHSCH_TRANS_RECV_DATE

NO

NO

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

CALCULATION

NVL(SHRTRAM_ACCEPTANCE_DATE, SORPCOL_TRANS_REV_DATE)

NO

NO
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

NO

NO


Ver: 9.2