Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Student Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: STUDENT

Description Contains data for the student for the academic period that will not be different when the person is admitted to more than one academic study within the timeframe. Includes indicators reflecting student current status in several important groupings to make reporting groups easier for the reporting user. Details include whether the current student status at the institution will permit the student to enroll or if the student is a new admit in the academic period.
Key & Frequency One row per person per academic period with student activity.
Recommended Search Columns PERSON_UID, ACADEMIC_PERIOD
ACADEMIC_PERIOD

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ACADEMIC_HISTORY_EXISTS_IND Academic History Exists Indicator Indicates whether the student has academic history information for the academic period. VARCHAR2(1)  

FUNCTION

SOKODSF.F_CHECK_FOR_ACAD_HISTORY_DATA

ACADEMIC_OUTCOME_ENROLLED_IND Academic Outcome Enrolled Indicator Indicates that the student counts in the headcount, has current academic period credits registered greater than 0, and has been admitted to an academic outcome that grants a degree or award. VARCHAR2(1)  

FUNCTION

MSKFUNC.F_DEGR_ENROLLED_IND

ACADEMIC_PERIOD Academic Period Academic period or time frame associated with the information on the student record. VARCHAR2(63)  

SGBSTDN

SGBSTDN_TERM_CODE_EFF

ACADEMIC_PERIOD_DESC Academic Period Description Academic period description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_STUDY_MATRIC_IN_COUNT Academic Study Matric IN Count Matriculation academic period for the student. NUMBER  

CALCULATION

DECODE(SGBSTDN_TERM_CODE_MATRIC,NULL,0,1)+DECODE(SGBSTDN_LEVL_CODE_2,NULL,0,DECODE(SGBSTDN_TERM_CODE_MATRIC,NULL,0,1))

ACADEMIC_YEAR Academic Year Academic year associated with the academic period on this record. VARCHAR2(63)  

FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_YEAR_DESC Academic Year Description Academic year description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

ACAD_OUTCOME_COMPLETED_COUNT 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 Acad Study Registered IN Count Count of academic studies or programs in which the student is formally registered in sections. NUMBER  

NA

NA

ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)  

NA

NA

ADMIT_IND Admit Indicator Indicates whether the student has been admitted to the institution for the academic period and student level in this record. VARCHAR2(1)  

FUNCTION

F_LEVEL_ADMITTED_FNC

ADVISOR_COUNT Advisor Count Count of current active advisors assigned to the student. NUMBER  

FUNCTION

MSKFUNC.F_COUNT_ADVISORS

ADVISOR_NAME_LIST Advisor List List of the names of the advisors for this student. VARCHAR2(4000)  

FUNCTION

LISTAGG (ADVISOR_NAME_LFMI, '-')

AID_ENROLLMENT_PERIOD Financial Aid Enrollment Period Aid enrollment period associated with the award schedule. This period can span multiple student terms. VARCHAR2(63)  

FUNCTION

MRKFUNC.F_GET_AID_ENROLL_PERIOD

AID_ENROLLMENT_PERIOD_DESC Financial Aid Enrollment Period Description Aid enrollment period description. VARCHAR2(255)  

FUNCTION

MRKFUNC.F_GET_AID_ENROLL_PERIOD

AID_YEAR Financial Aid Year Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005). VARCHAR2(63)  

FUNCTION

MRKFUNC.F_GET_AID_ENROLL_PERIOD

AID_YEAR_DESC Financial Aid Year Description Financial aid year name. VARCHAR2(255)  

FUNCTION

MRKFUNC.F_GET_AID_ENROLL_PERIOD

APPLICANT_IND Applicant Indicator Indicates whether the person has applied for admissions for this academic period and student level. VARCHAR2(1)  

FUNCTION

F_LEVEL_APPL_FNC

BLOCK_REGISTRATION_COUNT Block Registration Count Count of block registration codes assigned to the student. NUMBER  

FUNCTION

MSKFUNC.F_GET_BLOCK_REG_CNT

BLOCK_REGISTRATION_DESC_LIST Block Registration Description List List of all the descriptions for the block registration codes assigned or selected by this student. VARCHAR2(4000)  

FUNCTION

LISTAGG (BLOCK_REGISTRATION_DESC, '-')

BLOCK_REGISTRATION_LIST Block Registration List List of all the block registration codes assigned or selected by this student. VARCHAR2(4000)  

FUNCTION

LISTAGG (BLOCK_REGISTRATION, '-')

COHORT_COUNT Cohort Count Count of all the current active student cohort codes recorded for the person. NUMBER  

FUNCTION

MSKFUNC.F_COUNT_COHORTS

COHORT_DESC_LIST Cohort Description List List of all the descriptions for the cohort codes associated with this student. VARCHAR2(4000)  

FUNCTION

LISTAGG (COHORT_DESC, '-')

COHORT_LIST Cohort List List of all the cohort codes assigned to this student. VARCHAR2(4000)  

FUNCTION

LISTAGG (COHORT, '-')

CONTINUING_EDUCATION_IND Continuing Education Indicator Indicates whether the student is considered a continuing education student. Taking courses to earn continuing education units instead of credits. VARCHAR2(1)  

NA

NA

CURRENT_TIME_STATUS Current Time Status System-calculated time status for the academic period based on institution defined rules. For example, full time, part time, etc. VARCHAR2(63)  

SFBETRM

SFBETRM_TMST_CODE

CURRENT_TIME_STATUS_DESC Current Time Status Description Current time status description. VARCHAR2(255)  

STVTMST

STVTMST_DESC

DEANS_LIST_DATE Deans List Date Date on which the Dean's List code was recorded. DATE  

SHRTTRM

SHRTTRM_ASTD_DATE_DL

DEANS_LIST_DESC Deans List Description Student's deans list code description. VARCHAR2(255)  

STVASTD

STVASTD_DESC

DEANS_LIST_VALUE Deans List Value Identifies whether the student qualified for the dean's list this academic period. VARCHAR2(63)  

SHRTTRM

SHRTTRM_ASTD_CODE_DL

DEPOSIT_IND Deposit Indicator Indicates whether the student has paid an admissions deposit. VARCHAR2(1)  

FUNCTION

F_PAID_ADMISSIONS_DEPOSIT

EDUCATIONAL_GOAL Educational Goal Educational goal recorded for the student. VARCHAR2(63)  

SGBSTDN

SGBSTDN_EGOL_CODE

EDUCATIONAL_GOAL_DESC Educational Goal Description Educational goal description. VARCHAR2(255)  

STVEGOL

STVEGOL_DESC

EDUCATION_LEVEL Education Level Highest level of education completed by the person. VARCHAR2(63)  

SGBSTDN

SGBSTDN_EDLV_CODE

EDUCATION_LEVEL_DESC Education Level Description Description of the highest level of education recorded for the person. VARCHAR2(255)  

STVEDLV

STVEDLV_DESC

ENROLLED_IND Enrolled Indicator Indicates whether the student has enrolled for the academic period identified by the student having a registration enrollment status that effects headcount. VARCHAR2(1)  

FUNCTION

SOKODSF.F_ENROLLED_THIS_TERM

ENROLLMENT_EXISTS_IND Enrollment Exists Indicator Indicates whether the student has current enrollment information for the academic period. VARCHAR2(1)  

CALCULATION

DECODE(SFBETRM_PIDM, NULL, 'N', 'Y')

FINANCIAL_AID_AWARDED_IND Financial Financial Aid Awarded Indicator   VARCHAR2(1)  

FUNCTION

MRKFUNC.F_GET_FIN_AID_AWARDED_IND

FINANCIAL_AID_DISBURSED_IND Financial Financial Aid Disbursed Indicator   VARCHAR2(1)  

FUNCTION

MRKFUNC.F_GET_FIN_AID_DISBURSED_IND

FINANCIAL_AID_LOAN_IND Financial Financial Aid Loan Indicator   VARCHAR2(1)  

FUNCTION

MRKFUNC.F_GET_FIN_AID_LOAN_IND

FIN_AID_APPLICANT_IND Fin Aid Applicant Indicator Indicates whether the student is receiving any financial aid for the award year of the associated term. VARCHAR2(1)  

FUNCTION

F_FINAID_APPLICANT_IND

GRADE_MAILER_CHG_DATE Grade Mailer Change Date Date a revised or duplicate grade mailer was sent to the student. DATE  

SHRTTRM

SHRTTRM_GRADE_MAILER_CHG_DATE

GRADE_MAILER_DUP_DATE Grade Mailer Duplicate Date Date a duplicate grade mailer was sent. DATE  

SHRTTRM

SHRTTRM_GRADE_MAILER_DUP_DATE

GRADE_MAILER_DUP_IND Grade Mailer Duplicate Indicator Indicates whether a duplicate grade mailer should be sent to the student. VARCHAR2(1)  

SHRTTRM

SHRTTRM_GRADE_MAILER_DUP

GRADE_MAILER_STATUS Grade Mailer Status Status of the grade mailer. VARCHAR2(1)  

SHRTTRM

SHRTTRM_RECORD_STATUS_IND

GRADE_MAILER_STATUS_DATE Grade Mailer Status Date Date associated with the status of the grade mailer. DATE  

SHRTTRM

SHRTTRM_RECORD_STATUS_DATE

GRADE_MAILER_STATUS_DESC Grade Mailer Status Description Description of the grade mailer status. VARCHAR2(255)  

CALCULATION

DECODE(SHRTTRM_RECORD_STATUS_IND)

GRADE_MAILING_DATE Grade Mailing Date Date a grade mailer was sent to the student. DATE  

SHRTTRM

SHRTTRM_GRADE_MAILING_DATE

GRADUATE_CREDIT_ELIG_IND Graduate Credit Elig Indicator Indicates eligibility of student to take graduate courses for credit for this academic period. VARCHAR2(1)  

SGBSTDN

SGBSTDN_GRAD_CREDIT_APPR_IND

HOLD_COUNT Hold Count Count of the number of holds or restrictions to institution activities recorded for this person. Included may be stop of registration, receipt of a transcript or processing of graduation, etc. NUMBER  

FUNCTION

MSKFUNC.F_COUNT_HOLDS

HOLD_DESC_LIST Hold Description List List of the descriptions for all the holds assigned to this student. VARCHAR2(4000)  

FUNCTION

LISTAGG (HOLD_DESC, '-')

HOLD_LIST Hold List List of all the holds assigned to this student. VARCHAR2(4000)  

FUNCTION

LISTAGG (HOLD, '-')

HOLD_ORIGINATING_OFFICE_LIST Hold Originating Office List List of the offices that originated the holds for this student. VARCHAR2(4000)  

FUNCTION

LISTAGG (HOLD_ORIGINATING_OFFICE, '-')

HOLD_ORIGIN_DESC_LIST Hold Originating Office Description List List of the names of the offices that originated the holds for this student. VARCHAR2(4000)  

FUNCTION

LISTAGG (HOLD_ORIGINATING_OFFICE_DESC, '-')

HOUSING_IND Housing Indicator Indicates whether the student has institution housing for this academic period. VARCHAR2(1)  

FUNCTION

F_HOUS_THIS_TERM

ID ID Person's or organization's current identification number. VARCHAR2(63)  

SPRIDEN

SPRIDEN_ID

INQUIRER_IND Inquirer Indicator Indicates whether the student has any recruiting information. VARCHAR2(1)  

FUNCTION

F_INQUIRER_FNC

INST_AID_RECIPIENT_IND Inst Aid Recipient Indicator Indicates whether the student is receiving institutional financial aid for this academic period. VARCHAR2(1)  

FUNCTION

F_INST_AID_FNC

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)  

NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)  

NA

NA

NAME Name Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)  

FUNCTION

F_FORMAT_NAME

ORIENTATION_SESSION Orientation Session Orientation session assigned to the student. VARCHAR2(63)  

SGBSTDN

SGBSTDN_ORSN_CODE

ORIENTATION_SESSION_DESC Orientation Session Description Orientation session description associated with the orientation session code. VARCHAR2(255)  

STVORSN

STVORSN_DESC

OUTCOME_NUMBER Outcome Number Sequence number identifying a unique outcome record for the student. NUMBER  

NA

SORLCUR

SOKODSF.F_COUNT_COMPLETED_OUTCOMES

SORLCUR_ROLLED_SEQNO

PERSON_UID Person UID System generated, unique, internal identification number assigned to this person. NUMBER  

SPRIDEN

SPRIDEN_PIDM

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)  

NA

NA

PROGRESS_EVALUATION Progress Evaluation Progress evaluation as stored on the student record for this academic study. VARCHAR2(63)  

SGBSTDN

SHRTTRM

STVPREV

SGBSTDN_PREV_CODE

SHRTTRM_PREV_CODE

STVPREV_CODE

PROGRESS_EVALUATION_DESC Progress Evaluation Description Progress evaluation description. VARCHAR2(255)  

STVPREV

STVPREV_DESC

PROSPECT_IND Prospect Indicator Indicates whether this person has a prospect record. VARCHAR2(1)  

FUNCTION

F_PROSPECT_FNC

REGISTERED_IND Registered Indicator Indicates the student is registered in the academic period when at least one student course has a course registration status defined with a 'yes' in the include in section enrolled indicator. VARCHAR2(1)  

FUNCTION

SOKODSF.F_REGISTERED_THIS_TERM

REGISTRATION_REASON Registration Reason Recorded reason for the registration or in some cases reason for the registration withdrawal. Institution defined codes are used. VARCHAR2(63)  

SFBETRM

SFBETRM_RGRE_CODE

REGISTRATION_REASON_DESC Registration Reason Description Recorded registration reason description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

RESIDENCY Residency Residency of the student typically used to calculate tuition and fees to be charged. VARCHAR2(63)  

SGBSTDN

SGBSTDN_RESD_CODE

RESIDENCY_DESC Residency Description Residency code description. VARCHAR2(255)  

STVRESD

STVRESD_DESC

RESIDENCY_IND Residency Indicator 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)

SPORT_COUNT Sport Count Count of the number of sports activity recorded for the person. NUMBER  

FUNCTION

MSKFUNC.F_COUNT_SPORTS

SPORT_DESC_LIST Sport Description List List of the descriptions for each of the sports in which the student is participating. VARCHAR2(4000)  

FUNCTION

LISTAGG (ACTIVITY_DESC, '-')

SPORT_LIST Sport List List of all the sports in which the student is participating. VARCHAR2(4000)  

FUNCTION

LISTAGG (ACTIVITY, '-')

STUDENT_ATTRIBUTE_COUNT Student Attribute Count Count of student attributes recorded for the student. NUMBER  

FUNCTION

MSKFUNC.F_GET_STDNT_ATTR_CNT

STUDENT_ATTRIBUTE_DESC_LIST Student Attribute Description List List of the descriptions for all the student attributes assigned to this student. VARCHAR2(4000)  

FUNCTION

LISTAGG (STUDENT_ATTRIBUTE_DESC, '-')

STUDENT_ATTRIBUTE_LIST Student Attribute List List of all the student attributes associated with this student. VARCHAR2(4000)  

FUNCTION

LISTAGG (STUDENT_ATTRIBUTE, '-')

STUDENT_CLASSIFICATION Student Classification Identifies the student classification (i.e. year in school) after grades have been processed for this academic period. For example, first year, second year or freshman, sophomore, etc. This may be the same value as the Student Classification BOAP or when appropriate be the value to begin the next academic period. VARCHAR2(63)  

FUNCTION

F_CLASS_CALC_FNC

STUDENT_CLASSIFICATION_BOAP Student Classification - Beginning of Academic Period Identifies the students classification (i.e. class or year in school) when the academic period begins, for example, first year, second year or freshman, sophomore, etc. This will be the same value as the Student Classification when the previous academic period ended. VARCHAR2(63)  

FUNCTION

SGKCLAS.F_CLASS_CODE

STUDENT_CLASSIFICATION_DESC Student Classification Description Student classification description. VARCHAR2(255)  

STVCLAS

STVCLAS_DESC

STUDENT_CLASS_BOAP_DESC Student Classification - Beginning of Academic Period Description Beginning of academic period student classification. VARCHAR2(255)  

STVCLAS

STVCLAS_DESC

STUDENT_PLAN_ACTIVE_IND Student Plan Active Indicator Indicates whether this student has an active Banner registration plan. VARCHAR2(1)  

FUNCTION

MSKFUNC.F_GET_REG_PLAN_IND

STUDENT_PLAN_EXISTS_IND Student Plan Exists Indicator Indicates whether this student has a Banner registration plan. VARCHAR2(1)  

FUNCTION

MSKFUNC.F_GET_REG_PLAN_IND

STUDENT_STATUS Student Status Student's current status for the academic period. May include active and permitted to register, inactive and stop registration, graduated, etc. VARCHAR2(63)  

SGBSTDN

SGBSTDN_STST_CODE

STUDENT_STATUS_DESC Student Status Description Student's status description. VARCHAR2(255)  

STVSTST

STVSTST_DESC

SUB_ACADEMIC_PERIOD Sub Academic Period A session, portion or part of the academic period. VARCHAR2(63)  

NA

NA

SUB_ACADEMIC_PERIOD_DESC Sub Academic Period Description Sub academic period description. VARCHAR2(255)  

NA

NA

THIRD_PARTY_PLAN_ACTIVE_IND Third Party Plan Active Indicator Indicates whether this student has an active third party plan such as Degree Works. VARCHAR2(1)  

FUNCTION

MDKFUNC.F_GET_THIRD_PARY_PLAN_IND

THIRD_PARTY_PLAN_EXISTS_IND Third Party Plan Exists Indicator Indicates whether this student has a third party plan such as Degree Works. VARCHAR2(1)  

FUNCTION

MDKFUNC.F_GET_THIRD_PARY_PLAN_IND

TOTAL_BILLING Total Billing Sum of the billing units used to calculate the charges for this student in this academic period. NUMBER  

FUNCTION

F_CALC_REGISTRATION_HOURS

TOTAL_CEU_BILLING Total Continuing Education Unit Billing Sum of the continuing education unit billing units used to calculate the charges for this student for this academic period. NUMBER  

FUNCTION

F_CALC_REGISTRATION_HOURS

TOTAL_CEU_CREDITS Total Continuing Education Unit Credits Sum of the continuing education units for the student for this academic period. NUMBER  

FUNCTION

F_CALC_REGISTRATION_HOURS

TOTAL_CREDITS Total Credits Sum of the registered credits for the student for this academic period. NUMBER  

FUNCTION

F_CALC_REGISTRATION_HOURS

TOTAL_NON_CEU_BILLING Total Non Continuing Education Unit Billing Sum of the billing units for this student in the academic period that are not identified as earning continuing education units but regular credits. NUMBER  

FUNCTION

F_CALC_REGISTRATION_HOURS

TOTAL_NON_CEU_CREDITS Total Non Continuing Education Unit Credits Sum of the credits for this student in the academic period that are not identified as earning continuing education units. NUMBER  

FUNCTION

F_CALC_REGISTRATION_HOURS

TRANSFER_CENTER 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(63)  

SGBSTDN

SGBSTDN_TRCN_CODE

TRANSFER_CENTER_DESC Transfer Center Description Transfer center description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

VETERAN_CATEGORY Veteran Category Veteran category as standardized by the federal government to track attendance of particular veteran types or groups. VARCHAR2(1)  

SPBPERS

SPBPERS_VERA_IND

VETERAN_CATEGORY_DESC Veteran Category Description Person's veteran category description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

VETERAN_CERTIFICATION_CREDITS Veteran Certification Credits Number of credits registered as reported to veteran's administration for this certification. NUMBER  

SGRVETN

SGRVETN_VETC_CODE

VETERAN_CERTIFICATION_DATE Veteran Certification Date Date the veteran certification was entered or last updated. DATE  

SGRVETN

SGRVETN_VETC_DATE

VETERAN_FILE_NO Veteran File Number Veteran administration assigned identification number. VARCHAR2(255)  

SPBPERS

SPBPERS_VETC_FILE_NUMBER

VETERAN_SPECIAL_DISABLED_IND Veteran Special Disabled Indicator Indicates whether the person has been qualified as a disabled veteran. VARCHAR2(1)  

SPBPERS

SPBPERS_SDVET_IND

VETERAN_TYPE Veteran Type Veteran type associated with the person record. VARCHAR2(1)  

SGRVETN

SGRVETN_VETC_CODE

VETERAN_TYPE_DESC Veteran Type Description Veteran type description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC



Ver: 9.0