Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Student Composite View Reports

Banner 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 Local Source Local Target
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

NO

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

NA

NA

NO

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

SORCONT

SORCONT_CTYP_CODE

NO

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

SORCONT

SORCONT_CONTACT_DATE

NO

NO
FIRST_CONTACT_DESC First contact description. VARCHAR2(30)

STVCTYP

STVCTYP_DESC

NO

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

SORCONT

SORCONT_CTYP_CODE

NO

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

SORCONT

SORCONT_CONTACT_DATE

NO

NO
LATEST_CONTACT_DESC Last contact description. VARCHAR2(30)

STVCTYP

STVCTYP_DESC

NO

NO
LATEST_POST_SECONDARY_DESC Source/background institution name. VARCHAR2(30)

STVSBGI

STVSBGI_DESC

NO

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

FUNCTION

SOKODSF.F_SORPCOL_INFO

NO

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

SORHSCH

SORHSCH_SBGI_CODE

NO

NO
LATEST_SECONDARY_SCHOOL_DESC Source/background institution name. VARCHAR2(30)

STVSBGI

STVSBGI_DESC

NO

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

NA

NA

NO

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

NA

NA

NO

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

NA

NA

NO

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

NA

NA

NO

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

SARADAP

SRBRECR

SARADAP_PIDM

SRBRECR_PIDM

NO

NO

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

FUNCTION

SOKODSF.F_SORPCOL_INFO

NO

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

FUNCTION

SOKODSF.F_SORPCOL_INFO

NO

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

FUNCTION

SOKODSF.F_SORPCOL_INFO

NO

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

NA

NA

NO

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

NA

NA

NO

NO
PS_SCHOOL_RANK Prospect/applicant's previous institution class rank. NUMBER

NA

NA

NO

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

NA

NA

NO

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

FUNCTION

SOKODSF.F_SORPCOL_INFO

NO

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

FUNCTION

SOKODSF.F_SORPCOL_INFO

NO

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

SORHSCH

SORHSCH_DPLM_CODE

NO

NO
SECONDARY_SCHOOL_DIPLOMA_DESC Secondary school diploma description. VARCHAR2(30)

STVDPLM

STVDPLM_DESC

NO

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

SORHSCH

SORHSCH_GRADUATION_DATE

NO

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

SORHSCH

SORHSCH_PERCENTILE

NO

NO
SECONDARY_SCHOOL_RANK Person's institution class rank. NUMBER

SORHSCH

SORHSCH_CLASS_RANK

NO

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

SORHSCH

SORHSCH_GPA

NO

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

SORHSCH

SORHSCH_CLASS_SIZE

NO

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

NA

NA

NO

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

SORHSCH

SORHSCH_TRANS_RECV_DATE

NO

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

NA

NA

NO

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

NA

NA

NO

NO


Ver: