RETURN TO REPORTING VIEW REPORTS LIST
(EDW Source Report)
Student Reporting View Reports

SGHE 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.
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_OUTCOME_ENROLLED_IND 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 or time frame associated with the information on the student record. 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

FUNCTION

MSKFUNC.F_ACAD_STUDY_MATRIC_IN_COUNT

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 Organization-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

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

FUNCTION

F_LEVEL_APPL_FNC

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

FUNCTION

MSKFUNC.F_COUNT_COHORTS

COMBINED_ACADEMIC_STANDING Combined academic standing for the student. VARCHAR2(63)

SGBSTDN

SHRTTRM

STVCAST

SGBSTDN_CAST_CODE

SHRTTRM_CAST_CODE

STVCAST_CODE

COMBINED_ACAD_STANDING_DESC Combined academic standing code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

COMBINED_ACAD_STANDING_PERIOD Academic period associated with the combined academic standing for the student. VARCHAR2(63)

SGBSTDN

SGBSTDN_TERM_CODE_CAST

COMB_ACAD_STNDG_PERIOD_DESC Academic period description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

CONTINUING_EDUCATION_IND 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 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

GOKODSF.F_GET_DESC

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)

FUNCTION

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

FUNCTION

GOKODSF.F_GET_DESC

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

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

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

FUNCTION

F_HOUS_THIS_TERM

ID Person's or organization's current identification number. 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(94)

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)

FUNCTION

GOKODSF.F_GET_DESC

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)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

F_PROSPECT_FNC

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 of the student typically used to calculate tuition and fees to be charged. VARCHAR2(63)

SGBSTDN

SGBSTDN_RESD_CODE

RESIDENCY_DESC Residency code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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)

STVRESD

STVRESD_IN_STATE_IND

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

FUNCTION

MSKFUNC.F_COUNT_SPORTS

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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)

FUNCTION

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

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

SGRVETN

SGRVETN_VETC_CODE

VETERAN_TYPE_DESC Veteran type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC



Ver: 3.1