Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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	Institution Credits Attempted	Sum of institution course credits attempted by a student.	NUMBER		FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
INSTIITUTION_CREDITS_EARNED	Institution Credits Earned	Sum of institution course credits earned by a student.	NUMBER		FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
INSTIITUTION_CREDITS_PASSED	Institution 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	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
INSTIITUTION_GPA_CREDITS	Institution 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	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
INSTITUTION_CREDITS_ATTEMPTED	Institution Credits Attempted		NUMBER
INSTITUTION_CREDITS_EARNED	Institution Credits Earned		NUMBER
INSTITUTION_CREDITS_PASSED	Institution Credits Passed		NUMBER
INSTITUTION_GPA	Institution GPA - Grade Point Average or Average		NUMBER
INSTITUTION_GPA_CREDITS	Institution GPA - Grade Point Average or Average Credits		NUMBER
INSTITUTION_QUALITY_POINTS	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	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(2)		SHRDGMR	SHRDGMR_SEQ_NO
PERSON_UID		System generated, unique, internal identification number assigned to this person.	NUMBER(8)		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	Transfer Credits Attempted	Sum of transfer course credits attempted by a student.	NUMBER		FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
TRANSFER_CREDITS_EARNED	Transfer Credits Earned	Sum of transfer course credits earned by a student.	NUMBER		FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
TRANSFER_CREDITS_PASSED	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	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	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	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: