SPOC_PARTICIPANTS
Description:
List of participants on the plan of care tracked over versions as the plan is updated.

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 PART_TYPE_C_NAME VARCHAR No
The type category ID for a plan of care participant.
May contain organization-specific values: No
Category Entries:
Provider
Patient
Relation
Community Member
6 PART_PROV_ID VARCHAR No
The unique ID of the provider added as a plan of care participant.
7 PART_COMM_MEM VARCHAR No
This item contains the free text name of a community member participating in the creation of the plan of care.
8 PART_COMM_MEM_CNCT VARCHAR No
This item contains user entered contact information about a community member participant.
9 PART_COMM_MEM_REL VARCHAR No
This item contains the relationship to the patient of a free text community member added to the plan of care.
10 PART_DISCIPLINE_ID VARCHAR No
The unique ID of the discipline for the plan of care participant.
11 PART_DISCIPLINE_ID_DISC_NAME VARCHAR No
The name of the discipline record.
12 PART_ROLE_C_NAME VARCHAR No
The role category ID for a plan of care participant.
May contain organization-specific values: No
Category Entries:
Contributor
Reviewer
Owner
13 PART_CMT VARCHAR No
This item contains comments about the participants. Comments up to 100 characters are allowed.
14 PART_SIGNER_YN VARCHAR No
Indicates whether the participant in required to sign the plan of care.
May contain organization-specific values: No
Category Entries:
No
Yes
15 PART_SIGNED_YN VARCHAR No
Indicates whether the participant has signed the plan of care.
May contain organization-specific values: No
Category Entries:
Not Signed
Signed
Declined
Sent For Signature
16 PART_SIG_DATE DATETIME No
The date when the participant signed the plan of care.
17 PART_SIG_MTHD_C_NAME VARCHAR No
The signing method category ID for a plan of care participant.
May contain organization-specific values: No
Category Entries:
Mark as Signed
Re-Authentication
E-Signature
18 PART_MK_SIG_RSN_C_NAME VARCHAR No
The mark as signed reason category ID for the plan of care participant.
May contain organization-specific values: Yes
Category Entries:
Participant Signed on Paper
Other (See Comment)
19 PART_MK_SIG_CMT VARCHAR No
This item contains a comment for the reason a participant was marked as signed.
20 PART_CONTACT_RLA_ID NUMERIC No
The unique ID of the patient contact added as a participant for a plan of care.
21 PART_DECLN_RSN_C_NAME VARCHAR No
The decline reason category ID for a plan of care participant.
May contain organization-specific values: Yes
Category Entries:
Refused to Sign
Unable to Sign
Other (See Comment)
22 PART_DECLN_RSN_CMT VARCHAR No
This item contains the comment for the reason a participant declined to sign the plan.
23 PART_EXTEND_ROLE_C_NAME VARCHAR No
The extended role category ID for the plan of care participant.
May contain organization-specific values: Yes
24 PART_AGRMNT_TYP_C_NAME VARCHAR No
The agreement participant type category ID for participants on an agreement.
May contain organization-specific values: No
Category Entries:
Subject
Signer
25 PART_CONT_STATUS_C_NAME VARCHAR No
This item stores the contribution status for the corresponding participant on a plan of care.
May contain organization-specific values: No
Category Entries:
Has Not Contributed
Has Contributed
26 PART_CONTRIBN_UTC_DTTM DATETIME (UTC) No
This item stores the instant the contribution for the corresponding participant was recorded on the plan of care.
27 PART_COMM_MEM_PAT_FACING_NAME VARCHAR No
This item contains the free text patient-facing name of a community member participating in the creation of the plan of care.
28 PART_SIG_DOCUMENT_ID VARCHAR No
The linked E-Signature document for a given participant.