claim_rx_workers_comp_employer

Employer information related to workers' compensation for RX claims

Checks:

• claim_rx_workers_comp_employer_check - ((name <> ''::text) OR (address_id IS NOT NULL) OR (phone_id IS NOT NULL) OR (contact_name <> ''::text))

Foreign Keys:

• address_id => address_seen.address_id
• claim_id => claim.claim_id
• phone_id => phone.phone_id

Indexes:

• claim_rx_workers_comp_employer_address_id_idx - address_id
• claim_rx_workers_comp_employer_claim_id_idx - claim_id
• claim_rx_workers_comp_employer_phone_id_idx - phone_id

Column	Data Type	Nullable	Indexed	Description
claim_id	bigint	No	Yes	Links to the claim record Generated through expression:
name	text	No	No	Name of the employer (from NCPDP 315-CF) Generated through expression:
address_id	bigint	Yes	Yes	Employer address (from NCPDP 316-CG [street address], 317-CH [city], 318-CI [state], 319-CJ [ZIP]) Generated through expression:
phone_id	bigint	Yes	Yes	Employer phone number (from NCPDP 320-CK) Generated through expression:
contact_name	text	No	No	Primary contact for the employer (from NCPDP 321-CL) Generated through expression: