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.