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