yjhuoh

[
  {
    "raw_claim_id": 10,
    "prescription_number": "9d54dyzo4a",
    "pharmacy_npi": "test",
    "incoming_laker_user_uuid": "f637d5be-c524-39a9-8e7b-86935914965e",
    "incoming_remote_subscriber_id": "1357924680",
    "incoming_person_code": "10",
    "incoming_group_name": "different_group",
    "incoming_first_name": "JASON",

yjhuoh

SELECT DISTINCT
  bt.id AS user_id
  , (FIRST_VALUE(start_date_join.value) OVER
    (PARTITION BY start_date_join.user_id
     ORDER BY start_date_join.effective_date DESC,
              start_date_join.created_at DESC))::date AS start_date
  , (FIRST_VALUE(end_date_join.value) OVER
    (PARTITION BY end_date_join.user_id
     ORDER BY end_date_join.effective_date DESC,
              end_date_join.created_at DESC))::date AS end_date

yjhuoh

SELECT
  bt.id AS user_id
  , start_date_join.value::date AS start_date
  , end_date_join.value::date AS end_date
  , coverage_level_join.value AS coverage_level
FROM ${baseTable} bt
LEFT OUTER JOIN ${dataTable} start_date_join
  ON start_date_join.user_id = bt.id
  AND start_date_join.field = 'start_date'
  AND NOT EXISTS (SELECT 1 FROM ${dataTable} field_after

yjhuoh

Keybase proof

I hereby claim:

• I am yjhuoh on github.
• I am yjhuoh (https://keybase.io/yjhuoh) on keybase.
• I have a public key whose fingerprint is C1C3 29B9 3BFE 5551 5543 80A6 08E8 DC58 B6D3 82AA

To claim this, I am signing this object: