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.