User

view: user {
  sql_table_name: "User" ;;

  dimension: user_id_modifier {
    type: int
    sql: ${TABLE}.UserIdModifier ;;
  }

  dimension: authorization_level {
    type: yesno
    sql: ${TABLE}.AuthorizationLevel ;;
  }

  dimension: background_summary {
    sql: ${TABLE}.BackgroundSummary ;;
  }

  dimension: black_berry_pin {
    sql: ${TABLE}.BlackBerryPIN ;;
  }

  dimension: connection_string {
    sql: ${TABLE}.ConnectionString ;;
  }

  dimension: device_token {
    sql: ${TABLE}.DeviceToken ;;
  }

  dimension: display_name {
    sql: ${TABLE}.DisplayName ;;
  }

  dimension: does_user_have_read_only_access {
    sql: ${TABLE}.DoesUserHaveReadOnlyAccess ;;
  }

  dimension: email {
    sql: ${TABLE}.Email ;;
  }

  dimension: email_delivery_status_enum {
    type: yesno
    sql: ${TABLE}.EmailDeliveryStatusEnum ;;
  }

  dimension: failed_login_count {
    type: yesno
    sql: ${TABLE}.FailedLoginCount ;;
  }

  dimension: guid {
    sql: ${TABLE}.Guid ;;
  }

  dimension: has_mobile_api_access {
    sql: ${TABLE}.HasMobileApiAccess ;;
  }

  dimension: headshot_file_data {
    sql: ${TABLE}.HeadshotFileData ;;
  }

  dimension: headshot_mime_type {
    sql: ${TABLE}.HeadshotMimeType ;;
  }

  dimension: is_locked_out {
    sql: ${TABLE}.IsLockedOut ;;
  }

  dimension: is_mobile_phone_number_public {
    sql: ${TABLE}.IsMobilePhoneNumberPublic ;;
  }

  dimension: is_permissible_recruiter {
    sql: ${TABLE}.IsPermissibleRecruiter ;;
  }

  dimension: is_super_user {
    sql: ${TABLE}.IsSuperUser ;;
  }

  dimension: job_role_summary {
    sql: ${TABLE}.JobRoleSummary ;;
  }

  dimension: latest_promoter_clout {
    type: number
    sql: ${TABLE}.LatestPromoterClout ;;
  }

  dimension: latest_recruiter_clout {
    type: number
    sql: ${TABLE}.LatestRecruiterClout ;;
  }

  dimension: max_allowed_idle_minutes {
    type: int
    sql: ${TABLE}.MaxAllowedIdleMinutes ;;
  }

  dimension: mobile_api_auth_token {
    sql: ${TABLE}.MobileApiAuthToken ;;
  }

  dimension: mobile_app_version {
    sql: ${TABLE}.MobileAppVersion ;;
  }

  dimension: mobile_delivery_status_enum {
    type: yesno
    sql: ${TABLE}.MobileDeliveryStatusEnum ;;
  }

  dimension: mobile_device_type_enum {
    type: yesno
    sql: ${TABLE}.MobileDeviceTypeEnum ;;
  }

  dimension: mobile_phone_number {
    sql: ${TABLE}.MobilePhoneNumber ;;
  }

  dimension: organization_id {
    type: int
    sql: ${TABLE}.OrganizationId ;;
  }

  dimension: password_hash {
    sql: ${TABLE}.PasswordHash ;;
  }

  dimension: password_reset_token_hash {
    sql: ${TABLE}.PasswordResetTokenHash ;;
  }

  dimension: password_reset_token_salt {
    sql: ${TABLE}.PasswordResetTokenSalt ;;
  }

  dimension: password_salt {
    sql: ${TABLE}.PasswordSalt ;;
  }

  dimension: sport_email_signatures {
    sql: ${TABLE}.SportEmailSignatures ;;
  }

  dimension: start_year_at_organization {
    type: int
    sql: ${TABLE}.StartYearAtOrganization ;;
  }

  dimension: status {
    sql: ${TABLE}.Status ;;
  }

  dimension: user_id {
    type: int
    primary_key: yes
    sql: ${TABLE}.UserId ;;
  }

  dimension: user_id_creator {
    type: int
    sql: ${TABLE}.UserIdCreator ;;
  }

  dimension: user_notification_level_for_athlete_promotion_enum {
    type: yesno
    sql: ${TABLE}.<redacted> ;;
  }

  dimension: user_title_enum {
    type: int
    sql: ${TABLE}.UserTitleEnum ;;
  }

  dimension: user_type {
    type: yesno
    sql: ${TABLE}.UserType ;;
  }

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [detail*]
  }
}

- view: user
  sql_table_name: '"User"'
  fields:
  - dimension: user_id_modifier
    type: int
    sql: ${TABLE}.UserIdModifier
  - dimension: authorization_level
    type: yesno
    sql: ${TABLE}.AuthorizationLevel
  - dimension: background_summary
    sql: ${TABLE}.BackgroundSummary
  - dimension: black_berry_pin
    sql: ${TABLE}.BlackBerryPIN
  - dimension: connection_string
    sql: ${TABLE}.ConnectionString
  - dimension: device_token
    sql: ${TABLE}.DeviceToken
  - dimension: display_name
    sql: ${TABLE}.DisplayName
  - dimension: does_user_have_read_only_access
    sql: ${TABLE}.DoesUserHaveReadOnlyAccess
  - dimension: email
    sql: ${TABLE}.Email
  - dimension: email_delivery_status_enum
    type: yesno
    sql: ${TABLE}.EmailDeliveryStatusEnum
  - dimension: failed_login_count
    type: yesno
    sql: ${TABLE}.FailedLoginCount
  - dimension: guid
    sql: ${TABLE}.Guid
  - dimension: has_mobile_api_access
    sql: ${TABLE}.HasMobileApiAccess
  - dimension: headshot_file_data
    sql: ${TABLE}.HeadshotFileData
  - dimension: headshot_mime_type
    sql: ${TABLE}.HeadshotMimeType
  - dimension: is_locked_out
    sql: ${TABLE}.IsLockedOut
  - dimension: is_mobile_phone_number_public
    sql: ${TABLE}.IsMobilePhoneNumberPublic
  - dimension: is_permissible_recruiter
    sql: ${TABLE}.IsPermissibleRecruiter
  - dimension: is_super_user
    sql: ${TABLE}.IsSuperUser
  - dimension: job_role_summary
    sql: ${TABLE}.JobRoleSummary
  - dimension: latest_promoter_clout
    type: number
    sql: ${TABLE}.LatestPromoterClout
  - dimension: latest_recruiter_clout
    type: number
    sql: ${TABLE}.LatestRecruiterClout
  - dimension: max_allowed_idle_minutes
    type: int
    sql: ${TABLE}.MaxAllowedIdleMinutes
  - dimension: mobile_api_auth_token
    sql: ${TABLE}.MobileApiAuthToken
  - dimension: mobile_app_version
    sql: ${TABLE}.MobileAppVersion
  - dimension: mobile_delivery_status_enum
    type: yesno
    sql: ${TABLE}.MobileDeliveryStatusEnum
  - dimension: mobile_device_type_enum
    type: yesno
    sql: ${TABLE}.MobileDeviceTypeEnum
  - dimension: mobile_phone_number
    sql: ${TABLE}.MobilePhoneNumber
  - dimension: organization_id
    type: int
    sql: ${TABLE}.OrganizationId
  - dimension: password_hash
    sql: ${TABLE}.PasswordHash
  - dimension: password_reset_token_hash
    sql: ${TABLE}.PasswordResetTokenHash
  - dimension: password_reset_token_salt
    sql: ${TABLE}.PasswordResetTokenSalt
  - dimension: password_salt
    sql: ${TABLE}.PasswordSalt
  - dimension: sport_email_signatures
    sql: ${TABLE}.SportEmailSignatures
  - dimension: start_year_at_organization
    type: int
    sql: ${TABLE}.StartYearAtOrganization
  - dimension: status
    sql: ${TABLE}.Status
  - dimension: user_id
    type: int
    primary_key: true
    sql: ${TABLE}.UserId
  - dimension: user_id_creator
    type: int
    sql: ${TABLE}.UserIdCreator
  - dimension: user_notification_level_for_athlete_promotion_enum
    type: yesno
    sql: ${TABLE}.<redacted>
  - dimension: user_title_enum
    type: int
    sql: ${TABLE}.UserTitleEnum
  - dimension: user_type
    type: yesno
    sql: ${TABLE}.UserType
  - dimension_group: daily_notifications_unsubscribe_date_utc
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.DailyNotificationsUnsubscribeDateUtc
  - dimension_group: date_created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.DateCreated
  - dimension_group: date_modified
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.DateModified
  - dimension_group: last_activity
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.LastActivity
  - dimension_group: last_login
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.LastLogin
  - dimension_group: mobile_api_last_request_date_utc
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.MobileApiLastRequestDateUtc
  - dimension_group: mobile_api_last_user_activity_date_utc
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.MobileApiLastUserActivityDateUtc
  - dimension_group: password_reset_token_date_created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.PasswordResetTokenDateCreated
  - dimension_group: setup_date_utc
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.SetupDateUtc
  - measure: count
    type: count
    drill_fields:
    - detail*