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

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. Contains only the academic period and person who have applied 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 per curriculum per test rule.
Recommended Search Columns PERSON_UID, ACADEMIC_PERIOD
ACADEMIC_PERIOD
ACADEMIC_PERIOD, PERSON_UID, APPLICATION_NUMBER
COHORT, ACADEMIC_PERIOD
PERSON_UID, TEST_RULE
PERSON_UID, ACADEMIC_PERIOD, APPLICATION_NUMBER
ACADEMIC_PERIOD, STUDENT_LEVEL, PROGRAM

Target Column Business Definition Database Data Type Source Name Source Column
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)

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

APPLICANT_ACCEPT_IND This decision code indicates the applicant has accepted the admissions offer. VARCHAR2(1)

CALCULATION

DECODE(STVAPDC_STDN_ACC_IND)

APPLICATION_INACTIVE_IND This decision code indicates an inactive application status. VARCHAR2(1)

CALCULATION

DECODE(STVAPDC_APPL_INACT)

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

SARADAP

SARADAP_APPL_NO

APPLICATION_SIGNIF_IND Identifies whether the decision affects the acceptance of the application. Y - Application acceptance is effected by decision. VARCHAR2(1)

CALCULATION

DECODE(STVAPDC_SIGNF_IND)

AWARD_CATEGORY Government reporting category that groups awards and degrees together to count students. For example, Less than 2 yr, 2 yr, Bachelor, etc. 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 associated with this record. Campus for the course section, student course, student, applied for on the admission application, etc. VARCHAR2(63)

SORLCUR

SORLCUR_CAMP_CODE

CAMPUS_DESC Institution campus name. VARCHAR2(255)

STVCAMP

STVCAMP_DESC

CITIZENSHIP_IND Indicates whether the person is 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 First level of the institution organization structure that owns the student or the academic instruction for a student course. VARCHAR2(63)

SORLCUR

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

DECISION Value associated with the application number and decision for this academic period. VARCHAR2(63)

SARAPPD

SARAPPD_APDC_CODE

DECISION_DATE Date application decision was applied. DATE

SARAPPD

SARAPPD_APDC_DATE

DECISION_DESC Decision code description such as applicant accepted, pending decision, quick admit. VARCHAR2(255)

SARAPPD

SARAPPD_APDC_CODE

DECISION_NUMBER Internal decision sequence number associated with this decision for this application number. NUMBER

SARAPPD

SARAPPD_SEQ_NO

DECISION_SOURCE Identifies whether this decision is an institution decision or applicant decision. VARCHAR2(63)

FUNCTION

DECODE(GOKODSF.F_GET_DESC)

DEGREE Award, degree, diploma, certification upon completion of all the requirements for a particular academic study. For example, Bachelor of Science, Associate of Arts, Vocational Certificate. This information will be taken from the ODS Academic Study or Academic Outcome or Admissions Application reporting view as appropriate for the star scheme. VARCHAR2(63)

SORLCUR

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 responsible for the major subject area of a student course or associated with the major within the student academic study. VARCHAR2(63)

SORLFOS

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 Identifies the gender of the person. 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')

GENDER_DESIGNATION This gender identity of the person. VARCHAR2(63)

SPBPERS

SPBPERS_GNDR_CODE

GENDER_DESIGNATION_DESC The description of the gender identity. VARCHAR2(255)

GTVGNDR

GTVGNDR_GNDR_DESC

HISPANIC_LATINO_ETHNICITY_IND Indicates if person's ethnicity is Latino or Hispanic.This one ethnicity group was identified as a federal reporting group for ethnicity and race categories. VARCHAR2(1)

SPBPERS

SPBPERS_ETHN_CDE

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

SPRIDEN

SPRIDEN_ID

INSTITUTION_ADMIT_IND This decision code indicates an institution admit status. VARCHAR2(1)

CALCULATION

DECODE(STVAPDC_INST_ACC_IND)

INSTITUTION_DENIED_IND This decision code indicates an institution denied status. VARCHAR2(1)

CALCULATION

DECODE(STVAPDC_REJECT_IND)

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

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

MAINTAINED_IND Indicates whether the application decision was maintained by the system or the user. VARCHAR2(1)

SARAPPD

SARAPPD_MAINT_IND

MAINTENANCE_USER_ID Identification number of the most recent user to create or update a record. VARCHAR2(63)

SARAPPD

SARAPPD_USER

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

SORLFOS

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

PERSONAL_PRONOUN The personal pronoun of the person. VARCHAR2(63)

SPBPERS

SPBPERS_PPRN_CODE

PERSONAL_PRONOUN_DESC The description of the personal pronoun. VARCHAR2(255)

GTVPPRN

GTVPPRN_PPRN_DESC

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 Student's program, curriculum or course of study. This may be Data Not Available when program codes have not been defined by the institution. The alternate curriculum identification is by a combination of college, degree and major codes. VARCHAR2(63)

SORLCUR

SORLCUR_PROGRAM

PROGRAM_CLASSIFICATION Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting. 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 Level of study for the students program or course work. For example, Undergraduate, Graduate, Credit, Continuing Education, etc. VARCHAR2(63)

SORLCUR

SORLCUR_LEVL_CODE

STUDENT_LEVEL_DESC Student level description. VARCHAR2(255)

STVLEVL

STVLEVL_DESC

STUDENT_POPULATION Identifies the category this student that will be used for governmental reporting. The typical VALUES are new first time, 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

TEST_SCORE1 Test score value for this test code, date and person. VARCHAR2(63)

SORTEST

SORTEST_TEST_SCORE

TEST_SCORE2 Test score value for this test code, date and person. VARCHAR2(63)

SORTEST

SORTEST_TEST_SCORE

TEST_SCORE3 Test score value for this test code, date and person. VARCHAR2(63)

SORTEST

SORTEST_TEST_SCORE

TEST_SCORE4 Test score value for this test code, date and person. VARCHAR2(63)

SORTEST

SORTEST_TEST_SCORE

TEST_SCORE5 Test score value for this test code, date and person. VARCHAR2(63)

SORTEST

SORTEST_TEST_SCORE

TEST_SCORE6 Test score value for this test code, date and person. VARCHAR2(63)

SORTEST

SORTEST_TEST_SCORE

TEST_SCORE7 Test score value for this test code, date and person. VARCHAR2(63)

SORTEST

SORTEST_TEST_SCORE

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: 9.1