Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACADEMIC_PERIOD	Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year.	VARCHAR2(63)	NA	NA	NO	NO
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(255)	NA	NA	NO	NO
ACADEMIC_STUDY_VALUE	Area this GPA represents such as student level, college, major, etc. types of GPAs. In this example the type is the student level average or GPA.	VARCHAR2(63)	SHRLGPA	SHRLGPA_LEVL_CODE	NO	NO
ACADEMIC_STUDY_VALUE_DESC	Student level description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(63)	NA	NA	NO	NO
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(255)	NA	NA	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
CLASS_RANK	Student's institutional class rank.	NUMBER	NA	NA	NO	NO
CLASS_SIZE	Student's institutional class size.	NUMBER	NA	NA	NO	NO
COMPUTATION_DATE	Date the GPA was calculated.	DATE	SHRLGPA	SHRLGPA_ACTIVITY_DATE	NO	NO
CREDITS_ATTEMPTED	Credits attempted as defined by the grading rules of the institution. In-progress or transfer courses may be defined not to add to the credits attempted.	NUMBER	SHRLGPA	SHRLGPA_HOURS_ATTEMPTED	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	SHRLGPA	SHRLGPA_HOURS_EARNED	NO	NO
CREDITS_PASSED	Credits passed 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	SHRLGPA	SHRLGPA_HOURS_PASSED	NO	NO
GPA	Calculated grade point average or average for a set of courses completed.	NUMBER	SHRLGPA	SHRLGPA_GPA	NO	NO
GPA_CREDITS	Credits used to calculate the average or grade point average for the courses completed by the person.	NUMBER	SHRLGPA	SHRLGPA_GPA_HOURS	NO	NO
GPA_TYPE	Type of GPA displayed. Valid values are Institution (courses completed at this institution), Transfer (courses completed at another institution and transferred for credit), or Overall (all courses completed).	VARCHAR2(1)	SHRLGPA	SHRLGPA_GPA_TYPE_IND	NO	NO
GPA_TYPE_DESC	GPA type description.	VARCHAR2(11)	CALCULATION	DECODE(SHRLGPA_GPA_TYPE_IND,'I','INSTITUTION','T','TRANSFER','O','OVERALL')	NO	NO
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	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 when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
OFFICIAL_GPA_IND	Indicates whether the GPA information is official.	VARCHAR2(1)	NA	NA	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SHRLGPA	SHRLGPA_PIDM	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
QUALITY_POINTS	Student's cumulative quality points.	NUMBER	SHRLGPA	SHRLGPA_QUALITY_POINTS	NO	NO
SUB_ACADEMIC_PERIOD	A session, portion or part of the academic period.	VARCHAR2(63)	NA	NA	NO	NO
SUB_ACADEMIC_PERIOD_DESC	Sub academic period description.	VARCHAR2(255)	NA	NA	NO	NO

Ver: 9.2