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)
|
SHRDGMR
|
SHRDGMR_TERM_CODE_STUREC
|
ACADEMIC_PERIOD_DESC
|
Academic Period Description
|
Academic period description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
ACADEMIC_PERIOD_GRAD
|
Academic Period Graduate
|
Academic period when graduation requirements were or will be completed.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_TERM_CODE_GRAD
|
ACADEMIC_PERIOD_GRAD_DESC
|
Academic Period Graduate Description
|
Academic period description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_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
|
ADDRESS_RULE
|
Address Rule
|
Institution profile defined display rule determines which address displays for this person or entity. The display rule will exist on MGRSDAX with an internal group equal to ADDRESS and the institution defined internal code for government reporting of addresses.
|
VARCHAR2(30)
|
MGRSDAX
|
MGRSDAX_INTERNAL_CODE
|
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 current system date).
|
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)
|
FUNCTION
|
GOKODSF.F_GET_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)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
CITY
|
City
|
Address city, town or municipality.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_CITY
|
COHORT1
|
Cohort 1
|
Cohort tracking group assigned to the person through the Administrative UI display rules. When one of the internal codes defined under the internal group of CENSUS_FTE1 matchs one of the student cohort codes for the academic period, that student cohort will be used in this column.
|
VARCHAR2(63)
|
SGRCHRT
|
SGRCHRT_CHRT_CODE
|
COHORT2
|
Cohort 2
|
Cohort tracking group assigned to the person through the Administrative UI display rules. When one of the internal codes defined under the internal group of CENSUS_FTE2 matchs one of the student cohort codes for the academic period, that student cohort will be used in this column.
|
VARCHAR2(63)
|
SGRCHRT
|
SGRCHRT_CHRT_CODE
|
COHORT3
|
Cohort 3
|
Cohort tracking group assigned to the person through the Administrative UI display rules. When one of the internal codes defined under the internal group of CENSUS_FTE3 matchs one of the student cohort codes for the academic period, that student cohort will be used in this column.
|
VARCHAR2(63)
|
SGRCHRT
|
SGRCHRT_CHRT_CODE
|
COHORT_DESC1
|
Cohort Description 1
|
Cohort tracking group description assigned to the person.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
COHORT_DESC2
|
Cohort Description 2
|
Cohort tracking group description assigned to the person.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
COHORT_DESC3
|
Cohort Description 3
|
Cohort tracking group description assigned to the person.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
COHORT_RULE
|
Cohort Rule
|
Display rule that determines which cohort values are displayed for this person. Institution defined.
|
VARCHAR2(63)
|
MGRSDAX
|
MGRSDAX_INTERNAL_CODE
|
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)
|
FUNCTION
|
GOKODSF.F_GET_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
|
CREDITS_ATTEMPTED
|
Credits Attempted
|
Sum of credits attempted by a student for this academic outcome.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
CREDITS_EARNED
|
Credits Earned
|
Credits earned as defined by the grading rules of the institution. This number must be calculated by the system after the final grade is recorded for the student.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
CREDITS_PASSED
|
Credits Passed
|
Sum of credits passed by a student for this academic outcome.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
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)
|
SHRDGMR SORLCUR
|
SHRDGMR_DEGC_CODE SORLCUR_DEGC_CODE
|
DEGREE_DESC
|
Degree Description
|
Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_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)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
EDUCATIONAL_GOAL
|
Educational Goal
|
Educational goal recorded for the student.
|
VARCHAR2(63)
|
SGBSTDN
|
SGBSTDN_EGOL_CODE
|
EDUCATIONAL_GOAL_DESC
|
Educational Goal Description
|
Educational goal description.
|
VARCHAR2(255)
|
STVEGOL
|
STVEGOL_DESC
|
EDUCATION_LEVEL
|
Education Level
|
Highest level of education completed by the person.
|
VARCHAR2(63)
|
SGBSTDN
|
SGBSTDN_EDLV_CODE
|
EDUCATION_LEVEL_DESC
|
Education Level Description
|
Description of the highest level of education recorded for the person.
|
VARCHAR2(255)
|
STVEDLV
|
STVEDLV_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
|
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)
|
FUNCTION
|
GOKODSF.F_GET_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)
|
FUNCTION
|
GOKODSF.F_GET_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 major or subject area of academic instruction.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
FOURTH_DEPARTMENT_DESC
|
Fourth Department Description
|
Department Name.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_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)
|
FUNCTION
|
GOKODSF.F_GET_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 concentration 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)
|
FUNCTION
|
GOKODSF.F_GET_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 concentration 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)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
FOURTH_MAJOR_DESC
|
Fourth Major Description
|
Major or subject area of study description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_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)
|
FUNCTION
|
GOKODSF.F_GET_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 Institutional Program (CIP) codes used for reporting to the federal government.
|
VARCHAR2(63)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
FOURTH_PROGRAM_CLASSIF_DESC
|
Fourth Major Classification Description
|
Program classification code description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_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
|
GPA
|
Grade Point Average or Average
|
Calculated grade point average or average for a set of courses completed.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
GPA_CREDITS
|
Credits used in Grade Point Average or Average
|
Credits used to calculate the average or grade point average for the courses used to complete the outcome requirements.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
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
|
INSTITUTION_CREDITS_ATTEMPTED
|
Institution Credits Attempted
|
Sum of institution course credits attempted by a student.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
INSTITUTION_CREDITS_EARNED
|
Institution Credits Earned
|
Sum of institution course credits earned by a student.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
INSTITUTION_CREDITS_PASSED
|
Institution Credits Passed
|
Sum of institution course credits passed by a student for this academic outcome.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
INSTITUTION_GPA
|
Institution GPA - Grade Point Average or Average
|
Calculated of institution course grade point average or average for the set of courses completed.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
INSTITUTION_GPA_CREDITS
|
Institution GPA - Grade Point Average or Average Credits
|
Sum of institution course credits used in the GPA calculations for this student.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
INSTITUTION_QUALITY_POINTS
|
Institution Quality Points
|
Sum of institution course quality points used in the GPA calculations for this student.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
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)
|
FUNCTION
|
GOKODSF.F_GET_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)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
OUTCOME_GRADUATION_DATE
|
Official Graduation Date
|
Official date of graduation.
|
DATE
|
SHRDGMR
|
SHRDGMR_GRAD_DATE
|
OUTCOME_NUMBER
|
Outcome Number
|
Academic outcome (degree or award) internal sequence number.
|
NUMBER
|
SHRDGMR
|
SHRDGMR_SEQ_NO
|
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
|
SHRDGMR
|
SHRDGMR_PIDM
|
POSTAL_CODE
|
Postal Code
|
Address postal or zip 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)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
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)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
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)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
PROGRAM_CLASSIFICATION_DESC
|
Program Classification Description
|
Program classification description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
PROGRAM_DESC
|
Program Description
|
Person's program or course of study description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
QUALITY_POINTS
|
Quality Points
|
Sum of the student's quality points for this academic outcome.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
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
|
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)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
SECOND_DEPARTMENT
|
Second Department
|
Department responsible for the second major or subject area of academic instruction.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
SECOND_DEPARTMENT_DESC
|
Second Department Description
|
Description for the second layer of the institution organization associated with a second major or subject area for this academic study.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_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 concentrations 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
|
Name for the first concentration of study or emphasis attached to the second major for the person.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_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
|
Name for the second concentration of study or emphasis attached to the second major for the person.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_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 or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
SECOND_MAJOR_CONC_3_DESC
|
Second Major Concentration 3 Description
|
Name for the third concentration of study or emphasis attached to the second major for the person.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
SECOND_MAJOR_DESC
|
Second Major Description
|
Major area of study description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_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
|
Description for the second minor subject area of the person's academic study.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
SECOND_PROGRAM_CLASSIFICATION
|
Second Program Classification
|
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
|
GOKODSF.F_GET_DESC
|
SECOND_PROGRAM_CLASSIF_DESC
|
Second Program Classification Description
|
Program classification code description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
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)
|
FUNCTION
|
GOKODSF.F_GET_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)
|
FUNCTION
|
GOKODSF.F_GET_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)
|
FUNCTION
|
GOKODSF.F_GET_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)
|
FUNCTION
|
GOKODSF.F_GET_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)
|
FUNCTION
|
GOKODSF.F_GET_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 concentration 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)
|
FUNCTION
|
GOKODSF.F_GET_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 concentration 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)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
THIRD_MAJOR_DESC
|
Third Major Description
|
Major or subject area of study description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_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)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
THIRD_PROGRAM_CLASSIFICATION
|
Third Program Classification
|
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
|
GOKODSF.F_GET_DESC
|
THIRD_PROGRAM_CLASSIF_DESC
|
Third Program Classification Description
|
Program classification code description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
TRANSFER_CREDITS_ATTEMPTED
|
Transfer Credits Attempted
|
Sum of transfer course credits attempted by a student.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
TRANSFER_CREDITS_EARNED
|
Transfer Credits Earned
|
Sum of transfer course credits earned by a student.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
TRANSFER_CREDITS_PASSED
|
Transfer Credits Passed
|
Sum of transfer course credits passed by a student for this academic outcome.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
TRANSFER_GPA
|
Transfer GPA - Grade Point Average or Average
|
Calculated of transfer course grade point average or average for the set of courses completed.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
TRANSFER_GPA_CREDITS
|
Transfer GPA - Grade Point Average or Average Credits
|
Sum of transfer course credits used in the GPA calculations for this student.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
TRANSFER_QUALITY_POINTS
|
Transfer Quality Points
|
Sum of transfer course quality points used in the GPA calculations for this student.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|