Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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(8)		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(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: