TREATMENT_PATTERN_CYCLES

Description:

Pattern cycles in a treatment plan.

Primary Key

Column Name	Ordinal Position
TREATMENT_PLAN_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	TREATMENT_PLAN_ID	NUMERIC	No
	The unique identifier (.1 item) for the plan 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	PATTERN_CYCLE_SORT_VALUE	INTEGER	No
	Stores the Id to identify a cycle in a pattern. Note that multiple cycles can have the same Id if they are part of different patterns.
4	PATTERN_CYCLE_PATTERN_LINE	INTEGER	No
	Stores the line in SI TPL 11000 for the pattern this cycle is part of.
5	PATTERN_CYCLE_NAME	VARCHAR	No
	An override cycle name that is set on a pattern cycle. This will be set in the cycle created from that pattern cycle.
6	PATTERN_CYCLE_STATUS_C_NAME	VARCHAR	No
	The status of a pattern cycle in the plan. May contain organization-specific values: No Category Entries: Planned Started Completed Deleted Snapshot
7	PATTERN_CYCLE_LENGTH	INTEGER	No
	The length of the pattern cycle in days.
8	PATTERN_CYCLE_SRC_TYPE_C_NAME	VARCHAR	No
	The type of cycle this pattern cycle was created from. May contain organization-specific values: No Category Entries: Created From Normal Plan Cycle
9	PATTERN_CYCLE_SOURCE_LINE	INTEGER	No
	The line in the source where this cycle was created from.