ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
CURRENT_DATE	System current date (sysdate) or date the data was extracted.			NA	SYSDATE
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.			NA	NA
FIRST_CONTACT	Type of the earliest contact of the pre-student.			SORCONT	SORCONT_CTYP_CODE
FIRST_CONTACT_DATE	First contact of the pre-student by date.			SORCONT	SORCONT_CONTACT_DATE
FIRST_CONTACT_DESC	First contact description.			STVCTYP	STVCTYP_DESC
LATEST_CONTACT	Type of last contact that has been made with the pre-student.			SORCONT	SORCONT_CTYP_CODE
LATEST_CONTACT_DATE	Date of the last contact of the pre-student.			SORCONT	SORCONT_CONTACT_DATE
LATEST_CONTACT_DESC	Last contact description.			STVCTYP	STVCTYP_DESC
LATEST_POST_SECONDARY_DESC	Source/background institution name.			STVSBGI	STVSBGI_DESC
LATEST_POST_SECONDARY_SCHOOL	Most recent post secondary institution code for the recruit/applicant.			FUNCTION	SOKODSF.F_SORPCOL_INFO
LATEST_SECONDARY_SCHOOL	Most recent secondary school of the prospect/applicant identified by graduation date.			SORHSCH	SORHSCH_SBGI_CODE
LATEST_SECONDARY_SCHOOL_DESC	Source/background institution name.			STVSBGI	STVSBGI_DESC
LATEST_SEC_ATTEND_FROM_DATE	First date of attendance at the most recent secondary institution.			NA	NA
LATEST_SEC_ATTEND_TO_DATE	Last date of attendance at the most recent secondary institution.			NA	NA
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.			NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.			NA	NA
PERSON_UID	System generated, unique, internal identification number assigned to this person.			SARADAP SRBRECR	SARADAP_PIDM SRBRECR_PIDM
PS_ATTEND_FROM_DATE	First date of attendance at the post secondary institution.			FUNCTION	SOKODSF.F_SORPCOL_INFO
PS_ATTEND_TO_DATE	Last date of attendance at the post secondary institution.			FUNCTION	SOKODSF.F_SORPCOL_INFO
PS_GPA_TRANSFERRED	Transfer GPA. Informational data given on the student application about the post secondary institution listed.			FUNCTION	SOKODSF.F_SORPCOL_INFO
PS_OFFICIAL_TRANSCRIPT_IND	Indicates whether the post secondary institution transcript was an official transcript.			NA	NA
PS_SCHOOL_PERCENTILE	Prospect/applicant's class percentile as related to class rank and size at the previous institution.			NA	NA
PS_SCHOOL_RANK	Prospect/applicant's previous institution class rank.			NA	NA
PS_SCHOOL_SIZE	Size of the prospect/applicant's previous institution graduating class.			NA	NA
PS_TRANSCRIPT_RECEIVED_DATE	Date the academic transcript was received from the post secondary institution.			FUNCTION	SOKODSF.F_SORPCOL_INFO
PS_TRANSCRIPT_REVIEWED_DATE	Date the academic transcript was received from the post secondary institution.			FUNCTION	SOKODSF.F_SORPCOL_INFO
SECONDARY_SCHOOL_DIPLOMA	Person's secondary institution diploma type. For example, college preparatory, vocational, general, etc.			SORHSCH	SORHSCH_DPLM_CODE
SECONDARY_SCHOOL_DIPLOMA_DESC	Secondary school diploma description.			STVDPLM	STVDPLM_DESC
SECONDARY_SCHOOL_GRAD_DATE	Person's graduation date from the secondary institution.			SORHSCH	SORHSCH_GRADUATION_DATE
SECONDARY_SCHOOL_PERCENTILE	Person's class percentile as related to class rank and size.			SORHSCH	SORHSCH_PERCENTILE
SECONDARY_SCHOOL_RANK	Person's institution class rank.			SORHSCH	SORHSCH_CLASS_RANK
SECONDARY_SCHOOL_REPORTED_GPA	Person's secondary institution average or GPA.			SORHSCH	SORHSCH_GPA
SECONDARY_SCHOOL_SIZE	Size of the person's institution graduating class.			SORHSCH	SORHSCH_CLASS_SIZE
SEC_OFFICIAL_TRANSCRIPT_IND	Indicates whether the most recent secondary institution transcript was an official transcript.			NA	NA
SEC_TRANSCRIPT_RECEIVED_DATE	Date an secondary school academic transcript was received.			SORHSCH	SORHSCH_TRANS_RECV_DATE
SEC_TRANSCRIPT_REVIEWED_DATE	Date an academic transcript was reviewed by the institution.			NA	NA
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA

Ver: 8.3