Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
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
|
NO
|
NO
|
ACADEMIC_PERIOD_DESC
|
Academic period description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
ACADEMIC_PERIOD_GRADUATION
|
Academic period when graduation requirements were or will be completed.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_TERM_CODE_GRAD
|
NO
|
NO
|
ACADEMIC_PERIOD_GRAD_DESC
|
Academic period description.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_DESC
|
NO
|
NO
|
ACADEMIC_YEAR_GRADUATION
|
Year associated with this graduation date.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_ACYR_CODE
|
NO
|
NO
|
ACADEMIC_YEAR_GRADUATION_DESC
|
Graduation year description.
|
VARCHAR2(255)
|
STVACYR
|
STVACYR_DESC
|
NO
|
NO
|
ADMINISTRATIVE_GROUP
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
APPLIED_FOR_OUTCOME_IND
|
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
|
NO
|
NO
|
AWARD_CATEGORY
|
Government reporting category that groups awards and degrees together to count students. For example, Less than 2 yr, 2 yr, Bachelor, etc.
|
VARCHAR2(63)
|
STVDEGC
|
STVDEGC_ACAT_CODE
|
NO
|
NO
|
AWARD_CATEGORY_DESC
|
Award category description.
|
VARCHAR2(255)
|
STVACAT
|
STVACAT_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
BULLETIN_YEAR_DESC
|
Academic year description.
|
VARCHAR2(255)
|
STVACYR
|
STVACYR_DESC
|
NO
|
NO
|
CAMPUS
|
Campus associated with this record. Campus for the course section, student course, student, applied for on the admission application, etc.
|
VARCHAR2(63)
|
SORLCUR
|
SORLCUR_CAMP_CODE
|
NO
|
NO
|
CAMPUS_DESC
|
Institution campus name.
|
VARCHAR2(255)
|
STVCAMP
|
STVCAMP_DESC
|
NO
|
NO
|
COLLEGE
|
First level of the institution organization structure that owns the student or the academic instruction for a student course.
|
VARCHAR2(63)
|
SORLCUR
|
SORLCUR_COLL_CODE
|
NO
|
NO
|
COLLEGE_DESC
|
College, faculty or school name.
|
VARCHAR2(255)
|
STVCOLL
|
STVCOLL_DESC
|
NO
|
NO
|
CREDITS_ATTEMPTED
|
Sum of credits attempted by a student for this academic outcome.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
NO
|
NO
|
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
|
NO
|
NO
|
CREDITS_PASSED
|
Sum of credits passed by a student for this academic outcome.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
NO
|
NO
|
CURRICULUM_ORDER
|
Unique sequence number that identifies this academic study or program for the student.
|
NUMBER
|
CALCULATION
|
ROW_NUMBER
|
NO
|
NO
|
CURRICULUM_PRIORITY_NUMBER
|
Identifies the significanct ranking for a curricula.
|
NUMBER
|
SORLCUR
|
SORLCUR_PRIORITY_NO
|
NO
|
NO
|
DEGREE
|
Award, degree, diploma, certification upon completion of all the requirements for a particular academic study. For example, Bachelor of Science, Associate of Arts, Vocational Certificate. This information will be taken from the ODS Academic Study or Academic Outcome or Admissions Application reporting view as appropriate for the star scheme.
|
VARCHAR2(63)
|
SORLCUR
|
SORLCUR_DEGC_CODE
|
NO
|
NO
|
DEGREE_DESC
|
Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.
|
VARCHAR2(255)
|
STVDEGC
|
STVDEGC_DESC
|
NO
|
NO
|
DEPARTMENT
|
Department responsible for the major subject area of a student course or associated with the major within the student academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
NO
|
NO
|
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
|
NO
|
NO
|
DEPARTMENT_DESC
|
Department name.
|
VARCHAR2(255)
|
STVDEPT
|
STVDEPT_DESC
|
NO
|
NO
|
FIRST_CONCENTRATION
|
Concentration or study emphasis attached to the major for the student's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
FIRST_CONCENTRATION_DESC
|
Concentration or study emphasis description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
FIRST_MINOR
|
Minor subject area of the person's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
FIRST_MINOR_DESC
|
Minor subject area of study description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
FOURTH_DEPARTMENT
|
Department responsible for this major subject area of academic instruction.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
NO
|
NO
|
FOURTH_DEPARTMENT_DESC
|
Department name.
|
VARCHAR2(255)
|
STVDEPT
|
STVDEPT_DESC
|
NO
|
NO
|
FOURTH_MAJOR
|
Subject area or major focus recorded for the student's academic study. This may be blank.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
FOURTH_MAJOR_CONC_1
|
First concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
FOURTH_MAJOR_CONC_1_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
FOURTH_MAJOR_CONC_2
|
Second concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
FOURTH_MAJOR_CONC_2_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
FOURTH_MAJOR_CONC_3
|
Third concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
FOURTH_MAJOR_CONC_3_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
FOURTH_MAJOR_DESC
|
Major or subject area of study description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
FOURTH_MINOR
|
Fourth minor for the student within this academic study. This may be blank when no minor has been specified.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
FOURTH_MINOR_DESC
|
Minor area of study description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
FOURTH_PROGRAM_CLASSIFICATION
|
Program classification associated with the major subject area of study for this 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
|
NO
|
NO
|
FOURTH_PROGRAM_CLASSIF_DESC
|
Program classification code description.
|
VARCHAR2(255)
|
STVCIPC
|
STVCIPC_DESC
|
NO
|
NO
|
GPA
|
Calculated grade point average or average for the set of courses completed.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
NO
|
NO
|
GPA_CREDITS
|
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
|
NO
|
NO
|
GRADUATED_IND
|
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')
|
NO
|
NO
|
GRADUATION_STATUS
|
Identifies that an academic outcome is completed or still being sought, etc.
|
VARCHAR2(3)
|
SHRDGMR
|
SHRDGMR_GRST_CODE
|
NO
|
NO
|
GRADUATION_STATUS_DESC
|
Current graduation status description.
|
VARCHAR2(255)
|
STVGRST
|
STVGRST_DESC
|
NO
|
NO
|
GRAD_AUTHORIZED_ADDS_CHGS
|
Identifies that the student is authorized to add or drop based on graduation requirements.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_AUTHORIZED
|
NO
|
NO
|
GRAD_REQ_COMPLETED_ACAD_PER
|
Academic period when all graduation requirements were completed or will be completed.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_TERM_CODE_COMPLETED
|
NO
|
NO
|
GRAD_REQ_COMP_ACAD_PER_DESC
|
Academic period description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
HONORS_COUNT
|
Count of all honors recorded for the student.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_HONORS
|
NO
|
NO
|
ID
|
Identification number assigned to a person that is used externally for all communication and correspondence with the person.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
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
|
NO
|
NO
|
INSTITUTION_CREDITS_ATTEMPTED
|
Sum of institution course credits attempted by a student.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
NO
|
NO
|
INSTITUTION_CREDITS_EARNED
|
Sum of institution course credits earned by a student.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
NO
|
NO
|
INSTITUTION_CREDITS_PASSED
|
Sum of institution course credits passed by a student for this academic outcome.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
NO
|
NO
|
INSTITUTION_GPA
|
Calculated of institution course grade point average or average for the set of courses completed.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
NO
|
NO
|
INSTITUTION_GPA_CREDITS
|
Sum of institution course credits used in the GPA calculations for this student.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
NO
|
NO
|
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
|
NO
|
NO
|
MAJOR
|
Major subject area of the person's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
MAJOR_DESC
|
Name of the student's major subject area.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
MULTI_SOURCE_DESC
|
Institution description for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
NAME
|
Name of the student (Last name, First name Middle Initial format).
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
OFFICIAL_DOCUMENT_NAME
|
Name of the person as it appears on the outcome document.
|
VARCHAR2(500)
|
SHBDIPL
|
SHBDIPL_NAME
|
NO
|
NO
|
OUTCOME_APPLICATION_DATE
|
Date that the student applied for graduation in this academic outcome.
|
DATE
|
SHRDGMR
|
SHRDGMR_APPL_DATE
|
NO
|
NO
|
OUTCOME_AWARDED_IND
|
Identifies whether the academic outcome, award or degree has been officially awarded to the person.
|
VARCHAR2(1)
|
STVDEGS
|
STVDEGS_AWARD_STATUS_IND
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO NO
|
NO
|
PERSON_UID
|
System generated, unique, internal identification number assigned to the person.
|
NUMBER
|
SHRDGMR
|
SHRDGMR_PIDM
|
NO
|
NO
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
PROGRAM
|
Student's program, curriculum or course of study. This may be Data Not Available when program codes have not been defined by the institution. The alternate curriculum identification is by a combination of college, degree and major codes.
|
VARCHAR2(63)
|
SORLCUR
|
SORLCUR_PROGRAM
|
NO
|
NO
|
PROGRAM_CLASSIFICATION
|
Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting.
|
VARCHAR2(63)
|
STVMAJR
|
STVMAJR_CIPC_CODE
|
NO
|
NO
|
PROGRAM_CLASSIFICATION_DESC
|
Program classification description.
|
VARCHAR2(255)
|
STVCIPC
|
STVCIPC_DESC
|
NO
|
NO
|
PROGRAM_DESC
|
Program or course of study description.
|
VARCHAR2(255)
|
SMRPRLE
|
SMRPRLE_PROGRAM_DESC
|
NO
|
NO
|
QUALITY_POINTS
|
Quality points used to calculate the grade point average for this academic outcome.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
NO
|
NO
|
SECOND_CONCENTRATION
|
Concentration or study emphasis attached to the major for the student's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
SECOND_CONCENTRATION_DESC
|
Concentration or study emphasis description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
SECOND_DEPARTMENT
|
Department responsible for the second major or subject area of academic instruction.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
NO
|
NO
|
SECOND_DEPARTMENT_DESC
|
Department name.
|
VARCHAR2(255)
|
STVDEPT
|
STVDEPT_DESC
|
NO
|
NO
|
SECOND_MAJOR
|
Major subject area of the person's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
SECOND_MAJOR_CONC_1
|
First concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
SECOND_MAJOR_CONC_1_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
SECOND_MAJOR_CONC_2
|
Second concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
SECOND_MAJOR_CONC_2_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
SECOND_MAJOR_CONC_3
|
Third concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
SECOND_MAJOR_CONC_3_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
SECOND_MAJOR_DESC
|
Major or subject area of study description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
SECOND_MINOR
|
Second minor for the student within this academic study. This may be blank when no minor has been specified.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
SECOND_MINOR_DESC
|
Minor subject area of study description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
SECOND_PROGRAM_CLASSIFICATION
|
Program classification associated with the major subject area of study for this outcome. This may be the Classification of Program (CIP) codes used for reporting outcomes to the federal government.
|
VARCHAR2(63)
|
STVMAJR
|
STVMAJR_CIPC_CODE
|
NO
|
NO
|
SECOND_PROGRAM_CLASSIF_DESC
|
Program classification code description.
|
VARCHAR2(255)
|
STVCIPC
|
STVCIPC_DESC
|
NO
|
NO
|
STATUS
|
Current status of the academic outcome. For example, pending, awarded, etc.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_DEGS_CODE
|
NO
|
NO
|
STATUS_DESC
|
Outcome or award status description.
|
VARCHAR2(255)
|
STVDEGS
|
STVDEGS_DESC
|
NO
|
NO
|
STUDENT_LEVEL
|
Level of study for the students program or course work. For example, Undergraduate, Graduate, Credit, Continuing Education, etc.
|
VARCHAR2(63)
|
SORLCUR
|
SORLCUR_LEVL_CODE
|
NO
|
NO
|
STUDENT_LEVEL_DESC
|
Student level description.
|
VARCHAR2(255)
|
STVLEVL
|
STVLEVL_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
SUB_ACADEMIC_PERIOD_GRAD_DESC
|
Sub academic period description.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
THIRD_CONCENTRATION
|
Concentration or study emphasis attached to the major for the student's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
THIRD_CONCENTRATION_DESC
|
Concentration or study emphasis description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
THIRD_DEPARTMENT
|
Department responsible for the major or subject area of academic instruction.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
NO
|
NO
|
THIRD_DEPARTMENT_DESC
|
Department name.
|
VARCHAR2(255)
|
STVDEPT
|
STVDEPT_DESC
|
NO
|
NO
|
THIRD_MAJOR
|
Subject area or major focus recorded for the student's academic study. This may be blank.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
THIRD_MAJOR_CONC_1
|
First concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
THIRD_MAJOR_CONC_1_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
THIRD_MAJOR_CONC_2
|
Second concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
THIRD_MAJOR_CONC_2_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
THIRD_MAJOR_CONC_3
|
Third concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
THIRD_MAJOR_CONC_3_DESC
|
Student's concentration description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
THIRD_MAJOR_DESC
|
Major or subject area of study description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
THIRD_MINOR
|
Third minor for the student within this academic study. This may be blank when no minor has been specified.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
NO
|
NO
|
THIRD_MINOR_DESC
|
Minor area of study description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
NO
|
NO
|
THIRD_PROGRAM_CLASSIFICATION
|
Program classification associated with the major subject area of study for this 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
|
NO
|
NO
|
THIRD_PROGRAM_CLASSIF_DESC
|
Program classification code description.
|
VARCHAR2(255)
|
STVCIPC
|
STVCIPC_DESC
|
NO
|
NO
|
TRANSFER_CREDITS_ATTEMPTED
|
Sum of transfer course credits attempted by a student.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
NO
|
NO
|
TRANSFER_CREDITS_EARNED
|
Sum of transfer course credits earned by a student.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
NO
|
NO
|
TRANSFER_CREDITS_PASSED
|
Sum of transfer course credits passed by a student for this academic outcome.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
NO
|
NO
|
TRANSFER_GPA
|
Calculated of transfer course grade point average or average for the set of courses completed.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
NO
|
NO
|
TRANSFER_GPA_CREDITS
|
Sum of transfer course credits used in the GPA calculations for this student.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_GET_DEGREE_GPA_DATA
|
NO
|
NO
|
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
|
NO
|
NO
|
TRANSFER_WORK_EXISTS_IND
|
Indicates whether any transfer credits are recorded for the student that apply to this academic outcome.
|
VARCHAR2(1)
|
FUNCTION
|
F_CHECK_FOR_TRANSFER_WORK
|
NO
|
NO
|