ADVICE_TEXT

Description: |
This table extracts the text that was offered as care advice.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
CA_ID | 1 |
VERSION_DATE_REAL | 2 |
LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | CA_ID_CARE_ADVICE_NAME | VARCHAR | No |
The name of the care advice record.
2 | VERSION_DATE_REAL | FLOAT | No |
This is a numeric representation of the date of this version in your system. The integer portion of the number specifies the date of the version. The digits after the decimal point indicate multiple versions on one day.
3 | LINE | INTEGER | No |
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4 | CA_TEXT | VARCHAR | No |
The text of the Care Advice given to a patient.