OTP_ALERT_CSN

Description: |
The contact serial numbers (CSNs) of all alerts (ALT records) that have been shown for the linked patient order template (OTP) record.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
OTP_ID | 1 |
CONTACT_DATE_REAL | 2 |
LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | OTP_ID | NUMERIC | No |
The order template 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 number that corresponds to an alert contact serial number (CSN) in the order template in this row.
4 | CONTACT_DATE | DATETIME | No |
The contact date in external format of the showing of an alert contact serial number (CSN) in the order template in this row.
5 | CM_CT_OWNER_ID | VARCHAR | No |
The ID of the deployment owner for this contact.
6 | ALERT_CSN | NUMERIC | No |
The contact serial number (CSN) of an alert in the order template in this row.