CYCLE_PLAN_STATUS

Description:

This table contains data for what cycle plans have been finalized and by whom.

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	PLAN_CARD_C_NAME	VARCHAR	No
	The cycle plan card. This item is the key for each line. May contain organization-specific values: Yes Category Entries: Cycle Details Cycle Information Oocyte Retrieval Plan Embryo Transfer Plan Inseminate Oocytes Non-ART Insemination Biopsy for PGT
4	PLAN_STATE_C_NAME	VARCHAR	No
	The state of the plan, whether it has been finalized or amended May contain organization-specific values: No Category Entries: Finalized Amended
5	PLAN_UPDATE_USER_ID	VARCHAR	No
	The user that signed or amended the plan
6	PLAN_UPDATE_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
7	PLAN_UPDATE_INSTANT_UTC_DTTM	DATETIME (UTC)	No
	The instant a plan was signed/amended
8	AMENDMENT_REASON_C_NAME	VARCHAR	No
	The reason the user is amending the plan May contain organization-specific values: Yes Category Entries: System Update - Forced Amend Other Patient Request Provider Request New Clinical Information Financial/Insurance User Error
9	AMENDMENT_REASON_COMMENT	VARCHAR	No
	The free-text reason for amending the plan