| Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ACADEMIC_PERIOD_GRAD_1
|
Academic Period Graduate Degree 1
|
Academic period when all graduation requirements were completed or will be completed.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_TERM_CODE_GRAD
|
|
ACADEMIC_PERIOD_GRAD_2
|
Academic Period Graduate Degree 2
|
Academic period when all graduation requirements were completed or will be completed.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_TERM_CODE_GRAD
|
|
ACADEMIC_PERIOD_GRAD_3
|
Academic Period Graduate Degree 3
|
Academic period when all graduation requirements were completed or will be completed.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_TERM_CODE_GRAD
|
|
ACADEMIC_PERIOD_GRAD_DESC_1
|
Academic Period Graduate Degree 1 Description
|
Academic period description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
ACADEMIC_PERIOD_GRAD_DESC_2
|
Academic Period Graduate Degree 2 Description
|
Academic period description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
ACADEMIC_PERIOD_GRAD_DESC_3
|
Academic Period Graduate Degree 3 Description
|
Academic period description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
ACADEMIC_YEAR_GRAD_1
|
Academic Year Graduate Degree 1
|
Academic year associated with this graduation date.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_ACYR_CODE
|
|
ACADEMIC_YEAR_GRAD_2
|
Academic Year Graduate Degree 2
|
Academic year associated with this graduation date.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_ACYR_CODE
|
|
ACADEMIC_YEAR_GRAD_3
|
Academic Year Graduate Degree 3
|
Academic year associated with this graduation date.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_ACYR_CODE
|
|
ACADEMIC_YEAR_GRAD_DESC_1
|
Academic Year Graduate Degree 1 Description
|
Academic year description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
ACADEMIC_YEAR_GRAD_DESC_2
|
Academic Year Graduate Degree 2 Description
|
Academic year description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
ACADEMIC_YEAR_GRAD_DESC_3
|
Academic Year Graduate Degree 3 Description
|
Academic year description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
ACTIVITY_DATE
|
Activity Date
|
Date record was inserted or updated.
|
DATE
|
NA
|
SYSDATE
|
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
APPLICATION_DATE_1
|
Degree 1 Application Date
|
Date applied for graduation and completion of this academic outcome.
|
DATE
|
SHRDGMR
|
SHRDGMR_APPL_DATE
|
|
APPLICATION_DATE_2
|
Degree 2 Application Date
|
Date applied for graduation and completion of this academic outcome.
|
DATE
|
SHRDGMR
|
SHRDGMR_APPL_DATE
|
|
APPLICATION_DATE_3
|
Degree 3 Application Date
|
Date applied for graduation and completion of this academic outcome.
|
DATE
|
SHRDGMR
|
SHRDGMR_APPL_DATE
|
|
BULLETIN_YEAR_1
|
Degree 1 Bulletin Year
|
Academic year associated with the requirements completed for this graduation.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_ACYR_CODE_BULLETIN
|
|
BULLETIN_YEAR_2
|
Degree 2 Bulletin Year
|
Academic year associated with the requirements completed for this graduation.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_ACYR_CODE_BULLETIN
|
|
BULLETIN_YEAR_3
|
Degree 3 Bulletin Year
|
Academic year associated with the requirements completed for this graduation.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_ACYR_CODE_BULLETIN
|
|
BULLETIN_YEAR_DESC_1
|
Degree 1 Bulletin Year Description
|
Academic year description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
BULLETIN_YEAR_DESC_2
|
Degree 2 Bulletin Year Description
|
Academic year description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
BULLETIN_YEAR_DESC_3
|
Degree 3 Bulletin Year Description
|
Academic year description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
CAMPUS_1
|
Degree 1 Campus
|
Campus where the academic outcome requirements were completed.
|
VARCHAR2(63)
|
SORLCUR
|
SORLCUR_CAMP_CODE
|
|
CAMPUS_2
|
Degree 2 Campus
|
Campus where the academic outcome requirements were completed.
|
VARCHAR2(63)
|
SORLCUR
|
SORLCUR_CAMP_CODE
|
|
CAMPUS_3
|
Degree 3 Campus
|
Campus where the academic outcome requirements were completed.
|
VARCHAR2(63)
|
SORLCUR
|
SORLCUR_CAMP_CODE
|
|
CAMPUS_DESC_1
|
Degree 1 Campus Description
|
Institution campus name.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
CAMPUS_DESC_2
|
Degree 2 Campus Description
|
Institution campus name.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
CAMPUS_DESC_3
|
Degree 3 Campus Description
|
Institution campus name.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
CATEGORY_1
|
Degree 1 Award Category
|
Award category associated with the outcome, degree or award. Category used to group outcomes for reporting similar awards together. For example, less than two year, two year and four year awards.
|
VARCHAR2(63)
|
STVDEGC
|
STVDEGC_ACAT_CODE
|
|
CATEGORY_2
|
Degree 2 Award Category
|
Award category associated with the outcome, degree or award. Category used to group outcomes for reporting similar awards together. For example, less than two year, two year and four year awards.
|
VARCHAR2(63)
|
STVDEGC
|
STVDEGC_ACAT_CODE
|
|
CATEGORY_3
|
Degree 3 Award Category
|
Award category associated with the outcome, degree or award. Category used to group outcomes for reporting similar awards together. For example, less than two year, two year and four year awards.
|
VARCHAR2(63)
|
STVDEGC
|
STVDEGC_ACAT_CODE
|
|
CATEGORY_DESC_1
|
Degree 1 Award Category Description
|
Award category description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
CATEGORY_DESC_2
|
Degree 2 Award Category Description
|
Award category description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
CATEGORY_DESC_3
|
Degree 3 Award Category Description
|
Award category description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
COLLEGE_1
|
Degree 1 College
|
College, faculty or school to which the academic study for the student is associated.
|
VARCHAR2(63)
|
SORLCUR
|
SORLCUR_COLL_CODE
|
|
COLLEGE_2
|
Degree 2 College
|
College, faculty or school to which the academic study for the student is associated.
|
VARCHAR2(63)
|
SORLCUR
|
SORLCUR_COLL_CODE
|
|
COLLEGE_3
|
Degree 3 College
|
College, faculty or school to which the academic study for the student is associated.
|
VARCHAR2(63)
|
SORLCUR
|
SORLCUR_COLL_CODE
|
|
COLLEGE_DESC_1
|
Degree 1 College Description
|
College, faculty or school name.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
COLLEGE_DESC_2
|
Degree 2 College Description
|
College, faculty or school name.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
COLLEGE_DESC_3
|
Degree 3 College Description
|
College, faculty or school name.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
DEPARTMENT_1
|
Degree 1 Department
|
Department responsible to verify that academic outcome requirements are completed.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
|
DEPARTMENT_2
|
Degree 2 Department
|
Department responsible to verify that academic outcome requirements are completed.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
|
DEPARTMENT_3
|
Degree 3 Department
|
Department responsible to verify that academic outcome requirements are completed.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
|
DEPARTMENT_DESC_1
|
Degree 1 Department Description
|
Department name.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
DEPARTMENT_DESC_2
|
Degree 2 Department Description
|
Department name.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
DEPARTMENT_DESC_3
|
Degree 3 Department Description
|
Department name.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
GRADUATION_DATE_1
|
Degree 1 Graduation Date
|
Date for the formal completion or graduation in this academic outcome.
|
DATE
|
SHRDGMR
|
SHRDGMR_GRAD_DATE
|
|
GRADUATION_DATE_2
|
Degree 2 Graduation Date
|
Date for the formal completion or graduation in this academic outcome.
|
DATE
|
SHRDGMR
|
SHRDGMR_GRAD_DATE
|
|
GRADUATION_DATE_3
|
Degree 3 Graduation Date
|
Date for the formal completion or graduation in this academic outcome.
|
DATE
|
SHRDGMR
|
SHRDGMR_GRAD_DATE
|
|
GRADUATION_STATUS_1
|
Degree 1 Graduation Status
|
Indicates when an academic outcome is completed.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_GRST_CODE
|
|
GRADUATION_STATUS_2
|
Degree 2 Graduation Status
|
Indicates when an academic outcome is completed.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_GRST_CODE
|
|
GRADUATION_STATUS_3
|
Degree 3 Graduation Status
|
Indicates when an academic outcome is completed.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_GRST_CODE
|
|
GRADUATION_STATUS_DESC_1
|
Degree 1 Graduation Status Description
|
Current graduation status description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
GRADUATION_STATUS_DESC_2
|
Degree 2 Graduation Status Description
|
Current graduation status description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
GRADUATION_STATUS_DESC_3
|
Degree 3 Graduation Status Description
|
Current graduation status description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
GRAD_AUTHORIZED_ADDS_CHGS_1
|
Graduate Authorized Adds Charges 1
|
Indicates if the student is authorized to add or drop based on graduation requirements.
|
VARCHAR2(255)
|
SHRDGMR
|
SHRDGMR_AUTHORIZED
|
|
GRAD_AUTHORIZED_ADDS_CHGS_2
|
Graduate Authorized Adds Charges 2
|
Indicates if the student is authorized to add or drop based on graduation requirements.
|
VARCHAR2(255)
|
SHRDGMR
|
SHRDGMR_AUTHORIZED
|
|
GRAD_AUTHORIZED_ADDS_CHGS_3
|
Graduate Authorized Adds Charges 3
|
Indicates if the student is authorized to add or drop based on graduation requirements.
|
VARCHAR2(255)
|
SHRDGMR
|
SHRDGMR_AUTHORIZED
|
|
GRAD_REQ_COMPLETED_TERM_1
|
Degree 1 Graduate Requirements Completed Academic Period
|
Academic period when all graduation requirements were completed or will be completed.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_TERM_CODE_COMPLETED
|
|
GRAD_REQ_COMPLETED_TERM_2
|
Degree 2 Graduate Requirements Completed Academic Period
|
Academic period when all graduation requirements were completed or will be completed.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_TERM_CODE_COMPLETED
|
|
GRAD_REQ_COMPLETED_TERM_3
|
Degree 3 Graduate Requirements Completed Academic Period
|
Academic period when all graduation requirements were completed or will be completed.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_TERM_CODE_COMPLETED
|
|
GRAD_REQ_COMPLETED_TERM_DESC1
|
Degree 1 Graduate Requirements Completed Academic Period Description
|
Academic period description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
GRAD_REQ_COMPLETED_TERM_DESC2
|
Degree 2 Graduate Requirements Completed Academic Period Description
|
Academic period description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
GRAD_REQ_COMPLETED_TERM_DESC3
|
Degree 3 Graduate Requirements Completed Academic Period Description
|
Academic period description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
MAJOR_1
|
Degree 1 Major
|
First subject area or major focus recorded for the student's curriculum. This may not be blank.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
MAJOR_2
|
Degree 2 Major
|
First subject area or major focus recorded for the student's curriculum. This may not be blank.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
MAJOR_3
|
Degree 3 Major
|
First subject area or major focus recorded for the student's curriculum. This may not be blank.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
MAJOR_CONC1_1
|
Degree 1 Major Concentration 1
|
Concentration or study emphasis attached to the major for the student's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
MAJOR_CONC1_2
|
Degree 2 Major Concentration 1
|
Concentration or study emphasis attached to the major for the student's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
MAJOR_CONC1_3
|
Degree 3 Major Concentration 1
|
Concentration or study emphasis attached to the major for the student's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
MAJOR_CONC1_DESC_1
|
Degree 1 Major Concentration 1 Description
|
Concentration or study emphasis description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
MAJOR_CONC1_DESC_2
|
Degree 2 Major Concentration 1 Description
|
Concentration or study emphasis description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
MAJOR_CONC1_DESC_3
|
Degree 3 Major Concentration 1 Description
|
Concentration or study emphasis description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
MAJOR_CONC2_1
|
Degree 1 Major Concentration 2
|
Concentration or study emphasis description.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
MAJOR_CONC2_2
|
Degree 2 Major Concentration 2
|
Concentration or study emphasis description.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
MAJOR_CONC2_3
|
Degree 3 Major Concentration 2
|
Concentration or study emphasis description.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
MAJOR_CONC2_DESC_1
|
Degree 1 Major Concentration 2 Description
|
Concentration or study emphasis description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
MAJOR_CONC2_DESC_2
|
Degree 2 Major Concentration 2 Description
|
Concentration or study emphasis description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
MAJOR_CONC2_DESC_3
|
Degree 3 Major Concentration 2 Description
|
Concentration or study emphasis description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
MAJOR_CONC3_1
|
Degree 1 Major Concentration 3
|
Concentration or study emphasis description.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
MAJOR_CONC3_2
|
Degree 2 Major Concentration 3
|
Concentration or study emphasis description.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
MAJOR_CONC3_3
|
Degree 3 Major Concentration 3
|
Concentration or study emphasis description.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
MAJOR_CONC3_DESC_1
|
Degree 1 Major Concentration 3 Description
|
Concentration or study emphasis description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
MAJOR_CONC3_DESC_2
|
Degree 2 Major Concentration 3 Description
|
Concentration or study emphasis description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
MAJOR_CONC3_DESC_3
|
Degree 3 Major Concentration 3 Description
|
Concentration or study emphasis description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
MAJOR_DESC_1
|
Degree 1 Major Description
|
Name of the student's major subject area.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
MAJOR_DESC_2
|
Degree 2 Major Description
|
Name of the student's major subject area.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
MAJOR_DESC_3
|
Degree 3 Major Description
|
Name of the student's major subject area.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_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
|
|
OUTCOME_1
|
Degree 1
|
Degree or award code associated with the academic study.
|
VARCHAR2(63)
|
SHRDGMR SORLCUR
|
SHRDGMR_DEGC_CODE SORLCUR_DEGC_CODE
|
|
OUTCOME_2
|
Degree 2
|
Degree or award code associated with the academic study.
|
VARCHAR2(63)
|
SHRDGMR SORLCUR
|
SHRDGMR_DEGC_CODE SORLCUR_DEGC_CODE
|
|
OUTCOME_3
|
Degree 3
|
Degree or award code associated with the academic study.
|
VARCHAR2(63)
|
SHRDGMR SORLCUR
|
SHRDGMR_DEGC_CODE SORLCUR_DEGC_CODE
|
|
OUTCOME_DESC_1
|
Degree 1 Description
|
Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
OUTCOME_DESC_2
|
Degree 2 Description
|
Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
OUTCOME_DESC_3
|
Degree 3 Description
|
Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
OUTCOME_NUMBER_1
|
Outcome Number 1
|
Degree or award sequence number for this academic outcome for the student.
|
NUMBER
|
SHRDGMR
|
SHRDGMR_SEQ_NO
|
|
OUTCOME_NUMBER_2
|
Outcome Number 2
|
Degree or award sequence number for this academic outcome for the student.
|
NUMBER
|
SHRDGMR
|
SHRDGMR_SEQ_NO
|
|
OUTCOME_NUMBER_3
|
Outcome Number 3
|
Degree or award sequence number for this academic outcome for the student.
|
NUMBER
|
SHRDGMR
|
SHRDGMR_SEQ_NO
|
|
PERSON_UID
|
Person UID
|
System generated, unique, internal identification number assigned to the person.
|
NUMBER
|
SHRDGMR
|
SHRDGMR_PIDM
|
|
PRIMARY_MINOR_1
|
Degree 1 First Minor
|
Minor subject area of the person's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
PRIMARY_MINOR_2
|
Degree 2 First Minor
|
Minor subject area of the person's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
PRIMARY_MINOR_3
|
Degree 3 First Minor
|
Minor subject area of the person's academic study.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
PRIMARY_MINOR_DESC_1
|
Degree 1 First Minor Description
|
Minor subject area description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
PRIMARY_MINOR_DESC_2
|
Degree 2 First Minor Description
|
Minor subject area description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
PRIMARY_MINOR_DESC_3
|
Degree 3 First Minor Description
|
Minor subject area description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
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_1
|
Degree 1 Program
|
Program or course of study for the student. This may be blank when programs are not being used to manage a set of completion requirements.
|
VARCHAR2(63)
|
SORLCUR
|
SORLCUR_PROGRAM
|
|
PROGRAM_2
|
Degree 2 Program
|
Program or course of study for the student. This may be blank when programs are not being used to manage a set of completion requirements.
|
VARCHAR2(63)
|
SORLCUR
|
SORLCUR_PROGRAM
|
|
PROGRAM_3
|
Degree 3 Program
|
Program or course of study for the student. This may be blank when programs are not being used to manage a set of completion requirements.
|
VARCHAR2(63)
|
SORLCUR
|
SORLCUR_PROGRAM
|
|
PROGRAM_CLASSIFICATION_1
|
Degree 1 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 to the federal government.
|
VARCHAR2(63)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
PROGRAM_CLASSIFICATION_2
|
Degree 2 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 to the federal government.
|
VARCHAR2(63)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
PROGRAM_CLASSIFICATION_3
|
Degree 3 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 to the federal government.
|
VARCHAR2(63)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
PROGRAM_CLASSIFICATION_DESC_1
|
Degree 1 Program Classification Description
|
Program classification description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
PROGRAM_CLASSIFICATION_DESC_2
|
Degree 2 Program Classification Description
|
Program classification description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
PROGRAM_CLASSIFICATION_DESC_3
|
Degree 3 Program Classification Description
|
Program classification description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
PROGRAM_DESC_1
|
Degree 1 Program Description
|
Program or course of study description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
PROGRAM_DESC_2
|
Degree 2 Program Description
|
Program or course of study description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
PROGRAM_DESC_3
|
Degree 3 Program Description
|
Program or course of study description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
SECONDARY_DEPARTMENT_1
|
Degree 1 Second Major Department
|
Department responsible for the second major or subject area of academic instruction.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
|
SECONDARY_DEPARTMENT_2
|
Degree 2 Second Major Department
|
Department responsible for the major or subject area of academic instruction.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
|
SECONDARY_DEPARTMENT_3
|
Degree 3 Second Major Department
|
Department responsible for the major or subject area of academic instruction.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
|
SECONDARY_DEPARTMENT_DESC_1
|
Degree 1 Second Department Description
|
Department name.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
SECONDARY_DEPARTMENT_DESC_2
|
Degree 2 Second Department Description
|
Department name.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
SECONDARY_DEPARTMENT_DESC_3
|
Degree 3 Second Department Description
|
Department name.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
SECONDARY_MAJOR_1
|
Degree 1 Second Major
|
Subject area or major focus recorded for the student's academic study. This may be blank.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
SECONDARY_MAJOR_2
|
Degree 2 Second Major
|
Subject area or major focus recorded for the student's academic study. This may be blank.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
SECONDARY_MAJOR_3
|
Degree 3 Second Major
|
Subject area or major focus recorded for the student's academic study. This may be blank.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
SECONDARY_MAJOR_CONC1_1
|
Degree 1 Second Major Concentration 1
|
First 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 or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
SECONDARY_MAJOR_CONC1_2
|
Degree 2 Second Major Concentration 1
|
First 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 or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
SECONDARY_MAJOR_CONC1_3
|
Degree 3 Second Major Concentration 1
|
First 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 or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
SECONDARY_MAJOR_CONC1_DESC_1
|
Degree 1 Second Major Concentration 1 Description
|
Student's concentration description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
SECONDARY_MAJOR_CONC1_DESC_2
|
Degree 2 Second Major Concentration 1 Description
|
Student's concentration description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
SECONDARY_MAJOR_CONC1_DESC_3
|
Degree 3 Second Major Concentration 1 Description
|
Student's concentration description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
SECONDARY_MAJOR_CONC2_1
|
Degree 1 Second Major Concentration 2
|
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 or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
SECONDARY_MAJOR_CONC2_2
|
Degree 2 Second Major Concentration 2
|
Second concentration or focus of study within this student's major. This may be blank is concentrations are not being used, or if the major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
SECONDARY_MAJOR_CONC2_3
|
Degree 2 Second Major Concentration 3
|
Second concentration or focus of study within this student's major. This may be blank is concentrations are not being used, or if the major does not have a concentration or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
SECONDARY_MAJOR_CONC2_DESC_1
|
Degree 1 Second Major Concentration 2 Description
|
Student's concentration description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
SECONDARY_MAJOR_CONC2_DESC_2
|
Degree 2 Second Major Concentration 2 Description
|
Student's concentration description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
SECONDARY_MAJOR_CONC2_DESC_3
|
Degree 3 Second Major Concentration 2 Description
|
Student's concentration description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
SECONDARY_MAJOR_CONC3_1
|
Degree 3 Second Major Concentration 1
|
Third 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 or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
SECONDARY_MAJOR_CONC3_2
|
Degree 3 Second Major Concentration 2
|
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 or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
SECONDARY_MAJOR_CONC3_3
|
Degree 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 or emphasis.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
SECONDARY_MAJOR_CONC3_DESC_1
|
Degree 1 Second Major Concentration 3 Description
|
Student's concentration description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
SECONDARY_MAJOR_CONC3_DESC_2
|
Degree 2 Second Major Concentration 3 Description
|
Student's concentration description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
SECONDARY_MAJOR_CONC3_DESC_3
|
Degree 3 Second Major Concentration 3 Description
|
Student's concentration description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
SECONDARY_MAJOR_DESC_1
|
Degree 1 Second Major Description
|
Major or subject area of study description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
SECONDARY_MAJOR_DESC_2
|
Degree 2 Second Major Description
|
Major or subject area of study description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
SECONDARY_MAJOR_DESC_3
|
Degree 3 Second Major Description
|
Major or subject area of study description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
SECONDARY_MINOR_1
|
Degree 1 Second Minor
|
Second minor for the student within this academic study. This may be blank if no minor was specified.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
SECONDARY_MINOR_2
|
Degree 2 Second Minor
|
Second minor for the student within this academic study. This may be blank if no minor was specified.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
SECONDARY_MINOR_3
|
Degree 3 Second Minor
|
Second minor for the student within this academic study. This may be blank if no minor was specified.
|
VARCHAR2(63)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
|
SECONDARY_MINOR_DESC_1
|
Degree 1 Second Minor Description
|
Minor area of study description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
SECONDARY_MINOR_DESC_2
|
Degree 2 Second Minor Description
|
Minor area of study description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
SECONDARY_MINOR_DESC_3
|
Degree 3 Second Minor Description
|
Minor area of study description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
SEC_PROGRAM_CLASSIFICATION_1
|
Degree 1 Second 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
|
GOKODSF.F_GET_DESC
|
|
SEC_PROGRAM_CLASSIFICATION_2
|
Degree 2 Second 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)
|
STVMAJR
|
STVMAJR_CIPC_CODE
|
|
SEC_PROGRAM_CLASSIFICATION_3
|
Degree 3 Second 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 to the federal government.
|
VARCHAR2(63)
|
STVMAJR
|
STVMAJR_CIPC_CODE
|
|
SEC_PROGRAM_CLASSIF_DESC_1
|
Degree 1 Second Program Classification Description
|
Program classification code description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
SEC_PROGRAM_CLASSIF_DESC_2
|
Degree 2 Second Program Classification Description
|
Program classification code description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
SEC_PROGRAM_CLASSIF_DESC_3
|
Degree 3 Second Program Classification Description
|
Program classification code description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
STATUS_1
|
Degree 1 Status
|
Current status of the academic outcome. For example, pending, awarded, etc.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_DEGS_CODE
|
|
STATUS_2
|
Degree 2 Status
|
Current status of the academic outcome. For example, pending, awarded, etc.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_DEGS_CODE
|
|
STATUS_3
|
Degree 3 Status
|
Current status of the academic outcome. For example, pending, awarded, etc.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_DEGS_CODE
|
|
STATUS_DESC_1
|
Degree 1 Status Description
|
Outcome or award status description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
STATUS_DESC_2
|
Degree 2 Status Description
|
Outcome or award status description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
STATUS_DESC_3
|
Degree 3 Status Description
|
Outcome or award status description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_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_1
|
Degree 1 Student Level
|
Student level associated with the course work in the academic outcome. For example, undergraduate, graduate, etc.
|
VARCHAR2(63)
|
SORLCUR
|
SORLCUR_LEVL_CODE
|
|
STUDENT_LEVEL_2
|
Degree 2 Student Level
|
Student level associated with the course work in the academic outcome. For example, undergraduate, graduate, etc.
|
VARCHAR2(63)
|
SORLCUR
|
SORLCUR_LEVL_CODE
|
|
STUDENT_LEVEL_3
|
Degree 3 Student Level
|
Student level associated with the course work in the academic outcome. For example, undergraduate, graduate, etc.
|
VARCHAR2(63)
|
SORLCUR
|
SORLCUR_LEVL_CODE
|
|
STUDENT_LEVEL_DESC_1
|
Degree 1 Student Level Description
|
Student level description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
STUDENT_LEVEL_DESC_2
|
Degree 2 Student Level Description
|
Student level description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
STUDENT_LEVEL_DESC_3
|
Degree 3 Student Level Description
|
Student level description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
STUDENT_TERM_1
|
Degree 1 Academic Period
|
Academic period or time frame associated with this outcome or degree record.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_TERM_CODE_STUREC
|
|
STUDENT_TERM_2
|
Degree 2 Academic Period
|
Academic period or time frame associated with this outcome or degree record.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_TERM_CODE_STUREC
|
|
STUDENT_TERM_3
|
Degree 3 Academic Period
|
Academic period or time frame associated with this outcome or degree record.
|
VARCHAR2(63)
|
SHRDGMR
|
SHRDGMR_TERM_CODE_STUREC
|
|
STUDENT_TERM_DESC_1
|
Degree 1 Academic Period Description
|
Academic period description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
STUDENT_TERM_DESC_2
|
Degree 2 Academic Period Description
|
Academic period description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
STUDENT_TERM_DESC_3
|
Degree 3 Academic Period Description
|
Academic period description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|