claim_rx_clinical_measurement

Information about measurements associated with a diagnosis on an RX claim

Primary Key:

• claim_rx_clinical_id
• measurement_index

Checks:

• claim_rx_clinical_measurement_measurement_value_check - (measurement_value <> ''::text)

Foreign Keys:

• claim_rx_clinical_id => claim_rx_clinical.claim_rx_clinical_id

Column	Data Type	Nullable	Indexed	Description
claim_rx_clinical_id	bigint	No	Yes	Links to the claim_rx_clinical record Generated through expression:
measurement_index	smallint	No	Yes	Defines the order of measurements for a diagnosis found in the claim (from NCPDP 493-XE) Generated through expression:
measurement_datetime	timestamp without time zone	Yes	No	Date/time the measurement was collected (from NCPDP 494-ZE [date], 495-H1 [time]) Generated through expression:
measurement_type	measurement_qualifier_type	Yes	No	Type of measurement collected (from NCPDP 496-H2) Generated through expression:
measurement_unit	unit_type	Yes	No	Units used for the measurement (from NCPDP 497-H3) Generated through expression:
measurement_value	text	No	No	The value of the measurement (from NCPDP 499-H4) Generated through expression: