Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACADEMIC_PERIOD		Academic period or term associated with the information in the course attribute record.	VARCHAR2(0)		NA	NA
ACADEMIC_PERIOD_DESC		Academic period description.	VARCHAR2(0)		NA	NA
ACADEMIC_STUDY_AREA		This field displays the type of academic study area the GPA is being maintained for. Such as Level, College, Major, etc.	VARCHAR2(30)		CONSTANT	'LEVEL'
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(2)		SHRLGPA	SHRLGPA_LEVL_CODE
ACADEMIC_STUDY_VALUE_DESC		Student level description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
ACADEMIC_YEAR		Academic year associated with the academic period on this record.	VARCHAR2(0)		NA	NA
ACADEMIC_YEAR_DESC		Academic year description.	VARCHAR2(0)		NA	NA
CLASS_RANK		Student's institutional class rank.	NUMBER		NA	NA
CLASS_SIZE		Student's institutional class size.	NUMBER		NA	NA
COMPUTATION_DATE		Date the GPA was calculated.	DATE		SHRLGPA	SHRLGPA_ACTIVITY_DATE
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(11, 3)		SHRLGPA	SHRLGPA_HOURS_ATTEMPTED
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(11, 3)		SHRLGPA	SHRLGPA_HOURS_EARNED
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(11, 3)		SHRLGPA	SHRLGPA_HOURS_PASSED
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(23, 9)		SHRLGPA	SHRLGPA_GPA
GPA_CREDITS		Credits used to calculate the average or grade point average for the courses completed by the person.	NUMBER(11, 3)		SHRLGPA	SHRLGPA_GPA_HOURS
GPA_GROUPING		This field specifies if 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 associated time period.	VARCHAR2(6)		CONSTANT	'C'
GPA_GROUPING_DESC		This field specifies the description of the GPA grouping.	VARCHAR2(30)		CONSTANT	'CUMULATIVE VALUES'
GPA_TIME_IND		Time period associated with the GPA information. Valid values identify academic year, academic period, sub academic period, and not time based.	VARCHAR2(1)		CONSTANT	'N'
GPA_TIME_IND_DESC		This field specifies the description of the time period associated with the GPA information.	VARCHAR2(30)		CONSTANT	'NON-TIME BASED'
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
GPA_TYPE_DESC		GPA type description.	VARCHAR2(11)		CALCULATION	DECODE(SHRLGPA_GPA_TYPE_IND,'I','INSTITUTION','T','TRANSFER','O','OVERALL')
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_GPA_IND		Indicators which specifies whether the gpa info is official.	VARCHAR2(1)		NA	NA
PERSON_UID		System generated, unique, internal identification number assigned to this person.	NUMBER(8)		SHRLGPA	SHRLGPA_PIDM
QUALITY_POINTS		Student's cumulative quality points.	NUMBER(17, 6)		SHRLGPA	SHRLGPA_QUALITY_POINTS
SUB_ACADEMIC_PERIOD		A session, portion or part of the academic period.	VARCHAR2(0)		NA	NA
SUB_ACADEMIC_PERIOD_DESC		Sub academic period description.	VARCHAR2(0)		NA	NA
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: