Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ATTEND_FROM_DATE		Previous education first date of attendance.	DATE		NA	NA
ATTEND_TO_DATE		Previous education last date of attendance.	DATE		NA	NA
AWARD_CATEGORY	Award Category	Award category associated with the outcome, degree or award. Category used to group outcomes for reporting similar awards together. For example, less than two year, two year and four year awards.	VARCHAR2(0)		NA	NA
AWARD_CATEGORY_DESC	Award Category Description.	Award category description.	VARCHAR2(0)		NA	NA
COLLEGE	College	Identifies the college code associated with the post secondary institution.	VARCHAR2(0)		NA	NA
COLLEGE_DESC	College Description	Identifies the college code description associated with the post secondary institution.	VARCHAR2(0)		NA	NA
COLLEGE_PREP		Indicates whether the prospect/applicant's secondary school program was college preparatory.	VARCHAR2(1)		SORHSCH	SORHSCH_COLL_PREP_IND
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
EDUCATION_ACTIVITY_DATE	Education Activity Date	Identifies the last date this record was created or updated.	DATE		SORHSCH	SORHSCH_ACTIVITY_DATE
EDUCATION_DATA_ORIGIN	Education Data Origin		VARCHAR2(30)
EDUCATION_GOAL		Recorded education goal from the secondary or post secondary institution.	VARCHAR2(0)		NA	NA
EDUCATION_GOAL_DESC		Educational goal description.	VARCHAR2(0)		NA	NA
EDUCATION_USER_ID	Education User ID		VARCHAR2(30)
INSTITUTION		Source/ background institution code for the high school.	VARCHAR2(6)		SORHSCH	SORHSCH_SBGI_CODE
INSTITUTION_DESC		Source/background institution name.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
INSTITUTION_TYPE		Identifies a type for the source/background institution to be used for reporting.	VARCHAR2(1)		STVSBGI	STVSBGI_TYPE_IND
INSTITUTION_TYPE_DESC		This field specifies the source/background institution type.	VARCHAR2(30)		CONSTANT	'HIGHSCHOOL'
MIF_DESC		Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE		Not a valid column for any secondary school input to the ODS tables.	VARCHAR2(6)		NA	NA
OFFICIAL_TRANSCRIPT_IND		Indicates whether the transcript was an official transcript.	VARCHAR2(0)		NA	NA
PERCENTILE		Person's class percentile as related to class rank and size.	NUMBER(5, 2)		SORHSCH	SORHSCH_PERCENTILE
PERSON_UID		System generated, unique, internal identification number assigned to this person.	NUMBER(8)		SORHSCH	SORHSCH_PIDM
POST_SECONDARY_DEGREE		Not a valid column for any secondary school input to the ODS tables.	VARCHAR2(0)		NA	NA
POST_SECONDARY_DEGREE_DATE		Not a valid column for any secondary school input to the ODS tables.	DATE		NA	NA
POST_SECONDARY_DEGREE_DESC		Not a valid column for any secondary school input to the ODS tables.	VARCHAR2(0)		NA	NA
POST_SECONDARY_DEGREE_SEQUENCE		Not a valid column for any secondary school input to the ODS tables.	NUMBER		NA	NA
POST_SECONDARY_DEGREE_YEAR		Not a valid column for any secondary school input to the ODS tables.	VARCHAR2(0)		NA	NA
POST_SECONDARY_HONORS		Not a valid column for any secondary school input to the ODS tables.	VARCHAR2(0)		NA	NA
POST_SECONDARY_HONORS_DESC		Not a valid column for any secondary school input to the ODS tables.	VARCHAR2(0)		NA	NA
POST_SECONDARY_MAJOR1		Not a valid column for any secondary school input to the ODS tables.	VARCHAR2(0)		NA	NA
POST_SECONDARY_MAJOR2		Not a valid column for any secondary school input to the ODS tables.	VARCHAR2(0)		NA	NA
POST_SECONDARY_MAJOR3		Not a valid column for any secondary school input to the ODS tables.	VARCHAR2(0)		NA	NA
POST_SECONDARY_MAJOR_DESC1		Not a valid column for any secondary school input to the ODS tables.	VARCHAR2(0)		NA	NA
POST_SECONDARY_MAJOR_DESC2		Not a valid column for any secondary school input to the ODS tables.	VARCHAR2(0)		NA	NA
POST_SECONDARY_MAJOR_DESC3		Not a valid column for any secondary school input to the ODS tables.	VARCHAR2(0)		NA	NA
PROGRAM_CLASSIFICATION1		Not a valid column for any secondary school input to the ODS tables.	VARCHAR2(0)		NA	NA
PROGRAM_CLASSIFICATION2		Not a valid column for any secondary school input to the ODS tables.	VARCHAR2(0)		NA	NA
PROGRAM_CLASSIFICATION3		Not a valid column for any secondary school input to the ODS tables.	VARCHAR2(0)		NA	NA
PROGRAM_CLASSIFICATION_DESC1		Not a valid column for any secondary school input to the ODS tables.	VARCHAR2(0)		NA	NA
PROGRAM_CLASSIFICATION_DESC2		Not a valid column for any secondary school input to the ODS tables.	VARCHAR2(0)		NA	NA
PROGRAM_CLASSIFICATION_DESC3		Not a valid column for any secondary school input to the ODS tables.	VARCHAR2(0)		NA	NA
REQUIREMENT	Requirement		VARCHAR2(4)
REQUIREMENT_DESC	Requirement Description		VARCHAR2(30)
SCHOOL_GPA		Person's secondary institution average or GPA.	VARCHAR2(24)		SORHSCH	SORHSCH_GPA
SCHOOL_RANK		Person's institution class rank.	NUMBER(4)		SORHSCH	SORHSCH_CLASS_RANK
SCHOOL_SIZE		Size of the person's institution graduating class.	NUMBER(4)		SORHSCH	SORHSCH_CLASS_SIZE
SECONDARY_DIPLOMA		Person's secondary institution diploma type. For example, college preparatory, vocational, general, etc.	VARCHAR2(2)		SORHSCH	SORHSCH_DPLM_CODE
SECONDARY_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
SEQUENCE_NUMBER	Sequence Number	Sequence number of the attendance period from the transfer institution.	NUMBER		NA	NA
SOURCE_FLAG	Source Flag	Identifies which source view this records comes from, P for AS_PREVIOUS_EDUCATION_PCOL and H for AS_PREVIOUS_EDUCATION_HSCH. It is used in relation to the OWB mappings.	VARCHAR2(1)
TOTAL_TRANSFER_CREDITS		Not a valid column for any secondary school input to the ODS tables.	NUMBER		NA	NA
TRANSCRIPT_RECEIVED_DATE		Date an academic transcript was received.	DATE		SORHSCH	SORHSCH_TRANS_RECV_DATE
TRANSCRIPT_REVIEWED_DATE		Identifies the date the transcript was reviewed.	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: