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(6)	SGRSPRT	SGRSPRT_TERM_CODE	NO	NO
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(4)	STVTERM	STVTERM_ACYR_CODE	NO	NO
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ACTIVITY	Activity that identifies student participation that is to be recorded. Activities may include fraternity or sorority, chess or debate clubs, etc.	VARCHAR2(8)	SGRSPRT	SGRSPRT_ACTC_CODE	NO	NO
ACTIVITY_CATEGORY	Category associated with the activity so that like activities can be grouped for reporting.	VARCHAR2(5)	STVACTC	STVACTC_ACCG_CODE	NO	NO
ACTIVITY_CATEGORY_DESC	Activities category description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ACTIVITY_DESC	Student activity description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ACTIVITY_TYPE	Specifies a broad type of activity in which the specific activity can be grouped (for example, Sports, Cultural, or Volunteer).	VARCHAR2(5)	STVACTC	STVACTC_ACTP_CODE	NO	NO
ACTIVITY_TYPE_DESC	Activity type description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ATHLETIC_ACADEMIC_ELIGIBLE		VARCHAR2(2)				NO
ATHLETIC_ACAD_ELIGIBLE_DESC		VARCHAR2(30)				NO
ATHLETIC_AID_IND	Indicates whether the athletic sport is providing the student financial assistance.	VARCHAR2(1)	SGRSPRT	SGRSPRT_ATHL_AID_IND	NO	NO
ATHLETIC_SPORT_ACTIVE_IND		VARCHAR2(1)				NO
BEGIN_ACAD_PERIOD_ELIGIBLE		VARCHAR2(6)				NO
BEGIN_ACAD_PERIOD_ELIG_DESC		VARCHAR2(30)				NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
ELIGIBILITY	Identifies the person is eligible to participate in an official sport.	VARCHAR2(2)	SGRSPRT	SGRSPRT_ELIG_CODE	NO	NO
ELIGIBILITY_DESC	Eligibility code description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
END_ACAD_PERIOD_ELIGIBLE		VARCHAR2(6)				NO
END_ACAD_PERIOD_ELIGIBLE_DESC		VARCHAR2(30)				NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SGRSPRT	SGRSPRT_PIDM	NO	NO
SEASONS_COMPETITION_AVAILABLE		NUMBER				NO
SEASONS_COMPETITION_REMAINING		NUMBER				NO
SEASONS_COMPETITION_USED		NUMBER				NO
SEASONS_USED_IND		VARCHAR2(1)				NO
SEASON_CHANGE_REASON		VARCHAR2(4)				NO
SEASON_CHANGE_REASON_DESC		VARCHAR2(30)				NO
SPORT_ACTIVITY_DATE		DATE				NO
SPORT_STATUS	Identifies the person's current sport's status for the sport in this record.	VARCHAR2(2)	SGRSPRT	SGRSPRT_SPST_CODE	NO	NO
SPORT_STATUS_DESC	Description for the sport status.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
SUB_ACADEMIC_PERIOD	A session, portion or part of the academic period.	VARCHAR2(0)	NA	NA	NO	NO
SUB_ACADEMIC_PERIOD_DESC	Sub academic period description.	VARCHAR2(0)	NA	NA	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: