ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
ACADEMIC_PERIOD_END	This field identifies the ending academic period or term associated with the information on the academic study information record.			FUNCTION	SOKODSF.F_GET_END_SGBSTDN_TERM
ACADEMIC_PERIOD_END_DESC	This field specifies the description of the ending academic period or term associated with the academic period code.			STVTERM	STVTERM_DESC
ACADEMIC_PERIOD_START	This field identifies the starting academic period or term associated with the information on the academic study information record.			SGBSTDN	SGBSTDN_TERM_CODE_EFF
ACADEMIC_PERIOD_START_DESC	This field specifies the description of the starting academic period or term associated with the academic period code.			STVTERM	STVTERM_DESC
ACAD_OUTCOME_COMPLETED_COUNT	Count of outcomes completed, e.g., total number of certificates, diploma, awards, degrees that the student has been awarded.			FUNCTION	SOKODSF.F_COUNT_COMPLETED_OUTCOMES
ACAD_STUDY_REGISTERED_IN_COUNT	This column is not currently used. It was created as a placeholder for future reference.			NA	NA
BLOCK_SCHEDULE	The block schedule of the student for this term.			SGBSTDN	SGBSTDN_BLCK_CODE
BLOCK_SCHEDULE_DESC	The block schedule description.			STVBLCK	STVBLCK_DESC
CURRENT_DATE	System current date (sysdate) or date the data was extracted.			NA	SYSDATE
DOMAIN_VALUE	Domain column for future use, not currently populated.			NA	NA
DUAL_DEGREE	The dual degree code.			SGBSTDN	SGBSTDN_DEGC_CODE_DUAL
DUAL_DEGREE_COLLEGE	The college associated with the dual degree.			SGBSTDN	SGBSTDN_COLL_CODE_DUAL
DUAL_DEGREE_COLLEGE_DESC	The description of the college associated with the dual degree.			STVCOLL	STVCOLL_DESC
DUAL_DEGREE_DEPARTMENT	The department associated with the dual degree.			SGBSTDN	SGBSTDN_DEPT_CODE_DUAL
DUAL_DEGREE_DEPARTMENT_DESC	The description of the department associated with the dual degree.			STVDEPT	STVDEPT_DESC
DUAL_DEGREE_DESC	The description of the dual degree code.			STVDEGC	STVDEGC_DESC
DUAL_DEGREE_LEVEL	The level associated with the dual degree.			SGBSTDN	SGBSTDN_LEVL_CODE_DUAL
DUAL_DEGREE_LEVEL_DESC	The description of the level associated with the dual degree.			STVLEVL	STVLEVL_DESC
DUAL_DEGREE_MAJOR	The major associated with the dual degree.			SGBSTDN	SGBSTDN_MAJR_CODE_DUAL
DUAL_DEGREE_MAJOR_DESC	The description of the major associated with the dual degree.			STVMAJR	STVMAJR_DESC
DUAL_PROGRAM_CLASSIFICATION	This identifies the Classification of Institutional Programs (CIP) code of the major associated with the dual degree.			STVMAJR	STVMAJR_CIPC_CODE
DUAL_PROGRAM_CLASSIF_DESC	This identifies the description of the Classification of Institutional Programs (CIP) code of the major associated with the dual degree.			STVCIPC	STVCIPC_DESC
EDUCATIONAL_GOAL	The educational goal of the student for this term.			SGBSTDN	SGBSTDN_EGOL_CODE
EDUCATIONAL_GOAL_DESC	The description of the educational goal of the student for this term.			STVEGOL	STVEGOL_DESC
EDUCATION_LEVEL	A two position alphanumeric field which indicates the highest level of the education that the student completed.			SGBSTDN	SGBSTDN_EDLV_CODE
EDUCATION_LEVEL_DESC	The description of the educational level.			STVEDLV	STVEDLV_DESC
FTE_DIVISOR	This column is not currently used. It was created as a placeholder for future reference.			NA	NA
FTE_IND	This is a Y or N field to indicate if the student is a full time equivalent or not.			NA	NA
GRADUATE_CREDIT_ELIG_IND	This field identifies eligibility of student to take graduate courses for credit for the term.			SGBSTDN	SGBSTDN_GRAD_CREDIT_APPR_IND
INTENDED_TIME_STATUS	This is the students intended time status.			SGBSTDN	SGBSTDN_FULL_PART_IND
MIF_DESC	The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.			NA	NA
MIF_VALUE	The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.			NA	NA
ORIENTATION_SESSION	This field identifies the orientation session assigned to the student.			SGBSTDN	SGBSTDN_ORSN_CODE
ORIENTATION_SESSION_DESC	This field specifies the orientation session associated with the orientation session code.			STVORSN	STVORSN_DESC
PERMIT_REGISTRATION	Indicates whether or not the student is permitted to register for sections or schedule offerings in this academic period			STVSTST	STVSTST_REG_IND
PERSON_UID	The internal number used to uniquely identify an individual.			SGBSTDN	SGBSTDN_PIDM
RESIDENCY_IND	Indicates whether the residency is in or out area. May represent in or out of state/province, in or out of the EU, etc.			FUNCTION	DECODE(STVRESD_IN_STATE_IND)
STUDENT_FTE	This column is not currently used. It was created as a placeholder for future reference.			NA	NA
STUDENT_MEETING_TIME	The session of the students normal attendance.			SGBSTDN	SGBSTDN_SESS_CODE
STUDENT_MEETING_TIME_DESC	The description of the students session (e.g. Day, Evening, Weekend, etc.)			STVSESS	STVSESS_DESC
STUDENT_RESIDENCY	The residency of the student for this term.			SGBSTDN	SGBSTDN_RESD_CODE
STUDENT_RESIDENCY_DESC	The description of the residency code.			STVRESD	STVRESD_DESC
STUDENT_STATUS	The students status.			SGBSTDN	SGBSTDN_STST_CODE
STUDENT_STATUS_DESC	The description of the student status.			STVSTST	STVSTST_DESC
SUB_ACADEMIC_PERIOD	This field identifies the session or part of the academic period associated with the information on the academic study information record.			NA	NA
SUB_ACADEMIC_PERIOD_DESC	This field specifies the session or part of the academic period associated with the session code.			NA	NA
TRANSFER_CENTER	Institution defined to identify the student association with a transfer center. May be used to identify a standard set of transfer procedures by state/province articulation agreements, etc.			SGBSTDN	SGBSTDN_TRCN_CODE
TRANSFER_CENTER_DESC	Transfer center description.			STVTRCN	STVTRCN_DESC
ZONE_VALUE	Zone column for future use, not currently populated.			NA	NA

Ver: 8.3