SPOC_NOTES
Description:
Specialty plan of care notes information.

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

Column Information
Name Type Discontinued?
1 POC_ID NUMERIC No
The unique identifier for the plan of care record.
2 CONTACT_DATE_REAL FLOAT No
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
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 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
5 SPOC_NOTE_ID VARCHAR No
The unique ID of the note for the plan of care.
6 SPOC_NOTE_CSN NUMERIC No
This item contains a link to a note contact. The note contact can be used to determine what the note contained in a particular version.
7 SPOC_NOTE_PURPOSE_C_NAME VARCHAR No
The purpose category ID for the plan of care. The purpose is used to classify the note and match it to the section which contains its definitions.
May contain organization-specific values: Yes
Category Entries:
Physician's Assessment
Nurse's Assessment
Dietitian's Assessment
Social Worker's Assessment
Therapist's Assessment
Certification Statement
Rehab Potential and Discharge Plans
Advance Care Planning
IDG Assessment
Patient Understanding
Plan Assessment
Clergy's Assessment
Bereavement
IDG Orders
Hospice Non-Covered Items, Drugs, and Services
Cutover Assessment