RETURN TO REPORTING VIEW REPORTS LIST
(EDW Source Report)
Student Reporting View Reports

SGHE 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 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 Organization-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)

FUNCTION

GOKODSF.F_GET_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 Person's or organization's current identification number. 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)

FUNCTION

GOKODSF.F_GET_DESC

LATEST_POST_SECONDARY_DESC Source/background institution name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SORPCOL

SORPCOL_SBGI_CODE

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)

FUNCTION

GOKODSF.F_GET_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(94)

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

SORDEGR

SORDEGR_ATTEND_FROM

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

SORDEGR

SORDEGR_ATTEND_TO

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

SORDEGR

SORDEGR_GPA_TRANSFERRED

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

SORPCOL

SORPCOL_TRANS_RECV_DATE

PS_TRANSCRIPT_REVIEWED_DATE Date an academic transcript was reviewed. DATE

SORPCOL

SORPCOL_TRANS_REV_DATE

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)

FUNCTION

GOKODSF.F_GET_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: 3.1