claim_rx_clinical

Information about clinical diagnoses associated with an RX claim

Primary Key:

• claim_rx_clinical_id

Checks:

• claim_rx_clinical_diagnosis_code_check - ((diagnosis_code = upper(diagnosis_code)) AND (diagnosis_code <> ''::text))

Foreign Keys:

• claim_id => claim.claim_id

Indexes:

• claim_rx_clinical_claim_id_claim_rx_clinical_index_idx - claim_id, claim_rx_clinical_index

Column	Data Type	Nullable	Indexed	Description
claim_rx_clinical_id	bigint	No	Yes	Snowflake ID for the RX clinical diagnosis Generated through expression:
claim_id	bigint	No	Yes	Links to the claim record Generated through expression:
claim_rx_clinical_index	smallint	No	Yes	Defines the order of clinical records found in the claim (from NCPDP 491-VE) Generated through expression:
diagnosis_code_qualifier	text	No	No	Indicates the type of diagnosis code used (from NCPDP 492-WE) Generated through expression:
diagnosis_code	text	No	No	Indicates the type of diagnosis code used (from NCPDP 424-DO) Generated through expression: