Target Column	Business Name	Business Definition	Database Data Type	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	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
ACADEMIC_PERIOD_ADMITTED	Academic Period Admitted	Academic period or time frame the student was admitted to this academic study.	VARCHAR2(63)	SORLCUR	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)	SORLCUR	SORLCUR_TERM_CODE_MATRIC
ACADEMIC_PERIOD_MATRIC_DESC	Academic Period Matric 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. 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'')
ACADEMIC_STANDING_ACAD_PERIOD	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'')
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 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
ACADEMIC_STANDING_END_DATE	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
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 will be the begin academic period academic standing.	VARCHAR2(63)	SGBSTDN	SGBSTDN_ASTD_CODE
ACADEMIC_STAND_OVERRIDE_DESC	Academic Stand Override Description	Description for the academic standing override.	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	Acad Standing Acad Period Description	Academic period description associated with the student academic standing.	VARCHAR2(255)	STVTERM	STVTERM_DESC
ACAD_STANDING_END_DESC	Acad Standing End Description	Academic standing description.	VARCHAR2(255)	STVASTD	STVASTD_DESC
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	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)	SORLCUR	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	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	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 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	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)	SORLCUR	SORLCUR_TERM_CODE_CTLG
CATALOG_ACADEMIC_PERIOD_DESC	Catalog Academic Period Description	Catalog academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC
COLLEGE	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 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).	VARCHAR2(63)	SHRTTRM	SHRTTRM_CAST_CODE
COMBINED_ACAD_STAND_END_DATE	Combined Academic Stand End Date	Date combined academic standing 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 this is a cooperative education course.	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)	STVTMST	STVTMST_DESC
CURRICULUM_PRIORITY_NUMBER	Curriculum Priority Number	Identifies the significant 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	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 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 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 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 Classif Description	Program classification description.	VARCHAR2(255)	STVCIPC	STVCIPC_DESC
ENROLLED_IND	Enrolled Indicator	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
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	NVL(SORLCUR_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)	SORLFOS	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)	SORLFOS	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
FTE_IND	FTE - Full Time Equated Indicator	Indicates whether the student represents at least one FTE (full-time equivalent).	VARCHAR2(1)	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	NVL(SORLCUR_TERM_CODE_GRAD, SGBSTDN_TERM_CODE_GRAD)
GRAD_ACAD_PERIOD_INTENDED_DESC	Graduate Acad 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	NVL(SORLCUR_ACYR_CODE, SGBSTDN_ACYR_CODE)
GRAD_YEAR_INTENDED_DESC	Graduate Year Intended Description	Academic year description.	VARCHAR2(255)	STVACYR	STVACYR_DESC
ID	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
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	NVL(SORLCUR_LEAV_FROM_DATE, SGBSTDN_LEAV_FROM_DATE)
LEAVE_DATE_TO	Leave Date To	Date the student leave is schedule to or ends.	DATE	CALCULATION	NVL(SORLCUR_LEAV_TO_DATE, SGBSTDN_LEAV_TO_DATE)
LEAVE_REASON	Leave Reason	Leave code of the student for this academic period.	VARCHAR2(63)	CALCULATION	NVL(SORLCUR_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)	SORLFOS	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	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
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
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	DECODE(SORLCUR_TERM_CODE_ADMIT)
NON_TRADITIONAL_IND	Non Traditional Indicator	Indicates whether this academic study is non-traditional.	VARCHAR2(63)	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)	FUNCTION	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
PROGRAM	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	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_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)	FUNCTION	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 for the academic period.	VARCHAR2(63)	SHRTTRM	SHRTTRM_PREV_CODE
PROGRESS_EVALUATION_END_DATE	Progress Evaluation End Date	Date progress evaluation was overridden 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)	SORLFOS	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)	SORLFOS	SORLFOS_DEPT_CODE
SECOND_DEPARTMENT_DESC	Second Department Description	Department name.	VARCHAR2(255)	STVDEPT	STVDEPT_DESC
SECOND_MAJOR	Second Major	Major subject area of the person's academic study.	VARCHAR2(63)	SORLFOS	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)	SORLFOS	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)	SORLFOS	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)	SORLFOS	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)	SORLFOS	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 Classif 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)	NA	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)	NA	NA
SITE_COUNTY_CODE	Site County Code	County associated with the site address.	VARCHAR2(63)	NA	NA
SITE_COUNTY_CODE_DESC	Site County Code Description	Descriptions of the county associated with the site address.	VARCHAR2(255)	NA	NA
SITE_DELIVERY_POINT	Site Delivery Point	Delivery point associated with the site address for barcode mailings.	VARCHAR2(63)	NA	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 Line1	First line of the site address.	VARCHAR2(255)	STVSITE	STVSITE_STREET_ADDR1
SITE_STREET_LINE2	Site Street Line2	Second line of the site address.	VARCHAR2(255)	STVSITE	STVSITE_STREET_ADDR2
SITE_STREET_LINE3	Site Street Line3	Third line of the site address.	VARCHAR2(255)	STVSITE	STVSITE_STREET_ADDR3
SITE_STREET_LINE4	Site Street Line4	Fourth line of the site address.	VARCHAR2(255)	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'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	Student Classification - Beginning of Academic Period	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 Classification - Beginning of Academic Period 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
STUDENT_LEVEL	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	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	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)
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	NVL(SORLCUR_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)	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
SUB_ACADEMIC_PERIOD_ADMIT_DESC	Sub Academic Period Admit Description	Description of the session or part of the academic period associated with the session code.	VARCHAR2(255)	NA	NA
SUB_ACADEMIC_PERIOD_DESC	Sub Academic Period Description	Sub academic period description.	VARCHAR2(255)	NA	NA
SUB_ACADEMIC_PERIOD_MATRIC	Sub Academic Period Matric	Matriculation sub-academic period of the student.	VARCHAR2(63)	NA	NA
SUB_ACAD_PERIOD_MATRIC_DESC	Sub Acad Period Matric Description	Sub-academic period description.	VARCHAR2(255)	NA	NA
THIRD_CONCENTRATION	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	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 3 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	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
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

Ver: 9.2