claim_member_receive_time_view

Materialized: true

Definition

 SELECT claim.claim_member_id,
    max(tps.receive_time) AS receive_time
   FROM (claims.claim
     JOIN claims.trading_partner_submission tps USING (trading_partner_submission_id))
  GROUP BY claim.claim_member_id;

Indexes:

• claim_member_receive_time_view_claim_member_id_uq (Unique) - claim_member_id
• claim_member_receive_time_view_receive_time_idx - receive_time

Column	Data Type	Indexed
claim_member_id	bigint	No
receive_time	timestamp	No