REI_CYCLE_PAT_COMMENTS

Description:

Stores a patient's fertility cycle-level comment. Each line corresponds to a patient and an update to the comment.

Primary Key

Column Name	Ordinal Position
CYCLE_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	CYCLE_ID	NUMERIC	No
	Cycle ID of the cycle that this comment belongs to.
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	CYCLE_COMMENT_PAT_ID	VARCHAR	No
	Stores the patient ID of the patient that the comment is for.
4	CYCLE_COMMENT_VALUE	VARCHAR	No
	Stores the value of the saved cycle comment. Cycle comments are limited to 4000 characters.
5	CYCLE_COMMENT_UTC_DTTM	DATETIME (UTC)	No
	Instant in which the cycle comment was added or updated.
6	CYCLE_COMMENT_USER_ID	VARCHAR	No
	User ID of the provider that added or updated the cycle comment.
7	CYCLE_COMMENT_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
8	COMMENT_IS_LATEST_YN	VARCHAR	No
	Stores whether this line is the latest cycle comment for this patient. May contain organization-specific values: No Category Entries: No Yes