RETURN TO REPORTING VIEW REPORTS LIST
Student Reporting View Reports

SGHE 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 with other reporting views to meet external or internal reporting requirements.
Key & Frequency One row per person per academic period.
Recommended Search Columns PERSON_UID, ACADEMIC_PERIOD
ACADEMIC_PERIOD
ACADEMIC_PERIOD, STUDENT_CLASSIFICATION_BOAP
PERSON_UID, STUDENT_LEVEL, ACADEMIC_PERIOD
STUDENT_CLASSIFICATION, STUDENT_LEVEL, ACADEMIC_PERIOD
ACADEMIC_PERIOD, STUDENT_LEVEL
STUDENT_LEVEL
PERSON_UID, ACADEMIC_PERIOD, PRIMARY_PROGRAM_IND
ACADEMIC_PERIOD, PRIMARY_PROGRAM_IND
PERSON_UID, COHORT

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Academic period or time frame for this student enrollment record. VARCHAR2(63)

SFBETRM

SFBETRM_TERM_CODE

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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)

SGBSTDN

SORLCUR

SGBSTDN_TERM_CODE_MATRIC

SORLCUR_TERM_CODE_MATRIC

ACADEMIC_PERIOD_MATRIC_DESC Academic period description. VARCHAR2(255)

FUNCTION

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

ACTIVITY1 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 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 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 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 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 code that represents the sport participation. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

ACTIVITY_DESC5 Activity code that represents the sport participation. 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

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

FUNCTION

GOKODSF.F_GET_DESC

BIRTH_DATE Date of birth for the person. DATE

SPBPERS

SPBPERS_BIRTH_DATE

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

SARADAP

SGBSTDN

SORLCUR

SARADAP_CAMP_CODE

SGBSTDN_CAMP_CODE

SORLCUR_CAMP_CODE

CAMPUS_DESC Institution campus name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

CENSUS_FTE_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 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 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 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 Number of continuing education units awarded for completion of this course. NUMBER

FUNCTION

F_CALC_REGISTRATION_HOURS

CITIZENSHIP_DESC Citizen type description. VARCHAR2(255)

FUNCTION

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

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

SPBPERS

SPBPERS_CITZ_CODE

CITY Address city, town or municipality. VARCHAR2(20)

SPRADDR

SPRADDR_CITY

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

SGRCHRT

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

SGBSTDN

SORLCUR

SGBSTDN_COLL_CODE_1

SORLCUR_COLL_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

COUNTY County for this address. VARCHAR2(63)

SPRADDR

SPRADDR_CNTY_CODE

COUNTY_DESC County name for the address. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SHRLGPA

SHRLGPA_GPA

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

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

SGBSTDN

SORLCUR

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

FUNCTION

GOKODSF.F_GET_DESC

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

SGBSTDN

SORLFOS

SGBSTDN_DEPT_CODE

SORLFOS_DEPT_CODE

DEPARTMENT_DESC Department name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SGRSPRT

SGRSPRT_ELIG_CODE

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

SGRSPRT

SGRSPRT_ELIG_CODE

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

SGRSPRT

SGRSPRT_ELIG_CODE

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

SGRSPRT

SGRSPRT_ELIG_CODE

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

SGRSPRT

SGRSPRT_ELIG_CODE

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

SGBSTDN

SORLFOS

SGBSTDN_MAJR_CODE_CONC_1

SORLFOS_MAJR_CODE

FIRST_CONCENTRATION_DESC Concentration or study emphasis description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SGBSTDN

SORLFOS

SGBSTDN_MAJR_CODE_MINR_1

SORLFOS_MAJR_CODE

FIRST_MINOR_DESC Minor subject area description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SPRIDEN

SPRIDEN_FIRST_NAME

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

SORLFOS

SORLFOS_DEPT_CODE

FOURTH_DEPARTMENT_DESC Department name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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 Minor area of study description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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)

FUNCTION

GOKODSF.F_GET_DESC

FOURTH_PROGRAM_CLASSIF_DESC Program classification code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

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)

SGBSTDN

SGBSTDN_FULL_PART_IND

LAST_NAME Last name. VARCHAR2(60)

SPRIDEN

SPRIDEN_LAST_NAME

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

SGBSTDN

SORLFOS

SGBSTDN_MAJR_CODE_1

SORLFOS_MAJR_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

MIDDLE_NAME Middle name. VARCHAR2(15)

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 Nation associated with the address. VARCHAR2(63)

SPRADDR

SPRADDR_NATN_CODE

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

STVNATN

STVNATN_NATION

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

GOBINTL

GOBINTL_NATN_CODE_BIRTH

NATION_OF_BIRTH_DESC Name of the person's nation of birth. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NATION_OF_CITIZENSHIP Identifies the person's nation of citizenship. VARCHAR2(63)

GOBINTL

GOBINTL_NATN_CODE_BIRTH

NATION_OF_CITIZENSHIP_DESC Name of the person's nation of citizenship. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NON_TRADITIONAL_STUDENT_IND Year long or non degree seeking students. VARCHAR2(63)

NA

NA

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

SGBSTDN

SGBSTDN_ORSN_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

SFBETRM

SFBETRM_PIDM

POSTAL_CODE Address postal or postal code. VARCHAR2(10)

SPRADDR

SPRADDR_ZIP

PRIMARY_ETHNICITY Person's ethnicity. VARCHAR2(63)

SPBPERS

SPBPERS_ETHN_CODE

PRIMARY_ETHNICITY_DESC Ethnic code description. VARCHAR2(255)

STVETHN

STVETHN_DESC

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

CALCULATION

DECODE(SGBSTDN_LEVL_CODE,NULL,'N','Y'),DECODE(SORLCUR_LEVL_CODE,NULL,'N','Y'),'N')

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

STVETCT

GOKODSF.F_GET_DESC

STVETCT_DESC

PRIM_MEDICAL_CONDITION_DESC Medical condition description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SPRMEDI

SPRMEDI_MEDI_CODE

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)

SGBSTDN

SORLCUR

SGBSTDN_PROGRAM_1

SORLCUR_PROGRAM

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

STVMAJR

STVMAJR_CIPC_CODE

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)

FUNCTION

STVMAJR

GOKODSF.F_GET_DESC

STVMAJR_CIPC_CODE

PROGRAM_CLASSIFICATION_DESC Program classification code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PROGRAM_CLASSIFICATION_DESC_2 Program classification code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

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

SFBETRM

SFBETRM_RGRE_CODE

REGISTRATION_REASON_DESC Reason description associated with this student registration. 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 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 Concentration or study emphasis attached to the major for the student's academic study. VARCHAR2(63)

SGBSTDN

SORLFOS

SGBSTDN_MAJR_CODE_CONC_1_2

SORLFOS_MAJR_CODE

SECOND_CONCENTRATION_DESC Concentration or study emphasis description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SGBSTDN

SORLFOS

SGBSTDN_DEPT_CODE_2_2

SORLFOS_DEPT_CODE

SECOND_DEPARTMENT_DESC Department name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SGBSTDN

SORLFOS

SGBSTDN_MAJR_CODE_1_2

SORLFOS_MAJR_CODE

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

SGBSTDN

SORLFOS

SGBSTDN_MAJR_CODE_CONC_2

SORLFOS_MAJR_CODE

SECOND_MAJOR_CONC_1_DESC Student's concentration description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SGBSTDN

SORLFOS

SGBSTDN_MAJR_CODE_CONC_2_2

SORLFOS_MAJR_CODE

SECOND_MAJOR_CONC_2_DESC Student's concentration description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SGBSTDN

SORLFOS

SGBSTDN_MAJR_CODE_CONC_2_3

SORLFOS_MAJR_CODE

SECOND_MAJOR_CONC_3_DESC Student's concentration description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

SGBSTDN

SORLFOS

SGBSTDN_MAJR_CODE_MINR_1_2

SORLFOS_MAJR_CODE

SECOND_MINOR_DESC Minor area of study description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

CALCULATION

DECODE(SORLCUR_SITE_CODE)

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

NA

NA

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

STVSITE

STVSITE_CITY

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

NA

NA

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

NA

NA

SITE_COUNTY_CODE_DESC Descriptions of the county associated with the site address. VARCHAR2(255)

NA

NA

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

NA

NA

SITE_DESC Site or location name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

STVSITE

STVSITE_NATION_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

STVSITE

STVSITE_ZIPC

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

STVSITE

STVSITE_STATE

SITE_STATE_PROVINCE_DESC Name of the state/province. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SITE_STREET_LINE1 First line of the site address. VARCHAR2(63)

STVSITE

STVSITE_STREET_ADDR1

SITE_STREET_LINE2 Second line of the site address. VARCHAR2(63)

STVSITE

STVSITE_STREET_ADDR2

SITE_STREET_LINE3 Third line of the site address. VARCHAR2(63)

STVSITE

STVSITE_STREET_ADDR3

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

NA

NA

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

SGRSPRT

SGRSPRT_SPST_CODE

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

SGRSPRT

SGRSPRT_SPST_CODE

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

SGRSPRT

SGRSPRT_SPST_CODE

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

SGRSPRT

SGRSPRT_SPST_CODE

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

SGRSPRT

SGRSPRT_SPST_CODE

SPORT_STATUS_DESC1 Student participation status description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SPORT_STATUS_DESC2 Student participation status description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SPORT_STATUS_DESC3 Student participation status description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SPORT_STATUS_DESC4 Student participation status description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SPORT_STATUS_DESC5 Student participation status description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SPRADDR

SPRADDR_STAT_CODE

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

STVSTAT

STVSTAT_DESC

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_LEVEL Student level associated with the coursework in the academic outcome. Examples, include undergraduate and graduate, etc. VARCHAR2(63)

SGBSTDN

SORLCUR

SGBSTDN_LEVL_CODE

SORLCUR_LEVL_CODE

STUDENT_LEVEL_DESC Student level description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

NVL(SORLCUR_STYP_CODE, SGBSTDN_STYP_CODE)

STUDENT_POPULATION_DESC Student population or type 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

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

SGBSTDN

SORLFOS

SGBSTDN_MAJR_CODE_CONC_1_3

SORLFOS_MAJR_CODE

THIRD_CONCENTRATION_DESC Concentration or study emphasis description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SORLFOS

SORLFOS_DEPT_CODE

THIRD_DEPARTMENT_DESC Department name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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 First concentration or focus of study within this student's major. This may be blank when concentrations are not being used or wehn this major does not have a concentration or emphasis. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

THIRD_MAJOR_CONC_1_DESC Student's concentration description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SORLFOS

SORLFOS_MAJR_CODE

THIRD_MAJOR_CONC_2_DESC Student's concentration description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SORLFOS

SORLFOS_MAJR_CODE

THIRD_MAJOR_CONC_3_DESC Student's concentration description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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 Minor area of study description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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)

FUNCTION

STVMAJR

GOKODSF.F_GET_DESC

STVMAJR_CIPC_CODE

THIRD_PROGRAM_CLASSIF_DESC Program classification code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

F_CALC_REGISTRATION_HOURS

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 Credits used to sum the credits earned by a student per the rules of the institution. NUMBER

SHRLGPA

SHRLGPA_HOURS_EARNED

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 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 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 Date recorded as the date on which this current visa expires. DATE

GORVISA

GORVISA_VISA_EXPIRE_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 Most current visa type recorded for the academic period. Selection is made based on the start date and end date being within the academic period for this record. VARCHAR2(63)

GORVISA

GORVISA_VTYP_CODE

VISA_TYPE_DESC Visa type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC



Ver: 3.1