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.