Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	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)	SHRTGPA	SHRTGPA_TERM_CODE
ACADEMIC_PERIOD_DESC	Academic Period Description	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC
ACADEMIC_STUDY_AREA	Academic Study Area	Type of academic study area the GPA is being maintained for, such as level, college, major, etc.	VARCHAR2(255)	CONSTANT	'LEVEL'
ACADEMIC_STUDY_VALUE	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 SHRTGPA	SHRLGPA_LEVL_CODE SHRTGPA_LEVL_CODE
ACADEMIC_STUDY_VALUE_DESC	Academic Study Value Description	Student level description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ACADEMIC_YEAR	Academic Year	Academic year associated with the academic period on this record.	VARCHAR2(63)	FUNCTION	GOKODSF.F_GET_DESC
ACADEMIC_YEAR_DESC	Academic Year Description	Academic year description.	VARCHAR2(255)	STVACYR	STVACYR_DESC
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
CLASS_RANK	Class Rank	Student's institutional class rank.	NUMBER	NA	NA
CLASS_SIZE	Class Size	Student's institutional class size.	NUMBER	NA	NA
COMPUTATION_DATE	Computation Date	Date the GPA was calculated.	DATE	SHRLGPA	SHRLGPA_ACTIVITY_DATE
CREDITS_ATTEMPTED	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 SHRTGPA	SHRLGPA_HOURS_ATTEMPTED SHRTGPA_HOURS_ATTEMPTED
CREDITS_EARNED	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 SHRTGPA	SHRLGPA_HOURS_EARNED SHRTGPA_HOURS_EARNED
CREDITS_PASSED	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 SHRTGPA	SHRLGPA_HOURS_PASSED SHRTGPA_HOURS_PASSED
GPA	GPA - Grade Point Average or Average	Calculated grade point average or average for a set of courses completed.	NUMBER	SHREGPA SHRGPAC SHRGPAL SHRLGPA SHRTGPA	SHREGPA_GPA_I SHRGPAC_GPA SHRGPAL_GPA SHRLGPA_GPA SHRTGPA_GPA
GPA_CREDITS	GPA - Grade Point Average or Average Credits	Credits used to calculate the average or grade point average for the courses completed by the person.	NUMBER	SHRLGPA SHRTGPA	SHRLGPA_GPA_HOURS SHRTGPA_GPA_HOURS
GPA_GROUPING	GPA - Grade Point Average or Average Grouping	Specifies whether the GPA information is displayed for the specified academic period, or if it is cumulative up to and including the current time period associated with this record. Valid values are C for cumulative and P for associated time period.	VARCHAR2(255)	CONSTANT CONSTANT	'C' 'P'
GPA_GROUPING_DESC	GPA - Grade Point Average or Average Grouping Description	GPA grouping description.	VARCHAR2(255)	CONSTANT CONSTANT	'CUMULATIVE VALUES' 'PERIOD BASED VALUES'
GPA_TIME_IND	GPA - Grade Point Average or Average Time Indicator	Time period associated with the GPA information. Valid values identify academic year, academic period, sub academic period, and not time based.	VARCHAR2(255)	CONSTANT CONSTANT	'N' 'P'
GPA_TIME_IND_DESC	GPA - Grade Point Average or Average Time Indicator Description	GPA time period description.	VARCHAR2(255)	CONSTANT CONSTANT	'NON-TIME BASED' 'PERIOD'
GPA_TYPE	GPA - Grade Point Average or Average 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 SHRTGPA	SHRLGPA_GPA_TYPE_IND SHRTGPA_GPA_TYPE_IND
GPA_TYPE_DESC	GPA - Grade Point Average or Average Type Description	GPA type description.	VARCHAR2(11)	CALCULATION CALCULATION	DECODE(SHRLGPA_GPA_TYPE_IND,'I','INSTITUTION','T','TRANSFER','O','OVERALL') DECODE(SHRTGPA_GPA_TYPE_IND,'I','INSTITUTION','T','TRANSFER')
ID	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
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
OFFICIAL_GPA_IND	Official GPA - Grade Point Average or Average Indicator	Indicates whether the GPA information is official.	VARCHAR2(1)	NA	NA
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SHRLGPA SHRTGPA	SHRLGPA_PIDM SHRTGPA_PIDM
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
QUALITY_POINTS	Quality Points	Student's cumulative quality points.	NUMBER	SHRLGPA SHRTGPA	SHRLGPA_QUALITY_POINTS SHRTGPA_QUALITY_POINTS
SUB_ACADEMIC_PERIOD	Sub Academic Period	A session, portion or part of the academic period.	VARCHAR2(63)	NA	NA
SUB_ACADEMIC_PERIOD_DESC	Sub Academic Period Description	Sub academic period description.	VARCHAR2(255)	NA	NA

Ver: 9.2