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	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.	VARCHAR2(0)	NA	NA
COLLEGE	Identifies the college code associated with the post secondary institution.	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(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		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(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 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)	CONSTANT	'H'
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: