Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD_END	This field identifies the ending academic period or term associated with the information on the academic study information record.	VARCHAR2(6)	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.	VARCHAR2(30)	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.	VARCHAR2(6)	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.	VARCHAR2(30)	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.	NUMBER	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.	NUMBER	NA	NA
BLOCK_SCHEDULE	The block schedule of the student for this term.	VARCHAR2(10)	SGBSTDN	SGBSTDN_BLCK_CODE
BLOCK_SCHEDULE_DESC	The block schedule description.	VARCHAR2(30)	STVBLCK	STVBLCK_DESC
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA
DUAL_DEGREE	The dual degree code.	VARCHAR2(6)	SGBSTDN	SGBSTDN_DEGC_CODE_DUAL
DUAL_DEGREE_COLLEGE	The college associated with the dual degree.	VARCHAR2(2)	SGBSTDN	SGBSTDN_COLL_CODE_DUAL
DUAL_DEGREE_COLLEGE_DESC	The description of the college associated with the dual degree.	VARCHAR2(30)	STVCOLL	STVCOLL_DESC
DUAL_DEGREE_DEPARTMENT	The department associated with the dual degree.	VARCHAR2(4)	SGBSTDN	SGBSTDN_DEPT_CODE_DUAL
DUAL_DEGREE_DEPARTMENT_DESC	The description of the department associated with the dual degree.	VARCHAR2(30)	STVDEPT	STVDEPT_DESC
DUAL_DEGREE_DESC	The description of the dual degree code.	VARCHAR2(30)	STVDEGC	STVDEGC_DESC
DUAL_DEGREE_LEVEL	The level associated with the dual degree.	VARCHAR2(2)	SGBSTDN	SGBSTDN_LEVL_CODE_DUAL
DUAL_DEGREE_LEVEL_DESC	The description of the level associated with the dual degree.	VARCHAR2(30)	STVLEVL	STVLEVL_DESC
DUAL_DEGREE_MAJOR	The major associated with the dual degree.	VARCHAR2(4)	SGBSTDN	SGBSTDN_MAJR_CODE_DUAL
DUAL_DEGREE_MAJOR_DESC	The description of the major associated with the dual degree.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC
DUAL_PROGRAM_CLASSIFICATION	This identifies the Classification of Institutional Programs (CIP) code of the major associated with the dual degree.	VARCHAR2(6)	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.	VARCHAR2(30)	STVCIPC	STVCIPC_DESC
EDUCATIONAL_GOAL	The educational goal of the student for this term.	VARCHAR2(2)	SGBSTDN	SGBSTDN_EGOL_CODE
EDUCATIONAL_GOAL_DESC	The description of the educational goal of the student for this term.	VARCHAR2(30)	STVEGOL	STVEGOL_DESC
EDUCATION_LEVEL	A two position alphanumeric field which indicates the highest level of the education that the student completed.	VARCHAR2(3)	SGBSTDN	SGBSTDN_EDLV_CODE
EDUCATION_LEVEL_DESC	The description of the educational level.	VARCHAR2(30)	STVEDLV	STVEDLV_DESC
FTE_DIVISOR	This column is not currently used. It was created as a placeholder for future reference.	NUMBER	NA	NA
FTE_IND	This is a Y or N field to indicate if the student is a full time equivalent or not.	VARCHAR2(1)	NA	NA
GRADUATE_CREDIT_ELIG_IND	This field identifies eligibility of student to take graduate courses for credit for the term.	VARCHAR2(1)	SGBSTDN	SGBSTDN_GRAD_CREDIT_APPR_IND
INTENDED_TIME_STATUS	This is the students intended time status.	VARCHAR2(1)	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.	VARCHAR2(30)	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.	VARCHAR2(6)	NA	NA
ORIENTATION_SESSION	This field identifies the orientation session assigned to the student.	VARCHAR2(1)	SGBSTDN	SGBSTDN_ORSN_CODE
ORIENTATION_SESSION_DESC	This field specifies the orientation session associated with the orientation session code.	VARCHAR2(30)	STVORSN	STVORSN_DESC
PERMIT_REGISTRATION	Indicates whether or not the student is permitted to register for sections or schedule offerings in this academic period	VARCHAR2(1)	STVSTST	STVSTST_REG_IND
PERSON_UID	The internal number used to uniquely identify an individual.	NUMBER(8)	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.	VARCHAR2(1)	FUNCTION	DECODE(STVRESD_IN_STATE_IND)
STUDENT_FTE	This column is not currently used. It was created as a placeholder for future reference.	NUMBER	NA	NA
STUDENT_MEETING_TIME	The session of the students normal attendance.	VARCHAR2(1)	SGBSTDN	SGBSTDN_SESS_CODE
STUDENT_MEETING_TIME_DESC	The description of the students session (e.g. Day, Evening, Weekend, etc.)	VARCHAR2(30)	STVSESS	STVSESS_DESC
STUDENT_RESIDENCY	The residency of the student for this term.	VARCHAR2(1)	SGBSTDN	SGBSTDN_RESD_CODE
STUDENT_RESIDENCY_DESC	The description of the residency code.	VARCHAR2(30)	STVRESD	STVRESD_DESC
STUDENT_STATUS	The students status.	VARCHAR2(2)	SGBSTDN	SGBSTDN_STST_CODE
STUDENT_STATUS_DESC	The description of the student status.	VARCHAR2(30)	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.	VARCHAR2(6)	NA	NA
SUB_ACADEMIC_PERIOD_DESC	This field specifies the session or part of the academic period associated with the session code.	VARCHAR2(30)	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.	VARCHAR2(2)	SGBSTDN	SGBSTDN_TRCN_CODE
TRANSFER_CENTER_DESC	Transfer center description.	VARCHAR2(30)	STVTRCN	STVTRCN_DESC
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA

Ver: 8.1