RETURN TO COMPOSITE VIEW REPORTS LIST
Advancement Composite View Reports

SGHE Operational Data Store
Composite View Target: AA_DEGREE

Description Source composite view contains information on all degrees received by a person from any institution as applicable.

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_YEAR Academic year associated with the academic period on this record. VARCHAR2(4)

APRADEG

APRADEG_ACYR_CODE

ACADEMIC_YEAR_BULLETIN Academic year associated with the requirements completed for this graduation. VARCHAR2(4)

APRADEG

APRADEG_ACYR_CODE_BULLETIN

ACADEMIC_YEAR_BULLETIN_DESC Academic year description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

ADDITIONAL_MAJORS_IND Indicates whether there are additional majors or subject areas for this academic outcome. VARCHAR2(1)

FUNCTION

AOKODSF.F_CHECK_FOR_MORE_MAJORS

CAMPUS Campus associated with this degree. VARCHAR2(3)

APRADEG

APRADEG_CAMP_CODE

CAMPUS_DESC Institution campus name. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

COLLEGE College, faculty or school to which the academic study for the student is associated. VARCHAR2(2)

APRADEG

APRADEG_COLL_CODE

COLLEGE_DESC College, faculty or school name. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

DEGREE Degree or award code associated with the academic study. VARCHAR2(6)

APRADEG

APRADEG_DEGC_CODE

DEGREE_COMMENT Free form text comments about this degree. VARCHAR2(2000)

APRADEG

APRADEG_COMMENTS

DEGREE_DATE Date the degree was awarded to the constituent. DATE

APRADEG

APRADEG_DATE

DEGREE_DESC Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

DEGREE_NUMBER Internal sequence number. NUMBER(5)

APRADEG

APRADEG_SEQ_NO

DEPARTMENT1 Department responsible to verify the academic outcome requirements are completed. VARCHAR2(4)

APRADEG

APRADEG_DEPT_CODE

DEPARTMENT1_DESC Department name. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

DEPARTMENT2 Department responsible to verify the academic outcome requirements are completed. VARCHAR2(4)

APRADEG

APRADEG_DEPT_CODE_2

DEPARTMENT2_DESC Department name. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

DEPARTMENT_HONOR1 Departmental honors the constituent received with the associated degree. VARCHAR2(6)

APRADEG

APRADEG_HOND_CODE_1

DEPARTMENT_HONOR1_DESC Name of the departmental honor recorded. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

DEPARTMENT_HONOR2 Departmental honors the constituent received with the associated degree. VARCHAR2(6)

APRADEG

APRADEG_HOND_CODE_2

DEPARTMENT_HONOR2_DESC Name of the departmental honor recorded. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

DEPARTMENT_HONOR3 Departmental honors the constituent received with the associated degree. VARCHAR2(6)

APRADEG

APRADEG_HOND_CODE_3

DEPARTMENT_HONOR3_DESC Name of the departmental honor recorded. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

DEPARTMENT_HONOR4 Departmental honors the constituent received with the associated degree. VARCHAR2(6)

APRADEG

APRADEG_HOND_CODE_4

DEPARTMENT_HONOR4_DESC Name of the departmental honor recorded. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

DEPARTMENT_HONOR5 Departmental honors the constituent received with the associated degree. VARCHAR2(6)

APRADEG

APRADEG_HOND_CODE_5

DEPARTMENT_HONOR5_DESC Name of the departmental honor recorded. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

FIRST_CONCENTRATION First concentration or focus of study within the student's major. This may be blank when concentrations are not being used, or when the major does not have a concentration. VARCHAR2(4)

APRADEG

APRADEG_MAJR_CODE_CONC_1

FIRST_CONCENTRATION_DESC Description of the first concentration on the major. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

FIRST_MINOR Minor for the student within the academic study. This may be blank if no minor was specified. VARCHAR2(4)

APRADEG

APRADEG_MAJR_CODE_MINR_1

FIRST_MINOR_DESC Major or subject area of study description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

HONOR1 Honors the constituent received with the associated degree. VARCHAR2(6)

APRADEG

APRADEG_HONR_CODE

HONOR1_DESC Institutional honor (e.g., magna cum laude) associated with the institutional honor code recorded. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

HONOR2 Honors the constituent received with the associated degree. VARCHAR2(6)

APRADEG

APRADEG_HONR_CODE_2

HONOR2_DESC Institutional honor (e.g., magna cum laude) associated with the institutional honor code recorded. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

HONOR3 Honors the constituent received with the associated degree. VARCHAR2(6)

APRADEG

APRADEG_HONR_CODE_3

HONOR3_DESC Institutional honor (e.g., magna cum laude) associated with the institutional honor code recorded. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

HONOR4 Honors the constituent received with the associated degree. VARCHAR2(6)

APRADEG

APRADEG_HONR_CODE_4

HONOR4_DESC Institutional honor (magna cum laude, for example) associated with the recorded institutional honor code. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

HONOR5 Honors the constituent received with the associated degree. VARCHAR2(6)

APRADEG

APRADEG_HONR_CODE_5

HONOR5_DESC Institutional honor (e.g., magna cum laude) associated with the institutional honor code. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

INSTITUTION Institution at which the constituent earned the degree. VARCHAR2(6)

APRADEG

APRADEG_SBGI_CODE

INSTITUTION_DESC Name of the previous, secondary, or post secondary institution recorded for the person. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

INSTITUTION_IND Indicates whether the degree or award was earned at this institution. VARCHAR2(1)

CALCULATION

DECODE(APRADEG_SBGI_CODE,AUBINST_SBGI_CODE,'Y','N')

MAJOR1 Concentration of study or emphasis attached to the major for this academic study. VARCHAR2(4)

APRAMAJ

APRAMAJ_MAJR_CODE

MAJOR1_DESC Name of the student's major subject area. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

MAJOR2 Concentration of study or emphasis attached to the major for this academic study. VARCHAR2(4)

APRAMAJ

APRAMAJ_MAJR_CODE

MAJOR2_DESC Name of the student's major subject area. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

MAJOR3 Concentration of study or emphasis attached to the major for this academic study. VARCHAR2(4)

APRAMAJ

APRAMAJ_MAJR_CODE

MAJOR3_DESC Name of the student's major subject area. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

MIF_DESC Institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(30)

NA

NA

MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(6)

NA

NA

PERSON_UID System generated, unique, internal identification number assigned to the person. NUMBER(8)

APRADEG

APRADEG_PIDM

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(4)

APRADEG

APRADEG_MAJR_CODE_CONC_2

SECOND_CONCENTRATION_DESC Student's concentration description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

SECOND_MAJOR_CONC_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. VARCHAR2(4)

APRADEG

APRADEG_MAJR_CODE_CONC_4

SECOND_MAJOR_CONC_1_DESC Student's concentration description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

SECOND_MAJOR_CONC_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(4)

APRADEG

APRADEG_MAJR_CODE_CONC_5

SECOND_MAJOR_CONC_2_DESC Student's concentration description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

SECOND_MAJOR_CONC_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(4)

APRADEG

APRADEG_MAJR_CODE_CONC_6

SECOND_MAJOR_CONC_3_DESC Student's concentration description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

SECOND_MINOR Second minor for the student within this academic study. This may be blank if no minor was specified. VARCHAR2(4)

APRADEG

APRADEG_MAJR_CODE_MINR_2

SECOND_MINOR_DESC Major or subject area of study description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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(4)

APRADEG

APRADEG_MAJR_CODE_CONC_3

THIRD_CONCENTRATION_DESC Student's concentration description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA



Ver: 3.1