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

SGHE Banner Operational Data Store
Reporting View Target: STUDENT_EXTENDED

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.
Recommended Search Columns PERSON_UID, ACADEMIC_PERIOD
ACADEMIC_PERIOD
ACADEMIC_PERIOD, STUDENT_CLASSIFICATION_BOAP
STUDENT_CLASSIFICATION, ACADEMIC_PERIOD

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_HISTORY_EXISTS_IND 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 Indicates if the student is officially enrolled in an academic outcome in this enrollment time frame. VARCHAR2(1)

FUNCTION

MSKFUNC.F_DEGR_ENROLLED_IND

ACADEMIC_PERIOD Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year. VARCHAR2(63)

SGBSTDN

SGBSTDN_TERM_CODE_EFF

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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 associated with the academic period on this record. VARCHAR2(63)

FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(255)

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

NA

NA

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

NA

NA

ADMIT_IND 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 Count of current active advisors assigned to the student. NUMBER

FUNCTION

MSKFUNC.F_COUNT_ADVISORS

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

FUNCTION

LISTAGG (ADVISOR_NAME_LFMI, '-')

AID_ENROLLMENT_PERIOD Aid enrollment period associated with the award schedule. This period can span multiple student_extended terms. VARCHAR2(63)

FUNCTION

MRKFUNC.F_GET_AID_ENROLL_PERIOD

AID_ENROLLMENT_PERIOD_DESC Aid enrollment period description. VARCHAR2(255)

FUNCTION

MRKFUNC.F_GET_AID_ENROLL_PERIOD

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 name. VARCHAR2(255)

FUNCTION

MRKFUNC.F_GET_AID_ENROLL_PERIOD

APPLICANT_IND 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 Count of block registration codes assigned to the student. NUMBER

FUNCTION

MSKFUNC.F_GET_BLOCK_REG_CNT

BLOCK_REGISTRATION_DESC_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 List of all the block registration codes assigned or selected by this student. VARCHAR2(4000)

FUNCTION

LISTAGG (BLOCK_REGISTRATION, '-')

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

FUNCTION

MSKFUNC.F_COUNT_COHORTS

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

FUNCTION

LISTAGG (COHORT_DESC, '-')

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

FUNCTION

LISTAGG (COHORT, '-')

CONTINUING_EDUCATION_IND Indicates whether the course earns continuing education units instead of credits. VARCHAR2(1)

NA

NA

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. VARCHAR2(255)

FUNCTION

STVTMST

GOKODSF.F_GET_DESC

STVTMST_DESC

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

SHRTTRM

SHRTTRM_ASTD_DATE_DL

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

STVASTD

STVASTD_DESC

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 Indicates whether the student has paid an admissions deposit. VARCHAR2(1)

FUNCTION

F_PAID_ADMISSIONS_DEPOSIT

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

SGBSTDN

SGBSTDN_EGOL_CODE

EDUCATIONAL_GOAL_DESC Educational goal description. VARCHAR2(255)

STVEGOL

STVEGOL_DESC

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

SGBSTDN

SGBSTDN_EDLV_CODE

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

STVEDLV

STVEDLV_DESC

ENROLLED_IND 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 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   VARCHAR2(1)

FUNCTION

MRKFUNC.F_GET_FIN_AID_AWARDED_IND

FINANCIAL_AID_DISBURSED_IND   VARCHAR2(1)

FUNCTION

MRKFUNC.F_GET_FIN_AID_DISBURSED_IND

FINANCIAL_AID_LOAN_IND   VARCHAR2(1)

FUNCTION

MRKFUNC.F_GET_FIN_AID_LOAN_IND

FIN_AID_APPLICANT_IND 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 Date a revised or duplicate grade mailer was sent to the student. DATE

SHRTTRM

SHRTTRM_GRADE_MAILER_CHG_DATE

GRADE_MAILER_DUP_DATE Date a duplicate grade mailer was sent. DATE

SHRTTRM

SHRTTRM_GRADE_MAILER_DUP_DATE

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

SHRTTRM

SHRTTRM_GRADE_MAILER_DUP

GRADE_MAILER_STATUS Status of the grade mailer. VARCHAR2(1)

SHRTTRM

SHRTTRM_RECORD_STATUS_IND

GRADE_MAILER_STATUS_DATE Date associated with the status of the grade mailer. DATE

SHRTTRM

SHRTTRM_RECORD_STATUS_DATE

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

CALCULATION

DECODE(SHRTTRM_RECORD_STATUS_IND)

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

SHRTTRM

SHRTTRM_GRADE_MAILING_DATE

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

SGBSTDN

SGBSTDN_GRAD_CREDIT_APPR_IND

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 List of the descriptions for all the holds assigned to this student. VARCHAR2(4000)

FUNCTION

LISTAGG (HOLD_DESC, '-')

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

FUNCTION

LISTAGG (HOLD, '-')

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

FUNCTION

LISTAGG (HOLD_ORIGINATING_OFFICE_DESC, '-')

HOLD_ORIGIN_DESC_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 Idicates if the student has an institution housing assignement. VARCHAR2(1)

FUNCTION

F_HOUS_THIS_TERM

ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

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

FUNCTION

F_INQUIRER_FNC

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

FUNCTION

F_INST_AID_FNC

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

NA

NA

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

NA

NA

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

FUNCTION

F_FORMAT_NAME

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

SGBSTDN

SGBSTDN_ORSN_CODE

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

STVORSN

STVORSN_DESC

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

SORLCUR

SORLCUR_ROLLED_SEQNO

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

SPRIDEN

SPRIDEN_PIDM

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 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. VARCHAR2(255)

STVPREV

STVPREV_DESC

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

FUNCTION

F_PROSPECT_FNC

REGISTERED_IND 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 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 Recorded registration reason description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

RESIDENCY Residency code for the student identifying the type of charges the student will incur. VARCHAR2(63)

SGBSTDN

SGBSTDN_RESD_CODE

RESIDENCY_DESC Residency code description. VARCHAR2(255)

STVRESD

STVRESD_DESC

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)

CALCULATION

FUNCTION

DECODE(STVRESD_IN_STATE_IND)

DECODE(STVRESD_IN_STATE_IND)

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

FUNCTION

MSKFUNC.F_COUNT_SPORTS

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

FUNCTION

LISTAGG (ACTIVITY_DESC, '-')

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

FUNCTION

LISTAGG (ACTIVITY, '-')

STUDENT_ATTRIBUTE_COUNT Count of student attributes recorded for the student. NUMBER

FUNCTION

MSKFUNC.F_GET_STDNT_ATTR_CNT

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

FUNCTION

LISTAGG (STUDENT_ATTRIBUTE_DESC, '-')

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

FUNCTION

LISTAGG (STUDENT_ATTRIBUTE, '-')

STUDENT_CLASSIFICATION Identifies the student's current class at the institution. The typical VALUES are first year, second year, or freshman, sophomore, etc.. VARCHAR2(63)

FUNCTION

F_CLASS_CALC_FNC

STUDENT_CLASSIFICATION_BOAP Identifies the student?s 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. VARCHAR2(255)

STVCLAS

STVCLAS_DESC

STUDENT_CLASS_BOAP_DESC Beginning of academic period student classification. VARCHAR2(255)

STVCLAS

STVCLAS_DESC

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

FUNCTION

MSKFUNC.F_GET_REG_PLAN_IND

STUDENT_PLAN_EXISTS_IND Indicates whether this student has a Banner registration plan. VARCHAR2(1)

FUNCTION

MSKFUNC.F_GET_REG_PLAN_IND

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's status description. VARCHAR2(255)

STVSTST

STVSTST_DESC

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

NA

NA

SUB_ACADEMIC_PERIOD_DESC Sub academic period description. VARCHAR2(255)

NA

NA

THIRD_PARTY_PLAN_ACTIVE_IND 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 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 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 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 Sum of the continuing education units for the student for this academic period. NUMBER

FUNCTION

F_CALC_REGISTRATION_HOURS

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

FUNCTION

F_CALC_REGISTRATION_HOURS

TOTAL_NON_CEU_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 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 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. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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 Person's veteran category description.  

FUNCTION

GOKODSF.F_GET_DESC

VETERAN_CERTIFICATION_CREDITS Identifies the number of credits the student is certified for this academic period. NUMBER

SGRVETN

SGRVETN_CERT_HOURS

VETERAN_CERTIFICATION_DATE Identifies the date the veteran certification information was created or last updated. DATE

SGRVETN

SGRVETN_VETC_DATE

VETERAN_FILE_NO Veteran administration assigned identification number. VARCHAR2(255)

SPBPERS

SPBPERS_VETC_FILE_NUMBER

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

SPBPERS

SPBPERS_SDVET_IND

VETERAN_TYPE Veteran type associated with the person record. This may indicate if the persons is a gulf war veteran, etc. VARCHAR2(1)

SGRVETN

SGRVETN_VETC_CODE

VETERAN_TYPE_DESC Veteran type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC



Ver: 8.5