Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
ACADEMIC_HISTORY_EXISTS_IND
|
Indicates whether the student has academic history information for the academic period.
|
VARCHAR2(1)
|
FUNCTION
|
SOKODSF.F_CHECK_FOR_ACAD_HISTORY_DATA
|
NO
|
NO
|
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)
|
SGBSTDN
|
SGBSTDN_TERM_CODE_EFF
|
NO
|
NO
|
ACADEMIC_PERIOD_ADMITTED
|
Academic period or time frame the student was admitted to this academic study.
|
VARCHAR2(63)
|
SORLCUR
|
SORLCUR_TERM_CODE_ADMIT
|
NO
|
NO
|
ACADEMIC_PERIOD_ADMITTED_DESC
|
Academic period description.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_DESC
|
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_STANDING
|
Academic standing for the student as determined at the beginning of the academic period. Value may be the override academic standing when it exists or it will be the academic standing at the end of the most recent previous academic period. When neither value exists it will be the the default good standing (00). Indicates the student may continue to enroll or must seek assistance prior to continuing to study at the institution.
|
VARCHAR2(63)
|
FUNCTION
|
NVL(ACADEMIC_STANDING,MSKFUNC.F_ACADEMIC_STAND_DATA(PERSON_UID,ACADEMIC_PERIOD,PROGRAM_LEVEL,''ACADEMIC_STANDING'')
|
NO
|
NO
|
ACADEMIC_STANDING_ACAD_PERIOD
|
Academic period or time frame when this academic standing code is valid for the student. This will be the academic period in which the code was overridden if the calculated value is not to be used.
|
VARCHAR2(63)
|
FUNCTION
|
NVL(ACADEMIC_PERIOD,MSKFUNC.F_ACADEMIC_STAND_DATA(PERSON_UID,ACADEMIC_PERIOD,PROGRAM_LEVEL,''ACADEMIC_STANDING_ACAD_PERIOD'')
|
NO
|
NO
|
ACADEMIC_STANDING_DATE
|
Date the academic standing was applied to the student record. This may be derived from the end date of the academic period override or be the date the academic standing was assigned.
|
DATE
|
FUNCTION
|
NVL(ACADEMIC_STANDING_DATE,MSKFUNC.F_ACADEMIC_STAND_DATA(PERSON_UID,ACADEMIC_PERIOD,PROGRAM_LEVEL,''ACADEMIC_STANDING_DATE'')
|
NO
|
NO
|
ACADEMIC_STANDING_DESC
|
Description for the academic standing value.
|
VARCHAR2(255)
|
FUNCTION STVASTD
|
NVL(ACADEMIC_STANDING_DESC,MSKFUNC.F_ACADEMIC_STAND_DATA(PERSON_UID,ACADEMIC_PERIOD,PROGRAM_LEVEL,''ACADEMIC_STANDING_DESC'') STVASTD_DESC
|
NO NO
|
NO
|
ACADEMIC_STANDING_END
|
Academic standing for the student as determined after the grades are processed for the academic period. When there is no end academic standing recorded for the student no value will be displayed. Indicates the student may continue to enroll or must seek assistance prior to continuing to study at the institution.
|
VARCHAR2(63)
|
SHRTTRM
|
SHRTTRM_ASTD_CODE_END_OF_TERM
|
NO
|
NO
|
ACADEMIC_STANDING_END_DATE
|
Date that the academic standing was calculated and recorded for the student at the end of the academic period. This will be either the date the combined academic standing was calculated or derived from the start date of the academic period for which the academic standing was applied as an override.
|
DATE
|
SHRTTRM
|
SHRTTRM_ASTD_DATE_END_OF_TERM
|
NO
|
NO
|
ACADEMIC_STAND_OVERRIDE
|
Identifies the academic standing at the end of the previous academic period has been overridden for the student. This override will be the academic standing value will be the begin academic period academic standing.
|
VARCHAR2(63)
|
SGBSTDN
|
SGBSTDN_ASTD_CODE
|
NO
|
NO
|
ACADEMIC_STAND_OVERRIDE_DESC
|
Description for the academic standing override.
|
VARCHAR2(255)
|
STVASTD
|
STVASTD_DESC
|
NO
|
NO
|
ACADEMIC_YEAR
|
Academic year associated with the academic period on this record.
|
VARCHAR2(63)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
ACADEMIC_YEAR_DESC
|
Academic year description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
ACAD_STANDING_ACAD_PERIOD_DESC
|
Academic period description associated with the student academic standing.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_DESC
|
NO
|
NO
|
ACAD_STANDING_END_DESC
|
Academic standing description.
|
VARCHAR2(255)
|
STVASTD
|
STVASTD_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
|
ADMISSIONS_POPULATION
|
Identifies an admission population such as early admit, mature, adult and continuing education, etc., associated with the person and application.
|
VARCHAR2(63)
|
SORLCUR
|
SORLCUR_ADMT_CODE
|
NO
|
NO
|
ADMISSIONS_POPULATION_DESC
|
Admission population description.
|
VARCHAR2(255)
|
STVADMT
|
STVADMT_DESC
|
NO
|
NO
|
ADVISOR_COUNT
|
Count of current active advisors assigned to the student.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_ADVISORS
|
NO
|
NO
|
AGE_ADMITTED
|
Calculated age of the person at the time of admission to the institution.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_CALCULATE_AGE_ADMIT
|
NO
|
NO
|
AID_ENROLLMENT_PERIOD
|
Aid enrollment period associated with the award schedule. This period can span multiple student terms.
|
VARCHAR2(63)
|
FUNCTION
|
MRKFUNC.F_GET_AID_ENROLL_PERIOD
|
NO
|
NO
|
AID_ENROLLMENT_PERIOD_DESC
|
Aid enrollment period description.
|
VARCHAR2(255)
|
FUNCTION
|
MRKFUNC.F_GET_AID_ENROLL_PERIOD
|
NO
|
NO
|
AID_YEAR
|
Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005).
|
VARCHAR2(63)
|
FUNCTION
|
MRKFUNC.F_GET_AID_ENROLL_PERIOD
|
NO
|
NO
|
AID_YEAR_DESC
|
Financial aid year name.
|
VARCHAR2(255)
|
FUNCTION
|
MRKFUNC.F_GET_AID_ENROLL_PERIOD
|
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
|
BLOCK_SCHEDULE
|
Block schedule code assigned to the student. May be used by the institution to expedite the enrollment process to a block of sections or for reporting and identifying groups of students.
|
VARCHAR2(63)
|
SGBSTDN
|
SGBSTDN_BLCK_CODE
|
NO
|
NO
|
BLOCK_SCHEDULE_DESC
|
Description for the block schedule code.
|
VARCHAR2(255)
|
STVBLCK
|
STVBLCK_DESC
|
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
|
CATALOG_ACADEMIC_PERIOD
|
Catalog academic period used to measure completion requirements for the outcome.
|
VARCHAR2(63)
|
SORLCUR
|
SORLCUR_TERM_CODE_CTLG
|
NO
|
NO
|
CATALOG_ACADEMIC_PERIOD_DESC
|
Catalog academic period description.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_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
|
COMBINED_ACAD_STANDING
|
Combined academic standing for the student determined after the grades are processed for the academic period. Indicates the student may continue to enroll or must seek assistance prior to continuing to study at the institution.
|
VARCHAR2(63)
|
FUNCTION
|
NVL(COMBINED_ACAD_STANDING,MSKFUNC.F_ACADEMIC_STAND_DATA(PERSON_UID,ACADEMIC_PERIOD,PROGRAM_LEVEL,''COMBINED_ACAD_STANDING'')
|
NO
|
NO
|
COMBINED_ACAD_STANDING_DATE
|
Date the combined academic standing was applied to the student record. This may be derived from the start date of the academic period override or be the date the combined academic standing was assigned.
|
DATE
|
FUNCTION
|
NVL(COMBINED_ACAD_STANDING_DATE,MSKFUNC.F_ACADEMIC_STAND_DATA(PERSON_UID,ACADEMIC_PERIOD,PROGRAM_LEVEL,''COMBINED_ACAD_STANDING_DATE'')
|
NO
|
NO
|
COMBINED_ACAD_STANDING_DESC
|
Description for the combined academic standing value.
|
VARCHAR2(255)
|
FUNCTION
|
NVL(COMBINED_ACAD_STANDING_DESC,MSKFUNC.F_ACADEMIC_STAND_DATA(PERSON_UID,ACADEMIC_PERIOD,PROGRAM_LEVEL,''COMBINED_ACAD_STANDING_DESC'')
|
NO
|
NO
|
COMBINED_ACAD_STAND_END
|
Identifies a student's combined academic standing at the end of the academic period (probation, good standing, etc).
|
VARCHAR2(63)
|
SHRTTRM
|
SHRTTRM_CAST_CODE
|
NO
|
NO
|
COMBINED_ACAD_STAND_END_DATE
|
Date combined academic standing calculated or entered at the end of the academic period.
|
DATE
|
SHRTTRM
|
SHRTTRM_CAST_DATE
|
NO
|
NO
|
COMBINED_ACAD_STAND_END_DESC
|
Description for the combined academic standing value.
|
VARCHAR2(255)
|
STVCAST
|
STVCAST_DESC
|
NO
|
NO
|
COMB_ACAD_STAND_OVERRIDE
|
Identifies the combined academic standing at the end of the previous academic period has been overridden for the student. This override will be the combined academic standing value as of the academic period specified.
|
VARCHAR2(63)
|
SGBSTDN
|
SGBSTDN_CAST_CODE
|
NO
|
NO
|
COMB_ACAD_STAND_OVERRIDE_DESC
|
Description for the combined academic standing override value.
|
VARCHAR2(255)
|
STVCAST
|
STVCAST_DESC
|
NO
|
NO
|
COOPERATIVE_EDUCATION_IND
|
Indicates this is a cooperative education course.
|
VARCHAR2(1)
|
FUNCTION
|
MSKFUNC.F_CHECK_COOP_IND
|
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_DATE
|
Date the system-calculated time status for the academic period based on institution defined rules. For example, full time, part time, etc.
|
DATE
|
SFBETRM
|
SFBETRM_TMST_DATE
|
NO
|
NO
|
CURRENT_TIME_STATUS_DESC
|
Current time status description.
|
VARCHAR2(255)
|
STVTMST
|
STVTMST_DESC
|
NO
|
NO
|
CURRICULUM_PRIORITY_NUMBER
|
Identifies the significant ranking for a curricula.
|
NUMBER
|
SORLCUR
|
SORLCUR_PRIORITY_NO
|
NO
|
NO
|
DEANS_LIST_DATE
|
Date on which the Dean's List code was recorded.
|
DATE
|
SHRTTRM
|
SHRTTRM_ASTD_DATE_DL
|
NO
|
NO
|
DEANS_LIST_DESC
|
Student's dean's list code description.
|
VARCHAR2(255)
|
STVASTD
|
STVASTD_DESC
|
NO
|
NO
|
DEANS_LIST_VALUE
|
Identifies whether the student qualified for the dean's list this academic period.
|
VARCHAR2(63)
|
SHRTTRM
|
SHRTTRM_ASTD_CODE_DL
|
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
|
DUAL_DEGREE
|
Identifies this as a dual degree.
|
VARCHAR2(63)
|
SGBSTDN
|
SGBSTDN_DEGC_CODE_DUAL
|
NO
|
NO
|
DUAL_DEGREE_COLLEGE
|
College associated with the dual degree.
|
VARCHAR2(63)
|
SGBSTDN
|
SGBSTDN_COLL_CODE_DUAL
|
NO
|
NO
|
DUAL_DEGREE_COLLEGE_DESC
|
College, faculty or school description.
|
VARCHAR2(255)
|
STVCOLL
|
STVCOLL_DESC
|
NO
|
NO
|
DUAL_DEGREE_DEPARTMENT
|
Department associated with the dual degree.
|
VARCHAR2(63)
|
SGBSTDN
|
SGBSTDN_DEPT_CODE_DUAL
|
NO
|
NO
|
DUAL_DEGREE_DEPARTMENT_DESC
|
College, faculty or school description.
|
VARCHAR2(255)
|
STVDEPT
|
STVDEPT_DESC
|
NO
|
NO
|
DUAL_DEGREE_DESC
|
Dual degree description.
|
VARCHAR2(255)
|
STVDEGC
|
STVDEGC_DESC
|
NO
|
NO
|
DUAL_DEGREE_LEVEL
|
Level associated with the dual degree.
|
VARCHAR2(63)
|
SGBSTDN
|
SGBSTDN_LEVL_CODE_DUAL
|
NO
|
NO
|
DUAL_DEGREE_LEVEL_DESC
|
Student level description.
|
VARCHAR2(255)
|
STVLEVL
|
STVLEVL_DESC
|
NO
|
NO
|
DUAL_DEGREE_MAJOR
|
Major associated with the dual degree.
|
VARCHAR2(63)
|
SGBSTDN
|
SGBSTDN_MAJR_CODE_DUAL
|
NO
|
NO
|
DUAL_DEGREE_MAJOR_DESC
|
Major or subject area description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
DUAL_PROGRAM_CLASSIFICATION
|
Program classification sometimes referred to as the Classification of Institutional Programs (CIP) code for reporting this academic study.
|
VARCHAR2(63)
|
STVMAJR
|
STVMAJR_CIPC_CODE
|
NO
|
NO
|
DUAL_PROGRAM_CLASSIF_DESC
|
Program classification description.
|
VARCHAR2(255)
|
STVCIPC
|
STVCIPC_DESC
|
NO
|
NO
|
ENROLLED_IND
|
Indicates whether the student has enrolled for the academic period identified by the student having a registration enrollment status that effects headcount.
|
VARCHAR2(1)
|
FUNCTION
|
F_ENROLLED_THIS_TERM
|
NO
|
NO
|
ENROLLMENT_ADD_DATE
|
Date of the initial enrollment and course offering registration for this academic period.
|
DATE
|
SFBETRM
|
SFBETRM_ADD_DATE
|
NO
|
NO
|
ENROLLMENT_EXISTS_IND
|
Indicates whether the student has current enrollment information for the academic period.
|
VARCHAR2(1)
|
CALCULATION
|
DECODE(SFBETRM_PIDM, NULL, 'N', 'Y')
|
NO
|
NO
|
ENROLLMENT_STATUS
|
Student's current enrollment status for this academic period.
|
VARCHAR2(63)
|
SFBETRM
|
SFBETRM_ESTS_CODE
|
NO
|
NO
|
ENROLLMENT_STATUS_DATE
|
Date for the last update to enrollment status.
|
DATE
|
SFBETRM
|
SFBETRM_ESTS_DATE
|
NO
|
NO
|
ENROLLMENT_STATUS_DESC
|
Student's enrollment status description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
EXPECTED_GRADUATION_DATE
|
Expected graduation date.
|
DATE
|
CALCULATION
|
NVL(SORLCUR_EXP_GRAD_DATE, SGBSTDN_EXP_GRAD_DATE)
|
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
|
FOURTH_DEPARTMENT
|
Department responsible for the 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 outcome. This may be the Classification of Institutional Programs (CIP) codes used for reporting to 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
|
FTE_DIVISOR
|
Full time equivalency divisor.
|
NUMBER
|
NA
|
NA
|
NO
|
NO
|
FTE_IND
|
Indicates whether the student represents at least one FTE (full-time equivalent).
|
VARCHAR2(1)
|
NA
|
NA
|
NO
|
NO
|
GRADUATED_IND
|
Indicates whether the person has graduated or earned any academic outcomes to date.
|
VARCHAR2(1)
|
FUNCTION
|
SOKODSF.F_CHECK_FOR_GRADUATE_IND
|
NO
|
NO
|
GRAD_ACADEMIC_PERIOD_INTENDED
|
Intended academic period of graduation for the student.
|
VARCHAR2(63)
|
CALCULATION
|
NVL(SORLCUR_TERM_CODE_GRAD, SGBSTDN_TERM_CODE_GRAD)
|
NO
|
NO
|
GRAD_ACAD_PERIOD_INTENDED_DESC
|
Intended graduation term description.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_DESC
|
NO
|
NO
|
GRAD_YEAR_INTENDED
|
Intended year of graduation.
|
VARCHAR2(63)
|
CALCULATION
|
NVL(SORLCUR_ACYR_CODE, SGBSTDN_ACYR_CODE)
|
NO
|
NO
|
GRAD_YEAR_INTENDED_DESC
|
Academic year description.
|
VARCHAR2(255)
|
STVACYR
|
STVACYR_DESC
|
NO
|
NO
|
ID
|
Identification number assigned to a person that is used externally for all communication and correspondence with the person.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
INTENDED_TIME_STATUS
|
Student's intended time status.
|
VARCHAR2(1)
|
SGBSTDN
|
SGBSTDN_FULL_PART_IND
|
NO
|
NO
|
LEAVE_DATE_FROM
|
Date the student leave began.
|
DATE
|
CALCULATION
|
NVL(SORLCUR_LEAV_FROM_DATE, SGBSTDN_LEAV_FROM_DATE)
|
NO
|
NO
|
LEAVE_DATE_TO
|
Date the student leave is schedule to or ends.
|
DATE
|
CALCULATION
|
NVL(SORLCUR_LEAV_TO_DATE, SGBSTDN_LEAV_TO_DATE)
|
NO
|
NO
|
LEAVE_REASON
|
Leave code of the student for this academic period.
|
VARCHAR2(63)
|
CALCULATION
|
NVL(SORLCUR_LEAV_CODE, SGBSTDN_LEAV_CODE)
|
NO
|
NO
|
LEAVE_REASON_DESC
|
Student's leave code description for this term.
|
VARCHAR2(255)
|
STVLEAV
|
STVLEAV_DESC
|
NO
|
NO
|
MAJOR
|
Major subject area of the person's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
MAJOR_DESC
|
Name of the student's major subject area.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
MATRICULATED_IND
|
Indicates whether the student has matriculated, and was formally admitted to a degree granting academic study or program.
|
VARCHAR2(1)
|
CALCULATION
|
DECODE(SORLCUR_TERM_CODE_MATRIC)
|
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 for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
NAME
|
Name of the person (last name, first name middle initial).
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
NEW_STUDENT_IND
|
Indicates that this is the first academic period for the student and they are a new admit to the institution.
|
VARCHAR2(1)
|
CALCULATION
|
DECODE(SORLCUR_TERM_CODE_ADMIT)
|
NO
|
NO
|
NON_TRADITIONAL_IND
|
Indicates whether this academic study is non-traditional.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
OUTCOME_AWARDED_IND
|
Indicates that there is an academic outcome row for this academic study and academic period.
|
VARCHAR2(63)
|
FUNCTION
|
MSKFUNC.F_GET_OUTCOME_AWARDED_IND
|
NO
|
NO
|
PERMIT_REGISTRATION
|
Indicates whether the student is permitted to register for sections, or schedule offerings in this academic period.
|
VARCHAR2(1)
|
STVSTST
|
STVSTST_REG_IND
|
NO
|
NO
|
PERSON_UID
|
System generated, unique, internal identification number assigned to the person.
|
NUMBER
|
SGBSTDN
|
SGBSTDN_PIDM
|
NO
|
NO
|
PRIMARY_ADVISOR_NAME_FMIL
|
Advisor's current first name, middle name and last name.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
PRIMARY_ADVISOR_NAME_LFMI
|
Advisor's current last name, first name middle initial.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
PRIMARY_ADVISOR_PERSON_UID
|
System generated, unique, internal identification number assigned to the person.
|
NUMBER
|
SGRADVR
|
SGRADVR_ADVR_PIDM
|
NO
|
NO
|
PRIMARY_ADVISOR_TYPE
|
Primary advisor current advising assignment type.
|
VARCHAR2(63)
|
SGRADVR
|
SGRADVR_ADVR_CODE
|
NO
|
NO
|
PRIMARY_ADVISOR_TYPE_DESC
|
Advisor type description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_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
|
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_DESC
|
Program classification 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
|
PROGRESS_EVALUATION
|
Progress evaluation for the student determined after the grades are processed for the academic period. Indicates the student may continue to enroll or must seek assistance prior to continuing to study at the institution.
|
VARCHAR2(63)
|
FUNCTION
|
NVL(PROGRESS_EVALUATION,MSKFUNC.F_ACADEMIC_STAND_DATA(PERSON_UID,ACADEMIC_PERIOD,PROGRAM_LEVEL,''PROGRESS_EVALUATION'')
|
NO
|
NO
|
PROGRESS_EVALUATION_DATE
|
Date progress evaluation was overridden or entered for the academic period.
|
DATE
|
FUNCTION
|
NVL(PROGRESS_EVALUATION_DATE,MSKFUNC.F_ACADEMIC_STAND_DATA(PERSON_UID,ACADEMIC_PERIOD,PROGRAM_LEVEL,''PROGRESS_EVALUATION_DATE'')
|
NO
|
NO
|
PROGRESS_EVALUATION_DESC
|
Description for the progress evaluation value.
|
VARCHAR2(255)
|
FUNCTION
|
NVL(PROGRESS_EVALUATION_DESC,MSKFUNC.F_ACADEMIC_STAND_DATA(PERSON_UID,ACADEMIC_PERIOD,PROGRAM_LEVEL,''PROGRESS_EVALUATION_DESC'')
|
NO
|
NO
|
PROGRESS_EVALUATION_END
|
Identifies a student's progress evaluation value at the end of the academic period (probation, good standing, etc). This will be the value assigned when grades were processed for the academic period.
|
VARCHAR2(63)
|
SHRTTRM
|
SHRTTRM_PREV_CODE
|
NO
|
NO
|
PROGRESS_EVALUATION_END_DATE
|
Date progress evaluation was overridden or entered at the end of the academic period.
|
DATE
|
SHRTTRM
|
SHRTTRM_PREV_DATE
|
NO
|
NO
|
PROGRESS_EVALUATION_END_DESC
|
Description for the progress evaluation value.
|
VARCHAR2(255)
|
STVPREV
|
STVPREV_DESC
|
NO
|
NO
|
PROGRESS_EVAL_OVERRIDE
|
Identifies the progress evaluation at the end of the previous academic period has been overridden for the student. This override will be the progress evaluation value as of the academic period specified.
|
VARCHAR2(63)
|
SGBSTDN
|
SGBSTDN_PREV_CODE
|
NO
|
NO
|
PROGRESS_EVAL_OVERRIDE_DESC
|
Description for the progress evaluation override value.
|
VARCHAR2(255)
|
STVPREV
|
STVPREV_DESC
|
NO
|
NO
|
REGISTERED_IND
|
Indicates the student is registered when there is at least one graded student course in institutional academic history or one student course in registration with a course registration status to be included as enrolled for the academic period.
|
VARCHAR2(1)
|
FUNCTION
|
F_REGISTERED_THIS_TERM
|
NO
|
NO
|
REGISTRATION_REASON
|
Reason recorded for the student registration. May be the reason registered, or the reason the registration is withdrawn depending on the institution's definition.
|
VARCHAR2(63)
|
SFBETRM
|
SFBETRM_RGRE_CODE
|
NO
|
NO
|
REGISTRATION_REASON_DESC
|
Registration reason description.
|
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 if concentrations 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 if concentrations 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 if concentrations 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_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 subject area of the person's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
SECOND_MINOR_DESC
|
Minor area of study description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
SECOND_PROGRAM_CLASSIFICATION
|
Program classification associated with the major subject area of study for this outcome. This may be the Classification of Institutional Programs (CIP) codes used for reporting to the federal government.
|
VARCHAR2(63)
|
STVMAJR
|
STVMAJR_CIPC_CODE
|
NO
|
NO
|
SECOND_PROGRAM_CLASSIF_DESC
|
Program classification code description.
|
VARCHAR2(255)
|
STVCIPC
|
STVCIPC_DESC
|
NO
|
NO
|
SITE
|
Site or location where the student is attending or obtaining instruction.
|
VARCHAR2(63)
|
CALCULATION
|
NVL(SORLCUR_SITE_CODE,SGBSTDN_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 or 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
|
SPECIAL_EXAM_CREDIT
|
Identifies that special examination credit was granted to the student in this academic period.
|
VARCHAR2(63)
|
SHRTTRM
|
SHRTTRM_EXAM_CODE
|
NO
|
NO
|
SPECIAL_EXAM_DESC
|
Special examination credit description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
START_DATE
|
Date the student started studying. This is a non-term based field.
|
DATE
|
SORLCUR
|
SORLCUR_START_DATE
|
NO
|
NO
|
START_DATE_ADMITTED
|
Date the student began to study courses within this academic study.
|
DATE
|
STVTERM
|
STVTERM_START_DATE
|
NO
|
NO
|
START_DATE_MATRICULATED
|
Date the student was official accepted or matriculated into this academic study. It may be individual for the person or taken from the start date for the academic period in which the person was matriculated.
|
DATE
|
STVTERM
|
STVTERM_START_DATE
|
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's 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_FTE
|
Identifies the portion of full time equated load the student is currently registered for in this academic study for this academic period.
|
NUMBER
|
NA
|
NA
|
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)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
STUDENT_MEETING_TIME
|
Student's normal attendance time. May be either day, evening, weekend, etc.
|
VARCHAR2(63)
|
SGBSTDN
|
SGBSTDN_SESS_CODE
|
NO
|
NO
|
STUDENT_MEETING_TIME_DESC
|
Student's meeting session description.
|
VARCHAR2(255)
|
STVSESS
|
STVSESS_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)
|
CALCULATION
|
NVL(SORLCUR_STYP_CODE,SGBSTDN_STYP_CODE)
|
NO
|
NO
|
STUDENT_POPULATION_DESC
|
Student population or type description.
|
VARCHAR2(255)
|
STVSTYP
|
STVSTYP_DESC
|
NO
|
NO
|
STUDENT_RATE
|
Identifies any specific assessment rate to be used to determine the charges for this student.
|
VARCHAR2(63)
|
CALCULATION
|
NVL(SORLCUR_RATE_CODE, SGBSTDN_RATE_CODE)
|
NO
|
NO
|
STUDENT_RATE_DESC
|
Description for the rate code.
|
VARCHAR2(255)
|
STVRATE
|
STVRATE_DESC
|
NO
|
NO
|
STUDENT_STATUS
|
Student's current status for the academic period. May include active and permitted to register, inactive and stop registration, graduated, etc.
|
VARCHAR2(63)
|
SGBSTDN
|
SGBSTDN_STST_CODE
|
NO
|
NO
|
STUDENT_STATUS_DESC
|
Student's status description.
|
VARCHAR2(255)
|
STVSTST
|
STVSTST_DESC
|
NO
|
NO
|
SUB_ACADEMIC_PERIOD
|
A session, portion or part of the academic period.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
SUB_ACADEMIC_PERIOD_ADMITTED
|
Session or part of the academic period associated with the information on the academic study information record.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
SUB_ACADEMIC_PERIOD_ADMIT_DESC
|
Description of the session or part of the academic period associated with the session code.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
SUB_ACADEMIC_PERIOD_DESC
|
Sub academic period description.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
SUB_ACADEMIC_PERIOD_MATRIC
|
Matriculation sub-academic period of the student.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
SUB_ACAD_PERIOD_MATRIC_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 Institutional Programs (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
|
TRANSFER_CENTER
|
Informational data defined by the institution to identify a transfer center.
|
VARCHAR2(63)
|
SGBSTDN
|
SGBSTDN_TRCN_CODE
|
NO
|
NO
|
TRANSFER_CENTER_DESC
|
Transfer center description.
|
VARCHAR2(255)
|
STVTRCN
|
STVTRCN_DESC
|
NO
|
NO
|
TRANSFER_TO_INSTITUTION
|
Institution to which the student will transfer from this institution.
|
VARCHAR2(63)
|
SHRTTRM
|
SHRTTRM_SBGI_CODE_TRANS
|
NO
|
NO
|
TRANSFER_TO_INSTITUTION_DESC
|
Name of the institution the student plans to attend.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
WITHDRAWAL_REASON
|
If the student withdraws for the institution this identifies the major reason for the student withdrawal defined by institution values.
|
VARCHAR2(63)
|
SHRTTRM
|
SHRTTRM_WRSN_CODE
|
NO
|
NO
|
WITHDRAWAL_REASON_DESC
|
Reason for withdrawal description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
YEAR_ADMITTED
|
Academic year the student was admitted to this academic study.
|
VARCHAR2(63)
|
STVTERM
|
STVTERM_ACYR_CODE
|
NO
|
NO
|
YEAR_ADMITTED_DESC
|
Academic year description.
|
VARCHAR2(255)
|
STVACYR
|
STVACYR_DESC
|
NO
|
NO
|
YEAR_MATRICULATED
|
Academic year the student matriculated to this academic study.
|
VARCHAR2(63)
|
STVTERM
|
STVTERM_ACYR_CODE
|
NO
|
NO
|
YEAR_MATRICULATED_DESC
|
Academic year description.
|
VARCHAR2(255)
|
STVACYR
|
STVACYR_DESC
|
NO
|
NO
|