RETURN TO BANNER EDW META DATA REPORTS LIST
Athletic Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_ATHLETIC

Description Contains participation in athletic teams data for either official or auxiliary sports. Attributes identify the sport, sport status, eligibility, athletic aid indicator for the student as well as first and last year and academic period eligibility begins and ends. Measures include numbered of seasons of competition available, used and remaining.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
ATHLETIC_ACADEMIC_ELIGIBLE Identifies the person has met the academic requirements to participate in the sport. VARCHAR2(63)

SPORT

ATHLETIC_ACADEMIC_ELIGIBLE

NO

NO ATHLETIC
ATHLETIC_ACADEMIC_ELIGIBLE_LD Long description for the athletic academic eligible code. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO ATHLETIC
ATHLETIC_ACADEMIC_ELIGIBLE_SD Short description for the athletic academic eligible code. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO ATHLETIC
ATHLETIC_AID_IND Identifies the person receiving athletic aid for participation in this sport. NUMBER

SPORT

ATHLETIC_AID_IND

NO

NO ATHLETIC
ATHLETIC_AID_IND_LD Long description for athletic aid indicator. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO ATHLETIC
ATHLETIC_AID_IND_SD Short description for athletic aid indicator. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO ATHLETIC
ATHLETIC_ELIGIBILITY Eligibility Code. VARCHAR2(63)

SPORT

ELIGIBILITY

NO

NO ATHLETIC
ATHLETIC_ELIGIBILITY_LD Long description for the eligibility code. VARCHAR2(255)

SPORT

ELIGIBILITY_DESC

NO

NO ATHLETIC
ATHLETIC_ELIGIBILITY_SD Short description for the eligibility code. VARCHAR2(255)

SPORT

ELIGIBILITY_DESC

NO

NO ATHLETIC
ATHLETIC_KEY System generated, unique, internal primary key for the multi-institution facility. NUMBER

ETL_GENERATED

NA

NO

NO ATHLETIC
ATHLETIC_SPORT_ACTIVE_IND Identifies the sport as active or not for this person in this academic period as defined on the sport status.  

FUNCTION

ATHLETIC_SPORT_ACTIVE_IND

NO

NO ATHLETIC
ATHLETIC_SPORT_ACTIVE_IND_LD Long description for the sport status active indicator. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO ATHLETIC
ATHLETIC_SPORT_ACTIVE_IND_SD Short description for the sport status active indicator. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO ATHLETIC
ATHLETIC_SPORT_STATUS Sport Status Code. VARCHAR2(63)

SPORT

SPORT_STATUS

NO

NO ATHLETIC
ATHLETIC_SPORT_STATUS_LD Long description for the sport status. VARCHAR2(255)

SPORT

SPORT_STATUS_DESC

NO

NO ATHLETIC
ATHLETIC_SPORT_STATUS_SD Short description for the sport status. VARCHAR2(255)

SPORT

SPORT_STATUS_DESC

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