claim_rx_workers_comp_pay_to
Pay-to information related to workers' compensation for RX claims
Foreign Keys:address_id=>address_seen.address_idclaim_id=>claim.claim_id
claim_rx_workers_comp_pay_to_address_id_idx-address_idclaim_rx_workers_comp_pay_to_claim_id_idx-claim_id
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
claim_id | bigint | No | Yes | Links to the claim record Generated through expression: |
billing_entity_type | billing_entity_type | Yes | No | Billing entity type (from NCPDP 117-TR) Generated through expression: |
name | text | No | No | Name of entity to receive payment (from NCPDP 120-TU) Generated through expression: |
npi | text | No | No | National Provider Identifier for the entity to receive payment (from NCPDP 119-TT) Generated through expression: |
tax_identifier | text | No | No | Federal tax identifier for the entity to receive payment (from NCPDP 119-TT) Generated through expression: |
address_id | bigint | Yes | Yes | Address of the entity to receive payment (from NCPDP 121-TV [street address], 122-TW [city], 123-TX [state], 124-TY [ZIP]) Generated through expression: |