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

SGHE Banner Operational Data Store
Reporting View Target: PRE_STUDENT

Description Contains detail data for persons who are current active students at the institution. For example, persons who are either an applicant or a prospect of the institution. They will have one pre student record even if they have multiple inquiry records and/or applications. Details included in the pre student view will include last secondary and last post secondary institution attended when appropriate. It will also include a count of test scores recorded in the system for the person.
Key & Frequency One row per person.
Recommended Search Columns PERSON_UID

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)  

NA

NA

CONTACTS_COUNT Contacts Count Count the number of contacts made by the institution and recorded for this pre student. NUMBER  

FUNCTION

MSKFUNC.F_COUNT_CONTACTS

FIRST_CONTACT First Contact Type of the earliest contact of the pre-student. VARCHAR2(63)  

SORCONT

SORCONT_CTYP_CODE

FIRST_CONTACT_DATE First Contact Date First contact of the pre-student by date. DATE  

SORCONT

SORCONT_CONTACT_DATE

FIRST_CONTACT_DESC First Contact Description First contact description. VARCHAR2(255)  

STVCTYP

STVCTYP_DESC

HOLD_COUNT Hold Count Count of the number of holds or restrictions to institution activities recorded for this person. Included may be stop of registration, receipt of a transcript or processing of graduation, etc. NUMBER  

FUNCTION

MSKFUNC.F_COUNT_HOLDS

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

INTERESTS_COUNT Interests Count Count the number of extracurricular interests recorded for this person. NUMBER  

FUNCTION

MSKFUNC.F_COUNT_INTERESTS

LATEST_CONTACT Latest Contact Type of last contact that has been made with the pre-student. VARCHAR2(63)  

SORCONT

SORCONT_CTYP_CODE

LATEST_CONTACT_DATE Latest Contact Date Date of the last contact of the pre-student. DATE  

SORCONT

SORCONT_CONTACT_DATE

LATEST_CONTACT_DESC Latest Contact Description Last contact description. VARCHAR2(255)  

STVCTYP

STVCTYP_DESC

LATEST_POST_SECONDARY_DESC Latest Post Secondary Description Source/background institution name. VARCHAR2(255)  

STVSBGI

STVSBGI_DESC

LATEST_POST_SECONDARY_SCHOOL Latest Post Secondary School Source/background institution code for the prior college. VARCHAR2(63)  

FUNCTION

SOKODSF.F_SORPCOL_INFO

LATEST_SECONDARY_SCHOOL Latest Secondary School Most recent secondary school of the prospect/applicant identified by graduation date. VARCHAR2(63)  

SORHSCH

SORHSCH_SBGI_CODE

LATEST_SECONDARY_SCHOOL_DESC Latest Secondary School Description Source/background institution name. VARCHAR2(255)  

STVSBGI

STVSBGI_DESC

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

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

SARADAP

SRBRECR

SARADAP_PIDM

SRBRECR_PIDM

POST_SECONDARY_DEGREE1 Post Secondary Degree 1 First degree code associated with prior college. VARCHAR2(63)  

SORDEGR

SORDEGR_DEGC_CODE

POST_SECONDARY_DEGREE2 Post Secondary Degree 2 First degree code associated with prior college. VARCHAR2(63)  

SORDEGR

SORDEGR_DEGC_CODE

POST_SECONDARY_DEGREE_DATE1 Post Secondary Degree Date 1 First degree date associated with post secondary institution. DATE  

SORDEGR

SORDEGR_DEGC_DATE

POST_SECONDARY_DEGREE_DATE2 Post Secondary Degree Date 2 First degree date associated with post secondary institution. DATE  

SORDEGR

SORDEGR_DEGC_DATE

POST_SECONDARY_DEGREE_DESC1 Post Secondary Degree Description 1 Degree (e.g., bachelor of business administration, master of arts, juris doctor, etc.) associated with the degree code. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

POST_SECONDARY_DEGREE_DESC2 Post Secondary Degree Description 2 Degree (e.g., bachelor of business administration, master of arts, juris doctor, etc.) associated with the degree code. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

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

SORMAJR

SORMAJR_MAJR_CODE_MAJOR

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

SORMAJR

SORMAJR_MAJR_CODE_MAJOR

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

SORMAJR

SORMAJR_MAJR_CODE_MAJOR

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

POST_SECONDARY_SCHOOL_COUNT Post Secondary School Count Count of post secondary schools. NUMBER  

FUNCTION

MSKFUNC.F_COUNT_INSTITUTION_TYPES

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)  

NA

NA

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

NA

NA

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

NA

NA

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)  

NA

NA

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

NA

NA

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

NA

NA

PS_ATTEND_FROM_DATE Ps Attend From Date First date of attendance at the post secondary institution. DATE  

FUNCTION

SOKODSF.F_SORPCOL_INFO

PS_ATTEND_TO_DATE Ps Attend To Date Last date of attendance at the post secondary institution. DATE  

FUNCTION

SOKODSF.F_SORPCOL_INFO

PS_GPA_TRANSFERRED Ps GPA - Grade Point Average or Average Transferred Person's post secondary institution average or GPA. VARCHAR2(63)  

FUNCTION

SOKODSF.F_SORPCOL_INFO

PS_OFFICIAL_TRANSCRIPT_IND Ps Official Transcript Indicator Indicates whether the transcript was an official transcript. VARCHAR2(1)  

SORPCOL

SORPCOL_OFFICIAL_TRANS

PS_SCHOOL_PERCENTILE Ps School Percentile Prospect/applicant's class percentile as related to class rank and size at the previous institution. NUMBER  

NA

NA

PS_SCHOOL_RANK Ps School Rank Prospect/applicant's previous institution class rank. NUMBER  

NA

NA

PS_SCHOOL_SIZE Ps School Size Size of the prospect/applicant's previous institution graduating class. NUMBER  

NA

NA

PS_TRANSCRIPT_RECEIVED_DATE Ps Transcript Received Date Date an academic transcript was received. DATE  

FUNCTION

SOKODSF.F_SORPCOL_INFO

PS_TRANSCRIPT_REVIEWED_DATE Ps Transcript Reviewed Date Date an academic transcript was reviewed. DATE  

FUNCTION

SOKODSF.F_SORPCOL_INFO

SECONDARY_ATTEND_FROM_DATE Secondary Attend From Date Date the high school was attended from. DATE  

NA

NA

SECONDARY_ATTEND_TO_DATE Secondary Attend To Date Date the high school was attended to. DATE  

NA

NA

SECONDARY_SCHOOL_COUNT Secondary School Count Count of the secondary schools recorded as attended for this person. NUMBER  

FUNCTION

MSKFUNC.F_COUNT_INSTITUTION_TYPES

SECONDARY_SCHOOL_DIPLOMA Secondary School Diploma Person's secondary institution diploma type. For example, college preparatory, vocational, general, etc. VARCHAR2(63)  

SORHSCH

SORHSCH_DPLM_CODE

SECONDARY_SCHOOL_DIPLOMA_DESC Secondary School Diploma Description Secondary school diploma description. VARCHAR2(255)  

STVDPLM

STVDPLM_DESC

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

SORHSCH

SORHSCH_GRADUATION_DATE

SECONDARY_SCHOOL_PERCENTILE Secondary School Percentile Person's class percentile as related to class rank and size. NUMBER  

SORHSCH

SORHSCH_PERCENTILE

SECONDARY_SCHOOL_RANK Secondary School Rank Person's institution class rank. NUMBER  

SORHSCH

SORHSCH_CLASS_RANK

SECONDARY_SCHOOL_REPORTED_GPA Secondary School Reported GPA - Grade Point Average or Average Person's secondary institution average or GPA. VARCHAR2(63)  

SORHSCH

SORHSCH_GPA

SECONDARY_SCHOOL_SIZE Secondary School Size Size of the person's institution graduating class. NUMBER  

SORHSCH

SORHSCH_CLASS_SIZE

SECONDARY_SUBJECT_COUNT Secondary Subject Count Count of the secondary school subjects recorded for this person. NUMBER  

FUNCTION

MSKFUNC.F_COUNT_SECONDARY_SUBJECTS

SEC_OFFICIAL_TRANSCRIPT_IND Sec Official Transcript Indicator Indicates whether the most recent secondary institution transcript was an official transcript. VARCHAR2(1)  

NA

NA

SEC_TRANSCRIPT_RECEIVED_DATE Sec Transcript Received Date Date an secondary school academic transcript was received. DATE  

SORHSCH

SORHSCH_TRANS_RECV_DATE

SEC_TRANSCRIPT_REVIEWED_DATE Sec Transcript Reviewed Date Date an academic transcript was reviewed by the institution. DATE  

NA

NA

TEST_COUNT Test Count Count of the number of test scores recorded for this person. NUMBER  

FUNCTION

MSKFUNC.F_COUNT_TESTS



Ver: 9.0