Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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: