We use cookies from Google Analytics to improve our website. By accepting, you will receive these cookies from open.epic. Decline if you wish to use open.epic without these cookies. Read our privacy policy here.

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.