Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Student Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: GOVERNMENT_ADMISSIONS

Description Contains the common data required for government reporting on application statistics for a time frame. Contain only the academic period and person who have to the institution with all details regarding that application. This reporting view may be joined with other reporting views for external and or internal report requirements.
Key & Frequency One row per person per academic period per application number.
Recommended Search Columns PERSON_UID, TEST_RULE
ACADEMIC_PERIOD
PERSON_UID, ACADEMIC_PERIOD, APPLICATION_NUMBER
ACADEMIC_PERIOD, PERSON_UID
ACADEMIC_PERIOD, STUDENT_LEVEL, PROGRAM
ACADEMIC_PERIOD, PERSON_UID, APPLICATION_NUMBER
COHORT, ACADEMIC_PERIOD

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Academic period or time frame this person applied to study at this institution. VARCHAR2(63)

SARADAP

SARADAP_TERM_CODE_ENTRY

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

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

STVTERM

STVTERM_ACYR_CODE

ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

AGE Calculated Age (subtract the birth date from the current system date). NUMBER

FUNCTION

F_CALCULATE_AGE

APPLICATION_NUMBER Application number for the admission application record for a specific academic period. NUMBER

SABSUPL

SABSUPL_APPL_NO

AWARD_CATEGORY Award category associated with the outcome, degree or award. Category used to group outcomes for reporting similar awards together. For example, less than two year, two year and four year awards. VARCHAR2(63)

STVDEGC

STVDEGC_ACAT_CODE

AWARD_CATEGORY_DESC Award category description. VARCHAR2(255)

STVACAT

STVACAT_DESC

BIRTH_DATE Date of birth for the person. DATE

SPBPERS

SPBPERS_BIRTH_DATE

CAMPUS Campus to which applicant is applying. VARCHAR2(63)

SARADAP

SORLCUR

SARADAP_CAMP_CODE

SORLCUR_CAMP_CODE

CAMPUS_DESC Institution campus name. VARCHAR2(255)

STVCAMP

STVCAMP_DESC

CITIZENSHIP_IND Indicates whether the person has been identified as a citizen of the institution's home country. VARCHAR2(1)

SPBPERS

SPBPERS_CITZ_IND

COHORT Cohort tracking group assigned to the application through the Administrative UI display rules. VARCHAR2(63)

SARCHRT

SARCHRT_CHRT_CODE

COHORT_DESC Cohort code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

COLLEGE College, faculty or school to which the academic study for the student is associated. VARCHAR2(63)

SARADAP

SORLCUR

SARADAP_COLL_CODE_1

SORLCUR_COLL_CODE

COLLEGE_DESC College, faculty or school name. VARCHAR2(255)

STVCOLL

STVCOLL_DESC

COUNTY_ADMIT Indicates the county code of the student when they were admitted. The value is either stored in the administrative system or determined via a rule to look at a specific address and take the value. VARCHAR2(63)

SABSUPL

SABSUPL_CNTY_CODE_ADMIT

COUNTY_DESC_ADMIT County associated with the county code at the time of admission. VARCHAR2(255)

STVCNTY

STVCNTY_DESC

CURRICULUM_ORDER Unique sequence number that identifies this academic study or program for the student. NUMBER

CALCULATION

ROW_NUMBER

DEGREE Degree or award code associated with the academic study. VARCHAR2(63)

SARADAP

SORLCUR

SARADAP_DEGC_CODE_1

SORLCUR_DEGC_CODE

DEGREE_DESC Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc. VARCHAR2(255)

STVDEGC

STVDEGC_DESC

DEPARTMENT Department associated with the academic study on the admission application. VARCHAR2(63)

SARADAP

SORLFOS

SARADAP_DEPT_CODE

SORLFOS_DEPT_CODE

DEPARTMENT_DESC Department name. VARCHAR2(255)

STVDEPT

STVDEPT_DESC

EDUCATION_GOAL Applicant's educational goal at the time of application. VARCHAR2(63)

SARADAP

SARADAP_EGOL_CODE

EDUCATION_GOAL_DESC Educational goal description. VARCHAR2(255)

STVEGOL

STVEGOL_DESC

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

SARADAP

SARADAP_EDLV_CODE

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

STVEDLV

STVEDLV_DESC

FIRST_NAME Person's first or given name. VARCHAR2(63)

SPRIDEN

SPRIDEN_FIRST_NAME

GENDER Person's gender. Values are Male, Female or Not reported to the institution. VARCHAR2(63)

SPBPERS

SPBPERS_SEX

GENDER_DESC Identify as Male, Female or Not reported. VARCHAR2(63)

CALCULATION

DECODE(SPBPERS_SEX,'M','MALE','F','FEMALE','N','NOT REPORTED')

HISPANIC_LATINO_ETHNICITY_IND Indicates if person's ethnicity is Latino or Hispanic. Due to mandated changes to the collection of race and ethnicity, these classifications were changed to separate Race and Ethnicity. Ethnicity can now be defined as either Hispanic or Latino, or Not Hispanic or Latino. VARCHAR2(1)

SPBPERS

SPBPERS_ETHN_CODE

ID ID number given to the student to track their records at the institution. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

INTENDED_TIME_STATUS_DESC Indicates whether the student plans to attend with a full time or part time load. VARCHAR2(9)

CALCULATION

DECODE(SARADAP_FULL_PART_IND,'F', 'FULL TIME', 'P', 'PART TIME')

INTENDED_TIME_STATUS_IND Flag indicating whether the change in time status was calculated by the system or overridden and updated by a user. VARCHAR2(1)

SARADAP

SARADAP_FULL_PART_IND

LAST_NAME Last name. VARCHAR2(63)

SPRIDEN

SPRIDEN_LAST_NAME

LATEST_POST_SECONDARY_DESC Name of the post secondary institution attended. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

LATEST_POST_SECONDARY_SCHOOL Post secondary institution attended. VARCHAR2(63)

SORPCOL

SORPCOL_SBGI_CODE

LATEST_SECONDARY_SCHOOL Secondary institution attended. VARCHAR2(63)

SORHSCH

SORHSCH_SBGI_CODE

LATEST_SECONDARY_SCHOOL_DESC Name of the secondary institution attended. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

MAJOR Major subject area of the person's academic study. VARCHAR2(63)

SARADAP

SORLFOS

SARADAP_MAJR_CODE_1

SORLFOS_MAJR_CODE

MAJOR_DESC Name of the student's major subject area. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

MIDDLE_NAME Middle name. VARCHAR2(63)

SPRIDEN

SPRIDEN_MI

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

NATION_ADMIT Student's nation when they were admitted. The code is either stored in the Administrative UI, or determined via a rule to look at a specific address and take the value. VARCHAR2(63)

SABSUPL

SABSUPL_NATN_CODE_ADMIT

NATION_DESC_ADMIT Name of the nation of residence when the person was admitted. VARCHAR2(255)

STVNATN

STVNATN_NATION

PERSON_UID Internally generated by the system to uniquely identify the person or entity. NUMBER

SARADAP

SARADAP_PIDM

POST_SECONDARY_DEGREE Identifies the degree or award completed. This always shows the latest degree earned. VARCHAR2(63)

SORDEGR

SORDEGR_DEGR_SEQ_NO

POST_SECONDARY_DEGREE_DESC Post secondary degree or award description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

POST_SECONDARY_HONORS Identifies if an honor recognition is associated with the previous education degree or award. VARCHAR2(63)

SORDEGR

SORDEGR_HONR_CODE

POST_SECONDARY_HONORS_DESC Post secondary degree honor description associated with the degree or award. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PRIMARY_ETHNICITY Person's ethnicity. VARCHAR2(63)

SPBPERS

SPBPERS_ETHN_CODE

PRIMARY_ETHNICITY_DESC Ethnic code description. VARCHAR2(255)

STVETHN

STVETHN_DESC

PRIM_ETHNICITY_CATEGORY Ethnic group used for governmental reporting. VARCHAR2(63)

STVETHN

STVETHN_ETCT_CODE

PRIM_ETHNICITY_CATEGORY_DESC Ethnic category description as defined by the government reporting. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

PROGRAM Program or course of study for the student. This may be blank when programs are not being used to manage a set of completion requirements. VARCHAR2(63)

SORLCUR

SORLCUR_PROGRAM

PROGRAM_CLASSIFICATION Program classification associated with the major subject area of study for this outcome. Thsi may be the Classification of Institutional Program (CIP) codes used for reporting to the federal government. VARCHAR2(63)

STVMAJR

STVMAJR_CIPC_CODE

PROGRAM_CLASSIFICATION_DESC Program classification description. VARCHAR2(255)

STVCIPC

STVCIPC_DESC

PROGRAM_DESC Program or course of study description. VARCHAR2(255)

SMRPRLE

SMRPRLE_PROGRAM_DESC

PS_EDUCATION_GOAL NA VARCHAR2(63)

NA

NA

PS_EDUCATION_GOAL_DESC NA VARCHAR2(255)

NA

NA

PS_GPA_TRANSFERRED Transferred GPA from the person's previous post-secondary experience. VARCHAR2(63)

SORDEGR

SORDEGR_GPA_TRANSFERRED

PS_SCHOOL_PERCENTILE Person's class percentile as related to class rank and size. NUMBER

NA

NA

PS_SCHOOL_RANK Identifies the person's class rank. NUMBER

NA

NA

PS_SCHOOL_SIZE Person's class size. NUMBER

NA

NA

RACE_CATEGORY_COUNT Number of unique regulatory races selected by this person. NUMBER

FUNCTION

MGKFUNC.F_COUNT_RACE_CATEGORY

RACE_COUNT Number of races selected by this person. NUMBER

FUNCTION

MGKFUNC.F_COUNT_RACE

RACE_ETHNICITY_CONFIRM_DATE Race and ethnicity self confirmed date. DATE

SPBPERS

SPBPERS_CONFIRMED_RE_DATE

RACE_ETHNICITY_CONFIRM_IND Indicates if the person's race and ethnicity have been self-identified. VARCHAR2(1)

SPBPERS

SPBPERS_CONFIRMED_RE_CDE

SECONDARY_SCHOOL_DIPLOMA Diploma type earned at the secondary school attended. VARCHAR2(63)

SORHSCH

SORHSCH_DPLM_CODE

SECONDARY_SCHOOL_DIPLOMA_DESC Secondary school diploma type name. For example, College Prep, Vocational, etc. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SECONDARY_SCHOOL_GRAD_DATE Date the person graduated. DATE

SORHSCH

SORHSCH_GRADUATION_DATE

SECONDARY_SCHOOL_PERCENTILE Person's class percentile as related to class rank and size. NUMBER

SORHSCH

SORHSCH_PERCENTILE

SECONDARY_SCHOOL_RANK Person's class rank. NUMBER

SORHSCH

SORHSCH_CLASS_RANK

SECONDARY_SCHOOL_REPORTED_GPA Person's secondary school GPA or Average. VARCHAR2(63)

SORHSCH

SORHSCH_GPA

SECONDARY_SCHOOL_SIZE Person's class size. NUMBER

SORHSCH

SORHSCH_CLASS_SIZE

STATE_PROVINCE_ADMIT State/province code of the student when they were admitted. The value is either stored in the Administrative UI, or determined via a rule to look at a specific address and take the value. VARCHAR2(63)

SABSUPL

SABSUPL_STAT_CODE_ADMIT

STATE_PROVINCE_DESC_ADMIT State or province name where the person resided when they were admitted. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

STUDENT_LEVEL Student level associated with the coursework in the academic outcome. Examples, include undergraduate and graduate, etc. VARCHAR2(63)

SORLCUR

SORLCUR_LEVL_CODE

STUDENT_LEVEL_DESC Student level description. VARCHAR2(255)

STVLEVL

STVLEVL_DESC

STUDENT_POPULATION Student population or type for reporting. May include populations like new freshman, transfer, continuing, etc. VARCHAR2(63)

SARADAP

SARADAP_STYP_CODE

STUDENT_POPULATION_DESC Student population or type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SARADAP

SARADAP_RESD_CODE

STUDENT_RESIDENCY_DESC Student residency code description. VARCHAR2(255)

STVRESD

STVRESD_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

TEST1 Test score code associated with various tests, i.e., SAT, ACT, placement scores. VARCHAR2(63)

SORTEST

SORTEST_TESC_CODE

TEST2 Test score code associated with various tests, i.e., SAT, ACT, placement scores. VARCHAR2(63)

SORTEST

SORTEST_TESC_CODE

TEST3 Test score code associated with various tests, i.e., SAT, ACT, placement scores. VARCHAR2(63)

SORTEST

SORTEST_TESC_CODE

TEST4 Test score code associated with various tests, i.e., SAT, ACT, placement scores. VARCHAR2(63)

SORTEST

SORTEST_TESC_CODE

TEST5 Test score code associated with various tests, i.e., SAT, ACT, placement scores. VARCHAR2(63)

SORTEST

SORTEST_TESC_CODE

TEST6 Test score code associated with various tests, i.e., SAT, ACT, placement scores. VARCHAR2(63)

SORTEST

SORTEST_TESC_CODE

TEST7 Test score code associated with various tests, i.e., SAT, ACT, placement scores. VARCHAR2(63)

SORTEST

SORTEST_TESC_CODE

TEST_DESC1 Test description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

TEST_DESC2 Test description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

TEST_DESC3 Test description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

TEST_DESC4 Test description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

TEST_DESC5 Test description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

TEST_DESC6 Test description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

TEST_DESC7 Test description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

TEST_RULE Institution defined display rule set up in MGRSDAX that determines which test scores are displayed for this person. VARCHAR2(63)

MGRSDAX

MGRSDAX_INTERNAL_CODE

TRANSFER_CREDIT_ATTEMPTED Transferred credits attempted. NUMBER

SHRLGPA

SHRLGPA_HOURS_ATTEMPTED

TRANSFER_CREDIT_EARNED Transferred credits earned. NUMBER

SHRLGPA

SHRLGPA_HOURS_EARNED

TRANSFER_CREDIT_GPA Average or Grade Point Average for the credits and grades transferred to this institution. NUMBER

SHRLGPA

SHRLGPA_GPA

TRANSFER_CREDIT_GPA_CREDIT Transferred credits used in the transfer average or grade point average calculation. NUMBER

SHRLGPA

SHRLGPA_GPA_HOURS

TRANSFER_CREDIT_QUALITY_POINTS Transferred quality points. NUMBER

SHRLGPA

SHRLGPA_QUALITY_POINTS



Ver: 8.0