Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
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	NO	NO
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	NO	NO
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	NO	NO
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	NO	NO
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	NO	NO
ACAD_STUDY_REGISTERED_IN_COUNT	This column is not currently used. It was created as a placeholder for future reference.	NUMBER	NA	NA	NO	NO
BLOCK_SCHEDULE	The block schedule of the student for this term.	VARCHAR2(10)	SGBSTDN	SGBSTDN_BLCK_CODE	NO	NO
BLOCK_SCHEDULE_DESC	The block schedule description.	VARCHAR2(30)	STVBLCK	STVBLCK_DESC	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA	NO	NO
DUAL_DEGREE	The dual degree code.	VARCHAR2(6)	SGBSTDN	SGBSTDN_DEGC_CODE_DUAL	NO	NO
DUAL_DEGREE_COLLEGE	The college associated with the dual degree.	VARCHAR2(2)	SGBSTDN	SGBSTDN_COLL_CODE_DUAL	NO	NO
DUAL_DEGREE_COLLEGE_DESC	The description of the college associated with the dual degree.	VARCHAR2(30)	STVCOLL	STVCOLL_DESC	NO	NO
DUAL_DEGREE_DEPARTMENT	The department associated with the dual degree.	VARCHAR2(4)	SGBSTDN	SGBSTDN_DEPT_CODE_DUAL	NO	NO
DUAL_DEGREE_DEPARTMENT_DESC	The description of the department associated with the dual degree.	VARCHAR2(30)	STVDEPT	STVDEPT_DESC	NO	NO
DUAL_DEGREE_DESC	The description of the dual degree code.	VARCHAR2(30)	STVDEGC	STVDEGC_DESC	NO	NO
DUAL_DEGREE_LEVEL	The level associated with the dual degree.	VARCHAR2(2)	SGBSTDN	SGBSTDN_LEVL_CODE_DUAL	NO	NO
DUAL_DEGREE_LEVEL_DESC	The description of the level associated with the dual degree.	VARCHAR2(30)	STVLEVL	STVLEVL_DESC	NO	NO
DUAL_DEGREE_MAJOR	The major associated with the dual degree.	VARCHAR2(4)	SGBSTDN	SGBSTDN_MAJR_CODE_DUAL	NO	NO
DUAL_DEGREE_MAJOR_DESC	The description of the major associated with the dual degree.	VARCHAR2(30)	STVMAJR	STVMAJR_DESC	NO	NO
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	NO	NO
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	NO	NO
EDUCATIONAL_GOAL	The educational goal of the student for this term.	VARCHAR2(2)	SGBSTDN	SGBSTDN_EGOL_CODE	NO	NO
EDUCATIONAL_GOAL_DESC	The description of the educational goal of the student for this term.	VARCHAR2(30)	STVEGOL	STVEGOL_DESC	NO	NO
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	NO	NO
EDUCATION_LEVEL_DESC	The description of the educational level.	VARCHAR2(30)	STVEDLV	STVEDLV_DESC	NO	NO
FTE_DIVISOR	This column is not currently used. It was created as a placeholder for future reference.	NUMBER	NA	NA	NO	NO
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	NO	NO
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	NO	NO
INTENDED_TIME_STATUS	This is the students intended time status.	VARCHAR2(1)	SGBSTDN	SGBSTDN_FULL_PART_IND	NO	NO
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	NO	NO
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	NO	NO
ORIENTATION_SESSION	This field identifies the orientation session assigned to the student.	VARCHAR2(1)	SGBSTDN	SGBSTDN_ORSN_CODE	NO	NO
ORIENTATION_SESSION_DESC	This field specifies the orientation session associated with the orientation session code.	VARCHAR2(30)	STVORSN	STVORSN_DESC	NO	NO
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	NO	NO
PERSON_UID	The internal number used to uniquely identify an individual.	NUMBER	SGBSTDN	SGBSTDN_PIDM	NO	NO
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)	NO	NO
STUDENT_FTE	This column is not currently used. It was created as a placeholder for future reference.	NUMBER	NA	NA	NO	NO
STUDENT_MEETING_TIME	The session of the students normal attendance.	VARCHAR2(1)	SGBSTDN	SGBSTDN_SESS_CODE	NO	NO
STUDENT_MEETING_TIME_DESC	The description of the students session (e.g. Day, Evening, Weekend, etc.).	VARCHAR2(30)	STVSESS	STVSESS_DESC	NO	NO
STUDENT_RESIDENCY	The residency of the student for this term.	VARCHAR2(1)	SGBSTDN	SGBSTDN_RESD_CODE	NO	NO
STUDENT_RESIDENCY_DESC	The description of the residency code.	VARCHAR2(30)	STVRESD	STVRESD_DESC	NO	NO
STUDENT_STATUS	The students status.	VARCHAR2(2)	SGBSTDN	SGBSTDN_STST_CODE	NO	NO
STUDENT_STATUS_DESC	The description of the student status.	VARCHAR2(30)	STVSTST	STVSTST_DESC	NO	NO
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	NO	NO
SUB_ACADEMIC_PERIOD_DESC	This field specifies the session or part of the academic period associated with the session code.	VARCHAR2(30)	NA	NA	NO	NO
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	NO	NO
TRANSFER_CENTER_DESC	Transfer center description.	VARCHAR2(30)	STVTRCN	STVTRCN_DESC	NO	NO
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA	NO	NO

Ver: