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

Banner Operational Data Store
Reporting View Target: GOVERNMENT_STUDENT

Description Contains data for enrolled students required for government reporting. Details are included only for those persons who have a row in ENROLLMENT for the academic period reported. This reporting view can be joined with other reporting views to meet external or internal reporting requirements. The curriculum may also display up to four associated minors. The student's primary curriculum for the academic period will be flagged with the PRIMARY_PROGRAM_IND set to Y.
Key & Frequency One row per person per academic period per student level per program number per reportable cohort per active cohort.
Recommended Search Columns PERSON_UID, ACADEMIC_PERIOD
ACADEMIC_PERIOD
PERSON_UID, COHORT
PERSON_UID, ACADEMIC_PERIOD, PRIMARY_PROGRAM_IND, PROGRAM_NUMBER
ACADEMIC_PERIOD, PRIMARY_PROGRAM_IND

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

SFBETRM

SFBETRM_TERM_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_PERIOD_MATRICULATED Academic Period Matriculated Academic period or time frame in which the student was matriculated in this curriculum. The time period when they began formal study in this academic study. VARCHAR2(63)

SORLCUR

SORLCUR_TERM_CODE_MATRIC

ACADEMIC_PERIOD_MATRIC_DESC Academic Period Matric Description Academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

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

STVTERM

STVTERM_ACYR_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

ACTIVITY1 Activity 1 Activity code that represents official participation in a sport that was defined per the display rules for sport activities. Institution defined. VARCHAR2(63)

SGRSPRT

SGRSPRT_ACTC_CODE

ACTIVITY2 Activity 2 Activity code that represents official participation in a sport that was defined per the display rules for sport activities. Institution defined. VARCHAR2(63)

SGRSPRT

SGRSPRT_ACTC_CODE

ACTIVITY3 Activity 3 Activity code that represents official participation in a sport that was defined per the display rules for sport activities. Institution defined. VARCHAR2(63)

SGRSPRT

SGRSPRT_ACTC_CODE

ACTIVITY4 Activity 4 Activity code that represents official participation in a sport that was defined per the display rules for sport activities. Institution defined. VARCHAR2(63)

SGRSPRT

SGRSPRT_ACTC_CODE

ACTIVITY5 Activity 5 Activity code that represents official participation in a sport that was defined per the display rules for sport activities. Institution defined. VARCHAR2(63)

SGRSPRT

SGRSPRT_ACTC_CODE

ACTIVITY_DESC1 Activity Description 1 Activity code that represents the sport participation. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ACTIVITY_DESC2 Activity Description 2 Activity code that represents the sport participation. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ACTIVITY_DESC3 Activity Description 3 Activity code that represents the sport participation. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ACTIVITY_DESC4 Activity Description 4 Activity code that represents the sport participation. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ACTIVITY_DESC5 Activity Description 5 Activity code that represents the sport participation. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

AGE Age Calculated age (subtract the birth date from the start date for the academic period admit listed for the student). NUMBER

FUNCTION

F_CALCULATE_AGE

ATHLETIC_AID_IND1 Athletic Aid Indicator 1 Indicates whether the person is receiving sport athletic scholarship or aid for this sport activity. VARCHAR2(1)

SGRSPRT

SGRSPRT_ATHL_AID_IND

ATHLETIC_AID_IND2 Athletic Aid Indicator 2 Indicates whether the person is receiving sport athletic scholarship or aid for this sport activity. VARCHAR2(1)

SGRSPRT

SGRSPRT_ATHL_AID_IND

ATHLETIC_AID_IND3 Athletic Aid Indicator 3 Indicates whether the person is receiving sport athletic scholarship or aid for this sport activity. VARCHAR2(1)

SGRSPRT

SGRSPRT_ATHL_AID_IND

ATHLETIC_AID_IND4 Athletic Aid Indicator 4 Indicates whether the person is receiving sport athletic scholarship or aid for this sport activity. VARCHAR2(1)

SGRSPRT

SGRSPRT_ATHL_AID_IND

ATHLETIC_AID_IND5 Athletic Aid Indicator 5 Indicates whether the person is receiving sport athletic scholarship or aid for this sport activity. VARCHAR2(1)

SGRSPRT

SGRSPRT_ATHL_AID_IND

AWARD_CATEGORY 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 Award category description. VARCHAR2(255)

STVACAT

STVACAT_DESC

BIRTH_DATE Birth Date Date of birth for the person. DATE

SPBPERS

SPBPERS_BIRTH_DATE

CAMPUS 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 Campus Description Institution campus name. VARCHAR2(255)

STVCAMP

STVCAMP_DESC

CENSUS_FTE_1 Census FTE - Full Time Equated 1 Calculated value for the portion of a full time credit load for this person. Uses the FTE_DIVISOR1 and TOTAL_CREDITS for this student. NUMBER

CALCULATION

TOTAL_CREDITS / MSKFUNC.F_GET_CENSUS_FTE(COHORT, 'CENSUS_FTE1')

CENSUS_FTE_2 Census FTE - Full Time Equated 2 Calculated value for the portion of a full time credit load for this person. Uses the FTE_DIVISOR2 and TOTAL_CREDITS for this student. NUMBER

CALCULATION

TOTAL_CREDITS / MSKFUNC.F_GET_CENSUS_FTE(COHORT, 'CENSUS_FTE2')

CENSUS_FTE_3 Census FTE - Full Time Equated 3 Calculated value for the portion of a full time credit load for this person. Uses the FTE_DIVISOR3 and TOTAL_CREDITS for this student. NUMBER

CALCULATION

TOTAL_CREDITS / MSKFUNC.F_GET_CENSUS_FTE(COHORT, 'CENSUS_FTE3')

CENSUS_FTE_4 Census FTE - Full Time Equated 4 Calculated value for the portion of a full time credit load for this person. Uses the FTE_DIVISOR4 and TOTAL_CREDITS for this student. NUMBER

CALCULATION

TOTAL_CREDITS / MSKFUNC.F_GET_CENSUS_FTE(COHORT, 'CENSUS_FTE4')

CEU_CREDITS_IND Continuing Education Unit Credits Indicator Number of continuing education units awarded for completion of this course. NUMBER

FUNCTION

F_CALC_REGISTRATION_HOURS

CITIZENSHIP_DESC Citizenship Description Citizen type description. VARCHAR2(255)

STVCITZ

STVCITZ_DESC

CITIZENSHIP_IND Citizenship Indicator Indicates whether the person is a citizen of the institution's home country. VARCHAR2(1)

SPBPERS

SPBPERS_CITZ_IND

CITIZENSHIP_TYPE Citizenship Type Identifies the person's citizen type relationship to the institution's home country. VARCHAR2(63)

SPBPERS

SPBPERS_CITZ_CODE

CITY City Address city, town or municipality. VARCHAR2(63)

SPRADDR

SPRADDR_CITY

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

SGRCHRT

SGRCHRT_CHRT_CODE

COHORT_DESC Cohort Description Cohort code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

COLLEGE 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 Description College, faculty or school name. VARCHAR2(255)

STVCOLL

STVCOLL_DESC

COUNTY County County for this address. VARCHAR2(63)

SPRADDR

SPRADDR_CNTY_CODE

COUNTY_DESC County Description County name for the address. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

CUMULATIVE_GPA Cumulative Grade Point Average or Average GPA or Average for the specified group of courses completed. NUMBER

SHRLGPA

SHRLGPA_GPA

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

DEGREE 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 Description Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc. VARCHAR2(255)

STVDEGC

STVDEGC_DESC

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

STVDEPT

STVDEPT_DESC

ELIGIBILITY1 Eligibility 1 Indicates eligibility to officially participate in this sport as identified in the display rules. VARCHAR2(63)

SGRSPRT

SGRSPRT_ELIG_CODE

ELIGIBILITY2 Eligibility 2 Indicates eligibility to officially participate in this sport as identified in the display rules. VARCHAR2(63)

SGRSPRT

SGRSPRT_ELIG_CODE

ELIGIBILITY3 Eligibility 3 Indicates eligibility to officially participate in this sport as identified in the display rules. VARCHAR2(63)

SGRSPRT

SGRSPRT_ELIG_CODE

ELIGIBILITY4 Eligibility 4 Indicates eligibility to officially participate in this sport as identified in the display rules. VARCHAR2(63)

SGRSPRT

SGRSPRT_ELIG_CODE

ELIGIBILITY5 Eligibility 5 Indicates eligibility to officially participate in this sport as identified in the display rules. VARCHAR2(63)

SGRSPRT

SGRSPRT_ELIG_CODE

ENROLL_CENSUS_DATE1_IND ENROLL_CENSUS_DATE1_IND Identifies this student was enrolled in at least one course as of the first census date. VARCHAR2(1)

FUNCTION

SOKODSF.F_GET_ENROLL_CENSUS_IND

ENROLL_CENSUS_DATE2_IND Enrolled by Census Date 2 Identifies this student was enrolled in at least one course as of the second census date. VARCHAR2(1)

FUNCTION

SOKODSF.F_GET_ENROLL_CENSUS_IND

FIRST_CONCENTRATION First Concentration Concentration or study emphasis attached to the major for the student's academic study. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

FIRST_CONCENTRATION_DESC First Concentration Description Concentration or study emphasis description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

FIRST_MINOR First Minor Minor subject area of the person's academic study. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

FIRST_MINOR_DESC First Minor Description Minor subject area description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

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

SPRIDEN

SPRIDEN_FIRST_NAME

FOURTH_DEPARTMENT Fourth Department Department responsible for the second major or subject area of academic instruction. VARCHAR2(63)

SORLFOS

SORLFOS_DEPT_CODE

FOURTH_DEPARTMENT_DESC Fourth Department Description Department name. VARCHAR2(255)

STVDEPT

STVDEPT_DESC

FOURTH_MAJOR Fourth Major Subject area or major focus recorded for the student's academic study. This may be blank. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

FOURTH_MAJOR_CONC_1 Fourth Major Concentration 1 First concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

FOURTH_MAJOR_CONC_1_DESC Fourth Major Concentration 1 Description Student's concentration description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

FOURTH_MAJOR_CONC_2 Fourth Major Concentration 2 Second concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

FOURTH_MAJOR_CONC_2_DESC Fourth Major Concentration 2 Description Student's concentration description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

FOURTH_MAJOR_CONC_3 Fourth Major Concentration 3 Third concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

FOURTH_MAJOR_CONC_3_DESC Fourth Major Concentration 3 Description Student's concentration description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

FOURTH_MAJOR_DESC Fourth Major Description Major or subject area of study description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

FOURTH_MINOR Fourth Minor Fourth minor for the student within this academic study. This may be blank when no minor has been specified. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

FOURTH_MINOR_DESC Fourth Minor Description Minor area of study description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

FOURTH_PROGRAM_CLASSIFICATION Fourth Program Classification Program classification associated with the major subject area of study for this academic outcome. This may be the Classification of Instructional Program (CIP) codes used by the federal government. VARCHAR2(63)

STVMAJR

STVMAJR_CIPC_CODE

FOURTH_PROGRAM_CLASSIF_DESC Fourth Program Classification Description Program classification code description. VARCHAR2(255)

STVCIPC

STVCIPC_DESC

GENDER Gender Identifies the gender of the person. VARCHAR2(63)

SPBPERS

SPBPERS_SEX

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

CALCULATION

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

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

SPBPERS

SPBPERS_GNDR_CODE

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

GTVGNDR

GTVGNDR_GNDR_DESC

HISPANIC_LATINO_ETHNICITY_IND Hispanic Latino Ethnicity Indicator 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 ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

INTENDED_TIME_STATUS_DESC Intended Time Status Description Indicates whether the student plans to attend with a full time or part time load. VARCHAR2(255)

CALCULATION

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

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

SGBSTDN

SGBSTDN_FULL_PART_IND

LAST_NAME Last Name Last name. VARCHAR2(63)

SPRIDEN

SPRIDEN_LAST_NAME

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

SORLFOS

SORLFOS_MAJR_CODE

MAJOR_DESC Major Description Major subject area name for the person's academic study. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

MIDDLE_NAME Middle Name Middle name. VARCHAR2(63)

SPRIDEN

SPRIDEN_MI

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

NATION Nation Nation associated with the address. VARCHAR2(63)

SPRADDR

SPRADDR_NATN_CODE

NATION_DESC Nation Description Nation name associated with the address record. VARCHAR2(255)

STVNATN

STVNATN_NATION

NATION_OF_BIRTH Nation Of Birth Person's nation of birth. VARCHAR2(63)

GOBINTL

GOBINTL_NATN_CODE_BIRTH

NATION_OF_BIRTH_DESC Nation Of Birth Description Name of the person's nation of birth. VARCHAR2(255)

STVNATN

STVNATN_NATION

NATION_OF_CITIZENSHIP Nation Of Citizenship Nation of citizen recorded for the person. Important for some institutions, for understanding enrollment patterns and for reporting. VARCHAR2(63)

GOBINTL

GOBINTL_NATN_CODE_BIRTH

NATION_OF_CITIZENSHIP_DESC Nation Of Citizenship Description Name of the person's nation of citizenship. VARCHAR2(255)

STVNATN

STVNATN_NATION

NON_TRADITIONAL_STUDENT_IND Non Traditional Student Indicator Year long or non degree seeking students. VARCHAR2(63)

NA

NA

ORIENTATION_SESSION Orientation Session Orientation session recorded for the student. VARCHAR2(63)

SGBSTDN

SGBSTDN_ORSN_CODE

ORIENTATION_SESSION_DESC Orientation Session Description Description recorded for the orientation session recorded for the student. VARCHAR2(255)

STVORSN

STVORSN_DESC

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

SPBPERS

SPBPERS_PPRN_CODE

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

GTVPPRN

GTVPPRN_PPRN_DESC

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

SFBETRM

SFBETRM_PIDM

POSTAL_CODE Postal Code Address postal or postal code. VARCHAR2(63)

SPRADDR

SPRADDR_ZIP

PRIMARY_ETHNICITY Primary Ethnicity Person's ethnicity. VARCHAR2(63)

SPBPERS

SPBPERS_ETHN_CODE

PRIMARY_ETHNICITY_DESC Primary Ethnicity Description Ethnic code description. VARCHAR2(255)

STVETHN

STVETHN_DESC

PRIMARY_PROGRAM_IND Primary Program Indicator Indicates whether this is the student's primary academic study or program. VARCHAR2(1)

FUNCTION

CASE PROGRAM_NUMBER WHEN 1 THEN 'Y' ELSE 'N' END

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

STVETHN

STVETHN_ETCT_CODE

PRIM_ETHNICITY_CATEGORY_DESC Primary Ethnicity Category Description Ethnic category description as defined by the government reporting. VARCHAR2(255)

STVETCT

STVETCT_DESC

PRIM_MEDICAL_CONDITION_DESC Prim Medical Condition Description Medical condition description. VARCHAR2(255)

STVMEDI

STVMEDI_DESC

PRIM_MEDICAL_CONDTION Prim Medical Condtion Medical condition marked as the primary disability. VARCHAR2(63)

SPRMEDI

SPRMEDI_MEDI_CODE

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

NA

NA

PROGRAM 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 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_2 Program Classification 2 Program classification associated with the major subject area of study for this academic outcome. This 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 Program classification code description. VARCHAR2(255)

STVCIPC

STVCIPC_DESC

PROGRAM_CLASSIFICATION_DESC_2 Program Classification Description 2 Program classification code description. VARCHAR2(255)

STVCIPC

STVCIPC_DESC

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

SMRPRLE

SMRPRLE_PROGRAM_DESC

PROGRAM_NUMBER Program Number Unique sequence number that identifies this academic study or program for the student. VARCHAR2(3)

FUNCTION

ROW_NUMBER() OVER (PARTITION BY SORLCUR_PIDM, SGBSTDN_TERM_CODE_EFF ORDER BY SORLCUR_PRIORITY_NO)

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

FUNCTION

MGKFUNC.F_COUNT_RACE_CATEGORY

RACE_COUNT Race Count Number of races selected by this person. NUMBER

FUNCTION

MGKFUNC.F_COUNT_RACE

RACE_ETHNICITY_CONFIRM_DATE Race Ethnicity Confirm Date Race and ethnicity self confirmed date. DATE

SPBPERS

SPBPERS_CONFIRMED_RE_DATE

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

SPBPERS

SPBPERS_CONFIRMED_RE_CDE

REGISTRATION_REASON Registration Reason Reason recorded at the time of registration for this academic period. VARCHAR2(63)

SFBETRM

SFBETRM_RGRE_CODE

REGISTRATION_REASON_DESC Registration Reason Description Reason description associated with this student registration. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SGBSTDN

SGBSTDN_RESD_CODE

RESIDENCY_DESC Residency Description Student's residency description. Typically used to calculate fees to be charges and may indicate in area or out of area. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SECOND_CONCENTRATION Second Concentration Concentration or study emphasis attached to the major for the student's academic study. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

SECOND_CONCENTRATION_DESC Second Concentration Description Concentration or study emphasis description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

SECOND_DEPARTMENT Second Department Department responsible for the major or subject area of academic instruction. VARCHAR2(63)

SORLFOS

SORLFOS_DEPT_CODE

SECOND_DEPARTMENT_DESC Second Department Description Department name. VARCHAR2(255)

STVDEPT

STVDEPT_DESC

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

SORLFOS

SORLFOS_MAJR_CODE

SECOND_MAJOR_CONC_1 Second Major Concentration 1 First concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

SECOND_MAJOR_CONC_1_DESC Second Major Concentration 1 Description Student's concentration description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

SECOND_MAJOR_CONC_2 Second Major Concentration 2 Second concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

SECOND_MAJOR_CONC_2_DESC Second Major Concentration 2 Description Student's concentration description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

SECOND_MAJOR_CONC_3 Second Major Concentration 3 Third concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

SECOND_MAJOR_CONC_3_DESC Second Major Concentration 3 Description Student's concentration description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

SECOND_MAJOR_DESC Second Major Description Major or subject area of study description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

SECOND_MINOR Second Minor Second minor for the student within this academic study. This may be blank when no minor has been specified. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

SECOND_MINOR_DESC Second Minor Description Minor area of study description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

SITE Site Site or location to which applicant is applying. VARCHAR2(63)

CALCULATION

DECODE(SORLCUR_SITE_CODE)

SITE_CARRIER_ROUTE Site Carrier Route Carrier route associated with the site address for barcode mailings. VARCHAR2(63)

NA

NA

SITE_CITY Site City City town or municipality associated with the site address. VARCHAR2(63)

STVSITE

STVSITE_CITY

SITE_CORRECTION_DIGIT Site Correction Digit Correction digit associated with the site address for barcode mailings. VARCHAR2(63)

NA

NA

SITE_COUNTY_CODE Site County Code County associated with the site address. VARCHAR2(63)

NA

NA

SITE_COUNTY_CODE_DESC Site County Code Description Descriptions of the county associated with the site address. VARCHAR2(255)

NA

NA

SITE_DELIVERY_POINT Site Delivery Point Delivery point associated with the site address for barcode mailings. VARCHAR2(63)

NA

NA

SITE_DESC Site Description Site or location name. VARCHAR2(255)

STVSITE

STVSITE_DESC

SITE_NATION Site Nation Nation/country code associated with the site address. VARCHAR2(63)

STVSITE

STVSITE_NATION_CODE

SITE_NATION_DESC Site Nation Description Description for the nation/country associated with the site address. VARCHAR2(255)

STVNATN

STVNATN_NATION

SITE_POSTAL_CODE Site Postal Code Postal code associated with the site address. VARCHAR2(63)

STVSITE

STVSITE_ZIPC

SITE_STATE_PROVINCE Site State Province Identifies the state or province associated with this address. VARCHAR2(63)

STVSITE

STVSITE_STATE

SITE_STATE_PROVINCE_DESC Site State Province Description Name of the state/province. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

SITE_STREET_LINE1 Site Street Line1 First line of the site address. VARCHAR2(255)

STVSITE

STVSITE_STREET_ADDR1

SITE_STREET_LINE2 Site Street Line2 Second line of the site address. VARCHAR2(255)

STVSITE

STVSITE_STREET_ADDR2

SITE_STREET_LINE3 Site Street Line3 Third line of the site address. VARCHAR2(255)

STVSITE

STVSITE_STREET_ADDR3

SITE_STREET_LINE4 Site Street Line4 Fourth line of the site address. VARCHAR2(255)

NA

NA

SPORT_STATUS1 Sport Status 1 Current status for the sport participation for the sport selected in the display rules. VARCHAR2(63)

SGRSPRT

SGRSPRT_SPST_CODE

SPORT_STATUS2 Sport Status 2 Current status for the sport participation for the sport selected in the display rules. VARCHAR2(63)

SGRSPRT

SGRSPRT_SPST_CODE

SPORT_STATUS3 Sport Status 3 Current status for the sport participation for the sport selected in the display rules. VARCHAR2(63)

SGRSPRT

SGRSPRT_SPST_CODE

SPORT_STATUS4 Sport Status 4 Current status for the sport participation for the sport selected in the display rules. VARCHAR2(63)

SGRSPRT

SGRSPRT_SPST_CODE

SPORT_STATUS5 Sport Status 5 Current status for the sport participation for the sport selected in the display rules. VARCHAR2(63)

SGRSPRT

SGRSPRT_SPST_CODE

SPORT_STATUS_DESC1 Sport Status Description 1 Student participation status description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SPORT_STATUS_DESC2 Sport Status Description 2 Student participation status description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SPORT_STATUS_DESC3 Sport Status Description 3 Student participation status description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SPORT_STATUS_DESC4 Sport Status Description 4 Student participation status description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SPORT_STATUS_DESC5 Sport Status Description 5 Student participation status description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

STATE_PROVINCE State Province State or province associated with this address. VARCHAR2(63)

SPRADDR

SPRADDR_STAT_CODE

STATE_PROVINCE_DESC State Province Description State or province name associated with the address record. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

STUDENT_CLASSIFICATION 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 Student Classification - Beginning of Academic Period 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 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_LEVEL 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 Student level description. VARCHAR2(255)

STVLEVL

STVLEVL_DESC

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

FUNCTION

NVL(SORLCUR_STYP_CODE, SGBSTDN_STYP_CODE)

STUDENT_POPULATION_DESC Student Population Description Student population or type description. VARCHAR2(255)

STVSTYP

STVSTYP_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_CONCENTRATION Third Concentration Concentration or study emphasis attached to the major for the student's academic study. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

THIRD_CONCENTRATION_DESC Third Concentration Description Concentration or study emphasis description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

THIRD_DEPARTMENT Third Department Department responsible for the major or subject area of academic instruction. VARCHAR2(63)

SORLFOS

SORLFOS_DEPT_CODE

THIRD_DEPARTMENT_DESC Third Department Description Department name. VARCHAR2(255)

STVDEPT

STVDEPT_DESC

THIRD_MAJOR Third Major Subject area or major focus recorded for the student's academic study. This may be blank. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

THIRD_MAJOR_CONC_1 Third Major Concentration 1 First concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

THIRD_MAJOR_CONC_1_DESC Third Major Concentration 1 Description Student's concentration description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

THIRD_MAJOR_CONC_2 Third Major Concentration 2 Second concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

THIRD_MAJOR_CONC_2_DESC Third Major Concentration 2 Description Student's concentration description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

THIRD_MAJOR_CONC_3 Third Major Concentration 3 Third concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

THIRD_MAJOR_CONC_3_DESC Third Major Concentration 3 Description Student's concentration description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

THIRD_MAJOR_DESC Third Major Description Major or subject area of study description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

THIRD_MINOR Third Minor Third minor for the student within this academic study. This may be blank when no minor has been specified. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

THIRD_MINOR_DESC Third Minor Description Minor area of study description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

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

STVMAJR

STVMAJR_CIPC_CODE

THIRD_PROGRAM_CLASSIF_DESC Third Program Classification Description Program classification code description. VARCHAR2(255)

STVCIPC

STVCIPC_DESC

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

FUNCTION

F_CALC_REGISTRATION_HOURS

TOTAL_CREDITS_ATTEMPTED Total Credits Attempted Credits used to sum the credits attempted by a student per the rules of the institution. NUMBER

SHRLGPA

SHRLGPA_HOURS_ATTEMPTED

TOTAL_CREDITS_EARNED Total Credits Earned Credits used to sum the credits earned by a student per the rules of the institution. NUMBER

SHRLGPA

SHRLGPA_HOURS_EARNED

TOTAL_CREDITS_PASSED Total Credits Passed Credits used to sum the credits passed by a student per the rules of the institution. NUMBER

SHRLGPA

SHRLGPA_HOURS_PASSED

TOTAL_GPA_CREDITS Credits for Grade Point Average or Average Credits used in the calculation of a person's GPA or Average per the rules of the institution. NUMBER

SHRLGPA

SHRLGPA_GPA_HOURS

TOTAL_QUALITY_POINTS Total Quality Points Quality points used in the calculation of a person's GPA per the rules of the institution. NUMBER

SHRLGPA

SHRLGPA_QUALITY_POINTS

VISA_EXPIRE_DATE Visa Expire Date Date recorded as the date on which this current visa expires. DATE

GORVISA

GORVISA_VISA_EXPIRE_DATE

VISA_START_DATE Visa Start Date Date, if any, recorded as the date on which this current visa begins. DATE

GORVISA

GORVISA_VISA_START_DATE

VISA_TYPE Visa Type Type of visa issued to this person. For example, student, employment, visitor, etc. VARCHAR2(63)

GORVISA

GORVISA_VTYP_CODE

VISA_TYPE_DESC Visa Type Description Visa type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC



Ver: 9.2