Target Column	Business Definition	Database Data Type	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	Government reporting category that groups awards and degrees together to count students. For example, Less than 2 yr, 2 yr, Bachelor, etc.	VARCHAR2(0)	NA	NA
AWARD_CATEGORY_DESC	Award category description.	VARCHAR2(0)	NA	NA
COLLEGE	First level of the institution organization structure that owns the student or the academic instruction for a student course.	VARCHAR2(0)	NA	NA
COLLEGE_DESC	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	Identifies the last date this record was created or updated.	DATE	SORHSCH	SORHSCH_ACTIVITY_DATE
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		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	SORHSCH	SORHSCH_PERCENTILE
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	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		VARCHAR2(4)
REQUIREMENT_DESC		VARCHAR2(30)
SCHOOL_GPA	Person's secondary institution average or GPA.	VARCHAR2(24)	SORHSCH	SORHSCH_GPA
SCHOOL_RANK	Person's institution class rank.	NUMBER	SORHSCH	SORHSCH_CLASS_RANK
SCHOOL_SIZE	Size of the person's institution graduating class.	NUMBER	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 of the attendance period from the transfer institution.	NUMBER	NA	NA
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: