All values associated with a claim are stored in the Claim External Value record. The OPER_PROV_SEC_ID table holds secondary (legacy) identifiers for the operating provider.
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
OPER_PROV_SEC_QUAL
VARCHAR
No
This item holds a qualifier describing additional IDs used to identify the operating provider.
4
OPER_PROV_SEC_ID
VARCHAR
No
This item holds additional IDs for the operating provider.