member_seen_eligibility_view

Materialized: false

Definition

 SELECT me.member_seen_id,
    s.member_seen_id AS subscriber_member_seen_id,
    any_value(me.eligibility_id) AS eligibility_id,
    min(tps.submit_time) AS first_seen_time,
    max(tps.receive_time) AS last_seen_time
   FROM claims.member_eligibility me
     JOIN claims.member_eligibility s ON me.subscriber_member_eligibility_id = s.member_eligibility_id
     JOIN claims.trading_partner_submission tps ON tps.trading_partner_submission_id = me.trading_partner_submission_id
  GROUP BY me.member_seen_id, s.member_seen_id;

Column	Data Type	Indexed
member_seen_id	bigint	No
subscriber_member_seen_id	bigint	No
eligibility_id	bigint	No
first_seen_time	timestamp	No
last_seen_time	timestamp	No