OTHER_PROV

Description: |
All values associated with a claim are stored in the Claim External Value record. The OTHER_PROV table holds other provider values set by the system during claims processing or by user edits. These values are only filled for paper UB claims.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
RECORD_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | RECORD_ID | NUMERIC | No |
The unique identifier for the claim record.
2 | LINE | INTEGER | No |
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3 | PPR_OTH_NAM_LAST | VARCHAR | No |
This item holds the other provider's last name.
4 | PPR_OTH_NAM_FIRST | VARCHAR | No |
This item holds the other provider's first name.
5 | PPR_OTH_NAM_MID | VARCHAR | No |
This item holds the other provider's middle name.
6 | PPR_OTH_NAM_SUF | VARCHAR | No |
This item holds the suffix to the other provider's name (Jr, III, etc).
7 | PPR_OTH_NPI | VARCHAR | No |
This item holds the other provider's National Provider ID (NPI).
8 | PPR_OTH_SEC_QUAL | VARCHAR | No |
This item holds a qualifier describing additional ID used to identify the other provider.
9 | PPR_OTH_SEC_ID | VARCHAR | No |
This item holds an additional ID for the other provider.
10 | PPR_OTH_TYP_QUAL | VARCHAR | No |
This item holds the other provider's provider type qualifier.