| Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
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)
|
SHRDGMR
|
SHRDGMR_TERM_CODE_STUREC
|
|
ACADEMIC_PERIOD_DESC
|
Academic Period Description
|
Academic period description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
ACADEMIC_PERIOD_GRADUATION
|
Academic Period Graduation
|
Academic period when graduation requirements were or will be completed.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_TERM_CODE_GRAD
|
|
ACADEMIC_PERIOD_GRAD_DESC
|
Academic Period Graduate Description
|
Academic period description.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_DESC
|
|
ACADEMIC_YEAR_GRADUATION
|
Year of Graduation
|
Year associated with this graduation date.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_ACYR_CODE
|
|
ACADEMIC_YEAR_GRADUATION_DESC
|
Year Graduation Description
|
Graduation year description.
|
VARCHAR2(255)
|
STVACYR
|
STVACYR_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
|
|
APPLIED_FOR_OUTCOME_IND
|
Applied For Outcome Indicator
|
Indicates whether the person has applied to officially receive this specific degree or award as an academic outcome.
|
VARCHAR2(1)
|
FUNCTION
|
F_APPLIED_FOR_DEGREE
|
|
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
|
|
BULLETIN_YEAR
|
Bulletin Year
|
Academic year associated with the documented requirements to be completed for this academic outcome to be confirmed.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_ACYR_CODE_BULLETIN
|
|
BULLETIN_YEAR_DESC
|
Bulletin Year Description
|
Academic year description.
|
VARCHAR2(255)
|
STVACYR
|
STVACYR_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
|
|
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
|
|
CREDITS_ATTEMPTED
|
Credits Attempted
|
Sum of credits attempted by a student for this academic outcome.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
|
CREDITS_EARNED
|
Credits Earned
|
Credits earned as defined by the grading rules of the institution. This number must be calculated by the system after the final grade is recorded for the student.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
|
CREDITS_PASSED
|
Credits Passed
|
Sum of credits passed by a student for this academic outcome.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
|
CURRICULUM_ORDER
|
Curriculum Order
|
Unique sequence number that identifies this academic study or program for the student.
|
NUMBER
|
CALCULATION
|
ROW_NUMBER
|
|
CURRICULUM_PRIORITY_NUMBER
|
Curriculum Priority Number
|
Identifies the significanct ranking for a curricula.
|
NUMBER
|
SORLCUR
|
SORLCUR_PRIORITY_NO
|
|
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
|
|
DEPARTMENTAL_HONORS_COUNT
|
Departmental Honors Count
|
Count of all honors recorded for the student. Indicates the honor was approved by the department.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_HONORS
|
|
DEPARTMENT_DESC
|
Department Description
|
Department name.
|
VARCHAR2(255)
|
STVDEPT
|
STVDEPT_DESC
|
|
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 of study description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
|
FOURTH_DEPARTMENT
|
Fourth Department
|
Department responsible for this major 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 concentration 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 concentration 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 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 academic outcome. This may be Classification of Institutional Program (CIP) codes used for reporting outcomes 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
|
|
GPA
|
Grade Point Average or Average
|
Calculated grade point average or average for the set of courses completed.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
|
GPA_CREDITS
|
Credits for GPA or Average calculation
|
Credits used to calculate the average or grade point average for the courses used to complete the outcome requirements.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
|
GRADUATED_IND
|
Graduated Indicator
|
Indicates whether the person has earned this degree or other award from the institution.
|
VARCHAR2(1)
|
FUNCTION
|
DECODE(STVDEGS_AWARD_STATUS_IND,'A','Y','N')
|
|
GRADUATION_STATUS
|
Graduation Status
|
Identifies that an academic outcome is completed or still being sought, etc.
|
VARCHAR2(3)
|
SHRDGMR
|
SHRDGMR_GRST_CODE
|
|
GRADUATION_STATUS_DESC
|
Graduation Status Description
|
Current graduation status description.
|
VARCHAR2(255)
|
STVGRST
|
STVGRST_DESC
|
|
GRAD_AUTHORIZED_ADDS_CHGS
|
Graduate Authorized Additonal Charges
|
Identifies that the student is authorized to add or drop based on graduation requirements.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_AUTHORIZED
|
|
GRAD_REQ_COMPLETED_ACAD_PER
|
Graduate Req Completed Acad Period
|
Academic period when all graduation requirements were completed or will be completed.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_TERM_CODE_COMPLETED
|
|
GRAD_REQ_COMP_ACAD_PER_DESC
|
Graduate Req Comp Acad Period Description
|
Academic period description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
HONORS_COUNT
|
Honors Count
|
Count of all honors recorded for the student.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_HONORS
|
|
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
|
|
INSTITUTIONAL_HONORS_COUNT
|
Institutional Honors Count
|
Count of all honors recorded for the student. Indicate that the honor was approved at the institution level, including honors such as Cum Laude, Summa Cum Laude, First Class, etc.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_HONORS
|
|
INSTITUTION_CREDITS_ATTEMPTED
|
Institution Credits Attempted
|
Sum of institution course credits attempted by a student.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
|
INSTITUTION_CREDITS_EARNED
|
Institution Credits Earned
|
Sum of institution course credits earned by a student.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
|
INSTITUTION_CREDITS_PASSED
|
Institution Credits Passed
|
Sum of institution course credits passed by a student for this academic outcome.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
|
INSTITUTION_GPA
|
Institution GPA - Grade Point Average or Average
|
Calculated of institution course grade point average or average for the set of courses completed.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
|
INSTITUTION_GPA_CREDITS
|
Institution GPA - Grade Point Average or Average Credits
|
Sum of institution course credits used in the GPA calculations for this student.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
|
INSTITUTION_QUALITY_POINTS
|
Institution Quality Points
|
Sum of institution course quality points used in the GPA calculations for this student.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
|
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
|
|
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 student (Last name, First name Middle Initial format).
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
OFFICIAL_DOCUMENT_NAME
|
Official Name on Award
|
Name of the person as it appears on the outcome document.
|
VARCHAR2(500)
|
SHBDIPL
|
SHBDIPL_NAME
|
|
OUTCOME_APPLICATION_DATE
|
Outcome Application Date
|
Date that the student applied for graduation in this academic outcome.
|
DATE
|
SHRDGMR
|
SHRDGMR_APPL_DATE
|
|
OUTCOME_AWARDED_IND
|
Outcome Awarded Indicator
|
Identifies whether the academic outcome, award or degree has been officially awarded to the person.
|
VARCHAR2(1)
|
STVDEGS
|
STVDEGS_AWARD_STATUS_IND
|
|
OUTCOME_GRADUATION_DATE
|
Outcome Graduation Date
|
Date for the formal graduation for this academic outcome. This is the date that the completion of this degree or award is confirmed.
|
DATE
|
SHRDGMR
|
SHRDGMR_GRAD_DATE
|
|
OUTCOME_NUMBER
|
Outcome Number
|
Degree or award sequence number for this academic outcome for the student.
|
NUMBER
|
NA SHRDGMR
|
SOKODSF.F_COUNT_COMPLETED_OUTCOMES SHRDGMR_SEQ_NO
|
|
PERSON_UID
|
Person UID
|
System generated, unique, internal identification number assigned to the person.
|
NUMBER
|
SHRDGMR
|
SHRDGMR_PIDM
|
|
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
|
|
QUALITY_POINTS
|
Quality Points
|
Quality points used to calculate the grade point average for this academic outcome.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
|
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 second 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 when 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 when 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 when 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 for the student within this academic study. This may be blank when no minor has been specified.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
SECOND_MINOR_DESC
|
Second Minor Description
|
Minor subject 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 Program (CIP) codes used for reporting outcomes 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
|
|
STATUS
|
Status
|
Current status of the academic outcome. For example, pending, awarded, etc.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_DEGS_CODE
|
|
STATUS_DESC
|
Status Description
|
Outcome or award status description.
|
VARCHAR2(255)
|
STVDEGS
|
STVDEGS_DESC
|
|
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)
|
STVLEVL
|
STVLEVL_DESC
|
|
SUB_ACADEMIC_PERIOD_GRADUATION
|
Sub Academic Period Graduation
|
Graduation sub academic period or portion of the academic period when recorded for the student's completion.
|
VARCHAR2(63)
|
NA
|
NA
|
|
SUB_ACADEMIC_PERIOD_GRAD_DESC
|
Sub Academic Period Graduate 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 concentration 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
|
Third concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
THIRD_MAJOR_CONC_3_DESC
|
Third Major Concentration 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 academic outcome. This may be the classification of Institutional Program (CIP) codes used for reporting outcomes 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_CREDITS_ATTEMPTED
|
Transfer Credits Attempted
|
Sum of transfer course credits attempted by a student.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
|
TRANSFER_CREDITS_EARNED
|
Transfer Credits Earned
|
Sum of transfer course credits earned by a student.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
|
TRANSFER_CREDITS_PASSED
|
Transfer Credits Passed
|
Sum of transfer course credits passed by a student for this academic outcome.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
|
TRANSFER_GPA
|
Transfer GPA - Grade Point Average or Average
|
Calculated of transfer course grade point average or average for the set of courses completed.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
|
TRANSFER_GPA_CREDITS
|
Transfer GPA - Grade Point Average or Average Credits
|
Sum of transfer course credits used in the GPA calculations for this student.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
|
TRANSFER_QUALITY_POINTS
|
Transfer Quality Points
|
Sum of transfer course quality points used in the GPA calculations for this student.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
|
TRANSFER_WORK_EXISTS_IND
|
Transfer Work Exists Indicator
|
Indicates whether any transfer credits are recorded for the student that apply to this academic outcome.
|
VARCHAR2(1)
|
FUNCTION
|
F_CHECK_FOR_TRANSFER_WORK
|