RETURN TO COMPOSITE VIEW REPORTS LIST
Student Composite View Reports

SGHE Operational Data Store
Composite View Target: AS_PRE_STUDENT

Description Source composite view contains information on the person who has inquired or applied to be a student or has become a student at the institution. Included is secondary and post secondary information.

Target Column Business Definition Database Data Type Source Name Source Column
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

FIRST_CONTACT Type of the earliest contact of the pre-student. VARCHAR2(3)

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(30)

FUNCTION

GOKODSF.F_GET_DESC

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

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(30)

FUNCTION

GOKODSF.F_GET_DESC

LATEST_POST_SECONDARY_DESC Source/background institution name. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

LATEST_POST_SECONDARY_SCHOOL Most recent post secondary institution code for the recruit/applicant. VARCHAR2(6)

FUNCTION

F_CONCAT_SORPCOL

LATEST_SECONDARY_SCHOOL Most recent secondary school of the prospect/applicant identified by graduation date. VARCHAR2(6)

SORHSCH

SORHSCH_SBGI_CODE

LATEST_SECONDARY_SCHOOL_DESC Source/background institution name. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

LATEST_SEC_ATTEND_FROM_DATE First date of attendance at the most recent secondary institution. DATE

NA

NA

LATEST_SEC_ATTEND_TO_DATE Last date of attendance at the most recent secondary institution. DATE

NA

NA

MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER(8)

SARADAP

SRBRECR

SARADAP_PIDM

SRBRECR_PIDM

PS_ATTEND_FROM_DATE First date of attendance at the post secondary institution. DATE

FUNCTION

F_CONCAT_SORPCOL

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

FUNCTION

F_CONCAT_SORPCOL

PS_GPA_TRANSFERRED Transfer GPA. Informational data given on the student application about the post secondary institution listed. NUMBER

FUNCTION

F_CONCAT_SORPCOL

PS_OFFICIAL_TRANSCRIPT_IND Indicates whether the post secondary institution transcript was an official transcript. VARCHAR2(0)

NA

NA

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 the academic transcript was received from the post secondary institution. DATE

FUNCTION

F_CONCAT_SORPCOL

PS_TRANSCRIPT_REVIEWED_DATE Date the academic transcript was received from the post secondary institution. DATE

FUNCTION

F_CONCAT_SORPCOL

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

SORHSCH

SORHSCH_DPLM_CODE

SECONDARY_SCHOOL_DIPLOMA_DESC Secondary school diploma description. VARCHAR2(30)

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(5, 2)

SORHSCH

SORHSCH_PERCENTILE

SECONDARY_SCHOOL_RANK Person's institution class rank. NUMBER(4)

SORHSCH

SORHSCH_CLASS_RANK

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

SORHSCH

SORHSCH_GPA

SECONDARY_SCHOOL_SIZE Size of the person's institution graduating class. NUMBER(4)

SORHSCH

SORHSCH_CLASS_SIZE

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

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

ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA



Ver: 3.1