data.ml
LookML Social network sport

Athlete

Athlete model for social network sport.

source-preserved

Blocks

athlete.view.lkml · 354 lines
inferred 
view: athlete {
  sql_table_name: Athlete ;;

  dimension: athlete_id {
    type: int
    primary_key: yes
    sql: ${TABLE}.AthleteId ;;
  }

  dimension: actcomposite {
    sql: ${TABLE}.ACTComposite ;;
  }

  dimension: actenglish {
    sql: ${TABLE}.ACTEnglish ;;
  }

  dimension: actmath {
    sql: ${TABLE}.ACTMath ;;
  }

  dimension: admission_office_notes {
    sql: ${TABLE}.AdmissionOfficeNotes ;;
  }

  dimension: athlete_referrer {
    type: yesno
    sql: ${TABLE}.AthleteReferrer ;;
  }

  dimension: athletic_history {
    sql: ${TABLE}.AthleticHistory ;;
  }

  dimension: batting_stance {
    type: yesno
    sql: ${TABLE}.BattingStance ;;
  }

  dimension: commitment_level {
    type: yesno
    sql: ${TABLE}.CommitmentLevel ;;
  }

  dimension: committed_to_school {
    sql: ${TABLE}.CommittedToSchool ;;
  }

  dimension: denormalized_next_allowable_call_bylaw {
    sql: ${TABLE}.DenormalizedNextAllowableCallBylaw ;;
  }

  dimension: denormalized_next_allowable_call_reason {
    sql: ${TABLE}.DenormalizedNextAllowableCallReason ;;
  }

  dimension: denormalized_sort_score {
    type: int
    sql: ${TABLE}.DenormalizedSortScore ;;
  }

  dimension: dominant_side {
    type: yesno
    sql: ${TABLE}.DominantSide ;;
  }

  dimension: enrollment_academic_level {
    type: yesno
    sql: ${TABLE}.EnrollmentAcademicLevel ;;
  }

  dimension: fafsa_efc_amount {
    sql: ${TABLE}.FafsaEfcAmount ;;
  }

  dimension: fafsa_efc_school {
    sql: ${TABLE}.FafsaEfcSchool ;;
  }

  dimension: fafsa_pin {
    sql: ${TABLE}.FafsaPin ;;
  }

  dimension: gpa {
    type: number
    sql: ${TABLE}.Gpa ;;
  }

  dimension: height {
    type: number
    sql: ${TABLE}.Height ;;
  }

  dimension: high_school_graduation_year {
    type: int
    sql: ${TABLE}.HighSchoolGraduationYear ;;
  }

  dimension: hobbies_and_interests {
    sql: ${TABLE}.HobbiesAndInterests ;;
  }

  dimension: internal_rating_id {
    type: int
    sql: ${TABLE}.InternalRatingId ;;
  }

  dimension: is_midyear_transfer {
    sql: ${TABLE}.IsMidyearTransfer ;;
  }

  dimension: is_red_shirt {
    sql: ${TABLE}.IsRedShirt ;;
  }

  dimension: is_unweighted_gpa {
    sql: ${TABLE}.IsUnweightedGpa ;;
  }

  dimension: jersey_number_assigned {
    sql: ${TABLE}.JerseyNumberAssigned ;;
  }

  dimension: jersey_number_preferences {
    sql: ${TABLE}.JerseyNumberPreferences ;;
  }

  dimension: latest30_days_activity_total_points {
    type: int
    sql: ${TABLE}.Latest30DaysActivityTotalPoints ;;
  }

  dimension: latest365_days_activity_total_points {
    type: int
    sql: ${TABLE}.Latest365DaysActivityTotalPoints ;;
  }

  dimension: latest7_days_activity_total_points {
    type: int
    sql: ${TABLE}.Latest7DaysActivityTotalPoints ;;
  }

  dimension: latest90_days_activity_total_points {
    type: int
    sql: ${TABLE}.Latest90DaysActivityTotalPoints ;;
  }

  dimension: latest_all_time_activity_total_points {
    type: int
    sql: ${TABLE}.LatestAllTimeActivityTotalPoints ;;
  }

  dimension: latest_athlete_rank_in_class {
    type: int
    sql: ${TABLE}.LatestAthleteRankInClass ;;
  }

  dimension: latest_athlete_rank_in_class_percentile {
    type: number
    sql: ${TABLE}.LatestAthleteRankInClassPercentile ;;
  }

  dimension: latest_athlete_rank_total_points {
    type: number
    sql: ${TABLE}.LatestAthleteRankTotalPoints ;;
  }

  dimension: medical_notes {
    sql: ${TABLE}.MedicalNotes ;;
  }

  dimension: medical_status {
    type: yesno
    sql: ${TABLE}.MedicalStatus ;;
  }

  dimension: naia_id {
    sql: ${TABLE}.NaiaId ;;
  }

  dimension: ncaa_id {
    sql: ${TABLE}.NcaaId ;;
  }

  dimension: planned_college_major {
    sql: ${TABLE}.PlannedCollegeMajor ;;
  }

  dimension: preference_for_competition_level_enum {
    type: int
    sql: ${TABLE}.PreferenceForCompetitionLevelEnum ;;
  }

  dimension: preference_for_school_proximity_enum {
    type: int
    sql: ${TABLE}.PreferenceForSchoolProximityEnum ;;
  }

  dimension: preference_for_student_population_enum {
    type: yesno
    sql: ${TABLE}.PreferenceForStudentPopulationEnum ;;
  }

  dimension: promotional_cover_letter {
    sql: ${TABLE}.PromotionalCoverLetter ;;
  }

  dimension: prospect_status {
    type: yesno
    sql: ${TABLE}.ProspectStatus ;;
  }

  dimension: recommended_by_profile_id {
    type: int
    sql: ${TABLE}.RecommendedByProfileId ;;
  }

  dimension: recommended_by_user_id {
    type: int
    sql: ${TABLE}.RecommendedByUserId ;;
  }

  dimension: recruiting_class_year {
    type: number
    sql: ${TABLE}.RecruitingClassYear ;;
  }

  dimension: recruiting_class_year_offset {
    type: int
    sql: ${TABLE}.RecruitingClassYearOffset ;;
  }

  dimension: recruiting_notes {
    sql: ${TABLE}.RecruitingNotes ;;
  }

  dimension: roster_status {
    type: yesno
    sql: ${TABLE}.RosterStatus ;;
  }

  dimension: satcomposite {
    sql: ${TABLE}.SATComposite ;;
  }

  dimension: satmath {
    sql: ${TABLE}.SATMath ;;
  }

  dimension: satverbal {
    sql: ${TABLE}.SATVerbal ;;
  }

  dimension: satwriting {
    sql: ${TABLE}.SATWriting ;;
  }

  dimension: school_type {
    type: yesno
    sql: ${TABLE}.SchoolType ;;
  }

  dimension: schools_of_interest {
    sql: ${TABLE}.SchoolsOfInterest ;;
  }

  dimension: scouting_notes {
    sql: ${TABLE}.ScoutingNotes ;;
  }

  dimension: skills_deleted {
    sql: ${TABLE}.Skills_DELETED ;;
  }

  dimension: sports_played_flagged_enum {
    type: number
    sql: ${TABLE}.SportsPlayedFlaggedEnum ;;
  }

  dimension: student_id_number {
    sql: ${TABLE}.StudentIdNumber ;;
  }

  dimension: temp_high_school_graduation_year {
    type: int
    sql: ${TABLE}.TempHighSchoolGraduationYear ;;
  }

  dimension: temp_is_current_athlete {
    sql: ${TABLE}.TempIsCurrentAthlete ;;
  }

  dimension: temp_is_red_shirt {
    sql: ${TABLE}.TempIsRedShirt ;;
  }

  dimension: temp_school_type {
    type: yesno
    sql: ${TABLE}.TempSchoolType ;;
  }

  dimension: weight {
    type: number
    sql: ${TABLE}.Weight ;;
  }

  dimension_group: actnext_planned_date_tz_local {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.ACTNextPlannedDateTzLocal ;;
  }

  dimension_group: date_updated_via_questionnaire_utc {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.DateUpdatedViaQuestionnaireUtc ;;
  }

  dimension_group: denormalized_next_allowable_call_time_utc {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.DenormalizedNextAllowableCallTimeUtc ;;
  }

  dimension_group: medical_status_end {
    type: time
    timeframes: [date, week, month]
    convert_tz: no
    sql: ${TABLE}.MedicalStatusEndDate ;;
  }

  dimension_group: moved_from_prospects_on_date_utc {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.MovedFromProspectsOnDateUtc ;;
  }

  dimension_group: nlisigning_date_utc {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.NLISigningDateUtc ;;
  }

  dimension_group: satnext_planned_date_tz_local {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.SATNextPlannedDateTzLocal ;;
  }

  measure: count {
    type: count
    drill_fields: [athlete_id, internal_rating.internal_rating_id, internal_rating.display_name, athlete_team_match_history.count, athlete_team_match_history_previous.count]
  }
}
athlete.view.lookml · 236 lines
source-preserved 
- view: athlete
  sql_table_name: Athlete
  fields:
  - dimension: athlete_id
    type: int
    primary_key: true
    sql: ${TABLE}.AthleteId
  - dimension: actcomposite
    sql: ${TABLE}.ACTComposite
  - dimension: actenglish
    sql: ${TABLE}.ACTEnglish
  - dimension: actmath
    sql: ${TABLE}.ACTMath
  - dimension: admission_office_notes
    sql: ${TABLE}.AdmissionOfficeNotes
  - dimension: athlete_referrer
    type: yesno
    sql: ${TABLE}.AthleteReferrer
  - dimension: athletic_history
    sql: ${TABLE}.AthleticHistory
  - dimension: batting_stance
    type: yesno
    sql: ${TABLE}.BattingStance
  - dimension: commitment_level
    type: yesno
    sql: ${TABLE}.CommitmentLevel
  - dimension: committed_to_school
    sql: ${TABLE}.CommittedToSchool
  - dimension: denormalized_next_allowable_call_bylaw
    sql: ${TABLE}.DenormalizedNextAllowableCallBylaw
  - dimension: denormalized_next_allowable_call_reason
    sql: ${TABLE}.DenormalizedNextAllowableCallReason
  - dimension: denormalized_sort_score
    type: int
    sql: ${TABLE}.DenormalizedSortScore
  - dimension: dominant_side
    type: yesno
    sql: ${TABLE}.DominantSide
  - dimension: enrollment_academic_level
    type: yesno
    sql: ${TABLE}.EnrollmentAcademicLevel
  - dimension: fafsa_efc_amount
    sql: ${TABLE}.FafsaEfcAmount
  - dimension: fafsa_efc_school
    sql: ${TABLE}.FafsaEfcSchool
  - dimension: fafsa_pin
    sql: ${TABLE}.FafsaPin
  - dimension: gpa
    type: number
    sql: ${TABLE}.Gpa
  - dimension: height
    type: number
    sql: ${TABLE}.Height
  - dimension: high_school_graduation_year
    type: int
    sql: ${TABLE}.HighSchoolGraduationYear
  - dimension: hobbies_and_interests
    sql: ${TABLE}.HobbiesAndInterests
  - dimension: internal_rating_id
    type: int
    sql: ${TABLE}.InternalRatingId
  - dimension: is_midyear_transfer
    sql: ${TABLE}.IsMidyearTransfer
  - dimension: is_red_shirt
    sql: ${TABLE}.IsRedShirt
  - dimension: is_unweighted_gpa
    sql: ${TABLE}.IsUnweightedGpa
  - dimension: jersey_number_assigned
    sql: ${TABLE}.JerseyNumberAssigned
  - dimension: jersey_number_preferences
    sql: ${TABLE}.JerseyNumberPreferences
  - dimension: latest30_days_activity_total_points
    type: int
    sql: ${TABLE}.Latest30DaysActivityTotalPoints
  - dimension: latest365_days_activity_total_points
    type: int
    sql: ${TABLE}.Latest365DaysActivityTotalPoints
  - dimension: latest7_days_activity_total_points
    type: int
    sql: ${TABLE}.Latest7DaysActivityTotalPoints
  - dimension: latest90_days_activity_total_points
    type: int
    sql: ${TABLE}.Latest90DaysActivityTotalPoints
  - dimension: latest_all_time_activity_total_points
    type: int
    sql: ${TABLE}.LatestAllTimeActivityTotalPoints
  - dimension: latest_athlete_rank_in_class
    type: int
    sql: ${TABLE}.LatestAthleteRankInClass
  - dimension: latest_athlete_rank_in_class_percentile
    type: number
    sql: ${TABLE}.LatestAthleteRankInClassPercentile
  - dimension: latest_athlete_rank_total_points
    type: number
    sql: ${TABLE}.LatestAthleteRankTotalPoints
  - dimension: medical_notes
    sql: ${TABLE}.MedicalNotes
  - dimension: medical_status
    type: yesno
    sql: ${TABLE}.MedicalStatus
  - dimension: naia_id
    sql: ${TABLE}.NaiaId
  - dimension: ncaa_id
    sql: ${TABLE}.NcaaId
  - dimension: planned_college_major
    sql: ${TABLE}.PlannedCollegeMajor
  - dimension: preference_for_competition_level_enum
    type: int
    sql: ${TABLE}.PreferenceForCompetitionLevelEnum
  - dimension: preference_for_school_proximity_enum
    type: int
    sql: ${TABLE}.PreferenceForSchoolProximityEnum
  - dimension: preference_for_student_population_enum
    type: yesno
    sql: ${TABLE}.PreferenceForStudentPopulationEnum
  - dimension: promotional_cover_letter
    sql: ${TABLE}.PromotionalCoverLetter
  - dimension: prospect_status
    type: yesno
    sql: ${TABLE}.ProspectStatus
  - dimension: recommended_by_profile_id
    type: int
    sql: ${TABLE}.RecommendedByProfileId
  - dimension: recommended_by_user_id
    type: int
    sql: ${TABLE}.RecommendedByUserId
  - dimension: recruiting_class_year
    type: number
    sql: ${TABLE}.RecruitingClassYear
  - dimension: recruiting_class_year_offset
    type: int
    sql: ${TABLE}.RecruitingClassYearOffset
  - dimension: recruiting_notes
    sql: ${TABLE}.RecruitingNotes
  - dimension: roster_status
    type: yesno
    sql: ${TABLE}.RosterStatus
  - dimension: satcomposite
    sql: ${TABLE}.SATComposite
  - dimension: satmath
    sql: ${TABLE}.SATMath
  - dimension: satverbal
    sql: ${TABLE}.SATVerbal
  - dimension: satwriting
    sql: ${TABLE}.SATWriting
  - dimension: school_type
    type: yesno
    sql: ${TABLE}.SchoolType
  - dimension: schools_of_interest
    sql: ${TABLE}.SchoolsOfInterest
  - dimension: scouting_notes
    sql: ${TABLE}.ScoutingNotes
  - dimension: skills_deleted
    sql: ${TABLE}.Skills_DELETED
  - dimension: sports_played_flagged_enum
    type: number
    sql: ${TABLE}.SportsPlayedFlaggedEnum
  - dimension: student_id_number
    sql: ${TABLE}.StudentIdNumber
  - dimension: temp_high_school_graduation_year
    type: int
    sql: ${TABLE}.TempHighSchoolGraduationYear
  - dimension: temp_is_current_athlete
    sql: ${TABLE}.TempIsCurrentAthlete
  - dimension: temp_is_red_shirt
    sql: ${TABLE}.TempIsRedShirt
  - dimension: temp_school_type
    type: yesno
    sql: ${TABLE}.TempSchoolType
  - dimension: weight
    type: number
    sql: ${TABLE}.Weight
  - dimension_group: actnext_planned_date_tz_local
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.ACTNextPlannedDateTzLocal
  - dimension_group: date_updated_via_questionnaire_utc
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.DateUpdatedViaQuestionnaireUtc
  - dimension_group: denormalized_next_allowable_call_time_utc
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.DenormalizedNextAllowableCallTimeUtc
  - dimension_group: medical_status_end
    type: time
    timeframes:
    - date
    - week
    - month
    convert_tz: false
    sql: ${TABLE}.MedicalStatusEndDate
  - dimension_group: moved_from_prospects_on_date_utc
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.MovedFromProspectsOnDateUtc
  - dimension_group: nlisigning_date_utc
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.NLISigningDateUtc
  - dimension_group: satnext_planned_date_tz_local
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.SATNextPlannedDateTzLocal
  - measure: count
    type: count
    drill_fields:
    - athlete_id
    - internal_rating.internal_rating_id
    - internal_rating.display_name
    - athlete_team_match_history.count
    - athlete_team_match_history_previous.count

Contents

  • athlete.view.lkml
  • athlete.view.lookml