Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
ACADEMIC_PERIOD
|
Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year.
|
VARCHAR2(63)
|
SFBETRM
|
SFBETRM_TERM_CODE
|
NO
|
NO
|
ACADEMIC_PERIOD_DESC
|
Academic period description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
ACADEMIC_PERIOD_MATRIC_DESC
|
Academic period description.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_DESC
|
NO
|
NO
|
ACADEMIC_YEAR
|
Academic year associated with the academic period on this record.
|
VARCHAR2(63)
|
STVTERM
|
STVTERM_ACYR_CODE
|
NO
|
NO
|
ACADEMIC_YEAR_DESC
|
Academic year description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
ACTIVITY_DESC1
|
Activity code that represents the sport participation.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
ACTIVITY_DESC2
|
Activity code that represents the sport participation.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
ACTIVITY_DESC3
|
Activity code that represents the sport participation.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
ACTIVITY_DESC4
|
Activity code that represents the sport participation.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
ACTIVITY_DESC5
|
Activity code that represents the sport participation.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
ADMINISTRATIVE_GROUP
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
AWARD_CATEGORY_DESC
|
Award category description.
|
VARCHAR2(255)
|
STVACAT
|
STVACAT_DESC
|
NO
|
NO
|
BIRTH_DATE
|
Date of birth for the person.
|
DATE
|
SPBPERS
|
SPBPERS_BIRTH_DATE
|
NO
|
NO
|
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
|
NO
|
NO
|
CAMPUS_DESC
|
Institution campus name.
|
VARCHAR2(255)
|
STVCAMP
|
STVCAMP_DESC
|
NO
|
NO
|
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')
|
NO
|
NO
|
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')
|
NO
|
NO
|
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')
|
NO
|
NO
|
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')
|
NO
|
NO
|
CEU_CREDITS_IND
|
Number of continuing education units awarded for completion of this course.
|
NUMBER
|
FUNCTION
|
F_CALC_REGISTRATION_HOURS
|
NO
|
NO
|
CITIZENSHIP_DESC
|
Citizen type description.
|
VARCHAR2(255)
|
STVCITZ
|
STVCITZ_DESC
|
NO
|
NO
|
CITIZENSHIP_IND
|
Indicates whether the person is a citizen of the institution's home country.
|
VARCHAR2(1)
|
SPBPERS
|
SPBPERS_CITZ_IND
|
NO
|
NO
|
CITIZENSHIP_TYPE
|
Identifies the person's citizen type relationship to the institution's home country.
|
VARCHAR2(63)
|
SPBPERS
|
SPBPERS_CITZ_CODE
|
NO
|
NO
|
CITY
|
Address city, town or municipality.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_CITY
|
NO
|
NO
|
COHORT
|
Cohort tracking group assigned to the student through the Administrative UI display rules.
|
VARCHAR2(63)
|
SGRCHRT
|
SGRCHRT_CHRT_CODE
|
NO
|
NO
|
COHORT_DESC
|
Cohort code description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
COLLEGE_DESC
|
College, faculty or school name.
|
VARCHAR2(255)
|
STVCOLL
|
STVCOLL_DESC
|
NO
|
NO
|
COUNTY
|
County for this address.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_CNTY_CODE
|
NO
|
NO
|
COUNTY_DESC
|
County name for the address.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
CUMULATIVE_GPA
|
GPA or Average for the specified group of courses completed.
|
NUMBER
|
SHRLGPA
|
SHRLGPA_GPA
|
NO
|
NO
|
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
|
NO
|
NO
|
CURRENT_TIME_STATUS_DESC
|
Current time status description.
|
VARCHAR2(255)
|
STVTMST
|
STVTMST_DESC
|
NO
|
NO
|
DEGREE
|
Award, degree, diploma, certification upon completion of all the requirements for a particular academic study. For example, Bachelor of Science, Associate of Arts, Vocational Certificate. This information will be taken from the ODS Academic Study or Academic Outcome or Admissions Application reporting view as appropriate for the star scheme.
|
VARCHAR2(63)
|
SORLCUR
|
SORLCUR_DEGC_CODE
|
NO
|
NO
|
DEGREE_DESC
|
Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.
|
VARCHAR2(255)
|
STVDEGC
|
STVDEGC_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
DEPARTMENT_DESC
|
Department name.
|
VARCHAR2(255)
|
STVDEPT
|
STVDEPT_DESC
|
NO
|
NO
|
ELIGIBILITY1
|
Indicates eligibility to officially participate in this sport as identified in the display rules.
|
VARCHAR2(63)
|
SGRSPRT
|
SGRSPRT_ELIG_CODE
|
NO
|
NO
|
ELIGIBILITY2
|
Indicates eligibility to officially participate in this sport as identified in the display rules.
|
VARCHAR2(63)
|
SGRSPRT
|
SGRSPRT_ELIG_CODE
|
NO
|
NO
|
ELIGIBILITY3
|
Indicates eligibility to officially participate in this sport as identified in the display rules.
|
VARCHAR2(63)
|
SGRSPRT
|
SGRSPRT_ELIG_CODE
|
NO
|
NO
|
ELIGIBILITY4
|
Indicates eligibility to officially participate in this sport as identified in the display rules.
|
VARCHAR2(63)
|
SGRSPRT
|
SGRSPRT_ELIG_CODE
|
NO
|
NO
|
ELIGIBILITY5
|
Indicates eligibility to officially participate in this sport as identified in the display rules.
|
VARCHAR2(63)
|
SGRSPRT
|
SGRSPRT_ELIG_CODE
|
NO
|
NO
|
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
|
NO
|
NO
|
ENROLL_CENSUS_DATE2_IND
|
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
|
NO
|
NO
|
FIRST_CONCENTRATION
|
Concentration or study emphasis attached to the major for the student's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
FIRST_CONCENTRATION_DESC
|
Concentration or study emphasis description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
FIRST_MINOR
|
Minor subject area of the person's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
FIRST_MINOR_DESC
|
Minor subject area description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
FIRST_NAME
|
Person's first or given name.
|
VARCHAR2(63)
|
SPRIDEN
|
SPRIDEN_FIRST_NAME
|
NO
|
NO
|
FOURTH_DEPARTMENT
|
Department responsible for the second major or subject area of academic instruction.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
NO
|
NO
|
FOURTH_DEPARTMENT_DESC
|
Department name.
|
VARCHAR2(255)
|
STVDEPT
|
STVDEPT_DESC
|
NO
|
NO
|
FOURTH_MAJOR
|
Subject area or major focus recorded for the student's academic study. This may be blank.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
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
|
NO
|
NO
|
FOURTH_MAJOR_CONC_1_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
FOURTH_MAJOR_CONC_2_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
FOURTH_MAJOR_CONC_3_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
FOURTH_MAJOR_DESC
|
Major or subject area of study description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
FOURTH_MINOR_DESC
|
Minor area of study description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
FOURTH_PROGRAM_CLASSIF_DESC
|
Program classification code description.
|
VARCHAR2(255)
|
STVCIPC
|
STVCIPC_DESC
|
NO
|
NO
|
GENDER
|
Identifies the gender of the person.
|
VARCHAR2(63)
|
SPBPERS
|
SPBPERS_SEX
|
NO
|
NO
|
GENDER_DESC
|
Identify as Male, Female or Not reported.
|
VARCHAR2(63)
|
CALCULATION
|
DECODE(SPBPERS_SEX,'M','MALE','F','FEMALE','N','NOT REPORTED')
|
NO
|
NO
|
GENDER_DESIGNATION
|
This gender identity of the person.
|
VARCHAR2(63)
|
SPBPERS
|
SPBPERS_GNDR_CODE
|
NO
|
NO
|
GENDER_DESIGNATION_DESC
|
The description of the gender identity.
|
VARCHAR2(255)
|
GTVGNDR
|
GTVGNDR_GNDR_DESC
|
NO
|
NO
|
HISPANIC_LATINO_ETHNICITY_IND
|
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
|
NO
|
NO
|
ID
|
Identification number assigned to a person that is used externally for all communication and correspondence with the person.
|
VARCHAR2(63)
|
SPRIDEN
|
SPRIDEN_ID
|
NO
|
NO
|
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')
|
NO
|
NO
|
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
|
NO
|
NO
|
LAST_NAME
|
Last name.
|
VARCHAR2(63)
|
SPRIDEN
|
SPRIDEN_LAST_NAME
|
NO
|
NO
|
MAJOR
|
Major subject area of the person's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
MAJOR_DESC
|
Major subject area name for the person's academic study.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
MIDDLE_NAME
|
Middle name.
|
VARCHAR2(63)
|
SPRIDEN
|
SPRIDEN_MI
|
NO
|
NO
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
MULTI_SOURCE_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
NATION
|
Nation associated with the address.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_NATN_CODE
|
NO
|
NO
|
NATION_DESC
|
Nation name associated with the address record.
|
VARCHAR2(255)
|
STVNATN
|
STVNATN_NATION
|
NO
|
NO
|
NATION_OF_BIRTH
|
Person's nation of birth.
|
VARCHAR2(63)
|
GOBINTL
|
GOBINTL_NATN_CODE_BIRTH
|
NO
|
NO
|
NATION_OF_BIRTH_DESC
|
Name of the person's nation of birth.
|
VARCHAR2(255)
|
STVNATN
|
STVNATN_NATION
|
NO
|
NO
|
NATION_OF_CITIZENSHIP
|
Nation of citizen recorded for the person. Important for some institutions, for understanding enrollment patterns and for reporting.
|
VARCHAR2(63)
|
GOBINTL
|
GOBINTL_NATN_CODE_BIRTH
|
NO
|
NO
|
NATION_OF_CITIZENSHIP_DESC
|
Name of the person's nation of citizenship.
|
VARCHAR2(255)
|
STVNATN
|
STVNATN_NATION
|
NO
|
NO
|
NON_TRADITIONAL_STUDENT_IND
|
Year long or non degree seeking students.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
ORIENTATION_SESSION
|
Orientation session recorded for the student.
|
VARCHAR2(63)
|
SGBSTDN
|
SGBSTDN_ORSN_CODE
|
NO
|
NO
|
ORIENTATION_SESSION_DESC
|
Description recorded for the orientation session recorded for the student.
|
VARCHAR2(255)
|
STVORSN
|
STVORSN_DESC
|
NO
|
NO
|
PERSONAL_PRONOUN
|
The personal pronoun of the person.
|
VARCHAR2(63)
|
SPBPERS
|
SPBPERS_PPRN_CODE
|
NO
|
NO
|
PERSONAL_PRONOUN_DESC
|
The description of the personal pronoun.
|
VARCHAR2(255)
|
GTVPPRN
|
GTVPPRN_PPRN_DESC
|
NO
|
NO
|
PERSON_UID
|
Internally generated by the system to uniquely identify the person or entity.
|
NUMBER
|
SFBETRM
|
SFBETRM_PIDM
|
NO
|
NO
|
POSTAL_CODE
|
Address postal or postal code.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_ZIP
|
NO
|
NO
|
PRIMARY_ETHNICITY
|
Person's ethnicity.
|
VARCHAR2(63)
|
SPBPERS
|
SPBPERS_ETHN_CODE
|
NO
|
NO
|
PRIMARY_ETHNICITY_DESC
|
Ethnic code description.
|
VARCHAR2(255)
|
STVETHN
|
STVETHN_DESC
|
NO
|
NO
|
PRIMARY_PROGRAM_IND
|
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
|
NO
|
NO
|
PRIM_ETHNICITY_CATEGORY
|
Ethnic group used for governmental reporting.
|
VARCHAR2(63)
|
STVETHN
|
STVETHN_ETCT_CODE
|
NO
|
NO
|
PRIM_ETHNICITY_CATEGORY_DESC
|
Ethnic category description as defined by the government reporting.
|
VARCHAR2(255)
|
STVETCT
|
STVETCT_DESC
|
NO
|
NO
|
PRIM_MEDICAL_CONDITION_DESC
|
Medical condition description.
|
VARCHAR2(255)
|
STVMEDI
|
STVMEDI_DESC
|
NO
|
NO
|
PRIM_MEDICAL_CONDTION
|
Medical condition marked as the primary disability.
|
VARCHAR2(63)
|
SPRMEDI
|
SPRMEDI_MEDI_CODE
|
NO
|
NO
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
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
|
NO
|
NO
|
PROGRAM_CLASSIFICATION
|
Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting.
|
VARCHAR2(63)
|
STVMAJR
|
STVMAJR_CIPC_CODE
|
NO
|
NO
|
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
|
NO
|
NO
|
PROGRAM_CLASSIFICATION_DESC
|
Program classification code description.
|
VARCHAR2(255)
|
STVCIPC
|
STVCIPC_DESC
|
NO
|
NO
|
PROGRAM_CLASSIFICATION_DESC_2
|
Program classification code description.
|
VARCHAR2(255)
|
STVCIPC
|
STVCIPC_DESC
|
NO
|
NO
|
PROGRAM_DESC
|
Program or course of study description.
|
VARCHAR2(255)
|
SMRPRLE
|
SMRPRLE_PROGRAM_DESC
|
NO
|
NO
|
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)
|
NO
|
NO
|
RACE_CATEGORY_COUNT
|
Number of unique regulatory races selected by this person.
|
NUMBER
|
FUNCTION
|
MGKFUNC.F_COUNT_RACE_CATEGORY
|
NO
|
NO
|
RACE_COUNT
|
Number of races selected by this person.
|
NUMBER
|
FUNCTION
|
MGKFUNC.F_COUNT_RACE
|
NO
|
NO
|
RACE_ETHNICITY_CONFIRM_DATE
|
Race and ethnicity self confirmed date.
|
DATE
|
SPBPERS
|
SPBPERS_CONFIRMED_RE_DATE
|
NO
|
NO
|
RACE_ETHNICITY_CONFIRM_IND
|
Indicates if the person's race and ethnicity have been self-identified.
|
VARCHAR2(1)
|
SPBPERS
|
SPBPERS_CONFIRMED_RE_CDE
|
NO
|
NO
|
REGISTRATION_REASON
|
Reason recorded at the time of registration for this academic period.
|
VARCHAR2(63)
|
SFBETRM
|
SFBETRM_RGRE_CODE
|
NO
|
NO
|
REGISTRATION_REASON_DESC
|
Reason description associated with this student registration.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
RESIDENCY
|
Residency code for the student identifying the type of charges the student will incur.
|
VARCHAR2(63)
|
SGBSTDN
|
SGBSTDN_RESD_CODE
|
NO
|
NO
|
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
|
NO
|
NO
|
SECOND_CONCENTRATION
|
Concentration or study emphasis attached to the major for the student's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
SECOND_CONCENTRATION_DESC
|
Concentration or study emphasis description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
SECOND_DEPARTMENT
|
Department responsible for the major or subject area of academic instruction.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
NO
|
NO
|
SECOND_DEPARTMENT_DESC
|
Department name.
|
VARCHAR2(255)
|
STVDEPT
|
STVDEPT_DESC
|
NO
|
NO
|
SECOND_MAJOR
|
Major subject area of the person's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
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)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
SECOND_MAJOR_CONC_1_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
SECOND_MAJOR_CONC_2_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
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)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
SECOND_MAJOR_CONC_3_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
SECOND_MAJOR_DESC
|
Major or subject area of study description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
SECOND_MINOR_DESC
|
Minor area of study description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
SITE
|
Site or location to which applicant is applying.
|
VARCHAR2(63)
|
CALCULATION
|
DECODE(SORLCUR_SITE_CODE)
|
NO
|
NO
|
SITE_CARRIER_ROUTE
|
Carrier route associated with the site address for barcode mailings.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
SITE_CITY
|
City town or municipality associated with the site address.
|
VARCHAR2(63)
|
STVSITE
|
STVSITE_CITY
|
NO
|
NO
|
SITE_CORRECTION_DIGIT
|
Correction digit associated with the site address for barcode mailings.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
SITE_COUNTY_CODE
|
County associated with the site address.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
SITE_COUNTY_CODE_DESC
|
Descriptions of the county associated with the site address.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
SITE_DELIVERY_POINT
|
Delivery point associated with the site address for barcode mailings.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
SITE_DESC
|
Site or location name.
|
VARCHAR2(255)
|
STVSITE
|
STVSITE_DESC
|
NO
|
NO
|
SITE_NATION
|
Nation/country code associated with the site address.
|
VARCHAR2(63)
|
STVSITE
|
STVSITE_NATION_CODE
|
NO
|
NO
|
SITE_NATION_DESC
|
Description for the nation/country associated with the site address.
|
VARCHAR2(255)
|
STVNATN
|
STVNATN_NATION
|
NO
|
NO
|
SITE_POSTAL_CODE
|
Postal code associated with the site address.
|
VARCHAR2(63)
|
STVSITE
|
STVSITE_ZIPC
|
NO
|
NO
|
SITE_STATE_PROVINCE
|
Identifies the state or province associated with this address.
|
VARCHAR2(63)
|
STVSITE
|
STVSITE_STATE
|
NO
|
NO
|
SITE_STATE_PROVINCE_DESC
|
Name of the state/province.
|
VARCHAR2(255)
|
STVSTAT
|
STVSTAT_DESC
|
NO
|
NO
|
SITE_STREET_LINE1
|
First line of the site address.
|
VARCHAR2(255)
|
STVSITE
|
STVSITE_STREET_ADDR1
|
NO
|
NO
|
SITE_STREET_LINE2
|
Second line of the site address.
|
VARCHAR2(255)
|
STVSITE
|
STVSITE_STREET_ADDR2
|
NO
|
NO
|
SITE_STREET_LINE3
|
Third line of the site address.
|
VARCHAR2(255)
|
STVSITE
|
STVSITE_STREET_ADDR3
|
NO
|
NO
|
SITE_STREET_LINE4
|
Fourth line of the site address.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
SPORT_STATUS1
|
Current status for the sport participation for the sport selected in the display rules.
|
VARCHAR2(63)
|
SGRSPRT
|
SGRSPRT_SPST_CODE
|
NO
|
NO
|
SPORT_STATUS2
|
Current status for the sport participation for the sport selected in the display rules.
|
VARCHAR2(63)
|
SGRSPRT
|
SGRSPRT_SPST_CODE
|
NO
|
NO
|
SPORT_STATUS3
|
Current status for the sport participation for the sport selected in the display rules.
|
VARCHAR2(63)
|
SGRSPRT
|
SGRSPRT_SPST_CODE
|
NO
|
NO
|
SPORT_STATUS4
|
Current status for the sport participation for the sport selected in the display rules.
|
VARCHAR2(63)
|
SGRSPRT
|
SGRSPRT_SPST_CODE
|
NO
|
NO
|
SPORT_STATUS5
|
Current status for the sport participation for the sport selected in the display rules.
|
VARCHAR2(63)
|
SGRSPRT
|
SGRSPRT_SPST_CODE
|
NO
|
NO
|
SPORT_STATUS_DESC1
|
Student participation status description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
SPORT_STATUS_DESC2
|
Student participation status description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
SPORT_STATUS_DESC3
|
Student participation status description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
SPORT_STATUS_DESC4
|
Student participation status description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
SPORT_STATUS_DESC5
|
Student participation status description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
STATE_PROVINCE
|
State or province associated with this address.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_STAT_CODE
|
NO
|
NO
|
STATE_PROVINCE_DESC
|
State or province name associated with the address record.
|
VARCHAR2(255)
|
STVSTAT
|
STVSTAT_DESC
|
NO
|
NO
|
STUDENT_CLASSIFICATION
|
Identifies the student's current class at the institution. The typical VALUES are first year, second year, or freshman, sophomore, etc..
|
VARCHAR2(63)
|
FUNCTION
|
F_CLASS_CALC_FNC
|
NO
|
NO
|
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
|
NO
|
NO
|
STUDENT_CLASSIFICATION_DESC
|
Student classification description.
|
VARCHAR2(255)
|
STVCLAS
|
STVCLAS_DESC
|
NO
|
NO
|
STUDENT_CLASS_BOAP_DESC
|
Beginning of academic period student classification.
|
VARCHAR2(255)
|
STVCLAS
|
STVCLAS_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
STUDENT_LEVEL_DESC
|
Student level description.
|
VARCHAR2(255)
|
STVLEVL
|
STVLEVL_DESC
|
NO
|
NO
|
STUDENT_POPULATION
|
Identifies the category this student that will be used for governmental reporting. The typical VALUES are new first time, transfer, continuing, etc.
|
VARCHAR2(63)
|
FUNCTION
|
NVL(SORLCUR_STYP_CODE, SGBSTDN_STYP_CODE)
|
NO
|
NO
|
STUDENT_POPULATION_DESC
|
Student population or type description.
|
VARCHAR2(255)
|
STVSTYP
|
STVSTYP_DESC
|
NO
|
NO
|
SUB_ACADEMIC_PERIOD
|
A session, portion or part of the academic period.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
SUB_ACADEMIC_PERIOD_DESC
|
Sub academic period description.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
THIRD_CONCENTRATION
|
Concentration or study emphasis attached to the major for the student's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
THIRD_CONCENTRATION_DESC
|
Concentration or study emphasis description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
THIRD_DEPARTMENT
|
Department responsible for the major or subject area of academic instruction.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
NO
|
NO
|
THIRD_DEPARTMENT_DESC
|
Department name.
|
VARCHAR2(255)
|
STVDEPT
|
STVDEPT_DESC
|
NO
|
NO
|
THIRD_MAJOR
|
Subject area or major focus recorded for the student's academic study. This may be blank.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
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
|
NO
|
NO
|
THIRD_MAJOR_CONC_1_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
THIRD_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
|
NO
|
NO
|
THIRD_MAJOR_CONC_2_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
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 when this major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
THIRD_MAJOR_CONC_3_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
THIRD_MAJOR_DESC
|
Major or subject area of study description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
THIRD_MINOR_DESC
|
Minor area of study description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
THIRD_PROGRAM_CLASSIF_DESC
|
Program classification code description.
|
VARCHAR2(255)
|
STVCIPC
|
STVCIPC_DESC
|
NO
|
NO
|
TOTAL_CREDITS
|
Total credits for the student for this academic period.
|
NUMBER
|
FUNCTION
|
F_CALC_REGISTRATION_HOURS
|
NO
|
NO
|
TOTAL_CREDITS_ATTEMPTED
|
Credits used to sum the credits attempted by a student per the rules of the institution.
|
NUMBER
|
SHRLGPA
|
SHRLGPA_HOURS_ATTEMPTED
|
NO
|
NO
|
TOTAL_CREDITS_EARNED
|
Credits used to sum the credits earned by a student per the rules of the institution.
|
NUMBER
|
SHRLGPA
|
SHRLGPA_HOURS_EARNED
|
NO
|
NO
|
TOTAL_CREDITS_PASSED
|
Credits used to sum the credits passed by a student per the rules of the institution.
|
NUMBER
|
SHRLGPA
|
SHRLGPA_HOURS_PASSED
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
VISA_EXPIRE_DATE
|
Date recorded as the date on which this current visa expires.
|
DATE
|
GORVISA
|
GORVISA_VISA_EXPIRE_DATE
|
NO
|
NO
|
VISA_START_DATE
|
Date, if any, recorded as the date on which this current visa begins.
|
DATE
|
GORVISA
|
GORVISA_VISA_START_DATE
|
NO
|
NO
|
VISA_TYPE
|
Type of visa issued to this person. For example, student, employment, visitor, etc.
|
VARCHAR2(63)
|
GORVISA
|
GORVISA_VTYP_CODE
|
NO
|
NO
|
VISA_TYPE_DESC
|
Visa type description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|