Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
ACADEMIC_PERIOD
|
Academic period or time frame associated with this outcome or degree record.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_TERM_CODE_STUREC
|
ACADEMIC_PERIOD_DESC
|
Academic period description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
ACADEMIC_PERIOD_GRAD
|
Academic period when graduation requirements were or will be completed.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_TERM_CODE_GRAD
|
ACADEMIC_PERIOD_GRAD_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
|
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
|
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)
|
SORLCUR
|
SORLCUR_CAMP_CODE
|
CAMPUS_DESC
|
Institution campus name.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
CITY
|
Address city, town or municipality.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_CITY
|
COHORT1
|
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 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 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 tracking group description assigned to the person.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
COHORT_DESC2
|
Cohort tracking group description assigned to the person.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
COHORT_DESC3
|
Cohort tracking group description assigned to the person.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
COHORT_RULE
|
Display rule that determines which cohort values are displayed for this person. Institution defined.
|
VARCHAR2(63)
|
MGRSDAX
|
MGRSDAX_INTERNAL_CODE
|
COLLEGE
|
College, faculty or school to which the academic study for the student is associated.
|
VARCHAR2(63)
|
SORLCUR
|
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
|
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 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
|
Sum of credits passed by a student for this academic outcome.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
DEGREE
|
Degree or award code associated with the academic study.
|
VARCHAR2(63)
|
SHRDGMR SORLCUR
|
SHRDGMR_DEGC_CODE 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 responsible for the student's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
DEPARTMENT_DESC
|
Department name.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
EDUCATIONAL_GOAL
|
Educational goal recorded for the student.
|
VARCHAR2(63)
|
SGBSTDN
|
SGBSTDN_EGOL_CODE
|
EDUCATIONAL_GOAL_DESC
|
Educational goal description.
|
VARCHAR2(255)
|
STVEGOL
|
STVEGOL_DESC
|
EDUCATION_LEVEL
|
Highest level of education completed by the person.
|
VARCHAR2(63)
|
SGBSTDN
|
SGBSTDN_EDLV_CODE
|
EDUCATION_LEVEL_DESC
|
Description of the highest level of education recorded for the person.
|
VARCHAR2(255)
|
STVEDLV
|
STVEDLV_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)
|
SORLFOS
|
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)
|
SORLFOS
|
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(63)
|
SPRIDEN
|
SPRIDEN_FIRST_NAME
|
FOURTH_DEPARTMENT
|
Department responsible for the 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 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
|
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 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
|
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 Institutional Program (CIP) codes used for reporting to 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')
|
GPA
|
Calculated grade point average or average for a set of courses completed.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
GPA_CREDITS
|
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
|
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
|
LAST_NAME
|
Last name.
|
VARCHAR2(63)
|
SPRIDEN
|
SPRIDEN_LAST_NAME
|
MAJOR
|
Major subject area of the person's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
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(63)
|
SPRIDEN
|
SPRIDEN_MI
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
MULTI_SOURCE_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NATION
|
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
|
OUTCOME_GRADUATION_DATE
|
Official date of graduation.
|
DATE
|
SHRDGMR
|
SHRDGMR_GRAD_DATE
|
OUTCOME_NUMBER
|
Academic outcome (degree or award) internal sequence number.
|
NUMBER
|
SHRDGMR
|
SHRDGMR_SEQ_NO
|
PERSON_UID
|
Internally generated by the system to uniquely identify the person or entity.
|
NUMBER
|
SHRDGMR
|
SHRDGMR_PIDM
|
POSTAL_CODE
|
Address postal or zip code.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_ZIP
|
PRIMARY_ETHNICITY
|
Person's ethnicity.
|
VARCHAR2(63)
|
SPBPERS
|
SPBPERS_ETHN_CODE
|
PRIMARY_ETHNICITY_DESC
|
Ethnic code description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
PRIM_ETHNICITY_CATEGORY
|
Ethnic group used for governmental reporting.
|
VARCHAR2(63)
|
STVETHN
|
STVETHN_ETCT_CODE
|
PRIM_ETHNICITY_CATEGORY_DESC
|
Ethnic category description as defined by the government reporting.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
PROGRAM
|
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 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)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
PROGRAM_CLASSIFICATION_DESC
|
Program classification description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
PROGRAM_DESC
|
Person's program or course of study description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
QUALITY_POINTS
|
Sum of the student's quality points for this academic outcome.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
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
|
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
|
Concentration or study emphasis description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
SECOND_DEPARTMENT
|
Department responsible for the second major or subject area of academic instruction.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
SECOND_DEPARTMENT_DESC
|
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 subject area or focus recorded for the student's academic study. This may be blank.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
SECOND_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
|
SECOND_MAJOR_CONC_1_DESC
|
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 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
|
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
|
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
|
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
|
Major 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)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
SECOND_MINOR_DESC
|
Description for the second minor subject area of the person's academic study.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
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
|
Program classification code description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
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)
|
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)
|
SORLCUR
|
SORLCUR_LEVL_CODE
|
STUDENT_LEVEL_DESC
|
Student level 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)
|
SORLFOS
|
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 when 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 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
|
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 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
|
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 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
|
Program classification code description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|