Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
Source Name |
Source Column |
ACADEMIC_HISTORY_EXISTS_IND
|
Academic History Exists Indicator
|
Indicates whether the student has academic history information for the academic period.
|
VARCHAR2(1)
|
|
FUNCTION
|
SOKODSF.F_CHECK_FOR_ACAD_HISTORY_DATA
|
ACADEMIC_PERIOD
|
Academic Period
|
Academic period or time frame associated with the information on the student record.
|
VARCHAR2(63)
|
|
SGBSTDN
|
SGBSTDN_TERM_CODE_EFF
|
ACADEMIC_PERIOD_ADMITTED
|
Academic Period Admitted
|
Academic period or time frame the student was admitted to this academic study
|
VARCHAR2(63)
|
|
SGBSTDN SORLCUR
|
SGBSTDN_TERM_CODE_ADMIT SORLCUR_TERM_CODE_ADMIT
|
ACADEMIC_PERIOD_ADMITTED_DESC
|
Academic Period Admitted Description
|
Academic period description.
|
VARCHAR2(255)
|
|
STVTERM
|
STVTERM_DESC
|
ACADEMIC_PERIOD_DESC
|
Academic Period Description
|
Academic period description.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
ACADEMIC_PERIOD_MATRICULATED
|
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)
|
|
SGBSTDN SORLCUR
|
SGBSTDN_TERM_CODE_MATRIC SORLCUR_TERM_CODE_MATRIC
|
ACADEMIC_PERIOD_MATRIC_DESC
|
Academic Period Matriculated Description
|
Academic period description.
|
VARCHAR2(255)
|
|
STVTERM
|
STVTERM_DESC
|
ACADEMIC_STANDING
|
Academic Standing
|
Academic standing for the student as determined at the beginning of the academic period before grades are assigned. Indicates the student may continue to enroll or must seek assistance prior to continuing to study at the institution.
|
VARCHAR2(63)
|
|
FUNCTION
|
NVL(ACADEMIC_PERIOD,MSKFUNC.F_ACADEMIC_STAND_DATA(PERSON_UID,ACADEMIC_PERIOD,PROGRAM_LEVEL,''ACADEMIC_STANDING_ACAD_PERIOD'')
|
ACADEMIC_STANDING_ACAD_PERIOD
|
Academic Standing Academic Period
|
Academic period or time frame when this academic standing code is valid for the student.
|
VARCHAR2(63)
|
|
FUNCTION
|
NVL(ACADEMIC_STANDING_DESC,MSKFUNC.F_ACADEMIC_STAND_DATA(PERSON_UID,ACADEMIC_PERIOD,PROGRAM_LEVEL,''ACADEMIC_STANDING_DESC'')
|
ACADEMIC_STANDING_DATE
|
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'')
|
ACADEMIC_STANDING_DESC
|
Academic Standing Description
|
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
|
ACADEMIC_STANDING_END
|
Academic Standing End
|
Academic standing or progress indicator for the student as 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)
|
|
SHRTTRM
|
SHRTTRM_ASTD_CODE_END_OF_TERM
|
ACADEMIC_STANDING_END_DATE
|
Academic Standing End Date
|
Date that the academic standing no longer applies to the student. This may have been 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
|
ACADEMIC_STAND_OVERRIDE
|
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 as of the academic period specified.
|
VARCHAR2(63)
|
|
SGBSTDN
|
SGBSTDN_ASTD_CODE
|
ACADEMIC_STAND_OVERRIDE_DESC
|
Academic Stand Override Description
|
Description for the academic standing override value.
|
VARCHAR2(255)
|
|
STVASTD
|
STVASTD_DESC
|
ACADEMIC_YEAR
|
Academic Year
|
Academic year associated with the academic period on this record.
|
VARCHAR2(63)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
ACADEMIC_YEAR_DESC
|
Academic Year Description
|
Academic year description.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
ACAD_STANDING_ACAD_PERIOD_DESC
|
Academic Standing Academic Period Description
|
Academic period description associated with the student academic standing.
|
VARCHAR2(255)
|
|
STVTERM
|
STVTERM_DESC
|
ACAD_STANDING_END_DESC
|
Academic Standing End Description
|
Academic standing description.
|
VARCHAR2(255)
|
|
STVASTD
|
STVASTD_DESC
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
|
NA NA
|
NA NA
|
ADMISSIONS_POPULATION
|
Admissions Population
|
Identifies an admission population such as early admit, mature, adult and continuing education, etc., associated with the person and application.
|
VARCHAR2(63)
|
|
CALCULATION SGBSTDN SGBSTDN SORLCUR
|
DECODE(SORLCUR_ADMT_CODE) SGBSTDN_ADMT_CODE SGBSTDN_ADMT_CODE_2 SORLCUR_ADMT_CODE
|
ADMISSIONS_POPULATION_DESC
|
Admissions Population Description
|
Admission population description.
|
VARCHAR2(255)
|
|
STVADMT
|
STVADMT_DESC
|
ADVISOR_COUNT
|
Advisor Count
|
Count of current active advisors assigned to the student.
|
NUMBER
|
|
FUNCTION
|
MSKFUNC.F_COUNT_ADVISORS
|
AGE_ADMITTED
|
Age Admitted
|
Calculated age of the person at the time of admission to the institution.
|
NUMBER
|
|
FUNCTION
|
SOKODSF.F_CALCULATE_AGE_ADMIT
|
AID_ENROLLMENT_PERIOD
|
Financial 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
|
AID_ENROLLMENT_PERIOD_DESC
|
Financial Aid Enrollment Period Description
|
Aid enrollment period description.
|
VARCHAR2(255)
|
|
FUNCTION
|
MRKFUNC.F_GET_AID_ENROLL_PERIOD
|
AID_YEAR
|
Financial 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
|
AID_YEAR_DESC
|
Financial Aid Year Description
|
Financial aid year name.
|
VARCHAR2(255)
|
|
FUNCTION
|
MRKFUNC.F_GET_AID_ENROLL_PERIOD
|
AWARD_CATEGORY
|
Award Category
|
Award category associated with the outcome, degree or award. Category used to group outcomes for reporting similar awards together. For example, less than two year, two year and four year awards.
|
VARCHAR2(63)
|
|
STVDEGC
|
STVDEGC_ACAT_CODE
|
AWARD_CATEGORY_DESC
|
Award Category Description
|
Award category description.
|
VARCHAR2(255)
|
|
STVACAT
|
STVACAT_DESC
|
BLOCK_SCHEDULE
|
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
|
BLOCK_SCHEDULE_DESC
|
Block Schedule Description
|
Description for the block schedule code.
|
VARCHAR2(255)
|
|
STVBLCK
|
STVBLCK_DESC
|
CAMPUS
|
Campus
|
Campus associated with the student.
|
VARCHAR2(63)
|
|
SGBSTDN SGBSTDN SORLCUR
|
SGBSTDN_CAMP_CODE SGBSTDN_CAMP_CODE_2 SORLCUR_CAMP_CODE
|
CAMPUS_DESC
|
Campus Description
|
Institution campus name.
|
VARCHAR2(255)
|
|
STVCAMP
|
STVCAMP_DESC
|
CATALOG_ACADEMIC_PERIOD
|
Catalog Academic Period
|
Catalog academic period used to measure completion requirements for the outcome.
|
VARCHAR2(63)
|
|
SGBSTDN SGBSTDN SORLCUR
|
SGBSTDN_TERM_CODE_CTLG_1 SGBSTDN_TERM_CODE_CTLG_2 SORLCUR_TERM_CODE_CTLG
|
CATALOG_ACADEMIC_PERIOD_DESC
|
Catalog Academic Period Description
|
Catalog academic period description.
|
VARCHAR2(255)
|
|
STVTERM
|
STVTERM_DESC
|
COLLEGE
|
College
|
College, faculty or school to which the academic study for the student is associated.
|
VARCHAR2(63)
|
|
SGBSTDN SGBSTDN SORLCUR
|
SGBSTDN_COLL_CODE_1 SGBSTDN_COLL_CODE_2 SORLCUR_COLL_CODE
|
COLLEGE_DESC
|
College Description
|
College, faculty or school name.
|
VARCHAR2(255)
|
|
STVCOLL
|
STVCOLL_DESC
|
COMBINED_ACAD_STANDING
|
Combined Academic 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'')
|
COMBINED_ACAD_STANDING_DATE
|
Combined Academic 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'')
|
COMBINED_ACAD_STANDING_DESC
|
Combined Academic Standing Description
|
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'')
|
COMBINED_ACAD_STAND_END
|
Combined Academic Stand End
|
Identifies a student's combined academic standing at the end of the academic period (probation, good standing, etc). This will be the value assigned when grades were processed.
|
VARCHAR2(63)
|
|
SHRTTRM
|
SHRTTRM_CAST_CODE
|
COMBINED_ACAD_STAND_END_DATE
|
Combined Academic Stand End Date
|
Date combined academic standing was calculated or entered at the end of the academic period.
|
DATE
|
|
SHRTTRM
|
SHRTTRM_CAST_DATE
|
COMBINED_ACAD_STAND_END_DESC
|
Combined Academic Stand End Description
|
Description for the combined academic standing value.
|
VARCHAR2(255)
|
|
STVCAST
|
STVCAST_DESC
|
COMB_ACAD_STAND_OVERRIDE
|
Combined Academic 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
|
COMB_ACAD_STAND_OVERRIDE_DESC
|
Combined Academic Stand Override Description
|
Description for the combined academic standing override value.
|
VARCHAR2(255)
|
|
STVCAST
|
STVCAST_DESC
|
COOPERATIVE_EDUCATION_IND
|
Cooperative Education Indicator
|
Indicates that the student has work experience data in the database.
|
VARCHAR2(1)
|
|
FUNCTION
|
MSKFUNC.F_CHECK_COOP_IND
|
CURRENT_TIME_STATUS
|
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_DATE
|
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
|
CURRENT_TIME_STATUS_DESC
|
Current Time Status Description
|
Current time status description.
|
VARCHAR2(255)
|
|
FUNCTION STVTMST
|
GOKODSF.F_GET_DESC STVTMST_DESC
|
CURRICULUM_PRIORITY_NUMBER
|
Curriculum Priority Number
|
Identifies the significanct ranking for a curricula.
|
NUMBER
|
|
SORLCUR
|
SORLCUR_PRIORITY_NO
|
DEANS_LIST_DATE
|
Deans List Date
|
Date on which the Dean's List code was recorded.
|
DATE
|
|
SHRTTRM
|
SHRTTRM_ASTD_DATE_DL
|
DEANS_LIST_DESC
|
Deans List Description
|
Student's dean's list code description.
|
VARCHAR2(255)
|
|
STVASTD
|
STVASTD_DESC
|
DEANS_LIST_VALUE
|
Deans List Value
|
Identifies whether the student qualified for the dean's list this academic period.
|
VARCHAR2(63)
|
|
SHRTTRM
|
SHRTTRM_ASTD_CODE_DL
|
DEGREE
|
Degree
|
Degree or award code associated with the academic study.
|
VARCHAR2(63)
|
|
SGBSTDN SGBSTDN SORLCUR
|
SGBSTDN_DEGC_CODE_1 SGBSTDN_DEGC_CODE_2 SORLCUR_DEGC_CODE
|
DEGREE_DESC
|
Degree Description
|
Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.
|
VARCHAR2(255)
|
|
STVDEGC
|
STVDEGC_DESC
|
DEPARTMENT
|
Department
|
Department responsible for the student's academic study.
|
VARCHAR2(63)
|
|
SGBSTDN SGBSTDN SORLFOS
|
SGBSTDN_DEPT_CODE SGBSTDN_DEPT_CODE_2 SORLFOS_DEPT_CODE
|
DEPARTMENT_DESC
|
Department Description
|
Department name.
|
VARCHAR2(255)
|
|
STVDEPT
|
STVDEPT_DESC
|
DUAL_DEGREE
|
Dual Degree
|
Identifies this as a dual degree.
|
VARCHAR2(63)
|
|
SGBSTDN
|
SGBSTDN_DEGC_CODE_DUAL
|
DUAL_DEGREE_COLLEGE
|
Dual Degree College
|
College associated with the dual degree.
|
VARCHAR2(63)
|
|
SGBSTDN
|
SGBSTDN_COLL_CODE_DUAL
|
DUAL_DEGREE_COLLEGE_DESC
|
Dual Degree College Description
|
College, faculty or school description.
|
VARCHAR2(255)
|
|
STVCOLL
|
STVCOLL_DESC
|
DUAL_DEGREE_DEPARTMENT
|
Dual Degree Department
|
Department associated with the dual degree.
|
VARCHAR2(63)
|
|
SGBSTDN
|
SGBSTDN_DEPT_CODE_DUAL
|
DUAL_DEGREE_DEPARTMENT_DESC
|
Dual Degree Department Description
|
College, faculty or school description.
|
VARCHAR2(255)
|
|
STVDEPT
|
STVDEPT_DESC
|
DUAL_DEGREE_DESC
|
Dual Degree Description
|
Dual degree description.
|
VARCHAR2(255)
|
|
STVDEGC
|
STVDEGC_DESC
|
DUAL_DEGREE_LEVEL
|
Dual Degree Level
|
Level associated with the dual degree.
|
VARCHAR2(63)
|
|
SGBSTDN
|
SGBSTDN_LEVL_CODE_DUAL
|
DUAL_DEGREE_LEVEL_DESC
|
Dual Degree Level Description
|
Student level description.
|
VARCHAR2(255)
|
|
STVLEVL
|
STVLEVL_DESC
|
DUAL_DEGREE_MAJOR
|
Dual Degree Major
|
Major associated with the dual degree.
|
VARCHAR2(63)
|
|
SGBSTDN
|
SGBSTDN_MAJR_CODE_DUAL
|
DUAL_DEGREE_MAJOR_DESC
|
Dual Degree Major Description
|
Major or subject area description.
|
VARCHAR2(255)
|
|
STVMAJR
|
STVMAJR_DESC
|
DUAL_PROGRAM_CLASSIFICATION
|
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
|
DUAL_PROGRAM_CLASSIF_DESC
|
Dual Program Classification Description
|
Program classification description.
|
VARCHAR2(255)
|
|
STVCIPC
|
STVCIPC_DESC
|
ENROLLED_IND
|
Enrolled Indicator
|
Indicates whether the student's enrollment status includes them in headcounts.
|
VARCHAR2(1)
|
|
FUNCTION
|
F_ENROLLED_THIS_TERM
|
ENROLLMENT_ADD_DATE
|
Enrollment Additional Date
|
Date of the initial enrollment and course offering registration for this academic period.
|
DATE
|
|
SFBETRM
|
SFBETRM_ADD_DATE
|
ENROLLMENT_EXISTS_IND
|
Enrollment Exists Indicator
|
Indicates whether the student has current enrollment information for the academic period.
|
VARCHAR2(1)
|
|
CALCULATION
|
DECODE(SFBETRM_PIDM, NULL, 'N', 'Y')
|
ENROLLMENT_STATUS
|
Enrollment Status
|
Student's current enrollment status for this academic period.
|
VARCHAR2(63)
|
|
SFBETRM
|
SFBETRM_ESTS_CODE
|
ENROLLMENT_STATUS_DATE
|
Enrollment Status Date
|
Date for the last update to enrollment status.
|
DATE
|
|
SFBETRM
|
SFBETRM_ESTS_DATE
|
ENROLLMENT_STATUS_DESC
|
Enrollment Status Description
|
Student's enrollment status description.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
EXPECTED_GRADUATION_DATE
|
Expected Graduation Date
|
Expected graduation date.
|
DATE
|
|
CALCULATION SGBSTDN
|
NVL(SORLCUR_EXP_GRAD_DATE, SGBSTDN_EXP_GRAD_DATE) SGBSTDN_EXP_GRAD_DATE
|
FIRST_CONCENTRATION
|
First Concentration
|
Concentration or study emphasis attached to the major for the student's academic study.
|
VARCHAR2(63)
|
|
SGBSTDN SGBSTDN SORLFOS
|
SGBSTDN_MAJR_CODE_CONC_1 SGBSTDN_MAJR_CODE_CONC_2 SORLFOS_MAJR_CODE
|
FIRST_CONCENTRATION_DESC
|
First Concentration Description
|
Concentration or study emphasis description.
|
VARCHAR2(255)
|
|
STVMAJR
|
STVMAJR_DESC
|
FIRST_MINOR
|
First Minor
|
Minor subject area of the person's academic study.
|
VARCHAR2(63)
|
|
SGBSTDN SGBSTDN SORLFOS
|
SGBSTDN_MAJR_CODE_MINR_1 SGBSTDN_MAJR_CODE_MINR_2 SORLFOS_MAJR_CODE
|
FIRST_MINOR_DESC
|
First Minor Description
|
Minor subject area description.
|
VARCHAR2(255)
|
|
STVMAJR
|
STVMAJR_DESC
|
FOURTH_DEPARTMENT
|
Fourth Department
|
Department responsible for the major or subject area of academic instruction.
|
VARCHAR2(63)
|
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
FOURTH_DEPARTMENT_DESC
|
Fourth Department Description
|
Department name.
|
VARCHAR2(255)
|
|
STVDEPT
|
STVDEPT_DESC
|
FOURTH_MAJOR
|
Fourth Major
|
Subject area or major focus recorded for the student's academic study. This may be blank.
|
VARCHAR2(63)
|
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
FOURTH_MAJOR_CONC_1
|
Fourth Major Concentration 1
|
First concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
FOURTH_MAJOR_CONC_1_DESC
|
Fourth Major Concentration 1 Description
|
Student's concentration description.
|
VARCHAR2(255)
|
|
STVMAJR
|
STVMAJR_DESC
|
FOURTH_MAJOR_CONC_2
|
Fourth Major Concentration 2
|
Second concentration or focus of study within this student's major. This may be blank when 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
|
Fourth Major Concentration 2 Description
|
Student's concentration description.
|
VARCHAR2(255)
|
|
STVMAJR
|
STVMAJR_DESC
|
FOURTH_MAJOR_CONC_3
|
Fourth Major Concentration 3
|
Third concentration or focus of study within this student's major. This may be blank when 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
|
Fourth Major Concentration 3 Description
|
Student's concentration description.
|
VARCHAR2(255)
|
|
STVMAJR
|
STVMAJR_DESC
|
FOURTH_MAJOR_DESC
|
Fourth Major Description
|
Major or subject area of study description.
|
VARCHAR2(255)
|
|
STVMAJR
|
STVMAJR_DESC
|
FOURTH_MINOR
|
Fourth Minor
|
Fourth minor for the student within this academic study. This may be blank when no minor has been specified.
|
VARCHAR2(63)
|
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
FOURTH_MINOR_DESC
|
Fourth Minor Description
|
Minor area of study description.
|
VARCHAR2(255)
|
|
STVMAJR
|
STVMAJR_DESC
|
FOURTH_PROGRAM_CLASSIFICATION
|
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
|
FOURTH_PROGRAM_CLASSIF_DESC
|
Fourth Program Classification Description
|
Program classification code description.
|
VARCHAR2(255)
|
|
STVCIPC
|
STVCIPC_DESC
|
FTE_DIVISOR
|
FTE - Full Time Equated Divisor
|
Full time equivalency divisor.
|
NUMBER
|
|
NA NA
|
NA NA
|
FTE_IND
|
FTE - Full Time Equated Indicator
|
Indicates whether the student represents at least one FTE (full-time equivalent).
|
VARCHAR2(1)
|
|
NA NA
|
NA NA
|
GRADUATED_IND
|
Graduated Indicator
|
Indicates whether the person has graduated or earned any academic outcomes to date.
|
VARCHAR2(1)
|
|
FUNCTION
|
SOKODSF.F_CHECK_FOR_GRADUATE_IND
|
GRAD_ACADEMIC_PERIOD_INTENDED
|
Graduate Academic Period Intended
|
Intended academic period of graduation for the student.
|
VARCHAR2(63)
|
|
CALCULATION SGBSTDN
|
NVL(SORLCUR_TERM_CODE_GRAD, SGBSTDN_TERM_CODE_GRAD) SGBSTDN_TERM_CODE_GRAD
|
GRAD_ACAD_PERIOD_INTENDED_DESC
|
Graduate Academic Period Intended Description
|
Intended graduation term description.
|
VARCHAR2(255)
|
|
STVTERM
|
STVTERM_DESC
|
GRAD_YEAR_INTENDED
|
Graduate Year Intended
|
Intended year of graduation.
|
VARCHAR2(63)
|
|
CALCULATION SGBSTDN
|
NVL(SORLCUR_ACYR_CODE, SGBSTDN_ACYR_CODE) SGBSTDN_ACYR_CODE
|
GRAD_YEAR_INTENDED_DESC
|
Graduate Year Intended Description
|
Academic year description.
|
VARCHAR2(255)
|
|
STVACYR
|
STVACYR_DESC
|
ID
|
ID
|
Person's or organization's current identification number.
|
VARCHAR2(63)
|
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
INTENDED_TIME_STATUS
|
Intended Time Status
|
Student's intended time status.
|
VARCHAR2(1)
|
|
SGBSTDN
|
SGBSTDN_FULL_PART_IND
|
LEAVE_DATE_FROM
|
Leave Date From
|
Date the student leave began.
|
DATE
|
|
CALCULATION SGBSTDN
|
NVL(SORLCUR_LEAV_FROM_DATE, SGBSTDN_LEAV_FROM_DATE) SGBSTDN_LEAV_FROM_DATE
|
LEAVE_DATE_TO
|
Leave Date To
|
Date the student leave is schedule to or ends.
|
DATE
|
|
CALCULATION SGBSTDN
|
NVL(SORLCUR_LEAV_TO_DATE, SGBSTDN_LEAV_TO_DATE) SGBSTDN_LEAV_TO_DATE
|
LEAVE_REASON
|
Leave Reason
|
Leave code of the student for this academic period.
|
VARCHAR2(63)
|
|
CALCULATION SGBSTDN
|
NVL(SORLCUR_LEAV_CODE, SGBSTDN_LEAV_CODE) SGBSTDN_LEAV_CODE
|
LEAVE_REASON_DESC
|
Leave Reason Description
|
Student's leave code description for this term.
|
VARCHAR2(255)
|
|
STVLEAV
|
STVLEAV_DESC
|
MAJOR
|
Major
|
Major subject area of the person's academic study.
|
VARCHAR2(63)
|
|
SGBSTDN SGBSTDN SORLFOS
|
SGBSTDN_MAJR_CODE_1 SGBSTDN_MAJR_CODE_2 SORLFOS_MAJR_CODE
|
MAJOR_DESC
|
Major Description
|
Name of the student's major subject area.
|
VARCHAR2(255)
|
|
STVMAJR
|
STVMAJR_DESC
|
MATRICULATED_IND
|
Matriculated Indicator
|
Indicates whether the student has matriculated, and was formally admitted to a degree granting academic study or program.
|
VARCHAR2(1)
|
|
CALCULATION CALCULATION
|
DECODE(SGBSTDN_TERM_CODE_MATRIC,NULL,'N','Y') DECODE(SORLCUR_TERM_CODE_MATRIC)
|
MULTI_SOURCE
|
Multi Source
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
|
NA NA
|
NA NA
|
MULTI_SOURCE_DESC
|
Multi Source Description
|
Institution description for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
|
NA NA
|
NA NA
|
NAME
|
Name
|
Name of the person (last name, first name middle initial).
|
VARCHAR2(255)
|
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NEW_STUDENT_IND
|
New Student Indicator
|
Indicates that this is the first academic period for the student and they are a new admit to the institution.
|
VARCHAR2(1)
|
|
CALCULATION CALCULATION
|
DECODE(SGBSTDN_TERM_CODE_ADMIT) DECODE(SORLCUR_TERM_CODE_ADMIT)
|
NON_TRADITIONAL_IND
|
Non Traditional Indicator
|
Indicates whether this academic study is non-traditional.
|
VARCHAR2(63)
|
|
NA NA
|
NA NA
|
OUTCOME_AWARDED_IND
|
Outcome Awarded Indicator
|
Indicates that there is an academic outcome row for this academic study and academic period.
|
VARCHAR2(63)
|
|
FUNCTION
|
MSKFUNC.F_GET_OUTCOME_AWARDED_IND
|
PERMIT_REGISTRATION
|
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
|
PERSON_UID
|
Person UID
|
System generated, unique, internal identification number assigned to the person.
|
NUMBER
|
|
SGBSTDN
|
SGBSTDN_PIDM
|
PRIMARY_ADVISOR_NAME_FMIL
|
Primary Advisor Name First, Middle Initial, Last
|
Advisor's current first name, middle name and last name.
|
VARCHAR2(255)
|
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
PRIMARY_ADVISOR_NAME_LFMI
|
Primary Advisor Name Last, First, Middle Initial
|
Advisor's current last name, first name middle initial.
|
VARCHAR2(255)
|
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
PRIMARY_ADVISOR_PERSON_UID
|
Primary Advisor Person UID
|
System generated, unique, internal identification number assigned to the person.
|
NUMBER
|
|
SGRADVR
|
SGRADVR_ADVR_PIDM
|
PRIMARY_ADVISOR_TYPE
|
Primary Advisor Type
|
Primary advisor current advising assignment type.
|
VARCHAR2(63)
|
|
SGRADVR
|
SGRADVR_ADVR_CODE
|
PRIMARY_ADVISOR_TYPE_DESC
|
Primary Advisor Type Description
|
Advisor type description.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
PRIMARY_PROGRAM_IND
|
Primary Program Indicator
|
Indicates whether this is the student's primary academic study or program.
|
VARCHAR2(1)
|
|
CALCULATION CALCULATION CONSTANT FUNCTION
|
DECODE(SGBSTDN_LEVL_CODE,NULL,'N','Y') DECODE(SORLCUR_LEVL_CODE,NULL,'N','Y') 'N' CASE PROGRAM_NUMBER WHEN 1 THEN 'Y' ELSE 'N' END
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
|
NA NA
|
NA NA
|
PROGRAM
|
Program
|
Program or course of study for the student. This may be blank when programs are not being used to manage a set of completion requirements.
|
VARCHAR2(63)
|
|
SGBSTDN SGBSTDN SORLCUR
|
SGBSTDN_PROGRAM_1 SGBSTDN_PROGRAM_2 SORLCUR_PROGRAM
|
PROGRAM_CLASSIFICATION
|
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
|
PROGRAM_CLASSIFICATION_DESC
|
Program Classification Description
|
Program classification description.
|
VARCHAR2(255)
|
|
STVCIPC
|
STVCIPC_DESC
|
PROGRAM_DESC
|
Program Description
|
Program or course of study description.
|
VARCHAR2(255)
|
|
SMRPRLE
|
SMRPRLE_PROGRAM_DESC
|
PROGRAM_NUMBER
|
Program Number
|
Unique sequence number that identifies this academic study or program for the student.
|
VARCHAR2(3)
|
|
CALCULATION CALCULATION FUNCTION
|
DECODE(SGBSTDN_LEVL_CODE,NULL,NULL,'01') DECODE(SGBSTDN_LEVL_CODE_2,NULL,NULL,'02') ROW_NUMBER() OVER (PARTITION BY SORLCUR_PIDM, SGBSTDN_TERM_CODE_EFF ORDER BY SORLCUR_PRIORITY_NO)
|
PROGRESS_EVALUATION
|
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'')
|
PROGRESS_EVALUATION_DATE
|
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'')
|
PROGRESS_EVALUATION_DESC
|
Progress Evaluation Description
|
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'')
|
PROGRESS_EVALUATION_END
|
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.
|
VARCHAR2(63)
|
|
SHRTTRM
|
SHRTTRM_PREV_CODE
|
PROGRESS_EVALUATION_END_DATE
|
Progress Evaluation End Date
|
Date progress evaluation was calculated or entered at the end of the academic period.
|
DATE
|
|
SHRTTRM
|
SHRTTRM_PREV_DATE
|
PROGRESS_EVALUATION_END_DESC
|
Progress Evaluation End Description
|
Description for the progress evaluation value.
|
VARCHAR2(255)
|
|
STVPREV
|
STVPREV_DESC
|
PROGRESS_EVAL_OVERRIDE
|
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
|
PROGRESS_EVAL_OVERRIDE_DESC
|
Progress Eval Override Description
|
Description for the progress evaluation override value.
|
VARCHAR2(255)
|
|
STVPREV
|
STVPREV_DESC
|
REGISTERED_IND
|
Registered Indicator
|
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
|
REGISTRATION_REASON
|
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
|
REGISTRATION_REASON_DESC
|
Registration Reason Description
|
Registration reason description.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
SECOND_CONCENTRATION
|
Second Concentration
|
Concentration or study emphasis attached to the major for the student's academic study.
|
VARCHAR2(63)
|
|
SGBSTDN SGBSTDN SORLFOS
|
SGBSTDN_MAJR_CODE_CONC_1_2 SGBSTDN_MAJR_CODE_CONC_2_2 SORLFOS_MAJR_CODE
|
SECOND_CONCENTRATION_DESC
|
Second Concentration Description
|
Concentration or study emphasis description.
|
VARCHAR2(255)
|
|
STVMAJR
|
STVMAJR_DESC
|
SECOND_DEPARTMENT
|
Second Department
|
Department responsible for the major or subject area of academic instruction.
|
VARCHAR2(63)
|
|
SGBSTDN SGBSTDN SORLFOS
|
SGBSTDN_DEPT_CODE_1_2 SGBSTDN_DEPT_CODE_2_2 SORLFOS_DEPT_CODE
|
SECOND_DEPARTMENT_DESC
|
Second Department Description
|
Department name.
|
VARCHAR2(255)
|
|
STVDEPT
|
STVDEPT_DESC
|
SECOND_MAJOR
|
Second Major
|
Second major or subject area for this academic study.
|
VARCHAR2(63)
|
|
SGBSTDN SGBSTDN SORLFOS
|
SGBSTDN_MAJR_CODE_1_2 SGBSTDN_MAJR_CODE_2_2 SORLFOS_MAJR_CODE
|
SECOND_MAJOR_CONC_1
|
Second Major Concentration 1
|
First concentration or focus of study within this student's major. This may be blank if concentrations are not being used, or when this major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
|
SGBSTDN SGBSTDN SORLFOS
|
SGBSTDN_MAJR_CODE_CONC_121 SGBSTDN_MAJR_CODE_CONC_221 SORLFOS_MAJR_CODE
|
SECOND_MAJOR_CONC_1_DESC
|
Second Major Concentration 1 Description
|
Student's concentration description.
|
VARCHAR2(255)
|
|
STVMAJR
|
STVMAJR_DESC
|
SECOND_MAJOR_CONC_2
|
Second Major Concentration 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)
|
|
SGBSTDN SGBSTDN SORLFOS
|
SGBSTDN_MAJR_CODE_CONC_122 SGBSTDN_MAJR_CODE_CONC_222 SORLFOS_MAJR_CODE
|
SECOND_MAJOR_CONC_2_DESC
|
Second Major Concentration 2 Description
|
Student's concentration description.
|
VARCHAR2(255)
|
|
STVMAJR
|
STVMAJR_DESC
|
SECOND_MAJOR_CONC_3
|
Second Major Concentration 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)
|
|
SGBSTDN SGBSTDN SORLFOS
|
SGBSTDN_MAJR_CODE_CONC_123 SGBSTDN_MAJR_CODE_CONC_223 SORLFOS_MAJR_CODE
|
SECOND_MAJOR_CONC_3_DESC
|
Second Major Concentration 3 Description
|
Student's concentration description.
|
VARCHAR2(255)
|
|
STVMAJR
|
STVMAJR_DESC
|
SECOND_MAJOR_DESC
|
Second Major Description
|
Major or subject area of study description.
|
VARCHAR2(255)
|
|
STVMAJR
|
STVMAJR_DESC
|
SECOND_MINOR
|
Second Minor
|
Second minor subject area of the person's academic study.
|
VARCHAR2(63)
|
|
SGBSTDN SGBSTDN SORLFOS
|
SGBSTDN_MAJR_CODE_MINR_1_2 SGBSTDN_MAJR_CODE_MINR_2_2 SORLFOS_MAJR_CODE
|
SECOND_MINOR_DESC
|
Second Minor Description
|
Minor area of study description.
|
VARCHAR2(255)
|
|
STVMAJR
|
STVMAJR_DESC
|
SECOND_PROGRAM_CLASSIFICATION
|
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
|
SECOND_PROGRAM_CLASSIF_DESC
|
Second Program Classification Description
|
Program classification code description.
|
VARCHAR2(255)
|
|
STVCIPC
|
STVCIPC_DESC
|
SITE
|
Site
|
Site or location where the student is attending or obtaining instruction.
|
VARCHAR2(63)
|
|
CALCULATION
|
NVL(SORLCUR_SITE_CODE,SGBSTDN_SITE_CODE)
|
SITE_CARRIER_ROUTE
|
Site Carrier Route
|
Carrier route associated with the site address for barcode mailings.
|
VARCHAR2(63)
|
|
FUNCTION NA
|
GOKODSF.F_GET_NULL_VARCHAR2 NA
|
SITE_CITY
|
Site City
|
City, town or municipality associated with the site address.
|
VARCHAR2(63)
|
|
STVSITE
|
STVSITE_CITY
|
SITE_CORRECTION_DIGIT
|
Site Correction Digit
|
Correction digit associated with the site address for barcode mailings.
|
VARCHAR2(63)
|
|
FUNCTION NA
|
GOKODSF.F_GET_NULL_VARCHAR2 NA
|
SITE_COUNTY_CODE
|
Site County Code
|
County associated with the site address.
|
VARCHAR2(63)
|
|
FUNCTION NA
|
GOKODSF.F_GET_NULL_VARCHAR2 NA
|
SITE_COUNTY_CODE_DESC
|
Site County Code Description
|
Descriptions of the county associated with the site address.
|
VARCHAR2(255)
|
|
FUNCTION NA
|
GOKODSF.F_GET_NULL_VARCHAR2 NA
|
SITE_DELIVERY_POINT
|
Site Delivery Point
|
Delivery point associated with the site address for barcode mailings.
|
VARCHAR2(63)
|
|
FUNCTION NA
|
GOKODSF.F_GET_NULL_VARCHAR2 NA
|
SITE_DESC
|
Site Description
|
Site or location name.
|
VARCHAR2(255)
|
|
STVSITE
|
STVSITE_DESC
|
SITE_NATION
|
Site Nation
|
Nation/country code associated with the site address.
|
VARCHAR2(63)
|
|
STVSITE
|
STVSITE_NATION_CODE
|
SITE_NATION_DESC
|
Site Nation Description
|
Description for the nation/country associated with the site address.
|
VARCHAR2(255)
|
|
STVNATN
|
STVNATN_NATION
|
SITE_POSTAL_CODE
|
Site Postal Code
|
Postal code associated with the site address.
|
VARCHAR2(63)
|
|
STVSITE
|
STVSITE_ZIPC
|
SITE_STATE_PROVINCE
|
Site State Province
|
Identifies the state or province associated with this address.
|
VARCHAR2(63)
|
|
STVSITE
|
STVSITE_STATE
|
SITE_STATE_PROVINCE_DESC
|
Site State Province Description
|
Name of the state or province.
|
VARCHAR2(255)
|
|
STVSTAT
|
STVSTAT_DESC
|
SITE_STREET_LINE1
|
Site Street Line 1
|
First line of the site address.
|
VARCHAR2(255)
|
|
STVSITE
|
STVSITE_STREET_ADDR1
|
SITE_STREET_LINE2
|
Site Street Line 2
|
Second line of the site address.
|
VARCHAR2(255)
|
|
STVSITE
|
STVSITE_STREET_ADDR2
|
SITE_STREET_LINE3
|
Site Street Line 3
|
Third line of the site address.
|
VARCHAR2(255)
|
|
STVSITE
|
STVSITE_STREET_ADDR3
|
SITE_STREET_LINE4
|
Site Street Line 4
|
Fourth line of the site address.
|
VARCHAR2(255)
|
|
NA NA
|
NA NA
|
SPECIAL_EXAM_CREDIT
|
Special Exam Credit
|
Identifies that special examination credit was granted to the student in this academic period.
|
VARCHAR2(63)
|
|
SHRTTRM
|
SHRTTRM_EXAM_CODE
|
SPECIAL_EXAM_DESC
|
Special Exam Description
|
Special examination credit description.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
START_DATE
|
Start Date
|
Date the student started studying. This is a non-term based field.
|
DATE
|
|
SORLCUR
|
SORLCUR_START_DATE
|
START_DATE_ADMITTED
|
Start Date Admitted
|
Date the student began to study courses within this academic study.
|
DATE
|
|
STVTERM
|
STVTERM_START_DATE
|
START_DATE_MATRICULATED
|
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
|
STUDENT_CLASSIFICATION
|
Student Classification
|
Identifies the student classification (i.e. year in school) after grades have been processed for this academic period. For example, first year, second year or freshman, sophomore, etc. This may be the same value as the Student Classification BOAP or when appropriate be the value to begin the next academic period.
|
VARCHAR2(63)
|
|
FUNCTION
|
F_CLASS_CALC_FNC
|
STUDENT_CLASSIFICATION_BOAP
|
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
|
Student's classification description.
|
VARCHAR2(255)
|
|
STVCLAS
|
STVCLAS_DESC
|
STUDENT_CLASS_BOAP_DESC
|
Student Class Boap Description
|
Beginning of academic period student classification.
|
VARCHAR2(255)
|
|
STVCLAS
|
STVCLAS_DESC
|
STUDENT_FTE
|
Student FTE - Full Time Equated
|
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
|
NA NA
|
STUDENT_LEVEL
|
Student Level
|
Student level associated with the coursework in the academic outcome. Examples, include undergraduate and graduate, etc.
|
VARCHAR2(63)
|
|
SGBSTDN SORLCUR
|
SGBSTDN_LEVL_CODE SORLCUR_LEVL_CODE
|
STUDENT_LEVEL_DESC
|
Student Level Description
|
Student level description.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
STUDENT_MEETING_TIME
|
Student Meeting Time
|
Student's normal attendance time. May be either day, evening, weekend, etc.
|
VARCHAR2(63)
|
|
SGBSTDN
|
SGBSTDN_SESS_CODE
|
STUDENT_MEETING_TIME_DESC
|
Student Meeting Time Description
|
Student's meeting session description.
|
VARCHAR2(255)
|
|
STVSESS
|
STVSESS_DESC
|
STUDENT_POPULATION
|
Student Population
|
Student population or type for reporting. May include populations like new freshman, transfer, continuing, etc.
|
VARCHAR2(63)
|
|
CALCULATION SGBSTDN
|
NVL(SORLCUR_STYP_CODE,SGBSTDN_STYP_CODE) SGBSTDN_STYP_CODE
|
STUDENT_POPULATION_DESC
|
Student Population Description
|
Student population or type description.
|
VARCHAR2(255)
|
|
STVSTYP
|
STVSTYP_DESC
|
STUDENT_RATE
|
Student Rate
|
Identifies any specific assessment rate to be used to determine the charges for this student.
|
VARCHAR2(63)
|
|
CALCULATION SGBSTDN
|
NVL(SORLCUR_RATE_CODE, SGBSTDN_RATE_CODE) SGBSTDN_RATE_CODE
|
STUDENT_RATE_DESC
|
Student Rate Description
|
Description for the rate code.
|
VARCHAR2(255)
|
|
STVRATE
|
STVRATE_DESC
|
STUDENT_STATUS
|
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
|
STUDENT_STATUS_DESC
|
Student Status Description
|
Student's status description.
|
VARCHAR2(255)
|
|
STVSTST
|
STVSTST_DESC
|
SUB_ACADEMIC_PERIOD
|
Sub Academic Period
|
A session, portion or part of the academic period.
|
VARCHAR2(63)
|
|
FUNCTION NA NA
|
GOKODSF.F_GET_NULL_VARCHAR2 NA NA
|
SUB_ACADEMIC_PERIOD_ADMITTED
|
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
|
NA NA
|
SUB_ACADEMIC_PERIOD_ADMIT_DESC
|
Sub Academic Period Admitted Description
|
Description of the session or part of the academic period associated with the session code.
|
VARCHAR2(255)
|
|
NA NA
|
NA NA
|
SUB_ACADEMIC_PERIOD_DESC
|
Sub Academic Period Description
|
Sub academic period description.
|
VARCHAR2(255)
|
|
FUNCTION NA NA
|
GOKODSF.F_GET_NULL_VARCHAR2 NA NA
|
SUB_ACADEMIC_PERIOD_MATRIC
|
Sub Academic Period Matriculated
|
Matriculation sub-academic period of the student.
|
VARCHAR2(63)
|
|
NA NA
|
NA NA
|
SUB_ACAD_PERIOD_MATRIC_DESC
|
Sub Academic Period Matriculated Description
|
Sub-academic period description.
|
VARCHAR2(255)
|
|
NA NA
|
NA NA
|
THIRD_CONCENTRATION
|
Third Concentration
|
Concentration or study emphasis attached to the major for the student's academic study.
|
VARCHAR2(63)
|
|
SGBSTDN SGBSTDN SORLFOS
|
SGBSTDN_MAJR_CODE_CONC_1_3 SGBSTDN_MAJR_CODE_CONC_2_3 SORLFOS_MAJR_CODE
|
THIRD_CONCENTRATION_DESC
|
Third Concentration Description
|
Concentration or study emphasis description.
|
VARCHAR2(255)
|
|
STVMAJR
|
STVMAJR_DESC
|
THIRD_DEPARTMENT
|
Third Department
|
Department responsible for the major or subject area of academic instruction.
|
VARCHAR2(63)
|
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
THIRD_DEPARTMENT_DESC
|
Third Department Description
|
Department name.
|
VARCHAR2(255)
|
|
STVDEPT
|
STVDEPT_DESC
|
THIRD_MAJOR
|
Third Major
|
Subject area or major focus recorded for the student's academic study. This may be blank.
|
VARCHAR2(63)
|
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
THIRD_MAJOR_CONC_1
|
Third Major Concentration 1
|
First concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
THIRD_MAJOR_CONC_1_DESC
|
Third Major Concentration 1 Description
|
Student's concentration description.
|
VARCHAR2(255)
|
|
STVMAJR
|
STVMAJR_DESC
|
THIRD_MAJOR_CONC_2
|
Third Major Concentration 2
|
Second concentration or focus of study within this student's major. This may be blank when 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
|
Third Major Concentration 2 Description
|
Student's concentration description.
|
VARCHAR2(255)
|
|
STVMAJR
|
STVMAJR_DESC
|
THIRD_MAJOR_CONC_3
|
Third Major Concentration 3
|
Third concentration or focus of study within this student's major. This may be blank when 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
|
Third Major Concentration 3 Description
|
Student's concentration description.
|
VARCHAR2(255)
|
|
STVMAJR
|
STVMAJR_DESC
|
THIRD_MAJOR_DESC
|
Third Major Description
|
Major or subject area of study description.
|
VARCHAR2(255)
|
|
STVMAJR
|
STVMAJR_DESC
|
THIRD_MINOR
|
Third Minor
|
Third minor for the student within this academic study. This may be blank when no minor has been specified.
|
VARCHAR2(63)
|
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
THIRD_MINOR_DESC
|
Third Minor Description
|
Minor area of study description.
|
VARCHAR2(255)
|
|
STVMAJR
|
STVMAJR_DESC
|
THIRD_PROGRAM_CLASSIFICATION
|
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
|
THIRD_PROGRAM_CLASSIF_DESC
|
Third Program Classification Description
|
Program classification code description.
|
VARCHAR2(255)
|
|
STVCIPC
|
STVCIPC_DESC
|
TRANSFER_CENTER
|
Transfer Center
|
Informational data defined by the institution to identify a transfer center.
|
VARCHAR2(63)
|
|
SGBSTDN
|
SGBSTDN_TRCN_CODE
|
TRANSFER_CENTER_DESC
|
Transfer Center Description
|
Transfer center description.
|
VARCHAR2(255)
|
|
STVTRCN
|
STVTRCN_DESC
|
TRANSFER_TO_INSTITUTION
|
Transfer To Institution
|
Institution to which the student will transfer from this institution.
|
VARCHAR2(63)
|
|
SHRTTRM
|
SHRTTRM_SBGI_CODE_TRANS
|
TRANSFER_TO_INSTITUTION_DESC
|
Transfer To Institution Description
|
Name of the institution the student plans to attend.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
WITHDRAWAL_REASON
|
Withdrawal Reason
|
Reason for the student's withdrawal from this institution. Accepted elsewhere, financial difficulty, etc.
|
VARCHAR2(63)
|
|
SHRTTRM
|
SHRTTRM_WRSN_CODE
|
WITHDRAWAL_REASON_DESC
|
Withdrawal Reason Description
|
Reason for withdrawal description.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
YEAR_ADMITTED
|
Year Admitted
|
Academic year the student was admitted to this academic study.
|
VARCHAR2(63)
|
|
STVTERM
|
STVTERM_ACYR_CODE
|
YEAR_ADMITTED_DESC
|
Year Admitted Description
|
Academic year description.
|
VARCHAR2(255)
|
|
STVACYR
|
STVACYR_DESC
|
YEAR_MATRICULATED
|
Year Matriculated
|
Academic year the student matriculated to this academic study.
|
VARCHAR2(63)
|
|
STVTERM
|
STVTERM_ACYR_CODE
|
YEAR_MATRICULATED_DESC
|
Year Matriculated Description
|
Academic year description.
|
VARCHAR2(255)
|
|
STVACYR
|
STVACYR_DESC
|