Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ATTEND_FROM_DATE	Attend From Date	Previous education first date of attendance.	DATE		SHRTRAM	SHRTRAM_ATTN_BEGIN_DATE
ATTEND_TO_DATE	Attend To Date	Previous education last date of attendance.	DATE		SHRTRAM	SHRTRAM_ATTN_END_DATE
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(2)		STVDEGC	STVDEGC_ACAT_CODE
AWARD_CATEGORY_DESC		Award category description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
COLLEGE	College	Identifies the college code associated with the post secondary institution.	VARCHAR2(2)		SORDEGR	SORDEGR_COLL_CODE
COLLEGE_DESC	College Description	Identifies the college code description associated with the post secondary institution.	VARCHAR2(30)		STVCOLL	STVCOLL_DESC
COLLEGE_PREP		This field indicates whether the prospect/applicant high school program was college prep.	VARCHAR2(1)		NA	NA
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		SHRTRAM SHRTRIT SORPCOL	SHRTRAM_ACTIVITY_DATE SHRTRIT_ACTIVITY_DATE SORPCOL_ACTIVITY_DATE
EDUCATION_DATA_ORIGIN	Education Data Origin		VARCHAR2(30)
EDUCATION_GOAL	Education Goal	Recorded education goal from the secondary or post secondary institution.	VARCHAR2(2)		SORDEGR	SORDEGR_EGOL_CODE
EDUCATION_GOAL_DESC	Education Goal Description	Educational goal description.	VARCHAR2(30)		STVEGOL	STVEGOL_DESC
EDUCATION_USER_ID	Education User ID		VARCHAR2(30)
INSTITUTION	Institution	Source/background institution code for the prior college.	VARCHAR2(6)		SHRTRIT	SHRTRIT_SBGI_CODE
INSTITUTION_DESC		Source/background institution name.	VARCHAR2(30)		STVSBGI	STVSBGI_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	'COLLEGE'
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
OFFICIAL_TRANSCRIPT_IND	Official Transcript Indicator	Indicates whether the transcript was an official transcript.	VARCHAR2(1)		SHRTRIT	SHRTRIT_OFFICIAL_TRANS_IND
PERCENTILE		Person's class percentile as related to class rank and size.	NUMBER		NA	NA
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER(8)		SHRTRIT	SHRTRIT_PIDM
POST_SECONDARY_DEGREE	Post Secondary Degree	First degree code associated with prior college.	VARCHAR2(6)		SHRTRAM	SHRTRAM_DEGC_CODE
POST_SECONDARY_DEGREE_DATE		First degree date associated with post secondary institution.	DATE		SORDEGR	SORDEGR_DEGC_DATE
POST_SECONDARY_DEGREE_DESC		Degree (e.g., bachelor of business administration, master of arts, juris doctor, etc.) associated with the degree code.	VARCHAR2(30)		STVDEGC	STVDEGC_DESC
POST_SECONDARY_DEGREE_SEQUENCE		First degree sequence associated with post secondary institution.	NUMBER(2)		SORDEGR	SORDEGR_DEGR_SEQ_NO
POST_SECONDARY_DEGREE_YEAR		First degree year associated with post secondary institution.	VARCHAR2(4)		SORDEGR	SORDEGR_DEGC_YEAR
POST_SECONDARY_HONORS	Post Secondary Honors	Previous institution award honors earned and recorded for the person.	VARCHAR2(6)		SORDEGR	SORDEGR_HONR_CODE
POST_SECONDARY_HONORS_DESC	Post Secondary Honors Description	Previous institution honors description.	VARCHAR2(30)		STVHONR	STVHONR_DESC
POST_SECONDARY_MAJOR1		First major code associated with the post secondary institution.	VARCHAR2(4)		FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
POST_SECONDARY_MAJOR2		Second major code associated with the post secondary institution.	VARCHAR2(4)		FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
POST_SECONDARY_MAJOR3		Third major code associated with the post secondary institution.	VARCHAR2(4)		FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
POST_SECONDARY_MAJOR_DESC1		First major code description associated with the post secondary institution.	VARCHAR2(30)		FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
POST_SECONDARY_MAJOR_DESC2		Second major code description associated with the post secondary institution.	VARCHAR2(30)		FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
POST_SECONDARY_MAJOR_DESC3		Third major code description associated with the post secondary institution.	VARCHAR2(30)		FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
PROGRAM_CLASSIFICATION1		Program classification associated with the major subject area of study for this outcome. Classification of Institutional Programs (CIP) codes used for reporting outcomes to the federal government.	VARCHAR2(6)		FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
PROGRAM_CLASSIFICATION2		Program classification associated with the major subject area of study for this outcome. Classification of Institutional Programs (CIP) codes used for reporting outcomes to the federal government.	VARCHAR2(6)		FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
PROGRAM_CLASSIFICATION3		Program classification associated with the major subject area of study for this outcome. Classification of Institutional Programs (CIP) codes used for reporting outcomes to the federal government.	VARCHAR2(6)		FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
PROGRAM_CLASSIFICATION_DESC1	Program Classification Description 1	Program classification description.	VARCHAR2(80)		FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
PROGRAM_CLASSIFICATION_DESC2	Program Classification Description 2	Program classification description.	VARCHAR2(80)		FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
PROGRAM_CLASSIFICATION_DESC3	Program Classification Description 3	Program classification description.	VARCHAR2(80)		FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
REQUIREMENT	Requirement		VARCHAR2(4)
REQUIREMENT_DESC	Requirement Description		VARCHAR2(30)
SCHOOL_GPA		Person's post secondary institution average or GPA.	VARCHAR2(40)		SORDEGR	SORDEGR_GPA_TRANSFERRED
SCHOOL_RANK		Person's institution class rank.	NUMBER		NA	NA
SCHOOL_SIZE		Size of the person's institution graduating class.	NUMBER		NA	NA
SECONDARY_DIPLOMA		This field indicates the persons most secondary institution diploma type, i.e., college prep.	VARCHAR2(6)		NA	NA
SECONDARY_DIPLOMA_DESC		This field specifies the diploma type (e.g. college preparatory, general education) associated with the diploma type code.	VARCHAR2(30)		NA	NA
SECONDARY_SCHOOL_GRAD_DATE		Not a valid column for any post secondary school input to the ODS tables.	DATE		NA	NA
SEQUENCE_NUMBER	Sequence Number	Sequence number of the attendance period from the transfer institution.	NUMBER		SHRTRAM	SHRTRAM_SEQ_NO
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)		CONSTANT	'P'
TOTAL_TRANSFER_CREDITS		Number of transfer credits received from the previous post secondary institution.	NUMBER		FUNCTION	SOKODSF.F_CALC_TRANSFER_CREDITS
TRANSCRIPT_RECEIVED_DATE	Transcript Received Date	Date an academic transcript was received.	DATE		SHRTRIT	SHRTRIT_TRANS_DATE_RCVD
TRANSCRIPT_REVIEWED_DATE	Transcript Reviewed Date	Date an academic transcript was reviewed by the institution.	DATE		CALCULATION	NVL(SHRTRAM_ACCEPTANCE_DATE, SORPCOL_TRANS_REV_DATE)
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: