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