SERVICE_PLAN

Description: |
The SERVICE_PLAN table contains high-level information about service plans. Most workflow-related information in PLN is overtime and found in the SERVICE_PLAN_VERSION table.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
SERVICE_PLAN_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | SERVICE_PLAN_ID | NUMERIC | No |
The unique identifier (.1 item) for the service plan record.
2 | RECORD_STATUS_C_NAME | VARCHAR | No |
Stores the record status (hidden, soft-deleted, etc...). Category values are stored in table ZC_RECORD_STATUS_2.
May contain organization-specific values: No
Category Entries:
Soft Deleted
Hidden
Hidden and Soft Deleted
3 | COMMENT_NOTE_ID | VARCHAR | No |
The note record that contains comments for all versions of the service plan.
4 | RECORD_CREATION_DATE | DATETIME | No |
Stores the date the record was created
5 | PAT_ID | VARCHAR | No |
The ID of the patient to whom this plan belongs. This value is populated for plans associated with a Compass Rose episode.