Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
ACADEMIC_PERIOD_GRADUATION
|
Academic Period Graduation
|
Academic period when graduation requirements were completed.
|
VARCHAR2(63)
|
SORDEGR
|
SORDEGR_TERM_DEGREE
|
ACADEMIC_PERIOD_GRAD_DESC
|
Academic Period Graduate Description
|
Academic period description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
ACADEMIC_YEAR_GRADUATION
|
Academic Year Graduation
|
Academic year associated with this graduation date.
|
VARCHAR2(63)
|
SORDEGR
|
SORDEGR_DEGC_YEAR
|
ACADEMIC_YEAR_GRADUATION_DESC
|
Academic Year Graduation Description
|
Academic year description.
|
VARCHAR2(255)
|
SORDEGR
|
SORDEGR_DEGC_YEAR
|
ADDITIONAL_MAJORS_IND
|
Additional Majors Indicator
|
Indicates whether there are additional majors or subject areas for this academic outcome.
|
VARCHAR2(63)
|
FUNCTION
|
DECODE(SOKODSF.F_GET_SORMAJR_DATA)
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
ATTEND_FROM_DATE
|
Attend From Date
|
Previous education first date of attendance.
|
DATE
|
SHRTRAM SORDEGR
|
SHRTRAM_ATTN_BEGIN_DATE SORDEGR_ATTEND_FROM
|
ATTEND_TO_DATE
|
Attend To Date
|
Previous education last date of attendance.
|
DATE
|
SHRTRAM SORDEGR
|
SHRTRAM_ATTN_END_DATE SORDEGR_ATTEND_TO
|
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)
|
FUNCTION
|
GOKODSF.F_GET_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)
|
SORDEGR
|
SORDEGR_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
|
Sum of credits earned by a student for this academic outcome.
|
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
|
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)
|
SHRTRAM SORDEGR
|
SHRTRAM_DEGC_CODE SORDEGR_DEGC_CODE
|
DEGREE_COMMENT
|
Degree Comment
|
Free form text comments about this degree.
|
VARCHAR2(2000)
|
APRADEG
|
APRADEG_COMMENTS
|
DEGREE_DATE
|
Degree Date
|
Date the degree was awarded to the person.
|
DATE
|
SORDEGR
|
SORDEGR_DEGC_DATE
|
DEGREE_DESC
|
Degree Description
|
Description (for example, bachelor of business administration, master of arts, juris doctor, etc.) associated with the degree code.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_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
|
DEPARTMENT_HONORS_COUNT
|
Department Honors Count
|
Count of all honors recorded for the student. Indicates the honor was approved by the department.
|
NUMBER
|
CALCULATION FUNCTION
|
DECODE(APRADEG_HOND_CODE_1) MSKFUNC.F_COUNT_HONORS
|
FIRST_CONCENTRATION
|
First Concentration
|
First concentration or focus of study within this student's major. This may be blank when concentrations are not being used, or when the major does not have a concentration.
|
VARCHAR2(63)
|
FUNCTION
|
SOKODSF.F_GET_SORCONC_DATA
|
FIRST_CONCENTRATION_DESC
|
First Concentration Description
|
Description of the first concentration on the major.
|
VARCHAR2(255)
|
FUNCTION
|
SOKODSF.F_GET_SORCONC_DATA
|
FIRST_MINOR
|
First Minor
|
Minor for the student within the academic study. This may be blank if no minor was specified.
|
VARCHAR2(63)
|
FUNCTION
|
SOKODSF.F_GET_SORMINR_DATA
|
FIRST_MINOR_DESC
|
First Minor Description
|
First minor description.
|
VARCHAR2(255)
|
FUNCTION
|
SOKODSF.F_GET_SORMINR_DATA
|
GPA
|
Average or Grade Point Average
|
Grade point average or average calculated for this academic outcome.
|
VARCHAR2(63)
|
SORDEGR
|
SORDEGR_GPA_TRANSFERRED
|
GPA_CREDITS
|
Credits used in Grade Point Average or Average
|
Sum of credits used in the GPA calculation for this student for this academic outcome.
|
NUMBER
|
SORDEGR
|
SORDEGR_HOURS_TRANSFERRED
|
HONORS_COUNT
|
Honors Count
|
Count of all honors recorded for the student.
|
NUMBER
|
FUNCTION
|
DECODE(SORDEGR_HONR_CODE, NULL, 0, 1),
|
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
|
INSTITUTION
|
Institution
|
Institution at which the constituent earned the degree.
|
VARCHAR2(63)
|
SHRTRIT SORDEGR SORPCOL
|
SHRTRIT_SBGI_CODE SORDEGR_SBGI_CODE SORPCOL_SBGI_CODE
|
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
|
CALCULATION FUNCTION
|
DECODE(APRADEG_HONR_CODE) 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_DESC
|
Institution Description
|
Name of the Institution.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
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
|
INSTITUTION_TYPE
|
Institution Type
|
Identifies a type for the source/background institution to be used for reporting.
|
VARCHAR2(1)
|
STVSBGI
|
STVSBGI_TYPE_IND
|
INSTITUTION_TYPE_DESC
|
Institution Type Description
|
Type of institution description.
|
VARCHAR2(255)
|
CONSTANT
|
COLLEGE
|
INTERNAL_ACADEMIC_OUTCOME_IND
|
Internal Academic Outcome Indicator
|
Indicates whether the award, degree, academic outcome was completed at a different institution as identified by the institution noted for this record. This will be set to Y when the award is from this institution and to an N when this is an external award.
|
VARCHAR2(1)
|
CONSTANT
|
N
|
MAJOR
|
Major
|
Major subject area of the person's academic study.
|
VARCHAR2(63)
|
FUNCTION
|
SOKODSF.F_GET_SORMAJR_DATA
|
MAJOR_DESC
|
Major Description
|
Name of the student's major subject area.
|
VARCHAR2(255)
|
FUNCTION
|
SOKODSF.F_GET_SORMAJR_DATA
|
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
|
Person's name combining the last name, first name middle initial.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
OFFICIAL_DOCUMENT_NAME
|
Official Document Name
|
Name of the person as it appears on the outcome document.
|
VARCHAR2(500)
|
SHBDIPL
|
SHBDIPL_NAME
|
OUTCOME_GRADUATION_DATE
|
Outcome Graduation Date
|
Date for the formal completion or graduation in this academic outcome.
|
DATE
|
SORDEGR
|
SORDEGR_DEGC_DATE
|
OUTCOME_NUMBER
|
Outcome Number
|
Degree or award sequence number for this academic outcome for the student.
|
NUMBER
|
SHRTRAM SORDEGR
|
SHRTRAM_SEQ_NO SORDEGR_DEGR_SEQ_NO
|
PERSON_UID
|
Person UID
|
System generated, unique, internal identification number assigned to the person.
|
NUMBER
|
SHRTRIT SORDEGR SORPCOL
|
SHRTRIT_PIDM SORDEGR_PIDM SORPCOL_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)
|
FUNCTION
|
SOKODSF.F_GET_SORMAJR_DATA
|
PROGRAM_CLASSIFICATION_DESC
|
Program Classification Description
|
Program classification description.
|
VARCHAR2(255)
|
FUNCTION
|
SOKODSF.F_GET_SORMAJR_DATA
|
PROGRAM_DESC
|
Program Description
|
Program or course of study description.
|
VARCHAR2(255)
|
SMRPRLE
|
SMRPRLE_PROGRAM_DESC
|
QUALITY_POINTS
|
Quality Points
|
Sum of the quality points used to calculate the grade point average for this outcome.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
SECOND_CONCENTRATION
|
Second Concentration
|
Second concentration or focus of study within the student's major. This may be blank when concentrations are not being used, or if the major does not have a concentration.
|
VARCHAR2(63)
|
FUNCTION
|
SOKODSF.F_GET_SORCONC_DATA
|
SECOND_CONCENTRATION_DESC
|
Second Concentration Description
|
Student's concentration description.
|
VARCHAR2(255)
|
FUNCTION
|
SOKODSF.F_GET_SORCONC_DATA
|
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)
|
FUNCTION
|
SOKODSF.F_GET_SORMAJR_DATA
|
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 if the major does not have a concentration.
|
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 if the major does not have a concentration.
|
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 the student's major. This may be blank if concentrations are not being used, or if the major does not have a concentration.
|
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
|
Name of the student's major subject area.
|
VARCHAR2(255)
|
FUNCTION
|
SOKODSF.F_GET_SORMAJR_DATA
|
SECOND_MINOR
|
Second Minor
|
Second minor for the student within this academic study. This may be blank if no minor was specified.
|
VARCHAR2(63)
|
FUNCTION
|
SOKODSF.F_GET_SORMINR_DATA
|
SECOND_MINOR_DESC
|
Second Minor Description
|
Minor area of study description.
|
VARCHAR2(255)
|
FUNCTION
|
SOKODSF.F_GET_SORMINR_DATA
|
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 outcomes to the federal government.
|
VARCHAR2(63)
|
FUNCTION
|
SOKODSF.F_GET_SORMAJR_DATA
|
SECOND_PROGRAM_CLASSIF_DESC
|
Second Program Classif Description
|
Program classification description.
|
VARCHAR2(255)
|
FUNCTION
|
SOKODSF.F_GET_SORMAJR_DATA
|
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_GRAD
|
Sub Academic Period Graduate
|
Graduation date within this sub academic period.
|
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
|
Third concentration or focus of study within the student's major. This may be blank if concentrations are not being used, or if the major does not have a concentration.
|
VARCHAR2(63)
|
FUNCTION
|
SOKODSF.F_GET_SORCONC_DATA
|
THIRD_CONCENTRATION_DESC
|
Third Concentration Description
|
Student's concentration description.
|
VARCHAR2(255)
|
FUNCTION
|
SOKODSF.F_GET_SORCONC_DATA
|
THIRD_MAJOR
|
Third Major
|
Third subject area or major focus recorded for the student's curriculum. This may not be blank.
|
VARCHAR2(63)
|
FUNCTION
|
SOKODSF.F_GET_SORMAJR_DATA
|
THIRD_MAJOR_DESC
|
Third Major Description
|
Name of the student's major subject area.
|
VARCHAR2(255)
|
FUNCTION
|
SOKODSF.F_GET_SORMAJR_DATA
|
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 Program (CIP) codes used for reporting outcomes to the federal government.
|
VARCHAR2(63)
|
FUNCTION
|
SOKODSF.F_GET_SORMAJR_DATA
|
THIRD_PROGRAM_CLASSIF_DESC
|
Third Program Classif Description
|
Program classification description.
|
VARCHAR2(255)
|
FUNCTION
|
SOKODSF.F_GET_SORMAJR_DATA
|
TOTAL_TRANSFER_CREDITS
|
Total Transfer Credits
|
Number of transfer credits received from the previous post secondary institution.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_CALC_TRANSFER_CREDITS
|
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)
|
CALCULATION
|
DECODE(SORDEGR_SBGI_CODE)
|