Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Student Composite View Reports

Banner 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)

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: