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)
|
SHRTGPA
|
SHRTGPA_TERM_CODE
|
NO
|
NO
|
ACADEMIC_PERIOD_DESC
|
Academic period description.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_DESC
|
NO
|
NO
|
ACADEMIC_STUDY_AREA
|
Type of academic study area the GPA is being maintained for, such as level, college, major, etc.
|
VARCHAR2(255)
|
CONSTANT
|
'LEVEL'
|
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 SHRTGPA
|
SHRLGPA_LEVL_CODE SHRTGPA_LEVL_CODE
|
NO 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)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
ACADEMIC_YEAR_DESC
|
Academic year description.
|
VARCHAR2(255)
|
STVACYR
|
STVACYR_DESC
|
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 SHRTGPA
|
SHRLGPA_HOURS_ATTEMPTED SHRTGPA_HOURS_ATTEMPTED
|
NO 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 SHRTGPA
|
SHRLGPA_HOURS_EARNED SHRTGPA_HOURS_EARNED
|
NO 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 SHRTGPA
|
SHRLGPA_HOURS_PASSED SHRTGPA_HOURS_PASSED
|
NO NO
|
NO
|
GPA
|
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
|
NO NO NO NO NO
|
NO
|
GPA_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
|
NO NO
|
NO
|
GPA_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'
|
NO NO
|
NO
|
GPA_GROUPING_DESC
|
GPA grouping description.
|
VARCHAR2(255)
|
CONSTANT CONSTANT
|
'CUMULATIVE VALUES' 'PERIOD BASED VALUES'
|
NO NO
|
NO
|
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(255)
|
CONSTANT CONSTANT
|
'N' 'P'
|
NO NO
|
NO
|
GPA_TIME_IND_DESC
|
GPA time period description.
|
VARCHAR2(255)
|
CONSTANT CONSTANT
|
'NON-TIME BASED' 'PERIOD'
|
NO 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 SHRTGPA
|
SHRLGPA_GPA_TYPE_IND SHRTGPA_GPA_TYPE_IND
|
NO NO
|
NO
|
GPA_TYPE_DESC
|
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')
|
NO 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 SHRTGPA
|
SHRLGPA_PIDM SHRTGPA_PIDM
|
NO 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 SHRTGPA
|
SHRLGPA_QUALITY_POINTS SHRTGPA_QUALITY_POINTS
|
NO 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
|