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	SGBSTDN	SGBSTDN_PIDM
RESIDENCY_IND	Identifies whether the student is considered in or out of the district for enrollment charges. Typically this indicates in or out of state or province but may also be in or out of county or in or out of the European Union, 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: