Target Column	Business Definition	Database Data Type	Source Name	Source Column
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
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ACADEMIC_PERIOD_MATRICULATED	Academic period or time frame in which the student was matriculated in this curriculum. The time period when they began formal study in this academic study.	VARCHAR2(63)	SORLCUR	SORLCUR_TERM_CODE_MATRIC
ACADEMIC_PERIOD_MATRIC_DESC	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(63)	STVTERM	STVTERM_ACYR_CODE
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ACTIVITY1	Activity code that represents official participation in a sport that was defined per the display rules for sport activities. Institution defined.	VARCHAR2(63)	SGRSPRT	SGRSPRT_ACTC_CODE
ACTIVITY2	Activity code that represents official participation in a sport that was defined per the display rules for sport activities. Institution defined.	VARCHAR2(63)	SGRSPRT	SGRSPRT_ACTC_CODE
ACTIVITY3	Activity code that represents official participation in a sport that was defined per the display rules for sport activities. Institution defined.	VARCHAR2(63)	SGRSPRT	SGRSPRT_ACTC_CODE
ACTIVITY4	Activity code that represents official participation in a sport that was defined per the display rules for sport activities. Institution defined.	VARCHAR2(63)	SGRSPRT	SGRSPRT_ACTC_CODE
ACTIVITY5	Activity code that represents official participation in a sport that was defined per the display rules for sport activities. Institution defined.	VARCHAR2(63)	SGRSPRT	SGRSPRT_ACTC_CODE
ACTIVITY_DESC1	Activity code that represents the sport participation.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ACTIVITY_DESC2	Activity code that represents the sport participation.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ACTIVITY_DESC3	Activity code that represents the sport participation.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ACTIVITY_DESC4	Activity code that represents the sport participation.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ACTIVITY_DESC5	Activity code that represents the sport participation.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ADMINISTRATIVE_GROUP	Administrative-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 start date for the academic period admit listed for the student).	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	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.	VARCHAR2(255)	STVACAT	STVACAT_DESC
BIRTH_DATE	Date of birth for the person.	DATE	SPBPERS	SPBPERS_BIRTH_DATE
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	Institution campus name.	VARCHAR2(255)	STVCAMP	STVCAMP_DESC
CENSUS_FTE_1	Calculated value for the portion of a full time credit load for this person. Uses the FTE_DIVISOR1 and TOTAL_CREDITS for this student.	NUMBER	CALCULATION	TOTAL_CREDITS / MSKFUNC.F_GET_CENSUS_FTE(COHORT, 'CENSUS_FTE1')
CENSUS_FTE_2	Calculated value for the portion of a full time credit load for this person. Uses the FTE_DIVISOR2 and TOTAL_CREDITS for this student.	NUMBER	CALCULATION	TOTAL_CREDITS / MSKFUNC.F_GET_CENSUS_FTE(COHORT, 'CENSUS_FTE2')
CENSUS_FTE_3	Calculated value for the portion of a full time credit load for this person. Uses the FTE_DIVISOR3 and TOTAL_CREDITS for this student.	NUMBER	CALCULATION	TOTAL_CREDITS / MSKFUNC.F_GET_CENSUS_FTE(COHORT, 'CENSUS_FTE3')
CENSUS_FTE_4	Calculated value for the portion of a full time credit load for this person. Uses the FTE_DIVISOR4 and TOTAL_CREDITS for this student.	NUMBER	CALCULATION	TOTAL_CREDITS / MSKFUNC.F_GET_CENSUS_FTE(COHORT, 'CENSUS_FTE4')
CEU_CREDITS_IND	Number of continuing education units awarded for completion of this course.	NUMBER	FUNCTION	F_CALC_REGISTRATION_HOURS
CITIZENSHIP_DESC	Citizen type description.	VARCHAR2(255)	STVCITZ	STVCITZ_DESC
CITIZENSHIP_IND	Indicates whether the person is a citizen of the institution's home country.	VARCHAR2(1)	SPBPERS	SPBPERS_CITZ_IND
CITIZENSHIP_TYPE	Identifies the person's citizen type relationship to the institution's home country.	VARCHAR2(63)	SPBPERS	SPBPERS_CITZ_CODE
CITY	Address city, town or municipality.	VARCHAR2(63)	SPRADDR	SPRADDR_CITY
COHORT	Cohort tracking group assigned to the student through the Administrative UI display rules.	VARCHAR2(63)	SGRCHRT	SGRCHRT_CHRT_CODE
COHORT_DESC	Cohort code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
COLLEGE	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, faculty or school name.	VARCHAR2(255)	STVCOLL	STVCOLL_DESC
COUNTY	County for this address.	VARCHAR2(63)	SPRADDR	SPRADDR_CNTY_CODE
COUNTY_DESC	County name for the address.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
CUMULATIVE_GPA	GPA or Average for the specified group of courses completed.	NUMBER	SHRLGPA	SHRLGPA_GPA
CURRENT_TIME_STATUS	System-calculated time status for the academic period based on institution defined rules. For example, full time, part time, etc.	VARCHAR2(63)	SFBETRM	SFBETRM_TMST_CODE
CURRENT_TIME_STATUS_DESC	Current time status description.	VARCHAR2(255)	STVTMST	STVTMST_DESC
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
DEGREE_DESC	Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.	VARCHAR2(255)	STVDEGC	STVDEGC_DESC
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 name.	VARCHAR2(255)	STVDEPT	STVDEPT_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
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	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	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)	STVMAJR	STVMAJR_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)	STVMAJR	STVMAJR_DESC
FIRST_NAME	Person's first or given name.	VARCHAR2(63)	SPRIDEN	SPRIDEN_FIRST_NAME
FOURTH_DEPARTMENT	Department responsible for the second major or subject area of academic instruction.	VARCHAR2(63)	SORLFOS	SORLFOS_DEPT_CODE
FOURTH_DEPARTMENT_DESC	Department name.	VARCHAR2(255)	STVDEPT	STVDEPT_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)	STVMAJR	STVMAJR_DESC
FOURTH_MAJOR_CONC_2	Second concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.	VARCHAR2(63)	SORLFOS	SORLFOS_MAJR_CODE
FOURTH_MAJOR_CONC_2_DESC	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
FOURTH_MAJOR_CONC_3	Third concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.	VARCHAR2(63)	SORLFOS	SORLFOS_MAJR_CODE
FOURTH_MAJOR_CONC_3_DESC	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
FOURTH_MAJOR_DESC	Major or subject area of study description.	VARCHAR2(255)	STVMAJR	STVMAJR_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)	STVMAJR	STVMAJR_DESC
FOURTH_PROGRAM_CLASSIFICATION	Program classification associated with the major subject area of study for this academic outcome. This may be the Classification of Instructional Program (CIP) codes used by the federal government.	VARCHAR2(63)	STVMAJR	STVMAJR_CIPC_CODE
FOURTH_PROGRAM_CLASSIF_DESC	Program classification code description.	VARCHAR2(255)	STVCIPC	STVCIPC_DESC
GENDER	Identifies the gender of the person.	VARCHAR2(63)	SPBPERS	SPBPERS_SEX
GENDER_DESC	Identify as Male, Female or Not reported.	VARCHAR2(63)	CALCULATION	DECODE(SPBPERS_SEX,'M','MALE','F','FEMALE','N','NOT REPORTED')
HISPANIC_LATINO_ETHNICITY_IND	Indicates if person's ethnicity is Latino or Hispanic.This one ethnicity group was identified as a federal reporting group for ethnicity and race categories.	VARCHAR2(1)	SPBPERS	SPBPERS_ETHN_CDE
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID
INTENDED_TIME_STATUS_DESC	Indicates whether the student plans to attend with a full time or part time load.	VARCHAR2(255)	CALCULATION	DECODE(SARADAP_FULL_PART_IND,'F', 'FULL TIME', 'P', 'PART TIME')
INTENDED_TIME_STATUS_IND	Flag indicating whether the change in time status was calculated by the system or overridden and updated by a user.	VARCHAR2(1)	SGBSTDN	SGBSTDN_FULL_PART_IND
LAST_NAME	Last name.	VARCHAR2(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)	STVMAJR	STVMAJR_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)	STVNATN	STVNATN_NATION
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
NATION_OF_CITIZENSHIP_DESC	Name of the person's nation of citizenship.	VARCHAR2(255)	STVNATN	STVNATN_NATION
NON_TRADITIONAL_STUDENT_IND	Year long or non degree seeking students.	VARCHAR2(63)	NA	NA
ORIENTATION_SESSION	Orientation session recorded for the student.	VARCHAR2(63)	SGBSTDN	SGBSTDN_ORSN_CODE
ORIENTATION_SESSION_DESC	Description recorded for the orientation session recorded for the student.	VARCHAR2(255)	STVORSN	STVORSN_DESC
PERSON_UID	Internally generated by the system to uniquely identify the person or entity.	NUMBER	SFBETRM	SFBETRM_PIDM
POSTAL_CODE	Address postal or postal code.	VARCHAR2(63)	SPRADDR	SPRADDR_ZIP
PRIMARY_ETHNICITY	Person's ethnicity.	VARCHAR2(63)	SPBPERS	SPBPERS_ETHN_CODE
PRIMARY_ETHNICITY_DESC	Ethnic code description.	VARCHAR2(255)	STVETHN	STVETHN_DESC
PRIMARY_PROGRAM_IND	Indicates whether this is the student's primary academic study or program.	VARCHAR2(1)	FUNCTION	CASE PROGRAM_NUMBER WHEN 1 THEN 'Y' ELSE 'N' END
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)	STVETCT	STVETCT_DESC
PRIM_MEDICAL_CONDITION_DESC	Medical condition description.	VARCHAR2(255)	STVMEDI	STVMEDI_DESC
PRIM_MEDICAL_CONDTION	Medical condition marked as the primary disability.	VARCHAR2(63)	SPRMEDI	SPRMEDI_MEDI_CODE
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
PROGRAM	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	Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting.	VARCHAR2(63)	STVMAJR	STVMAJR_CIPC_CODE
PROGRAM_CLASSIFICATION_2	Program classification associated with the major subject area of study for this academic outcome. This may be the Classification of Institutional Program (CIP) codes used for reporting to the federal government.	VARCHAR2(63)	STVMAJR	STVMAJR_CIPC_CODE
PROGRAM_CLASSIFICATION_DESC	Program classification code description.	VARCHAR2(255)	STVCIPC	STVCIPC_DESC
PROGRAM_CLASSIFICATION_DESC_2	Program classification code description.	VARCHAR2(255)	STVCIPC	STVCIPC_DESC
PROGRAM_DESC	Program or course of study description.	VARCHAR2(255)	SMRPRLE	SMRPRLE_PROGRAM_DESC
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	Number of unique regulatory races selected by this person.	NUMBER	FUNCTION	MGKFUNC.F_COUNT_RACE_CATEGORY
RACE_COUNT	Number of races selected by this person.	NUMBER	FUNCTION	MGKFUNC.F_COUNT_RACE
RACE_ETHNICITY_CONFIRM_DATE	Race and ethnicity self confirmed date.	DATE	SPBPERS	SPBPERS_CONFIRMED_RE_DATE
RACE_ETHNICITY_CONFIRM_IND	Indicates if the person's race and ethnicity have been self-identified.	VARCHAR2(1)	SPBPERS	SPBPERS_CONFIRMED_RE_CDE
REGISTRATION_REASON	Reason recorded at the time of registration for this academic period.	VARCHAR2(63)	SFBETRM	SFBETRM_RGRE_CODE
REGISTRATION_REASON_DESC	Reason description associated with this student registration.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
RESIDENCY	Residency code for the student identifying the type of charges the student will incur.	VARCHAR2(63)	SGBSTDN	SGBSTDN_RESD_CODE
RESIDENCY_DESC	Student's residency description. Typically used to calculate fees to be charges and may indicate in area or out of area.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
SECOND_CONCENTRATION	Concentration or study emphasis attached to the major for the student's academic study.	VARCHAR2(63)	SORLFOS	SORLFOS_MAJR_CODE
SECOND_CONCENTRATION_DESC	Concentration or study emphasis description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
SECOND_DEPARTMENT	Department responsible for the major or subject area of academic instruction.	VARCHAR2(63)	SORLFOS	SORLFOS_DEPT_CODE
SECOND_DEPARTMENT_DESC	Department name.	VARCHAR2(255)	STVDEPT	STVDEPT_DESC
SECOND_MAJOR	Major subject area of the person's academic study.	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 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	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_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	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
SECOND_MAJOR_CONC_3	Third concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration.	VARCHAR2(63)	SORLFOS	SORLFOS_MAJR_CODE
SECOND_MAJOR_CONC_3_DESC	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
SECOND_MAJOR_DESC	Major or subject area of study description.	VARCHAR2(255)	STVMAJR	STVMAJR_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	Minor area of study description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
SITE	Site or location to which applicant is applying.	VARCHAR2(63)	CALCULATION	DECODE(SORLCUR_SITE_CODE)
SITE_CARRIER_ROUTE	Carrier route associated with the site address for barcode mailings.	VARCHAR2(63)	NA	NA
SITE_CITY	City town or municipality associated with the site address.	VARCHAR2(63)	STVSITE	STVSITE_CITY
SITE_CORRECTION_DIGIT	Correction digit associated with the site address for barcode mailings.	VARCHAR2(63)	NA	NA
SITE_COUNTY_CODE	County associated with the site address.	VARCHAR2(63)	NA	NA
SITE_COUNTY_CODE_DESC	Descriptions of the county associated with the site address.	VARCHAR2(255)	NA	NA
SITE_DELIVERY_POINT	Delivery point associated with the site address for barcode mailings.	VARCHAR2(63)	NA	NA
SITE_DESC	Site or location name.	VARCHAR2(255)	STVSITE	STVSITE_DESC
SITE_NATION	Nation/country code associated with the site address.	VARCHAR2(63)	STVSITE	STVSITE_NATION_CODE
SITE_NATION_DESC	Description for the nation/country associated with the site address.	VARCHAR2(255)	STVNATN	STVNATN_NATION
SITE_POSTAL_CODE	Postal code associated with the site address.	VARCHAR2(63)	STVSITE	STVSITE_ZIPC
SITE_STATE_PROVINCE	Identifies the state or province associated with this address.	VARCHAR2(63)	STVSITE	STVSITE_STATE
SITE_STATE_PROVINCE_DESC	Name of the state/province.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
SITE_STREET_LINE1	First line of the site address.	VARCHAR2(255)	STVSITE	STVSITE_STREET_ADDR1
SITE_STREET_LINE2	Second line of the site address.	VARCHAR2(255)	STVSITE	STVSITE_STREET_ADDR2
SITE_STREET_LINE3	Third line of the site address.	VARCHAR2(255)	STVSITE	STVSITE_STREET_ADDR3
SITE_STREET_LINE4	Fourth line of the site address.	VARCHAR2(255)	NA	NA
SPORT_STATUS1	Current status for the sport participation for the sport selected in the display rules.	VARCHAR2(63)	SGRSPRT	SGRSPRT_SPST_CODE
SPORT_STATUS2	Current status for the sport participation for the sport selected in the display rules.	VARCHAR2(63)	SGRSPRT	SGRSPRT_SPST_CODE
SPORT_STATUS3	Current status for the sport participation for the sport selected in the display rules.	VARCHAR2(63)	SGRSPRT	SGRSPRT_SPST_CODE
SPORT_STATUS4	Current status for the sport participation for the sport selected in the display rules.	VARCHAR2(63)	SGRSPRT	SGRSPRT_SPST_CODE
SPORT_STATUS5	Current status for the sport participation for the sport selected in the display rules.	VARCHAR2(63)	SGRSPRT	SGRSPRT_SPST_CODE
SPORT_STATUS_DESC1	Student participation status description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
SPORT_STATUS_DESC2	Student participation status description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
SPORT_STATUS_DESC3	Student participation status description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
SPORT_STATUS_DESC4	Student participation status description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
SPORT_STATUS_DESC5	Student participation status description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
STATE_PROVINCE	State or province associated with this address.	VARCHAR2(63)	SPRADDR	SPRADDR_STAT_CODE
STATE_PROVINCE_DESC	State or province name associated with the address record.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
STUDENT_CLASSIFICATION	Identifies the student'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
STUDENT_CLASSIFICATION_BOAP	Identifies the student's classification (i.e. class or year in school) when the academic period begins, for example, first year, second year or freshman, sophomore, etc. This will be the same value as the Student Classification when the previous academic period ended.	VARCHAR2(63)	FUNCTION	SGKCLAS.F_CLASS_CODE
STUDENT_CLASSIFICATION_DESC	Student classification description.	VARCHAR2(255)	STVCLAS	STVCLAS_DESC
STUDENT_CLASS_BOAP_DESC	Beginning of academic period student classification.	VARCHAR2(255)	STVCLAS	STVCLAS_DESC
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.	VARCHAR2(255)	STVLEVL	STVLEVL_DESC
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)
STUDENT_POPULATION_DESC	Student population or type description.	VARCHAR2(255)	STVSTYP	STVSTYP_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)	STVMAJR	STVMAJR_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)	STVDEPT	STVDEPT_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)	STVMAJR	STVMAJR_DESC
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
THIRD_MAJOR_CONC_2_DESC	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
THIRD_MAJOR_CONC_3	Third concentration or focus of study within this student's major. This may be blank when concentrations are not being used or 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)	STVMAJR	STVMAJR_DESC
THIRD_MAJOR_DESC	Major or subject area of study description.	VARCHAR2(255)	STVMAJR	STVMAJR_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)	STVMAJR	STVMAJR_DESC
THIRD_PROGRAM_CLASSIFICATION	Program classification associated with the major subject area of study for this outcome. This may be the Classification of Instructional Program (CIP) codes used for reporting to the federal government.	VARCHAR2(63)	STVMAJR	STVMAJR_CIPC_CODE
THIRD_PROGRAM_CLASSIF_DESC	Program classification code description.	VARCHAR2(255)	STVCIPC	STVCIPC_DESC
TOTAL_CREDITS	Total credits for the student for this academic period.	NUMBER	FUNCTION	F_CALC_REGISTRATION_HOURS
TOTAL_CREDITS_ATTEMPTED	Credits used to sum the credits attempted by a student per the rules of the institution.	NUMBER	SHRLGPA	SHRLGPA_HOURS_ATTEMPTED
TOTAL_CREDITS_EARNED	Credits used to sum the credits earned by a student per the rules of the institution.	NUMBER	SHRLGPA	SHRLGPA_HOURS_EARNED
TOTAL_CREDITS_PASSED	Credits used to sum the credits passed by a student per the rules of the institution.	NUMBER	SHRLGPA	SHRLGPA_HOURS_PASSED
TOTAL_GPA_CREDITS	Credits used in the calculation of a person's GPA or Average per the rules of the institution.	NUMBER	SHRLGPA	SHRLGPA_GPA_HOURS
TOTAL_QUALITY_POINTS	Quality points used in the calculation of a person's GPA per the rules of the institution.	NUMBER	SHRLGPA	SHRLGPA_QUALITY_POINTS
VISA_EXPIRE_DATE	Date recorded as the date on which this current visa expires.	DATE	GORVISA	GORVISA_VISA_EXPIRE_DATE
VISA_START_DATE	Date, if any, recorded as the date on which this current visa begins.	DATE	GORVISA	GORVISA_VISA_START_DATE
VISA_TYPE	Type of visa issued to this person. For example, student, employment, visitor, etc.	VARCHAR2(63)	GORVISA	GORVISA_VTYP_CODE
VISA_TYPE_DESC	Visa type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC

Ver: 8.5