Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD_GRADUATION	Academic period when all graduation requirements were completed or will be completed.	VARCHAR2(6)	SHRDGMR	SHRDGMR_TERM_CODE_GRAD
ACADEMIC_PERIOD_GRAD_DESC	Academic period description.	VARCHAR2(30)	STVTERM	STVTERM_DESC
ACADEMIC_YEAR_GRADUATION	Academic year associated with this graduation date.	VARCHAR2(4)	SHRDGMR	SHRDGMR_ACYR_CODE
ACADEMIC_YEAR_GRADUATION_DESC	Academic year description.	VARCHAR2(30)	STVACYR	STVACYR_DESC
APPLIED_FOR_OUTCOME_IND	Indicates whether the person has applied to official receive the degree or award for this academic outcome.	VARCHAR2(1)	FUNCTION	F_APPLIED_FOR_DEGREE
BULLETIN_YEAR	Academic year associated with the requirements completed for this graduation.	VARCHAR2(4)	SHRDGMR	SHRDGMR_ACYR_CODE_BULLETIN
BULLETIN_YEAR_DESC	Academic year description.	VARCHAR2(30)	STVACYR	STVACYR_DESC
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(2)	STVDEGC	STVDEGC_ACAT_CODE
CATEGORY_DESC	Award category description.	VARCHAR2(30)	STVACAT	STVACAT_DESC
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 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
CREDITS_PASSED	Sum of credits passed by a student for this academic outcome.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
GPA	Calculated grade point average or average for a set of courses completed.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
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
GRADUATED_IND	Indicates whether the person has graduated or earned any academic outcomes to date.	VARCHAR2(1)	FUNCTION	DECODE(STVDEGS_AWARD_STATUS_IND,'A','Y','N')
GRADUATION_STATUS	Graduation status indicates when an academic outcome has been completed.	VARCHAR2(3)	SHRDGMR	SHRDGMR_GRST_CODE
GRADUATION_STATUS_DESC	Current graduation status description.	VARCHAR2(30)	STVGRST	STVGRST_DESC
GRAD_AUTHORIZED_ADDS_CHGS	Indicates if the student is authorized to add or drop based on graduation requirements.	VARCHAR2(33)	SHRDGMR	SHRDGMR_AUTHORIZED
GRAD_REQ_COMPLETED_APRD	Academic period when all graduation requirements were completed or will be completed.	VARCHAR2(6)	SHRDGMR	SHRDGMR_TERM_CODE_COMPLETED
GRAD_REQ_COMPLETED_APRD_DESC	Academic period description.	VARCHAR2(30)	STVTERM	STVTERM_DESC
INSTIITUTION_CREDITS_ATTEMPTED	Sum of institution course credits attempted by a student.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
INSTIITUTION_CREDITS_EARNED	Sum of institution course credits earned by a student.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
INSTIITUTION_CREDITS_PASSED	Sum of institution course credits passed by a student for this academic outcome.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
INSTIITUTION_GPA	Calculated of institution course grade point average or average for the set of courses completed.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
INSTIITUTION_GPA_CREDITS	Sum of institution course credits used in the GPA calculations for this student.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
INSTIITUTION_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_CREDITS_ATTEMPTED		NUMBER
INSTITUTION_CREDITS_EARNED		NUMBER
INSTITUTION_CREDITS_PASSED		NUMBER
INSTITUTION_GPA		NUMBER
INSTITUTION_GPA_CREDITS		NUMBER
INSTITUTION_QUALITY_POINTS		NUMBER
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA
OFFICIAL_DOCUMENT_NAME	Name of the person as it appears on the outcome document.	VARCHAR2(500)	SHBDIPL	SHBDIPL_NAME
OUTCOME_APPLICATION_DATE	Date applied for graduation and completion of this academic outcome.	DATE	SHRDGMR	SHRDGMR_APPL_DATE
OUTCOME_AWARDED_IND	Indicates when a outcome is awarded, pending or sought per the rules of the institution.	VARCHAR2(1)	STVDEGS	STVDEGS_AWARD_STATUS_IND
OUTCOME_GRADUATION_DATE	Date for the formal completion or graduation in this academic outcome.	DATE	SHRDGMR	SHRDGMR_GRAD_DATE
OUTCOME_NUMBER	Degree or award sequence number for this academic outcome for the student.	NUMBER	SHRDGMR	SHRDGMR_SEQ_NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SHRDGMR	SHRDGMR_PIDM
QUALITY_POINTS	Quality points used to calculate grade point average for this outcome.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
STATUS	Identifies the current status of the academic outcome. May be pending, awarded, etc.	VARCHAR2(2)	SHRDGMR	SHRDGMR_DEGS_CODE
STATUS_DESC	Description for the outcome or award status.	VARCHAR2(30)	STVDEGS	STVDEGS_DESC
STUDENT_TERM	Academic period or time frame associated with this outcome or degree record.	VARCHAR2(6)	SHRDGMR	SHRDGMR_TERM_CODE_STUREC
STUDENT_TERM_DESC	Academic period description.	VARCHAR2(30)	STVTERM	STVTERM_DESC
SUB_ACADEMIC_PERIOD_GRADUATION	Graduation sub academic year.	VARCHAR2(3)	NA	NA
SUB_ACADEMIC_PERIOD_GRAD_DESC	Graduation sub academic year description.	VARCHAR2(30)	NA	NA
TRANSFER_CREDITS_ATTEMPTED	Sum of transfer course credits attempted by a student.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
TRANSFER_CREDITS_EARNED	Sum of transfer course credits earned by a student.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
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	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	Sum of transfer course credits used in the GPA calculations for this student.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
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	Indicates whether any transfer credits are recorded for the student that apply to this academic outcome.	VARCHAR2(1)	FUNCTION	F_CHECK_FOR_TRANSFER_WORK
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: