| Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
Source Name |
Source Column |
|
ACADEMIC_PERIOD
|
Academic Period
|
Academic period or time frame for this student enrollment record.
|
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
|
Organization-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
|
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
|
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 to which applicant is applying.
|
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 has been identified as 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
|
College, faculty or school to which the academic study for the student is associated.
|
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
|
Degree or award code associated with the academic study.
|
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 associated with the academic study on the admission application.
|
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
|
Person's gender. Values are Male, Female or Not reported to the institution.
|
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')
|
|
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
|
ID number given to the student to track their records at the institution.
|
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
|
Identifies the person's nation of citizenship.
|
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
|
|
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
|
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
|
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 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 of the student typically used to calculate tuition and fees to be charged.
|
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
|
Subject area or major focus recorded for the student's academic study. This may be blank.
|
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 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
|
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
|
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
|
Student level description.
|
VARCHAR2(255)
|
|
STVLEVL
|
STVLEVL_DESC
|
|
STUDENT_POPULATION
|
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 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
|
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
|
Visa type description.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|