Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACADEMIC_TIME_KEY	Key for the academic time dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	ATHLETIC
ATHLETIC_COUNT_KEY	Key for the athletic count.	NUMBER	ETL_GENERATED	NA	NO	NO	ATHLETIC
ATHLETIC_FIRST_YEAR	Initial or earliest academic year of participation in this sport.	NUMBER	FUNCTION	NVL((SELECT MIN(ACADEMIC_YEAR) FROM MST_SPORT SPORT WHERE SPORT.PERSON_UID = A.PERSON_UID AND SPORT.ACTIVITY = A.ACTIVITY),'1900')	NO	NO	ATHLETIC
ATHLETIC_GROUP_KEY	Key for the athletic group.	NUMBER	ETL_GENERATED	NA	NO	NO	ATHLETIC
ATHLETIC_KEY	Key for the athletic dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	ATHLETIC
ATHLETIC_LAST_YEAR	Last or latest academic year of participation in this sport.	NUMBER	FUNCTION	NVL((SELECT MIN(ACADEMIC_YEAR) FROM MST_SPORT SPORT WHERE SPORT.PERSON_UID = A.PERSON_UID AND SPORT.ACTIVITY = A.ACTIVITY),'1900')	NO	NO	ATHLETIC
BEGIN_ACADPD_OF_ELIG_KEY	Initial or earliest academic period of eligibility to participate in this sport.	NUMBER	ETL_GENERATED	NA	NO	NO	ATHLETIC
DEMOGRAPHIC_KEY	Key for the demographic dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	ATHLETIC
END_ACADPD_OF_ELIG_KEY	Last or latest academic year of eligibility to participate in this sport.	NUMBER	ETL_GENERATED	NA	NO	NO	ATHLETIC
MULTI_SOURCE_KEY	Key for the multi source dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	ATHLETIC
PERSON_UID	Key for the person dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	ATHLETIC
SEASONS_COMPETITION_AVAILABLE	Seasons of competition available to be used by the person in this sport.	NUMBER	SPORT	SEASONS_COMPETITION_AVAILABLE	NO	NO	ATHLETIC
SEASONS_COMPETITION_REMAINING	Seasons of competition approved for the person in this sport. This is a calculated value based on the original number of seasons of competition and number recorded for the person.	NUMBER	SPORT	SEASONS_COMPETITION_REMAINING	NO	NO	ATHLETIC
SEASONS_COMPETITION_USED	Seasons of competition used by the person in this sport. This is a calculated value based on the original number of seasons of competition and number recorded for the person.	NUMBER	SPORT	SEASONS_COMPETITION_USED	NO	NO	ATHLETIC
STUDENT_ACTIVITY_KEY	Key for the student activity dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	ATHLETIC
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL_GENERATED	NA	NO	NO	ATHLETIC
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL_GENERATED	NA	NO	NO	ATHLETIC

Ver: 9.0