ACT_PW_COMP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Act pw comp |
Definition: | Pathway components on the activity data model |
Table Type: | ACTIVITY |
Column Detail - ACT_PW_COMP
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVATED_DT_TM | DATETIME | Y | Date and time the component was activated |
ACTIVATED_IND | DOUBLE | Y | Indicator that the component has been activated |
ACTIVATED_PRSNL_ID | DOUBLE | N | Id of the person who activated the component |
ACTIVATED_TZ | DOUBLE | Y | Time zone associated with the corresponding dt_tm column. |
ACTIVE_IND | DOUBLE | Y | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ACT_CARE_CAT_ID | DOUBLE | N | Id of the activity care category this component is associated with |
ACT_PW_COMP_GROUP_NBR | DOUBLE | N | A numeric identifier that groups protocol and treatment period components |
ACT_PW_COMP_ID | DOUBLE | N | Unique id of this component |
ACT_TIME_FRAME_ID | DOUBLE | N | ## OBSOLETE ## Id of the activity time frame this component is associated with |
AFTER_QTY | DOUBLE | Y | The offset quantity of age_units_cd that this component starts after the time frame the component is associated with starts |
AGE_UNITS_CD | DOUBLE | N | The time unit code for the after_qty field |
CANCELED_DT_TM | DATETIME | Y | Date and time the component was cancelled |
CANCELED_IND | DOUBLE | Y | Indicates if the component has been cancelled |
CAPTURE_VARIANCE_IND | DOUBLE | Y | Indicator used to define if a variance will be captured at result entry time for result outcome component types |
CHEMO_IND | DOUBLE | N | This field is used to mark the component as the chemo medication. |
CHEMO_RELATED_IND | DOUBLE | N | This field is used to mark the component as related to the chemo medication. |
COMP_LABEL | VARCHAR(255) | Y | Textual description of the component for label component type components |
COMP_STATUS_CD | DOUBLE | N | Status code of the component |
COMP_TYPE_CD | DOUBLE | N | Component type code |
COND_DESC | VARCHAR(100) | Y | Textual description of the condition associated with this component |
COND_EVAL_DT_TM | DATETIME | Y | Date and time the condition was evaluated |
COND_EVAL_IND | DOUBLE | Y | Indicates if the condition has been evaluated |
COND_EVAL_PRSNL_ID | DOUBLE | N | Id of the person who evaluated the condition. |
COND_EVAL_RESULT_IND | DOUBLE | Y | 1 = true, 0 = false when the condition was last evaluated |
COND_FALSE_IND | DOUBLE | Y | If the condition is met (component should be included) when condition is false, this indicator should be set to 1. |
COND_IND | DOUBLE | Y | Does this component have an active condition defined for it |
COND_MODULE_NAME | VARCHAR(30) | Y | The MODULE_NAME from the EKS_MODULE table that is used to evaluate the condition |
COND_NOTE_ID | DOUBLE | N | Id of textual information on the long_text table associated with the condition for this component |
COND_SYS_EVAL_IND | DOUBLE | Y | Denotes if the condition was evaluated by the system. If this is 1, then the condition was evaluated by a EKM script. |
CREATED_DT_TM | DATETIME | Y | Date and time the component was created |
CREATED_TZ | DOUBLE | Y | Time zone associated with the corresponding dt_tm column. |
CROSS_PHASE_GROUP_IND | DOUBLE | N | Identifies whether or not the component is active in a cross phase group. |
CROSS_PHASE_GROUP_NBR | DOUBLE | N | Identifier of a cross phase component group that the component belongs to. |
DCP_CLIN_CAT_CD | DOUBLE | N | Entry on codeset 16389 that identifies the clinical category of the component within the plan. |
DCP_CLIN_SUB_CAT_CD | DOUBLE | N | Entry on codeset 29700 that identifies the clinical sub category of the component within the pathway. |
DCP_FORMS_REF_ID | DOUBLE | N | ID of the form that will be used to capture a variance for the outcome |
DEFAULT_ORD_SENT_DISP | VARCHAR(255) | Y | Display string for the default order sentence associated with the plan orderable component. |
DEFAULT_OS_IND | DOUBLE | N | Indicates whether pre-defined order sentences should be considered as the default order sentence for the order component. |
DISCONTINUE_TYPE_FLAG | DOUBLE | Y | Provides additional information about the discontinued state of this component. 0 = no additional info, 1 = discontinued by Phase |
DISPLAY_FORMAT_XML | VARCHAR(1000) | N | Contains the display format attributes of the component. |
DOSE_INFO_HIST_BLOB_ID | DOUBLE | N | This field contains the dose information history of the component |
DURATION_QTY | DOUBLE | Y | Quantity of the duration this component lasts for. Used for result outcome type components. |
DURATION_UNIT_CD | DOUBLE | N | Time unit code of of the duration this component lasts for |
ENCNTR_ID | DOUBLE | N | This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number. |
END_DT_TM | DATETIME | Y | The end date and time for this component as calculated by taking the time frame start and end date and time and applying the component offset and duration |
EVENT_CD | DOUBLE | N | The event code associated with the DTA for a result outcome component |
EXISTING_IND | DOUBLE | Y | Indicates the order was existing before the pathway component was created and is being referenced by the pathway component |
INCLUDED_DT_TM | DATETIME | Y | Date and time the component was included |
INCLUDED_IND | DOUBLE | Y | Indicates the component is included in the pathway |
INCLUDED_TZ | DOUBLE | Y | Time zone associated with the corresponding dt_tm column. |
LAST_ACTION_SEQ | DOUBLE | Y | Sequence of the last action to take place on this component |
LINKED_TO_TF_IND | DOUBLE | Y | Indicates that this component is linked to the time frame to determine it's duration. |
LOCK_TARGET_DOSE_FLAG | DOUBLE | N | Lock target dose flag. A flag to lock the target dose in the dose calculator. 0 = not set, 1 = off, 2 = on. |
LONG_BLOB_ID | DOUBLE | N | Unique identifier of modified component detail blob on the long blob table |
MIN_TOLERANCE_INTERVAL | DOUBLE | N | The minimum quantity of time that must past between two administrations of a medication. |
MIN_TOLERANCE_INTERVAL_UNIT_CD | DOUBLE | N | The unit of time that the minimum tolerance is given in. |
MISSING_REQUIRED_IND | DOUBLE | N | Indicates whether the order sentence in the OS_DISPLAY_LINE column on the table has all the required fields populated based on the order component format. |
OFFSET_QUANTITY | DOUBLE | Y | Component offset from the start of the phase |
OFFSET_UNIT_CD | DOUBLE | Y | component offset unit code such as days, hours, minutes |
ORDER_SENTENCE_ID | DOUBLE | N | Order sentence selected for this component |
ORIGINATING_ENCNTR_ID | DOUBLE | Y | The encounter id if the component is originally included in the plan. If the component is excluded from the plan, originally, then the value shall be 0 (unless it is included subsequentially). THIS FIELD CAN CONTAIN NULLS. |
ORIG_PRNT_ENT_ID | DOUBLE | N | Id of the parent entity when the component was originally created |
OUTCOME_FORMS_REF_ID | DOUBLE | N | The id of the form that will be used to directly document results against an outcome. |
OUTCOME_OPERATOR_CD | DOUBLE | N | Outcome operator code that determine how to evaluate the outcome (<,>,=,<=,>=,!=). Used for result outcome type components |
PARENT_ENTITY_ID | DOUBLE | N | Id of the parent entity for the component |
PARENT_ENTITY_NAME | VARCHAR(32) | Y | Name of the parent entity table |
PATHWAY_COMP_ID | DOUBLE | N | Id of the pathway_comp on the reference database |
PATHWAY_ID | DOUBLE | N | Id of the pathway this component is associated with |
PATHWAY_UUID | VARCHAR(255) | Y | The unique identifier for a component in a plan favorite or a component across all versions of a reference plan. |
PERSISTENT_IND | DOUBLE | Y | Indicate is the component will continue to display after the phase it belongs to has been initiated. |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
REFERENCE_TASK_ID | DOUBLE | N | Order task that will be used to create task for a result outcome. This field is only used for result outcome type components. |
REF_PRNT_ENT_ID | DOUBLE | N | Holds the id of the reference item that this component relates to (order_synonym, discrete task assay, long_text) |
REF_PRNT_ENT_NAME | VARCHAR(32) | Y | Name of the parent entity from the pathway_comp (reference model) for this component |
REJECT_PROTOCOL_REVIEW_IND | DOUBLE | N | Indicate whether the component is the reason for phase protocol review rejection. |
RELATED_COMP_ID | DOUBLE | N | Id of the related component that is associated with this component |
REPEAT_IND | DOUBLE | Y | Indicator to determine if the component should be performed every time the condition is met if the component is related to a condition component |
REQUIRED_IND | DOUBLE | Y | Indicator that defines the component as being required |
RESULT_TYPE_CD | DOUBLE | N | Result type code for result outcome components that defines the result type of the DTA being evaluated for the outcome |
RESULT_UNITS_CD | DOUBLE | N | Result units code value for result outcome components that are numeric |
RESULT_VALUE | DOUBLE | Y | Result value used to evaluate result outcome components |
RRF_AGE_QTY | DOUBLE | Y | Age quantity used to determine the proper reference range factor when evaluating a result outcome |
RRF_AGE_UNITS_CD | DOUBLE | N | Time units code used to define the age used to determine the reference range factor to be used when evaluating a result outcome |
RRF_SEX_CD | DOUBLE | N | Sex code value used to determine the reference range factor to be used when evaluating a result outcome |
SEQUENCE | DOUBLE | N | Sequence used to order the component within the time frame and care category the component belongs to |
START_DT_TM | DATETIME | Y | Date the component was started. Calculated from the time frame start date and time and the after_qty and age_units_cd |
TASK_ASSAY_CD | DOUBLE | N | Id of the discrete task assay used to define a result outcome |
UNLINK_START_DT_TM_IND | DOUBLE | N | Indicates whether or not the component is no longer linked to the phase start date and time. A value of 1 indicates that the component is no longer linked. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
VARIANCE_REQUIRED_IND | DOUBLE | Y | Indicator that will determine if charting a variance when a result outcome is not met during result entry will be required |
Relationship Detail - ACT_PW_COMP
Child Column in ACT_PW_COMP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DCP_FORMS_REF_ID | DCP_FORMS_REF | DCP_FORM_INSTANCE_ID |
OUTCOME_FORMS_REF_ID | DCP_FORMS_REF | DCP_FORM_INSTANCE_ID | |
ENCNTR_ID | ENCOUNTER | ENCNTR_ID | |
ORIGINATING_ENCNTR_ID | ENCOUNTER | ENCNTR_ID | |
DOSE_INFO_HIST_BLOB_ID | LONG_BLOB | LONG_BLOB_ID | |
LONG_BLOB_ID | LONG_BLOB | LONG_BLOB_ID | |
COND_NOTE_ID | LONG_TEXT | LONG_TEXT_ID | |
ORDER_SENTENCE_ID | ORDER_SENTENCE | ORDER_SENTENCE_ID | |
REFERENCE_TASK_ID | ORDER_TASK | REFERENCE_TASK_ID | |
PATHWAY_ID | PATHWAY | PATHWAY_ID | |
PATHWAY_COMP_ID | PATHWAY_COMP | PATHWAY_COMP_ID | |
PERSON_ID | PERSON | PERSON_ID |
Parent Column in ACT_PW_COMP (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ACT_PW_COMP_ID | ACT_PW_COMP_G | ACT_PW_COMP_ID |
ACT_PW_COMP_R | ACT_PW_COMP_S_ID | ||
ACT_PW_COMP_R | ACT_PW_COMP_T_ID | ||
PW_COMP_ACTION | ACT_PW_COMP_ID | ||
PW_COMP_ACT_RELTN | ACT_PW_COMP_ID | ||
PW_VARIANCE_RELTN | OUTCOME_COMP_ID |
ACT_PW_COMP_G
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Pathway component group activity table |
Definition: | Used to define groups of components within a pathway. |
Table Type: | ACTIVITY |
Column Detail - ACT_PW_COMP_G
Column Name | Type | Null? | Definition |
---|---|---|---|
ACT_PW_COMP_G_ID | DOUBLE | N | Unique identifier of the group. |
ACT_PW_COMP_ID | DOUBLE | N | Unique identifier of a component within the group. |
ANCHOR_COMPONENT_IND | DOUBLE | N | Designates a component group member as the anchor component for the group. Only used by groups with a LINKEDCOMP type_mean. |
DESCRIPTION | VARCHAR(99) | Y | Group Description |
INCLUDED_IND | DOUBLE | N | Denotes that an item is included in the group |
LINKING_RULE_FLAG | DOUBLE | N | A flag that determines the type of linking rule to be used for the component group. Only used by groups with a LINKEDCOMP type_mean. 0 - Not Set, 1 - At Least, 2 - Exactly, and 3 - At Most. |
LINKING_RULE_QUANTITY | DOUBLE | N | A quantity to be applied in conjunction with the linking_rule_flag. Only used by groups with a LINKEDCOMP type_mean. |
OVERRIDE_REASON_FLAG | DOUBLE | N | Controls the manner in which override reasons are harvested for plan component linking groups. 0 - Tooltip only; 1 - Dialog - optional; 2 - Dialog - required |
PATHWAY_ID | DOUBLE | N | Pathway entry id from the pathway table that this group belongs to. |
PW_COMP_SEQ | DOUBLE | Y | Sequence of the component within the group. |
TYPE_MEAN | VARCHAR(12) | N | Meaning that identifies the type of group. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - ACT_PW_COMP_G
Child Column in ACT_PW_COMP_G(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ACT_PW_COMP_ID | ACT_PW_COMP | ACT_PW_COMP_ID |
PATHWAY_ID | PATHWAY | PATHWAY_ID |
Parent Column in ACT_PW_COMP_G (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ACT_PW_COMP_G_ID | ACT_PW_COMP_G_ACTION | ACT_PW_COMP_G_ID |
ACT_PW_COMP_ID | ACT_PW_COMP_G_ACTION | ACT_PW_COMP_ID |
ACT_PW_COMP_G_ACTION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | ACT_PW_COMP_G_ACTION |
Definition: | A record of actions performed on activity component groups. |
Table Type: | ACTIVITY |
Column Detail - ACT_PW_COMP_G_ACTION
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_DT_TM | DATETIME | Y | The date/time that the action was performed. |
ACTION_TZ | DOUBLE | N | The time zone in which the action was performed. |
ACT_PW_COMP_G_ACTION_ID | DOUBLE | N | Primary Key - uniquely identifies a row in the table |
ACT_PW_COMP_G_ID | DOUBLE | N | The id of the group upon which the action was performed. First column of 2-column foreign key from ACT_PW_COMP_G table. |
ACT_PW_COMP_ID | DOUBLE | N | value from the same field in the ACT_PW_COMP_G table and correlates with the ACT_PW_COMP_G_ID field to make up the compound foreign key. |
PRSNL_ID | DOUBLE | N | The id of the person who performed the action. |
REASON_CD | DOUBLE | N | A codified reason that the action was performed. |
REASON_COMMENT | VARCHAR(512) | Y | A free text reason that the action was performed. |
SEQUENCE | DOUBLE | N | A sequence to track the order in which actions were performed on the group. |
TYPE_FLAG | DOUBLE | N | A flag to designate the type of the action performed. 0 = None, 1 = Override |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - ACT_PW_COMP_G_ACTION
Child Column in ACT_PW_COMP_G_ACTION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ACT_PW_COMP_G_ID | ACT_PW_COMP_G | ACT_PW_COMP_G_ID |
ACT_PW_COMP_ID | ACT_PW_COMP_G | ACT_PW_COMP_ID | |
PRSNL_ID | PRSNL | PERSON_ID |
ACT_PW_COMP_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Pathway component relationship |
Definition: | Used to define relationships between pathway components. |
Table Type: | ACTIVITY |
Column Detail - ACT_PW_COMP_R
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | N | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
ACT_PW_COMP_S_ID | DOUBLE | N | Relationship source pathway component id from the act_pw_comp table. |
ACT_PW_COMP_T_ID | DOUBLE | N | Relationship target pathway component id from the act_pw_comp table. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
OFFSET_QTY | DOUBLE | Y | Obsolete Replaced by column OFFSET_QUANTITY (which is defined as a FLOAT datatype) |
OFFSET_QUANTITY | DOUBLE | Y | Offset quantity used to define a time offset for the relationship. |
OFFSET_UNIT_CD | DOUBLE | N | Identifies the offset unit (Minutes, Hours, Days). |
PATHWAY_ID | DOUBLE | N | Foreign key to the pathway row that owns this relationship |
TYPE_MEAN | VARCHAR(12) | N | Meaning that identifies the type of relationship. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - ACT_PW_COMP_R
Child Column in ACT_PW_COMP_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ACT_PW_COMP_S_ID | ACT_PW_COMP | ACT_PW_COMP_ID |
ACT_PW_COMP_T_ID | ACT_PW_COMP | ACT_PW_COMP_ID | |
PATHWAY_ID | PATHWAY | PATHWAY_ID |
CORR_EVENT_SET_MAPPING
Column Section | Top of Page |
Table-level Detail
Description: | Correspondence Event Set Mapping |
Definition: | This table is used to map event_Sets to other event_sets. Each mapping will be associated with a correspondence_type_cd |
Table Type: | REFERENCE |
Column Detail - CORR_EVENT_SET_MAPPING
Column Name | Type | Null? | Definition |
---|---|---|---|
CORRESPONDENCE_TYPE_CD | DOUBLE | N | The type of correspondence this mapping is valid for. |
CORR_EVENT_SET_MAPPING_ID | DOUBLE | N | Unique identifier for mapping row. |
EVENT_SET_NAME | VARCHAR(255) | N | The from event set name.Column |
INHERITANCE_FLAG | DOUBLE | N | Indicates whether the event set mapping supersedes or adds to previous event set mappings higher in the event set hierarchy. (0 indicates the mapping combines with inherited mappings, while 1 indicates that inherited mappings are discarded). |
MAPPED_EVENT_SET_NAME | VARCHAR(255) | N | The event set that the from event set is mapped to |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |