Reporting View Target: PRE

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 Definition Database Data Type Source Name Source Column

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

NA

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 Type of the earliest contact of the pre-student. VARCHAR2(63)
SORCONT

SORCONT_CTYP_CODE

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

SORCONT_CONTACT_DATE

FIRST_CONTACT_DESC First contact description. VARCHAR2(255)
STVCTYP

STVCTYP_DESC

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

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

MSKFUNC.F_COUNT_INTERESTS

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

SORCONT_CTYP_CODE

LATEST_CONTACT_DATE Date of the last contact of the pre-student. DATE
SORCONT

SORCONT_CONTACT_DATE

LATEST_CONTACT_DESC Last contact description. VARCHAR2(255)
STVCTYP

STVCTYP_DESC

LATEST_POST_SECONDARY_DESC Source/background institution name. VARCHAR2(255)
STVSBGI

STVSBGI_DESC

LATEST_POST_SECONDARY_SCHOOL Source/background institution code for the prior college. VARCHAR2(63)
FUNCTION

SOKODSF.F_SORPCOL_INFO

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

STVSBGI_DESC

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

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

SARADAP_PIDM
SRBRECR_PIDM

POST_SECONDARY_DEGREE1 First degree code associated with prior college. VARCHAR2(63)
SORDEGR

SORDEGR_DEGC_CODE

POST_SECONDARY_DEGREE2 First degree code associated with prior college. VARCHAR2(63)
SORDEGR

SORDEGR_DEGC_CODE

POST_SECONDARY_DEGREE_DATE1 First degree date associated with post secondary institution. DATE
SORDEGR

SORDEGR_DEGC_DATE

POST_SECONDARY_DEGREE_DATE2 First degree date associated with post secondary institution. DATE
SORDEGR

SORDEGR_DEGC_DATE

POST_SECONDARY_DEGREE_DESC1 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 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 First major code associated with the post secondary institution. VARCHAR2(63)
SORMAJR

SORMAJR_MAJR_CODE_MAJOR

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

SORMAJR_MAJR_CODE_MAJOR

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

SORMAJR_MAJR_CODE_MAJOR

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

GOKODSF.F_GET_DESC

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

GOKODSF.F_GET_DESC

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

GOKODSF.F_GET_DESC

POST_SECONDARY_SCHOOL_COUNT Count of post secondary schools. NUMBER
FUNCTION

MSKFUNC.F_COUNT_INSTITUTION_TYPES

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

NA

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

NA

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

NA

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

NA

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

NA

PROGRAM_CLASSIFICATION3_DESC 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 First date of attendance at the post secondary institution. DATE
FUNCTION

SOKODSF.F_SORPCOL_INFO

PS_ATTEND_TO_DATE Last date of attendance at the post secondary institution. DATE
FUNCTION

SOKODSF.F_SORPCOL_INFO

PS_GPA_TRANSFERRED Person's post secondary institution average or GPA. VARCHAR2(63)
FUNCTION

SOKODSF.F_SORPCOL_INFO

PS_OFFICIAL_TRANSCRIPT_IND Indicates whether the transcript was an official transcript. VARCHAR2(1)
SORPCOL

SORPCOL_OFFICIAL_TRANS

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 Prospect/applicant's previous institution class rank. NUMBER
NA

NA

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

NA

PS_TRANSCRIPT_RECEIVED_DATE Date an academic transcript was received. DATE
FUNCTION

SOKODSF.F_SORPCOL_INFO

PS_TRANSCRIPT_REVIEWED_DATE Date an academic transcript was reviewed. DATE
FUNCTION

SOKODSF.F_SORPCOL_INFO

SECONDARY_ATTEND_FROM_DATE Date the high school was attended from. DATE
NA

NA

SECONDARY_ATTEND_TO_DATE Date the high school was attended to. DATE
NA

NA

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

MSKFUNC.F_COUNT_INSTITUTION_TYPES

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. VARCHAR2(255)
STVDPLM

STVDPLM_DESC

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

SORHSCH_GRADUATION_DATE

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

SORHSCH_PERCENTILE

SECONDARY_SCHOOL_RANK Person's institution class rank. NUMBER
SORHSCH

SORHSCH_CLASS_RANK

SECONDARY_SCHOOL_REPORTED_GPA Person's secondary institution average or GPA. VARCHAR2(63)
SORHSCH

SORHSCH_GPA

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

SORHSCH_CLASS_SIZE

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

MSKFUNC.F_COUNT_SECONDARY_SUBJECTS

SEC_OFFICIAL_TRANSCRIPT_IND Indicates whether the most recent secondary institution transcript was an official transcript. VARCHAR2(1)
NA

NA

SEC_TRANSCRIPT_RECEIVED_DATE Date an secondary school academic transcript was received. DATE
SORHSCH

SORHSCH_TRANS_RECV_DATE

SEC_TRANSCRIPT_REVIEWED_DATE Date an academic transcript was reviewed by the institution. DATE
NA

NA

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

MSKFUNC.F_COUNT_TESTS

Ver: 8.5

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 Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
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	Type of the earliest contact of the pre-student.	VARCHAR2(63)	SORCONT	SORCONT_CTYP_CODE
FIRST_CONTACT_DATE	First contact of the pre-student by date.	DATE	SORCONT	SORCONT_CONTACT_DATE
FIRST_CONTACT_DESC	First contact description.	VARCHAR2(255)	STVCTYP	STVCTYP_DESC
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	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
INTERESTS_COUNT	Count the number of extracurricular interests recorded for this person.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_INTERESTS
LATEST_CONTACT	Type of last contact that has been made with the pre-student.	VARCHAR2(63)	SORCONT	SORCONT_CTYP_CODE
LATEST_CONTACT_DATE	Date of the last contact of the pre-student.	DATE	SORCONT	SORCONT_CONTACT_DATE
LATEST_CONTACT_DESC	Last contact description.	VARCHAR2(255)	STVCTYP	STVCTYP_DESC
LATEST_POST_SECONDARY_DESC	Source/background institution name.	VARCHAR2(255)	STVSBGI	STVSBGI_DESC
LATEST_POST_SECONDARY_SCHOOL	Source/background institution code for the prior college.	VARCHAR2(63)	FUNCTION	SOKODSF.F_SORPCOL_INFO
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	Source/background institution name.	VARCHAR2(255)	STVSBGI	STVSBGI_DESC
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
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SARADAP SRBRECR	SARADAP_PIDM SRBRECR_PIDM
POST_SECONDARY_DEGREE1	First degree code associated with prior college.	VARCHAR2(63)	SORDEGR	SORDEGR_DEGC_CODE
POST_SECONDARY_DEGREE2	First degree code associated with prior college.	VARCHAR2(63)	SORDEGR	SORDEGR_DEGC_CODE
POST_SECONDARY_DEGREE_DATE1	First degree date associated with post secondary institution.	DATE	SORDEGR	SORDEGR_DEGC_DATE
POST_SECONDARY_DEGREE_DATE2	First degree date associated with post secondary institution.	DATE	SORDEGR	SORDEGR_DEGC_DATE
POST_SECONDARY_DEGREE_DESC1	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	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	First major code associated with the post secondary institution.	VARCHAR2(63)	SORMAJR	SORMAJR_MAJR_CODE_MAJOR
POST_SECONDARY_MAJOR2	Second major code associated with the post secondary institution.	VARCHAR2(63)	SORMAJR	SORMAJR_MAJR_CODE_MAJOR
POST_SECONDARY_MAJOR3	Third major code associated with the post secondary institution.	VARCHAR2(63)	SORMAJR	SORMAJR_MAJR_CODE_MAJOR
POST_SECONDARY_MAJOR_DESC1	First major code description associated with the post secondary institution.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
POST_SECONDARY_MAJOR_DESC2	Second major code description associated with the post secondary institution.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
POST_SECONDARY_MAJOR_DESC3	Third major code description associated with the post secondary institution.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
POST_SECONDARY_SCHOOL_COUNT	Count of post secondary schools.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_INSTITUTION_TYPES
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)	NA	NA
PROGRAM_CLASSIFICATION1_DESC	Classification of Institutional Programs (CIP) code description for the first major code associated with the post secondary institution.	VARCHAR2(255)	NA	NA
PROGRAM_CLASSIFICATION2	Classification of Institutional Programs (CIP) code of the second major code associated with the post secondary institution.	VARCHAR2(63)	NA	NA
PROGRAM_CLASSIFICATION2_DESC	Classification of Institutional Programs (CIP) code for the second major code associated with the post secondary institution.	VARCHAR2(255)	NA	NA
PROGRAM_CLASSIFICATION3	Classification of Institutional Programs (CIP) code of the third major code associated with the post secondary institution.	VARCHAR2(63)	NA	NA
PROGRAM_CLASSIFICATION3_DESC	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	First date of attendance at the post secondary institution.	DATE	FUNCTION	SOKODSF.F_SORPCOL_INFO
PS_ATTEND_TO_DATE	Last date of attendance at the post secondary institution.	DATE	FUNCTION	SOKODSF.F_SORPCOL_INFO
PS_GPA_TRANSFERRED	Person's post secondary institution average or GPA.	VARCHAR2(63)	FUNCTION	SOKODSF.F_SORPCOL_INFO
PS_OFFICIAL_TRANSCRIPT_IND	Indicates whether the transcript was an official transcript.	VARCHAR2(1)	SORPCOL	SORPCOL_OFFICIAL_TRANS
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	Prospect/applicant's previous institution class rank.	NUMBER	NA	NA
PS_SCHOOL_SIZE	Size of the prospect/applicant's previous institution graduating class.	NUMBER	NA	NA
PS_TRANSCRIPT_RECEIVED_DATE	Date an academic transcript was received.	DATE	FUNCTION	SOKODSF.F_SORPCOL_INFO
PS_TRANSCRIPT_REVIEWED_DATE	Date an academic transcript was reviewed.	DATE	FUNCTION	SOKODSF.F_SORPCOL_INFO
SECONDARY_ATTEND_FROM_DATE	Date the high school was attended from.	DATE	NA	NA
SECONDARY_ATTEND_TO_DATE	Date the high school was attended to.	DATE	NA	NA
SECONDARY_SCHOOL_COUNT	Count of the secondary schools recorded as attended for this person.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_INSTITUTION_TYPES
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.	VARCHAR2(255)	STVDPLM	STVDPLM_DESC
SECONDARY_SCHOOL_GRAD_DATE	Person's graduation date from the secondary institution.	DATE	SORHSCH	SORHSCH_GRADUATION_DATE
SECONDARY_SCHOOL_PERCENTILE	Person's class percentile as related to class rank and size.	NUMBER	SORHSCH	SORHSCH_PERCENTILE
SECONDARY_SCHOOL_RANK	Person's institution class rank.	NUMBER	SORHSCH	SORHSCH_CLASS_RANK
SECONDARY_SCHOOL_REPORTED_GPA	Person's secondary institution average or GPA.	VARCHAR2(63)	SORHSCH	SORHSCH_GPA
SECONDARY_SCHOOL_SIZE	Size of the person's institution graduating class.	NUMBER	SORHSCH	SORHSCH_CLASS_SIZE
SECONDARY_SUBJECT_COUNT	Count of the secondary school subjects recorded for this person.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_SECONDARY_SUBJECTS
SEC_OFFICIAL_TRANSCRIPT_IND	Indicates whether the most recent secondary institution transcript was an official transcript.	VARCHAR2(1)	NA	NA
SEC_TRANSCRIPT_RECEIVED_DATE	Date an secondary school academic transcript was received.	DATE	SORHSCH	SORHSCH_TRANS_RECV_DATE
SEC_TRANSCRIPT_REVIEWED_DATE	Date an academic transcript was reviewed by the institution.	DATE	NA	NA
TEST_COUNT	Count of the number of test scores recorded for this person.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_TESTS