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

Ver: