POC_MEDICATIONS

Description: |
This table contains medication information for the Plan of Care (POC) master file.

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 plan of care record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | ORDER_MED_ID | NUMERIC | No |
The unique identifiers for order records associated with current medications that appear in the plan of care.
4 | MEDICATION_ID_MEDICATION_NAME | VARCHAR | No |
The name of this medication record.
5 | DISPLAY_NAM | VARCHAR | No |
This item contains the medication display name at time the POC was created.
6 | ORDER_CLASS_C_NAME | VARCHAR | No |
This item contains the medication order class.
May contain organization-specific values: Yes
Category Entries:
Normal
7 | PROV_ID_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
8 | FREQ_ID | VARCHAR | No |
This item contains the medication frequency.
9 | FREQ_ID_FREQ_NAME | VARCHAR | No |
The name of the frequency record.
10 | MEDICATION_DOSE | VARCHAR | No |
This item contains the medication dose.
11 | MEDICATION_ROUT_C_NAME | VARCHAR | No |
This item contains the medication route.
May contain organization-specific values: Yes
12 | MEDICATION_QTY | VARCHAR | No |
This item contains the medication quantity dispensed.
13 | MEDICATION_REFIL | VARCHAR | No |
This item contains the number of refills.
14 | MEDICATION_SIG | VARCHAR | No |
This item contains the medication sig.
15 | MEDICATION_LONG_SIG | VARCHAR | No |
This item contains the medication long sig.
16 | MEDICATION_START_DT | DATETIME | No |
This item contains the medication start date.
17 | MEDICATION_END_DT | DATETIME | No |
This item contains the medication end date.
18 | MEDICATION_CMT | VARCHAR | No |
This item contains the medication comments.
19 | MEDICATION_TAKING_DIFF_LINE | INTEGER | No |
The line to show in the plan of care if a medication on the plan of care is documented as being taken differently than prescribed.
20 | ORDER_MODE_C_NAME | VARCHAR | No |
This will store whether the medication is ordered as an inpatient or an outpatient med
May contain organization-specific values: No
Category Entries:
Outpatient
Inpatient
21 | PRN_REASONS | VARCHAR | No |
For medications on the hospice plan of care that were ordered PRN, the reason documented for taking the medication.
22 | INDICATIONS | VARCHAR | No |
Indications for a medication on a hospice plan of care.
23 | HOSPICE_CVG_C_NAME | VARCHAR | No |
This column indicates the hospice coverage status of medications which are pulled to the hospice plan of care.
May contain organization-specific values: No
Category Entries:
Hospice Covered
Not Hospice Covered
24 | DISCON_UTC_DTTM | DATETIME (UTC) | No |
This item stores the discontinued instant (UTC) of medications which are pulled to the hospice plan of care.
25 | HSPC_NONCVRD_MED_RSN_C_NAME | VARCHAR | No |
The reason a patient's medication is not covered by the hospice benefit. This appears on the Hospice Plan of Care.
May contain organization-specific values: Yes
Category Entries:
Other
26 | HSPC_NONCVRD_MED_RSN_C_CMT | VARCHAR | No |
The comment for the reason a patient's medication is not covered by the hospice benefit. This appears on the Hospice Plan of Care.
The category values for this column were already listed for column: HSPC_NONCVRD_MED_RSN_C_NAME