REI_NEXT_VISIT_PLAN

Description: |
Table containing data for a patient's fertility next visit plan. Each row corresponds to a linked patient and plan creation date.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
CYCLE_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | CYCLE_ID | NUMERIC | No |
The unique identifier (.1 item) for the cycle record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | NEXT_PLAN_PAT_ID | VARCHAR | No |
Stores the ID of the patient that this next visit plan is for.
4 | PLAN_DATE | DATETIME | No |
Stores the date of the plan creation date.
5 | RETURN_DATE | DATETIME | No |
Planned return date for the patient for this plan.
6 | PLAN_COMMENT_VALUE | VARCHAR | No |
Stores the value of the saved comment for this next visit’s plan. Comments are limited to a maximum of 4000 characters.
7 | PLAN_UPDATE_UTC_DTTM | DATETIME (UTC) | No |
Instant in which this next visit’s plan was added or updated.
8 | PLAN_USER_ID | VARCHAR | No |
User ID of the provider that added or updated this next visit’s plan.
9 | PLAN_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
10 | LATEST_PLAN_YN | VARCHAR | No |
Indicates whether this plan in the group is the latest plan for this patient for this day.
May contain organization-specific values: No
Category Entries:
No
Yes
11 | REI_PLAN_STATUS_C_NAME | VARCHAR | No |
Stores the status of this plan.
May contain organization-specific values: No
Category Entries:
Not Started
In Progress
Ready for Review
Ready for Follow-Ups
Follow-Ups Completed
Deleted