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)	STVCTYP	STVCTYP_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)	STVCTYP	STVCTYP_DESC
LATEST_POST_SECONDARY_DESC	Source/background institution name.	VARCHAR2(30)	STVSBGI	STVSBGI_DESC
LATEST_POST_SECONDARY_SCHOOL	Most recent post secondary institution code for the recruit/applicant.	VARCHAR2(6)	FUNCTION	SOKODSF.F_SORPCOL_INFO
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)	STVSBGI	STVSBGI_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	SARADAP SRBRECR	SARADAP_PIDM SRBRECR_PIDM
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	Transfer GPA. Informational data given on the student application about the post secondary institution listed.	NUMBER	FUNCTION	SOKODSF.F_SORPCOL_INFO
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	SOKODSF.F_SORPCOL_INFO
PS_TRANSCRIPT_REVIEWED_DATE	Date the academic transcript was received from the post secondary institution.	DATE	FUNCTION	SOKODSF.F_SORPCOL_INFO
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)	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(24)	SORHSCH	SORHSCH_GPA
SECONDARY_SCHOOL_SIZE	Size of the person's institution graduating class.	NUMBER	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: