ALT_BPA_CHAIN_ID
Description:
This table holds the asynchronous OurPractice Advisory (OPA) chains that are associated with this Alert's (ALT) contact.

Primary Key
Column Name Ordinal Position
ALERT_ID 1
CONTACT_DATE_REAL 2
LINE 3

Column Information
Name Type Discontinued?
1 ALERT_ID NUMERIC No
The ALT record ID
2 CONTACT_DATE_REAL FLOAT No
This is a numeric representation of the date of this encounter in your system. The integer portion of the number specifies the date of the encounter. The digits after the decimal point indicate multiple visits on one day.
3 LINE INTEGER No
The Line Count
4 ALT_CHAIN_ID NUMERIC No
This item links alert record contacts that occur in a chain together with a unified ID.