RETURN TO COMPOSITE VIEW REPORTS LIST
Student Composite View Reports

SGHE Operational Data Store
Composite View Target: AS_GENERAL_STUDENT

Description Source composite view contains information associated with each program/curriculum for a student. A student may have as many academic study or program records as permitted by the institution ERP system.

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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_DESC

DUAL_DEGREE_DESC The description of the dual degree code. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_DESC

DUAL_PROGRAM_CLASSIFICATION This identifies the Classification of Institutional Programs (CIP) code of the major associated with the dual degree. VARCHAR2(6)

FUNCTION

GOKODSF.F_GET_DESC

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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_DESC

PERMIT_REGISTRATION Indicates whether or not the student is permitted to register for sections or schedule offerings in this academic period VARCHAR2(1)

FUNCTION

GOKODSF.F_GET_DESC

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(GOKODSF.F_GET_DESC)

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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_DESC

STUDENT_STATUS The students status. VARCHAR2(2)

SGBSTDN

SGBSTDN_STST_CODE

STUDENT_STATUS_DESC The description of the student status. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_DESC

ZONE_VALUE Zone column for future use, not currently populated. VARCHAR2(6)

NA

NA



Ver: 3.1