Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACADEMIC_PERIOD	Academic Period	Academic period or time frame this sport activity was recorded for the student.	VARCHAR2(63)		SGRSPRT	SGRSPRT_TERM_CODE
ACADEMIC_PERIOD_DESC	Academic Period Description	Academic period 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)		FUNCTION	GOKODSF.F_GET_DESC
ACTIVITY	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	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	Activity Category Description	Activities category description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
ACTIVITY_DESC	Activity Description	Student activity description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
ACTIVITY_TYPE	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	Activity type description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
ATHLETIC_ACADEMIC_ELIGIBLE	Athletic Academic Eligible	Athletic eligibility reporting code.	VARCHAR2(63)		SGRSPRT	SGRSPRT_SAEL_CODE
ATHLETIC_ACAD_ELIGIBLE_DESC	Athletic Academic Eligible Description	Athletic eligibility reporting code description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
ATHLETIC_AID_IND	Athletic Aid Indicator	Indicates whether the athletic sport is providing the student financial assistance.	VARCHAR2(1)		SGRSPRT	SGRSPRT_ATHL_AID_IND
ATHLETIC_SPORT_ACTIVE_IND	Athletic Sport Active Indicator	Indicates whether the student with the associated sports status is active in the sport.	VARCHAR2(1)		STVSPST	STVSPST_ACTIVE_IND
BEGIN_ACAD_PERIOD_ELIGIBLE	Begin Academic Period Eligible	Starting academic eligibility term for the athletic competition.	VARCHAR2(63)		SGRATHC	SGRATHC_ELIG_BEGIN_TERM_CODE
BEGIN_ACAD_PERIOD_ELIG_DESC	Begin Academic Period Eligible Description	Beginning academic period eligible description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
ELIGIBILITY	Eligibility	Identifies the person is eligible to participate in an official sport.	VARCHAR2(63)		SGRSPRT	SGRSPRT_ELIG_CODE
ELIGIBILITY_DESC	Eligibility Description	Eligibility code description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
END_ACAD_PERIOD_ELIGIBLE	End Academic Period Eligible	Ending academic eligibility term for the athletic competition.	VARCHAR2(63)		SGRATHC	SGRATHC_ELIG_END_TERM_CODE
END_ACAD_PERIOD_ELIGIBLE_DESC	End Academic Period Eligible Description	Ending academic period eligible description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
ID	ID	Person's or organization's current identification number.	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
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER		SGRSPRT	SGRSPRT_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
SEASONS_COMPETITION_AVAILABLE	Seasons Competition Available	Number of seasons competition is available.	NUMBER		SGRATHC	SGRATHC_SEASONS_AVAILABLE
SEASONS_COMPETITION_REMAINING	Seasons Competition Remaining	Number of remaining seasons of competition available.	NUMBER		CALCULATION	SEASONS_COMPETITION_AVAILABLE - SEASONS_COMPETITION_USED
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	Seasons Used Indicator	Indicates used season of competition.	VARCHAR2(1)		SGRATHC	SGRATHC_SEASONS_USED_IND
SEASON_CHANGE_REASON	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	Season change reason description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
SPORT_ACTIVITY_DATE	Sport Activity Date	Date record was inserted or updated.	DATE		SGRSPRT	SGRSPRT_ACTIVITY_DATE
SPORT_STATUS	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	Sport status description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
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.0