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