The intent of this view is to create a single location to query for GraceNote results for a person regardless of if those results are individual or as a part of a team. To achieve this it unions the two marts, ais_phase_results and ais_phase_results_team_members into a single view.
This is best queried with a PERSON_ID, however the other Person metadata is attached as well.
Update Frequency
GraceNote data is synced to the AIS once a day at approx. 3:00 AM CET (11:00 AM AEST). Data Pipelines then execute at 11:30 AM and take on average about 30 minutes to complete these pipelines currently only run Monday to Friday.
Fields
The fields of the table are the same as AIS_PHASE_RESULTS/AIS_PHASE_RESULTS_TEAM_MEMBERS and as with those tables there are some helper fields and booleans for narrowing results:
IS_OLYMPICS_OR_PARA_GAMES,
IS_COMM_GAMES,
IS_WINTER_GAMES,
IS_SUMMER_GAMES,
IS_PARA_SUMMER_GAMES,
IS_PARA_WINTER_GAMES,
IS_OLYMPIC_QUAL
All of these use CompetitionSetDetails to determine a TRUE/FALSE value.
Some links exist to EED based data, these are only as good as the data contained in those tables at this point:
EED_TEAM_SIZE
EED_CYCLE,
EED_ISJNR,
IS_JRBME,
STAR_RATING,
DATA_LEAD,
AMS_LEAD,
EED_DISCIPLINE_ID,
EED_PROGRAM_ID,
EED_PROGRAM_NAME,
IS_CURRENTLY_FUNDED,
The additional fields in the table are also listed below:
PHASE_RESULT_ID,
PERSON_ID,
PERSON_NAME,
PERSON_FIRST_NAME,
PERSON_LAST_NAME,
PERSON_DOB,
PERSON_DOD,
PERSON_BIRTH_COUNTRY,
PERSON_COMPETED_AS_NAME,
PERSON_COMPETED_AS_FIRST_NAME,
PERSON_COMPETED_AS_LAST_NAME,
PERSON_COMPETED_AS_NAME_OFFICIAL,
PERSON_NATIONALITY,
PERSON_AGE_DAYS_AT_COMPETITION,
PERSON_AGE_YEARS_AT_COMPETITION,
TEAM_ID,
TEAM_NAME,
NOC_ID,
NOC,
SPORT_ID,
SPORT_NAME,
SPORT_TYPE,
CONTAINER_SPORT_ID,
CONTAINER_SPORT_GROUP,
IS_ABLE_SPORT,
IS_SUMMER_SPORT,
IS_PARALYMPIC_SPORT,
IS_OLYMPIC_SPORT,
COMPETITION_ID,
COMPETITION_NAME,
COMPETITION_DERIVED,
COMPETITION_COUNTRY,
COMPETITION_CONTINENT,
COMPETITION_CITY,
COMPETITION_SET_ID,
COMPETITION_SET,
EDITION_ID,
EDITION,
EDITION_CITY,
EDITION_STATE,
EDITION_COUNTRY,
EDITION_CONTINENT,
EDITION_START_DATE,
EDITION_END_DATE,
EDITION_NUMBER,
SEASON_ID,
SEASON,
SEASON_START_DATE,
SEASON_END_DATE,
EVENT_ID,
EVENT_GENDER,
EVENT_TEAM_SIZE_GRACENOTE,
CONTAINER_EVENT_ID,
EVENT_NAME,
EVENT_INDIV_TEAM_TYPE,
PHASE_ID,
PHASE_VENUE,
CLASS,
PHASE,
PHASE1,
PHASE2,
PHASE3,
PHASE4,
PHASE5,
PHASE1_LEVEL,
PHASE2_LEVEL,
PHASE3_LEVEL,
PHASE4_LEVEL,
PHASE5_LEVEL,
IS_EVENT_PHASE,
PHASE_CITY,
PHASE_START_DATE,
PHASE_END_DATE,
RESULT,
RESULT_TYPE,
RESULT_CODE,
RESULT_TIME_VALUE_SECONDS,
RESULT_NON_TIME_VALUE,
RESULT_SUFFIX,
RANK,
RANK_NUMBER,
RANK_MEDAL,
RANK_MEDAL_SCORE,
RANK_CORRECTION,
RANK_CORRECTION_REASON,
PREV_RANK,
TIED,
STATUS_CODE,
CREATE_DATE,
MODIFY_DATE,
START_NUMBER,
