|
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. |
|
|