Target Column	Business Definition	Database Data Type	Source Name	Source Column
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)	SGRSPRT	SGRSPRT_TERM_CODE
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
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.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ACTIVITY	Activity that identifies student participation that is to be recorded. Activities may include fraternity or sorority, chess or debate clubs, etc.	VARCHAR2(63)	SGRSPRT	SGRSPRT_ACTC_CODE
ACTIVITY_CATEGORY	Category associated with the activity so that like activities can be grouped for reporting.	VARCHAR2(63)	STVACTC	STVACTC_ACCG_CODE
ACTIVITY_CATEGORY_DESC	Activities category description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ACTIVITY_DESC	Student activity description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ACTIVITY_TYPE	Specifies a broad type of activity in which the specific activity can be grouped (for example, Sports, Cultural, or Volunteer).	VARCHAR2(63)	STVACTC	STVACTC_ACTP_CODE
ACTIVITY_TYPE_DESC	Activity type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
ATHLETIC_ACADEMIC_ELIGIBLE	Athletic eligibility reporting code.	VARCHAR2(63)	SGRSPRT	SGRSPRT_SAEL_CODE
ATHLETIC_ACAD_ELIGIBLE_DESC	Athletic eligibility reporting code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ATHLETIC_AID_IND	Indicates whether the athletic sport is providing the student financial assistance.	VARCHAR2(1)	SGRSPRT	SGRSPRT_ATHL_AID_IND
ATHLETIC_SPORT_ACTIVE_IND	Indicates whether the student with the associated sports status is active in the sport.	VARCHAR2(1)	STVSPST	STVSPST_ACTIVE_IND
BEGIN_ACAD_PERIOD_ELIGIBLE	Starting academic eligibility term for the athletic competition.	VARCHAR2(63)	SGRATHC	SGRATHC_ELIG_BEGIN_TERM_CODE
BEGIN_ACAD_PERIOD_ELIG_DESC	Beginning academic period eligible description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ELIGIBILITY	Identifies the person is eligible to participate in an official sport.	VARCHAR2(63)	SGRSPRT	SGRSPRT_ELIG_CODE
ELIGIBILITY_DESC	Eligibility code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
END_ACAD_PERIOD_ELIGIBLE	Ending academic eligibility term for the athletic competition.	VARCHAR2(63)	SGRATHC	SGRATHC_ELIG_END_TERM_CODE
END_ACAD_PERIOD_ELIGIBLE_DESC	Ending academic period eligible description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
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	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SGRSPRT	SGRSPRT_PIDM
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
SEASONS_COMPETITION_AVAILABLE	Number of seasons competition is available.	NUMBER	SGRATHC	SGRATHC_SEASONS_AVAILABLE
SEASONS_COMPETITION_REMAINING	Number of remaining seasons of competition available.	NUMBER	CALCULATION	SEASONS_COMPETITION_AVAILABLE - SEASONS_COMPETITION_USED
SEASONS_COMPETITION_USED	Number of used seasons of competition.	NUMBER	FUNCTION FUNCTION	SOKODSF.F_CALC_SEASONS_USED TO BE FILLED IN BY DEVELOPER
SEASONS_USED_IND	Indicates used season of competition.	VARCHAR2(1)	SGRATHC	SGRATHC_SEASONS_USED_IND
SEASON_CHANGE_REASON	Reason for a change to the number of seasons available.	VARCHAR2(63)	SGRATHC	SGRATHC_SARE_CODE
SEASON_CHANGE_REASON_DESC	Season change reason description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
SPORT_ACTIVITY_DATE	Date record was inserted or updated.	DATE	SGRSPRT	SGRSPRT_ACTIVITY_DATE
SPORT_STATUS	Identifies the person's current sport's status for the sport in this record.	VARCHAR2(63)	SGRSPRT	SGRSPRT_SPST_CODE
SPORT_STATUS_DESC	Sport status description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
SUB_ACADEMIC_PERIOD	A session, portion or part of the academic period.	VARCHAR2(63)	NA	NA
SUB_ACADEMIC_PERIOD_DESC	Sub academic period description.	VARCHAR2(255)	NA	NA

Ver: 9.1