dbt Freelance marketplace

${table}.employer Ranking

${table}.employer Ranking model for freelance marketplace.

inferred

Blocks

dbt SQL LKML LookML

${TABLE}.employer_ranking.sql · 76 lines

inferred

-- models/${TABLE}.employer_ranking.sql
{{ config(materialized='view') }}

SELECT
    RANK() OVER(PARTITION by uid order by cdate) AS rank
  , e.*
  , aa.hr_assig_with_billing AS hr_assignments_with_billing
  , aa.fp_assig_with_billing AS fp_assignments_with_billing
  , op.cnt_hr_openings_posted AS count_hr_openings_posted
  , op.cnt_fp_openings_posted AS count_fp_openings_posted
  FROM {{ this }}.employer_data AS e
  LEFT JOIN
    (SELECT
        a.employer
      , count(distinct case when a.ishr = 1 then a.assignment else null end) as hr_assig_with_billing
      , count(distinct case when a.isfp = 1 then a.assignment else null end) as fp_assig_with_billing
      FROM {{ this }}.assignment_data a
      WHERE a.include_in_generic_stats = 't'
      AND a.first_date_worked is NOT NULL
      group by 1) AS aa on e.employer = aa.employer
  LEFT JOIN
    (SELECT
        o.employer
      , count(distinct case when o.type = 'hr' then o.opening else null end) as cnt_hr_openings_posted
      , count(distinct case when o.type = 'fp' then o.opening else null end) as cnt_fp_openings_posted
      FROM {{ this }}.opening_data as o
      WHERE o.include_in_generic_stats = 't'
      AND o.cancel_initiator <> 'MQ'
      GROUP by 1) AS op on e.employer = op.employer

# models/schema.yml
version: 2

models:
  - name: ${TABLE}.employer_ranking
    columns:
      - name: hr_assignments_with_billing
      - name: fp_assignments_with_billing
      - name: count_hr_openings_posted
      - name: count_fp_openings_posted
      - name: rank
      - name: employer
      - name: user
      - name: uid
      - name: agency
      - name: fpcnt
      - name: hrcnt
      - name: cdate
      - name: first_date_worked
      - name: last_date_worked
      - name: first_opening_date
      - name: last_opening_date
      - name: hours
      - name: hours_total_7
      - name: hours_total_30
      - name: hours_offline_7
      - name: hr_charge
      - name: hr_charge_7
      - name: hr_charge_14
      - name: hr_charge_30
      - name: hr_charge_60
      - name: hr_charge_90
      - name: hr_charge_120
      - name: hr_charge_150
      - name: hr_charge_180
      - name: hr_charge_210
      - name: hr_charge_240
      - name: hr_charge_270
      - name: hr_charge_300
      - name: hr_charge_330
      - name: hr_charge_360
      - name: bonus
      - name: refund
      - name: salary
      - name: fp_charge
      - name: fp_charge_7

Assumptions

materialized='view' is the default; no persist hint found.
schema.yml columns come from view dimensions; a primary_key dimension gets unique + not_null tests.

${TABLE}.employer_ranking.sql · 26 lines

source-preserved validation: not checked

SELECT
    RANK() OVER(PARTITION by uid order by cdate) AS rank
  , e.*
  , aa.hr_assig_with_billing AS hr_assignments_with_billing
  , aa.fp_assig_with_billing AS fp_assignments_with_billing
  , op.cnt_hr_openings_posted AS count_hr_openings_posted
  , op.cnt_fp_openings_posted AS count_fp_openings_posted
  FROM ${TABLE}.employer_data AS e
  LEFT JOIN
    (SELECT
        a.employer
      , count(distinct case when a.ishr = 1 then a.assignment else null end) as hr_assig_with_billing
      , count(distinct case when a.isfp = 1 then a.assignment else null end) as fp_assig_with_billing
      FROM ${TABLE}.assignment_data a
      WHERE a.include_in_generic_stats = 't'
      AND a.first_date_worked is NOT NULL
      group by 1) AS aa on e.employer = aa.employer
  LEFT JOIN
    (SELECT
        o.employer
      , count(distinct case when o.type = 'hr' then o.opening else null end) as cnt_hr_openings_posted
      , count(distinct case when o.type = 'fp' then o.opening else null end) as cnt_fp_openings_posted
      FROM ${TABLE}.opening_data as o
      WHERE o.include_in_generic_stats = 't'
      AND o.cancel_initiator <> 'MQ'
      GROUP by 1) AS op on e.employer = op.employer

${TABLE}.employer_ranking.view.lkml · 513 lines

inferred

view: ${TABLE}.employer_ranking {
  derived_table: {
    sql: SELECT
    RANK() OVER(PARTITION by uid order by cdate) AS rank
  , e.*
  , aa.hr_assig_with_billing AS hr_assignments_with_billing
  , aa.fp_assig_with_billing AS fp_assignments_with_billing
  , op.cnt_hr_openings_posted AS count_hr_openings_posted
  , op.cnt_fp_openings_posted AS count_fp_openings_posted
  FROM ${TABLE}.employer_data AS e
  LEFT JOIN
    (SELECT
        a.employer
      , count(distinct case when a.ishr = 1 then a.assignment else null end) as hr_assig_with_billing
      , count(distinct case when a.isfp = 1 then a.assignment else null end) as fp_assig_with_billing
      FROM ${TABLE}.assignment_data a
      WHERE a.include_in_generic_stats = 't'
      AND a.first_date_worked is NOT NULL
      group by 1) AS aa on e.employer = aa.employer
  LEFT JOIN
    (SELECT
        o.employer
      , count(distinct case when o.type = 'hr' then o.opening else null end) as cnt_hr_openings_posted
      , count(distinct case when o.type = 'fp' then o.opening else null end) as cnt_fp_openings_posted
      FROM ${TABLE}.opening_data as o
      WHERE o.include_in_generic_stats = 't'
      AND o.cancel_initiator <> 'MQ'
      GROUP by 1) AS op on e.employer = op.employer ;;
  }

  dimension: hr_assignments_with_billing {
    sql: ${TABLE}.hr_assignments_with_billing ;;
  }

  dimension: fp_assignments_with_billing {
    sql: ${TABLE}.fp_assignments_with_billing ;;
  }

  dimension: count_hr_openings_posted {
    sql: ${TABLE}.count_hr_openings_posted ;;
  }

  dimension: count_fp_openings_posted {
    sql: ${TABLE}.count_fp_openings_posted ;;
  }

  dimension: rank {
    type: number
    sql: ${TABLE}.rank ;;
  }

  dimension: employer {
    type: number
    sql: ${TABLE}.employer ;;
  }

  dimension: user {
    type: number
    sql: ${TABLE}.user ;;
  }

  dimension: uid {
    sql: ${TABLE}.uid ;;
  }

  dimension: agency {
    type: number
    sql: ${TABLE}.agency ;;
  }

  dimension: fpcnt {
    type: number
    sql: ${TABLE}.fpcnt ;;
  }

  dimension: hrcnt {
    type: number
    sql: ${TABLE}.hrcnt ;;
  }

  dimension: cdate {
    sql: ${TABLE}.cdate ;;
  }

  dimension: first_date_worked {
    sql: ${TABLE}.first_date_worked ;;
  }

  dimension: last_date_worked {
    sql: ${TABLE}.last_date_worked ;;
  }

  dimension: first_opening_date {
    sql: ${TABLE}.first_opening_date ;;
  }

  dimension: last_opening_date {
    sql: ${TABLE}.last_opening_date ;;
  }

  dimension: hours {
    type: number
    sql: ${TABLE}.hours ;;
  }

  dimension: hours_total_7 {
    type: number
    sql: ${TABLE}.hours_total_7 ;;
  }

  dimension: hours_total_30 {
    type: number
    sql: ${TABLE}.hours_total_30 ;;
  }

  dimension: hours_offline_7 {
    type: number
    sql: ${TABLE}.hours_offline_7 ;;
  }

  dimension: hr_charge {
    type: number
    sql: ${TABLE}.hr_charge ;;
  }

  dimension: hr_charge_7 {
    type: number
    sql: ${TABLE}.hr_charge_7 ;;
  }

  dimension: hr_charge_14 {
    type: number
    sql: ${TABLE}.hr_charge_14 ;;
  }

  dimension: hr_charge_30 {
    type: number
    sql: ${TABLE}.hr_charge_30 ;;
  }

  dimension: hr_charge_60 {
    type: number
    sql: ${TABLE}.hr_charge_60 ;;
  }

  dimension: hr_charge_90 {
    type: number
    sql: ${TABLE}.hr_charge_90 ;;
  }

  dimension: hr_charge_120 {
    type: number
    sql: ${TABLE}.hr_charge_120 ;;
  }

  dimension: hr_charge_150 {
    type: number
    sql: ${TABLE}.hr_charge_150 ;;
  }

  dimension: hr_charge_180 {
    type: number
    sql: ${TABLE}.hr_charge_180 ;;
  }

  dimension: hr_charge_210 {
    type: number
    sql: ${TABLE}.hr_charge_210 ;;
  }

  dimension: hr_charge_240 {
    type: number
    sql: ${TABLE}.hr_charge_240 ;;
  }

  dimension: hr_charge_270 {
    type: number
    sql: ${TABLE}.hr_charge_270 ;;
  }

  dimension: hr_charge_300 {
    type: number
    sql: ${TABLE}.hr_charge_300 ;;
  }

  dimension: hr_charge_330 {
    type: number
    sql: ${TABLE}.hr_charge_330 ;;
  }

  dimension: hr_charge_360 {
    type: number
    sql: ${TABLE}.hr_charge_360 ;;
  }

  dimension: bonus {
    type: number
    sql: ${TABLE}.bonus ;;
  }

  dimension: refund {
    type: number
    sql: ${TABLE}.refund ;;
  }

  dimension: salary {
    type: number
    sql: ${TABLE}.salary ;;
  }

  dimension: fp_charge {
    type: number
    sql: ${TABLE}.fp_charge ;;
  }

  dimension: fp_charge_7 {
    type: number
    sql: ${TABLE}.fp_charge_7 ;;
  }

  dimension: fp_charge_14 {
    type: number
    sql: ${TABLE}.fp_charge_14 ;;
  }

  dimension: fp_charge_30 {
    type: number
    sql: ${TABLE}.fp_charge_30 ;;
  }

  dimension: fp_charge_60 {
    type: number
    sql: ${TABLE}.fp_charge_60 ;;
  }

  dimension: fp_charge_90 {
    type: number
    sql: ${TABLE}.fp_charge_90 ;;
  }

  dimension: fp_charge_120 {
    type: number
    sql: ${TABLE}.fp_charge_120 ;;
  }

  dimension: fp_charge_150 {
    type: number
    sql: ${TABLE}.fp_charge_150 ;;
  }

  dimension: fp_charge_180 {
    type: number
    sql: ${TABLE}.fp_charge_180 ;;
  }

  dimension: fp_charge_210 {
    type: number
    sql: ${TABLE}.fp_charge_210 ;;
  }

  dimension: fp_charge_240 {
    type: number
    sql: ${TABLE}.fp_charge_240 ;;
  }

  dimension: fp_charge_270 {
    type: number
    sql: ${TABLE}.fp_charge_270 ;;
  }

  dimension: fp_charge_300 {
    type: number
    sql: ${TABLE}.fp_charge_300 ;;
  }

  dimension: fp_charge_330 {
    type: number
    sql: ${TABLE}.fp_charge_330 ;;
  }

  dimension: fp_charge_360 {
    type: number
    sql: ${TABLE}.fp_charge_360 ;;
  }

  dimension: total_charge {
    type: number
    sql: ${TABLE}.total_charge ;;
  }

  dimension: total_charge_30 {
    type: number
    sql: ${TABLE}.total_charge_30 ;;
  }

  dimension: total_charge_sans_bonus {
    type: number
    sql: ${TABLE}.total_charge_sans_bonus ;;
  }

  dimension: total_hours_actual {
    type: number
    sql: ${TABLE}.total_hours_actual ;;
  }

  dimension: total_charge_sans_bonus_180 {
    type: number
    sql: ${TABLE}.total_charge_sans_bonus_180 ;;
  }

  dimension: total_hours_actual_180 {
    type: number
    sql: ${TABLE}.total_hours_actual_180 ;;
  }

  dimension: asg_active {
    type: number
    sql: ${TABLE}.asg_active ;;
  }

  dimension: asg_closed {
    type: number
    sql: ${TABLE}.asg_closed ;;
  }

  dimension: opn_cancelled {
    type: number
    sql: ${TABLE}.opn_cancelled ;;
  }

  dimension: opn_filled {
    type: number
    sql: ${TABLE}.opn_filled ;;
  }

  dimension: opn_requested {
    type: number
    sql: ${TABLE}.opn_requested ;;
  }

  dimension: jap_in_process {
    type: number
    sql: ${TABLE}.jap_in_process ;;
  }

  dimension: jap_in_process_by_client {
    type: number
    sql: ${TABLE}.jap_in_process_by_client ;;
  }

  dimension: jap_total_by_client {
    type: number
    sql: ${TABLE}.jap_total_by_client ;;
  }

  dimension: jap_total {
    type: number
    sql: ${TABLE}.jap_total ;;
  }

  dimension: signup_date {
    sql: ${TABLE}.signup_date ;;
  }

  dimension: second_hire_date {
    sql: ${TABLE}.second_hire_date ;;
  }

  dimension: second_start_date {
    sql: ${TABLE}.second_start_date ;;
  }

  dimension: second_job_post_date {
    sql: ${TABLE}.second_job_post_date ;;
  }

  dimension: first_job_post_date {
    sql: ${TABLE}.first_job_post_date ;;
  }

  dimension: corrected_first_job_post_date {
    sql: ${TABLE}.corrected_first_job_post_date ;;
  }

  dimension: first_hr_job_post_date {
    sql: ${TABLE}.first_hr_job_post_date ;;
  }

  dimension: first_application_date {
    sql: ${TABLE}.first_application_date ;;
  }

  dimension: first_interview_date {
    sql: ${TABLE}.first_interview_date ;;
  }

  dimension: first_hire_date {
    sql: ${TABLE}.first_hire_date ;;
  }

  dimension: first_start_date {
    sql: ${TABLE}.first_start_date ;;
  }

  dimension: unique_second_start_date {
    sql: ${TABLE}.unique_second_start_date ;;
  }

  dimension: first_hr_start_date {
    sql: ${TABLE}.first_hr_start_date ;;
  }

  dimension: hv_50_hrs {
    sql: ${TABLE}.hv_50_hrs ;;
  }

  dimension: hv_150_hrs {
    sql: ${TABLE}.hv_150_hrs ;;
  }

  dimension: hv_50_hrs_mo {
    sql: ${TABLE}.hv_50_hrs_mo ;;
  }

  dimension: hv_150_hrs_mo {
    sql: ${TABLE}.hv_150_hrs_mo ;;
  }

  dimension: hv_50_hrs_sus {
    sql: ${TABLE}.hv_50_hrs_sus ;;
  }

  dimension: hv_150_hrs_sus {
    sql: ${TABLE}.hv_150_hrs_sus ;;
  }

  dimension: last_nps_score {
    sql: ${TABLE}.last_nps_score ;;
  }

  dimension: first_nps_score {
    sql: ${TABLE}.first_nps_score ;;
  }

  dimension: first_feedback_score {
    type: number
    sql: ${TABLE}.first_feedback_score ;;
  }

  dimension: last_feedback_score {
    type: number
    sql: ${TABLE}.last_feedback_score ;;
  }

  dimension: avg_fb_weighted {
    type: number
    sql: ${TABLE}.avg_fb_weighted ;;
  }

  dimension: longest_hourly_14 {
    sql: ${TABLE}.longest_hourly_14 ;;
  }

  dimension: first_fp_date_worked {
    sql: ${TABLE}.first_fp_date_worked ;;
  }

  dimension: count_hired_charge_30 {
    sql: ${TABLE}.count_hired_charge_30 ;;
  }

  dimension: first_opening {
    type: number
    sql: ${TABLE}.first_opening ;;
  }

  dimension: pipeline_status {
    sql: ${TABLE}.pipeline_status ;;
  }

  dimension: is_agency {
    sql: ${TABLE}.is_agency ;;
  }

  dimension: first_contract_date {
    sql: ${TABLE}.first_contract_date ;;
  }

  dimension: opn_total {
    type: number
    sql: ${TABLE}.opn_total ;;
  }

  dimension: include_in_generic_stats {
    sql: ${TABLE}.include_in_generic_stats ;;
  }

  dimension: total_feedback {
    sql: ${TABLE}.total_feedback ;;
  }

  dimension: total_asg {
    sql: ${TABLE}.total_asg ;;
  }

  dimension: adjusted_score {
    sql: ${TABLE}.adjusted_score ;;
  }

  measure: count {
    type: count
  }
}

${TABLE}.employer_ranking.view.lookml · 302 lines

source-preserved

- view: ${TABLE}.employer_ranking
  derived_table:
    sql: SELECT
    RANK() OVER(PARTITION by uid order by cdate) AS rank
  , e.*
  , aa.hr_assig_with_billing AS hr_assignments_with_billing
  , aa.fp_assig_with_billing AS fp_assignments_with_billing
  , op.cnt_hr_openings_posted AS count_hr_openings_posted
  , op.cnt_fp_openings_posted AS count_fp_openings_posted
  FROM ${TABLE}.employer_data AS e
  LEFT JOIN
    (SELECT
        a.employer
      , count(distinct case when a.ishr = 1 then a.assignment else null end) as hr_assig_with_billing
      , count(distinct case when a.isfp = 1 then a.assignment else null end) as fp_assig_with_billing
      FROM ${TABLE}.assignment_data a
      WHERE a.include_in_generic_stats = 't'
      AND a.first_date_worked is NOT NULL
      group by 1) AS aa on e.employer = aa.employer
  LEFT JOIN
    (SELECT
        o.employer
      , count(distinct case when o.type = 'hr' then o.opening else null end) as cnt_hr_openings_posted
      , count(distinct case when o.type = 'fp' then o.opening else null end) as cnt_fp_openings_posted
      FROM ${TABLE}.opening_data as o
      WHERE o.include_in_generic_stats = 't'
      AND o.cancel_initiator <> 'MQ'
      GROUP by 1) AS op on e.employer = op.employer
  fields:
  - dimension: hr_assignments_with_billing
    sql: ${TABLE}.hr_assignments_with_billing
  - dimension: fp_assignments_with_billing
    sql: ${TABLE}.fp_assignments_with_billing
  - dimension: count_hr_openings_posted
    sql: ${TABLE}.count_hr_openings_posted
  - dimension: count_fp_openings_posted
    sql: ${TABLE}.count_fp_openings_posted
  - dimension: rank
    type: number
    sql: ${TABLE}.rank
  - dimension: employer
    type: number
    sql: ${TABLE}.employer
  - dimension: user
    type: number
    sql: ${TABLE}.user
  - dimension: uid
    sql: ${TABLE}.uid
  - dimension: agency
    type: number
    sql: ${TABLE}.agency
  - dimension: fpcnt
    type: number
    sql: ${TABLE}.fpcnt
  - dimension: hrcnt
    type: number
    sql: ${TABLE}.hrcnt
  - dimension: cdate
    sql: ${TABLE}.cdate
  - dimension: first_date_worked
    sql: ${TABLE}.first_date_worked
  - dimension: last_date_worked
    sql: ${TABLE}.last_date_worked
  - dimension: first_opening_date
    sql: ${TABLE}.first_opening_date
  - dimension: last_opening_date
    sql: ${TABLE}.last_opening_date
  - dimension: hours
    type: number
    sql: ${TABLE}.hours
  - dimension: hours_total_7
    type: number
    sql: ${TABLE}.hours_total_7
  - dimension: hours_total_30
    type: number
    sql: ${TABLE}.hours_total_30
  - dimension: hours_offline_7
    type: number
    sql: ${TABLE}.hours_offline_7
  - dimension: hr_charge
    type: number
    sql: ${TABLE}.hr_charge
  - dimension: hr_charge_7
    type: number
    sql: ${TABLE}.hr_charge_7
  - dimension: hr_charge_14
    type: number
    sql: ${TABLE}.hr_charge_14
  - dimension: hr_charge_30
    type: number
    sql: ${TABLE}.hr_charge_30
  - dimension: hr_charge_60
    type: number
    sql: ${TABLE}.hr_charge_60
  - dimension: hr_charge_90
    type: number
    sql: ${TABLE}.hr_charge_90
  - dimension: hr_charge_120
    type: number
    sql: ${TABLE}.hr_charge_120
  - dimension: hr_charge_150
    type: number
    sql: ${TABLE}.hr_charge_150
  - dimension: hr_charge_180
    type: number
    sql: ${TABLE}.hr_charge_180
  - dimension: hr_charge_210
    type: number
    sql: ${TABLE}.hr_charge_210
  - dimension: hr_charge_240
    type: number
    sql: ${TABLE}.hr_charge_240
  - dimension: hr_charge_270
    type: number
    sql: ${TABLE}.hr_charge_270
  - dimension: hr_charge_300
    type: number
    sql: ${TABLE}.hr_charge_300
  - dimension: hr_charge_330
    type: number
    sql: ${TABLE}.hr_charge_330
  - dimension: hr_charge_360
    type: number
    sql: ${TABLE}.hr_charge_360
  - dimension: bonus
    type: number
    sql: ${TABLE}.bonus
  - dimension: refund
    type: number
    sql: ${TABLE}.refund
  - dimension: salary
    type: number
    sql: ${TABLE}.salary
  - dimension: fp_charge
    type: number
    sql: ${TABLE}.fp_charge
  - dimension: fp_charge_7
    type: number
    sql: ${TABLE}.fp_charge_7
  - dimension: fp_charge_14
    type: number
    sql: ${TABLE}.fp_charge_14
  - dimension: fp_charge_30
    type: number
    sql: ${TABLE}.fp_charge_30
  - dimension: fp_charge_60
    type: number
    sql: ${TABLE}.fp_charge_60
  - dimension: fp_charge_90
    type: number
    sql: ${TABLE}.fp_charge_90
  - dimension: fp_charge_120
    type: number
    sql: ${TABLE}.fp_charge_120
  - dimension: fp_charge_150
    type: number
    sql: ${TABLE}.fp_charge_150
  - dimension: fp_charge_180
    type: number
    sql: ${TABLE}.fp_charge_180
  - dimension: fp_charge_210
    type: number
    sql: ${TABLE}.fp_charge_210
  - dimension: fp_charge_240
    type: number
    sql: ${TABLE}.fp_charge_240
  - dimension: fp_charge_270
    type: number
    sql: ${TABLE}.fp_charge_270
  - dimension: fp_charge_300
    type: number
    sql: ${TABLE}.fp_charge_300
  - dimension: fp_charge_330
    type: number
    sql: ${TABLE}.fp_charge_330
  - dimension: fp_charge_360
    type: number
    sql: ${TABLE}.fp_charge_360
  - dimension: total_charge
    type: number
    sql: ${TABLE}.total_charge
  - dimension: total_charge_30
    type: number
    sql: ${TABLE}.total_charge_30
  - dimension: total_charge_sans_bonus
    type: number
    sql: ${TABLE}.total_charge_sans_bonus
  - dimension: total_hours_actual
    type: number
    sql: ${TABLE}.total_hours_actual
  - dimension: total_charge_sans_bonus_180
    type: number
    sql: ${TABLE}.total_charge_sans_bonus_180
  - dimension: total_hours_actual_180
    type: number
    sql: ${TABLE}.total_hours_actual_180
  - dimension: asg_active
    type: number
    sql: ${TABLE}.asg_active
  - dimension: asg_closed
    type: number
    sql: ${TABLE}.asg_closed
  - dimension: opn_cancelled
    type: number
    sql: ${TABLE}.opn_cancelled
  - dimension: opn_filled
    type: number
    sql: ${TABLE}.opn_filled
  - dimension: opn_requested
    type: number
    sql: ${TABLE}.opn_requested
  - dimension: jap_in_process
    type: number
    sql: ${TABLE}.jap_in_process
  - dimension: jap_in_process_by_client
    type: number
    sql: ${TABLE}.jap_in_process_by_client
  - dimension: jap_total_by_client
    type: number
    sql: ${TABLE}.jap_total_by_client
  - dimension: jap_total
    type: number
    sql: ${TABLE}.jap_total
  - dimension: signup_date
    sql: ${TABLE}.signup_date
  - dimension: second_hire_date
    sql: ${TABLE}.second_hire_date
  - dimension: second_start_date
    sql: ${TABLE}.second_start_date
  - dimension: second_job_post_date
    sql: ${TABLE}.second_job_post_date
  - dimension: first_job_post_date
    sql: ${TABLE}.first_job_post_date
  - dimension: corrected_first_job_post_date
    sql: ${TABLE}.corrected_first_job_post_date
  - dimension: first_hr_job_post_date
    sql: ${TABLE}.first_hr_job_post_date
  - dimension: first_application_date
    sql: ${TABLE}.first_application_date
  - dimension: first_interview_date
    sql: ${TABLE}.first_interview_date
  - dimension: first_hire_date
    sql: ${TABLE}.first_hire_date
  - dimension: first_start_date
    sql: ${TABLE}.first_start_date
  - dimension: unique_second_start_date
    sql: ${TABLE}.unique_second_start_date
  - dimension: first_hr_start_date
    sql: ${TABLE}.first_hr_start_date
  - dimension: hv_50_hrs
    sql: ${TABLE}.hv_50_hrs
  - dimension: hv_150_hrs
    sql: ${TABLE}.hv_150_hrs
  - dimension: hv_50_hrs_mo
    sql: ${TABLE}.hv_50_hrs_mo
  - dimension: hv_150_hrs_mo
    sql: ${TABLE}.hv_150_hrs_mo
  - dimension: hv_50_hrs_sus
    sql: ${TABLE}.hv_50_hrs_sus
  - dimension: hv_150_hrs_sus
    sql: ${TABLE}.hv_150_hrs_sus
  - dimension: last_nps_score
    sql: ${TABLE}.last_nps_score
  - dimension: first_nps_score
    sql: ${TABLE}.first_nps_score
  - dimension: first_feedback_score
    type: number
    sql: ${TABLE}.first_feedback_score
  - dimension: last_feedback_score
    type: number
    sql: ${TABLE}.last_feedback_score
  - dimension: avg_fb_weighted
    type: number
    sql: ${TABLE}.avg_fb_weighted
  - dimension: longest_hourly_14
    sql: ${TABLE}.longest_hourly_14
  - dimension: first_fp_date_worked
    sql: ${TABLE}.first_fp_date_worked
  - dimension: count_hired_charge_30
    sql: ${TABLE}.count_hired_charge_30
  - dimension: first_opening
    type: number
    sql: ${TABLE}.first_opening
  - dimension: pipeline_status
    sql: ${TABLE}.pipeline_status
  - dimension: is_agency
    sql: ${TABLE}.is_agency
  - dimension: first_contract_date
    sql: ${TABLE}.first_contract_date
  - dimension: opn_total
    type: number
    sql: ${TABLE}.opn_total
  - dimension: include_in_generic_stats
    sql: ${TABLE}.include_in_generic_stats
  - dimension: total_feedback
    sql: ${TABLE}.total_feedback
  - dimension: total_asg
    sql: ${TABLE}.total_asg
  - dimension: adjusted_score
    sql: ${TABLE}.adjusted_score
  - measure: count
    type: count

${TABLE}.employer_ranking.sql
${TABLE}.employer_ranking.sql
${TABLE}.employer_ranking.view.lkml
${TABLE}.employer_ranking.view.lookml

${table}.employer Ranking

Blocks

Assumptions

Contents