Table Detail Report

PATHWAY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pathway
Definition: Pathway activity table
Table Type: ACTIVITY





Column Detail - PATHWAY


Column Name Type Null? Definition
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.
ACTUAL_END_DT_TM DATETIME Y Date and time the pathway ended.
AGE_UNITS_CD DOUBLE N The default time unit of measure used for time frames associated with this pathway.
ALERTS_ON_PLAN_IND DOUBLE N Phase level attribute to indicate whether to show alerts upon signing of a phase into a planned phase. Alerts include Interaction Checking, Discern Alerts and Dose Calculator.
ALERTS_ON_PLAN_UPD_IND DOUBLE N Phase level attribute to indicate whether to show alerts upon subsequent phase signing of a phase into a planned phase. Alerts include Interaction Checking, Discern Alerts and Dose Calculator.
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.
CALC_END_DT_TM DATETIME Y Calculated end date and time of the pathway.
CALC_END_ESTIMATED_IND DOUBLE N To indicate whether the phase end date time is estimated or precise.
CALC_END_TZ DOUBLE Y Time zone associated with the corresponding dt_tm column.
COMP_FORMS_REF_ID DOUBLE N Id from the dcp_forms_ref table of the form that will be used to capture component level variances for this pathway.
COPY_SOURCE_PATHWAY_ID DOUBLE N copy of source pathway id originated from copy DoT. This value only populates when Pathway row is being created from Copy Dot workflow. For all other cases the COPY_SOURCE_PATHWAY_ID will be zero.
CROSS_ENCNTR_IND DOUBLE N Indicates the pathway is designed to be activated across multiple encounters. These pathways will not automatically be discontinued upon discharge of the patient.
CYCLE_END_NBR DOUBLE N Indicates number to be used to default for the end cycle number while ordering the plan if the same plan is not ordered on the patient within 180 days.
CYCLE_LABEL_CD DOUBLE N Indicates the default "Cycle" label to show client defined values such as Week, Course, Etc. Code set 4002313
CYCLE_NBR DOUBLE N This field is used to store the cycle number for the plan.
DC_REASON_CD DOUBLE N Pathway discontinue reason code
DC_TEXT_ID DOUBLE N Id of the text that represents the free textdiscontinue reason.
DEFAULT_VIEW_MEAN VARCHAR(12) N This field is used to store the default view for the plan.
DESCRIPTION VARCHAR(1000) N Pathway description
DIAGNOSIS_CAPTURE_IND DOUBLE N This field is used to prompt the user to enter the diagnosis for the plan.
DISCONTINUED_DT_TM DATETIME Y Date and time the pathway was discontinued
DISCONTINUED_IND DOUBLE Y Indicates the pathway is dicontinued
DISCONTINUED_TZ DOUBLE Y Time zone associated with the corresponding dt_tm column.
DISPLAY_METHOD_CD DOUBLE N Code value field used to flex plan component display in the application.
DURATION_QTY DOUBLE Y Duration quantity for plans and phases that have a specified duration.
DURATION_UNIT_CD DOUBLE N Identifies the duration unit (Minutes, Hours, Days).
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
ENDED_IND DOUBLE Y Indicates the pathway has ended
END_EFFECTIVE_DT_TM DATETIME N 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.
FUTURE_LOCATION_FACILITY_CD DOUBLE N FUTURE LOCATION
FUTURE_LOCATION_NURSE_UNIT_CD DOUBLE N FUTURE NURSE LOCATION
LAST_ACTION_SEQ DOUBLE Y Sequence of the last action for the pathway
LINKED_PHASE_IND DOUBLE N This indicator synchronizes the start date-time of the phases within a multi-phase plan. i.e.changing the start date-time of a linked phase within the multi-phase plan will update the start date-time of the another linked phase within the same plan.
LONG_TEXT_ID DOUBLE N Id of the textual comments associated with this pathway
ORDER_DT_TM DATETIME Y Date and time the pathway was ordered
ORDER_TZ DOUBLE Y Time zone associated with the corresponding dt_tm column.
PARENT_PHASE_DESC VARCHAR(100) Y This field is used to store the display description of a parent phase for a sub phase.
PATHWAY_CATALOG_ID DOUBLE N Id of the pathway catalog this pathway was created from
PATHWAY_CLASS_CD DOUBLE N Code value field used to group pathways according to user-defined classification
PATHWAY_CUSTOMIZED_PLAN_ID DOUBLE N The unique identifier of the customized plan used to create the pathway
PATHWAY_GROUP_ID DOUBLE N The pathway_id of the phase group's parent.
PATHWAY_ID DOUBLE N Unique id of the pathway
PATHWAY_TYPE_CD DOUBLE N Code value field used to group pathways according to user-defined types
PERIOD_CUSTOM_LABEL VARCHAR(40) Y The custom label used to create the description of any treatment periods belonging to this phase.
PERIOD_NBR DOUBLE N The period number for a treatment period phase.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PW_CAT_GROUP_ID DOUBLE N Pathway catalog id for the group level pathway row on the pathway_catalog table.
PW_CAT_VERSION DOUBLE Y The version of the pathway catalog used to create this instance of the pathway on the activity table.
PW_FORMS_REF_ID DOUBLE N Id from the dcp_forms_ref table of the form that will be used to capture PW level variances for this pathway.
PW_GROUP_DESC VARCHAR(1000) Y Description of the group level pathway.
PW_GROUP_NBR DOUBLE Y Unique id used to group multiple phases as a group to form a multi-phase pathway.
PW_STATUS_CD DOUBLE N Status code of the pathway
REF_OWNER_PERSON_ID DOUBLE N Unique id from the person table that identifies the personnel who created and owns the reference plan from the pathway_catalog table.
RESTRICT_CC_ADD_IND DOUBLE Y Indicator used to restrict the ability to add categories of care to the pathway when the pathway is being ordered on a patient
RESTRICT_COMP_ADD_IND DOUBLE Y Indicator used to restrict the ability to add components to the pathway when the pathway is being ordered on a patient
RESTRICT_TF_ADD_IND DOUBLE Y Indicator used to restrict the ability to add time frames to the pathway when the pathway is being ordered on a patient
REVIEW_REQUIRED_SIG_COUNT DOUBLE N The number of signatures that will be required to complete protocol review for this phase.
REVIEW_STATUS_FLAG DOUBLE N 0 - None 1 - Pending 2 - Completed 3 - Rejected 4 - Opt-Out 5 - Planning
STARTED_IND DOUBLE Y Indicates that the pathway has been started
START_DT_TM DATETIME Y Date and time the pathway was started
START_ESTIMATED_IND DOUBLE N To indicate whether the phase start date time is estimated or precise.
START_TZ DOUBLE Y Time zone associated with the corresponding dt_tm column.
STATUS_DT_TM DATETIME N Date and time the status was set to it's current value
STATUS_PRSNL_ID DOUBLE N Id of the person who last changed the status of the pathway
STATUS_TZ DOUBLE Y Time zone associated with the corresponding dt_tm column.
SYNONYM_NAME VARCHAR(200) Y Plan Synonym used when the pathway entry was added
TYPE_MEAN VARCHAR(12) Y Meaning that indicates the type of entry on the pathway table.
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.
VERSION DOUBLE Y Version number of the pathway
VERSION_PATHWAY_ID DOUBLE N The id of the pathway that this entry is a past version of. This will only be filled out for entries that are past versions of a pathway.
WARNING_LEVEL_BIT DOUBLE N A bitmask which indicates if the phase has a warning associated to it. If the bitmask is 0, no warning is associated to the phase. If the mask is valued, it indicates that a warning is associated to the phase. The 0th bit represents the presence of data separated by the encounter move process. Other bits will be defined in future releases.



Relationship Detail - PATHWAY


Child Column in PATHWAY(FK) Parent Table Name Parent Column Name
Parents: COMP_FORMS_REF_ID DCP_FORMS_REF DCP_FORM_INSTANCE_ID
PW_FORMS_REF_ID DCP_FORMS_REF DCP_FORM_INSTANCE_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
COPY_SOURCE_PATHWAY_ID PATHWAY PATHWAY_ID
PATHWAY_GROUP_ID PATHWAY PATHWAY_ID
PATHWAY_CATALOG_ID PATHWAY_CATALOG PATHWAY_CATALOG_ID
PW_CAT_GROUP_ID PATHWAY_CATALOG PATHWAY_CATALOG_ID
PATHWAY_CUSTOMIZED_PLAN_ID PATHWAY_CUSTOMIZED_PLAN PATHWAY_CUSTOMIZED_PLAN_ID
PERSON_ID PERSON PERSON_ID




Parent Column in PATHWAY (PK) Child Table Name Child Column Name
Children: PATHWAY_ID ACT_PW_COMP PATHWAY_ID
ACT_PW_COMP_G PATHWAY_ID
ACT_PW_COMP_R PATHWAY_ID
PATHWAY COPY_SOURCE_PATHWAY_ID
PATHWAY PATHWAY_GROUP_ID
PATHWAY_ACTION PATHWAY_ID
PATHWAY_NOTIFICATION PATHWAY_ID
PATHWAY_RELTN PATHWAY_S_ID
PATHWAY_RELTN PATHWAY_T_ID
PATHWAY_REVIEW PATHWAY_ID
PW_COMP_ACT_RELTN PATHWAY_ID
PW_PROCESSING_ACTION PATHWAY_ID
PW_VARIANCE_RELTN PATHWAY_ID


PATHWAY_ACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pathway action
Definition: Pathway action Table
Table Type: ACTIVITY





Column Detail - PATHWAY_ACTION


Column Name Type Null? Definition
ACTION_COMMENT VARCHAR(255) Y Comments about the Action
ACTION_DT_TM DATETIME N Date and time the action occurred
ACTION_PRSNL_ID DOUBLE N Id of the person who performed the action
ACTION_REASON_CD DOUBLE N Plan action reason
ACTION_TYPE_CD DOUBLE N Action code
ACTION_TZ DOUBLE Y Time zone associated with the corresponding dt_tm column.
COMMUNICATION_TYPE_CD DOUBLE N Identifies the communication type of the order, e.g., written, verbal, etc.
DURATION_QTY DOUBLE Y Duration quantity before the action was applied.
DURATION_UNIT_CD DOUBLE N Duration unit before the action was applied.
END_DT_TM DATETIME Y Pathway end date and time before the action was applied.
END_ESTIMATED_IND DOUBLE N To indicate whether the phase end date time is estimated or precise.
END_TZ DOUBLE Y Time zone associated with the corresponding dt_tm column.
PATHWAY_ACTION_ID DOUBLE N Add as 3rd column of Primary Key. Can be 0 for rows prior to being added. This column, when populated, will be unique by itself.
PATHWAY_CATALOG_ID DOUBLE N Unique identifier of the PATHWAY_CATALOG the action is associated with.
PATHWAY_ID DOUBLE N Id of the pathway the action is associated with
PROVIDER_ID DOUBLE N The Id of the ordering provider.
PW_ACTION_SEQ DOUBLE N Sequence of the action
PW_STATUS_CD DOUBLE N Status code of the pathway
START_DT_TM DATETIME Y Pathway start date and time before the action was applied.
START_ESTIMATED_IND DOUBLE N To indicate whether the phase start date time is estimated or precise.
START_TZ DOUBLE Y Time zone associated with the corresponding dt_tm column.
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 - PATHWAY_ACTION


Child Column in PATHWAY_ACTION(FK) Parent Table Name Parent Column Name
Parents: PATHWAY_ID PATHWAY PATHWAY_ID
PATHWAY_CATALOG_ID PATHWAY_CATALOG PATHWAY_CATALOG_ID
ACTION_PRSNL_ID PRSNL PERSON_ID
PROVIDER_ID PRSNL PERSON_ID


PATHWAY_CATALOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: PATHWAY CATALOG
Definition: Pathway Catalog contains all of the pathway reference definitions.
Table Type: REFERENCE





Column Detail - PATHWAY_CATALOG


Column Name Type Null? Definition
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.
AGE_UNITS_CD DOUBLE N The default time unit of measure used for time frames associated with this pathway.
ALERTS_ON_PLAN_IND DOUBLE N Phase level attribute to indicate whether to show alerts upon signing of a phase into a planned phase. Alerts include Interaction Checking, Discern Alerts and Dose Calculator.
ALERTS_ON_PLAN_UPD_IND DOUBLE N Phase level attribute to indicate whether to show alerts upon subsequent phase signing of a phase into a planned phase. Alerts include Interaction Checking, Discern Alerts and Dose Calculator.
ALLOW_COPY_FORWARD_IND DOUBLE N Used to indicate whether a plan is eligible to be copied forward from previous administration
AUTO_INITIATE_IND DOUBLE N Phase level attribute to indicate whether to initiate the phase of the plan upon signing of a phase for the first time.
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.
COMP_FORMS_REF_ID DOUBLE N Id from the dcp_forms_ref table of the form that will be used to capture component level variances for this pathway.
CONCEPT_CKI VARCHAR(255) Y Unique CKI identifier
CROSS_ENCNTR_IND DOUBLE N Indicates the pathway is designed to be activated across multiple encounters. These pathways will not automatically be discontinued upon discharge of the patient.
CYCLE_BEGIN_NBR DOUBLE N Indicates number to be used to default for the begin cycle number while ordering the plan if the same plan is not ordered on the patient within 180 days. If this is valued, cycle_end_nbr will also be valued.
CYCLE_DISPLAY_END_IND DOUBLE N Indicates whether users can see the Standard Cycle Number or End Value in the application while ordering or modifying the plan cycle information.
CYCLE_END_NBR DOUBLE N Indicates number to be used to default for the end cycle number while ordering the plan if the same plan is not ordered on the patient within 180 days. If this is valued, cycle_begin_nbr will also be valued.
CYCLE_INCREMENT_NBR DOUBLE N Indicates number to be used to increment plan cycle number instead of the default value of one.
CYCLE_IND DOUBLE N This field is used to prompt the user for a cycle number for the plan when it is ordered.
CYCLE_LABEL_CD DOUBLE N Indicates the default "Cycle" label to show client defined values such as Week, Course, Etc
CYCLE_LOCK_END_IND DOUBLE N Indicates whether users can modify the Standard Cycle Number or End Value in the application while ordering or modifying the plan cycle information. This field can have the value of one only when the cycle_display_end_ind is set.
DEFAULT_ACTION_INPT_FUTURE_CD DOUBLE N Indicates default phase action to be used while selecting plan for the inpatient encounter type for future visit type. When optional_ind is set on the Phase, values can be Order now, Plan for later, Order for future visit and Do not order. When optional_ind is not set on the Phase or is a single phase plan, values can be Order now, Plan for later, and Order for future visit. Do not order is not available. Code Set is 4002320.
DEFAULT_ACTION_INPT_NOW_CD DOUBLE N Indicates default phase action to be used while selecting plan for the inpatient encounter type for this visit type. When optional_ind is set on the Phase, values can be Order now, Plan for later and Do not order. When optional_ind is not set on the Phase or is a single phase plan, values can be Order now, Plan for later. Do not order is not available. Code Set is 4002320.
DEFAULT_ACTION_OUTPT_FUTURE_CD DOUBLE N Indicates default phase action to be used while selecting plan for the outpatient encounter type for future visit type. When optional_ind is set on the Phase, values can be Order now, Plan for later, Order for future visit and Do not order. When optional_ind is not set on the Phase or is a single phase plan, values can be Order now, Plan for later, and Order for future visit. Do not order is not available. Code Set is 4002320.
DEFAULT_ACTION_OUTPT_NOW_CD DOUBLE N Indicates default phase action to be used while selecting plan for the outpatient encounter type for this visit type. When optional_ind is set on the Phase, values can be Order now, Plan for later and Do not order. When optional_ind is not set on the Phase or is a single phase plan, values can be Order now, Plan for later. Do not order is not available. Code Set is 4002320.
DEFAULT_START_TIME_TXT VARCHAR(10) Y THE DEFAULT START TIME FOR THE PHASE
DEFAULT_VIEW_MEAN VARCHAR(12) N This field is used to set the default view for the plan in the application.
DEFAULT_VISIT_TYPE_FLAG DOUBLE N Defaults Phase actions during plan selection based on the visit type 0 - None 1 - This Visit 2 - Future Inpatient 3 - Future Outpatient
DESCRIPTION VARCHAR(100) N description of the pathway
DESCRIPTION_KEY VARCHAR(100) N Description key
DESCRIPTION_KEY_A_NLS VARCHAR(400) Y DESCRIPTION_KEY_A_NLS column
DESCRIPTION_KEY_NLS VARCHAR(202) Y Description key used for international sites
DIAGNOSIS_CAPTURE_IND DOUBLE N This field is used to prompt the user to enter the diagnosis for the plan.
DISABLE_ACTIVATE_ALL_IND DOUBLE N This column indicates whether the Activate All button for DoT phases needs to be enabled or disabled.
DISPLAY_DESCRIPTION VARCHAR(100) Y User visible display value of plan name
DISPLAY_METHOD_CD DOUBLE N Code value field used to flex plan component display in the application.
DURATION_QTY DOUBLE Y Duration quantity for plans and phases that have a specified duration.
DURATION_UNIT_CD DOUBLE N Identifies the duration unit (Minutes, Hours, Days).
END_EFFECTIVE_DT_TM DATETIME N 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.
FUTURE_IND DOUBLE N FUTURE INDICATOR
HIDE_FLEXED_COMP_IND DOUBLE N This indicator controls whether or not components that are unavailable for current encounter due to facility flexing are loaded by the application
LINKED_PHASE_IND DOUBLE N This indicator synchronizes the start date-time of the phases within a multi-phase plan. i.e.changing the start date-time of a linked phase within the multi-phase plan will update the start date-time of the another linked phase within the same plan.
LONG_TEXT_ID DOUBLE N Id of the textual comments associated with this pathway
OPEN_BY_DEFAULT_IND DOUBLE N The column indicates whether all the phases, or a phase, is open by default.
OPTIONAL_IND DOUBLE N Indicates that phase can be removed from the plan in the application during plan selection.
OVERRIDE_MRD_ON_PLAN_IND DOUBLE N Indicates to allow missing required detail upon signing of a plan into a planned status when the preference: planmissingrequireddetailswarnonsign is set to 2
PATHWAY_CATALOG_ID DOUBLE N Unique id of this pathway catalog entry
PATHWAY_CLASS_CD DOUBLE N Code value field used to group pathways according to user-defined classification
PATHWAY_TYPE_CD DOUBLE N Code value field used to group pathways according to user-defined types
PATHWAY_UUID VARCHAR(255) N The pathway unique universal identifier
PERIOD_CUSTOM_LABEL VARCHAR(40) Y The custom label used to create the description of any treatment periods belonging to this phase.
PERIOD_NBR DOUBLE N The period number for a treatment period phase.
PRIMARY_IND DOUBLE N indicates which phase of a multiphase plan will be the primary phase in the plan prompt dialog. The target for the start date time control in the plan prompt.
PROMPT_ON_SELECTION_IND DOUBLE N Indicates whether to prompt user for plan start information on plan selection
PROVIDER_PROMPT_IND DOUBLE N Indicator to prompt for ordering provider.
PW_FORMS_REF_ID DOUBLE N Id from the dcp_forms_ref table of the form that will be used to capture PW level variances for this pathway.
REF_OWNER_PERSON_ID DOUBLE N Unique id from the person table that identifies the personnel who created and owns the reference plan from the pathway_catalog table.
RESCHEDULE_REASON_ACCEPT_FLAG DOUBLE N This value indicates whether the capture of a phase/treatment period reschedule reason will be: 0 - Off, 1 - Optional, or 2 - Required
RESTRICTED_ACTIONS_BITMASK DOUBLE N The bitmask for the restricted actions for a plan. The following values are supported: 0x0 - No restriction, 0x1 - Restricted from being ordered as a plan proposal, 0x2 - Restricted from being saved as favorite on the profile, ;0x4 - Restricted from being searched.
RESTRICT_CC_ADD_IND DOUBLE Y Indicator used to restrict the ability to add categories of care to the pathway when the pathway is being ordered on a patient
RESTRICT_COMP_ADD_IND DOUBLE Y Indicator used to restrict the ability to add components to the pathway when the pathway is being ordered on a patient
RESTRICT_TF_ADD_IND DOUBLE Y Indicator used to restrict the ability to add time frames to the pathway when the pathway is being ordered on a patient
REVIEW_REQUIRED_SIG_COUNT DOUBLE N The number of signatures that will be required to complete protocol review for this phase.
ROUTE_FOR_REVIEW_IND DOUBLE N ** OBSOLETE ** - 0 - for no routing is needed for the phase 1 - routing is required** THIS COLUMN BECOMES OBSOLETE WHEN COLUMN REVIEW_REQUIRED_SIG_COUNT IS ADDED TO THE TABLE. (June 2016)
STANDARD_CYCLE_NBR DOUBLE N This field is used to validate the cycle number entered by the user against the standard.
SUB_PHASE_IND DOUBLE N This indicator signals whether or not a single phase plan can be used as a sub phase in another plan.
TYPE_MEAN VARCHAR(12) Y Meaning that indicates the type of entry on the pathway catalog table.
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.
VERSION DOUBLE N Number used to indicate the version of the pathway. Everytime the pathway catalog entry is modified the version is incremented.
VERSION_PW_CAT_ID DOUBLE N The id of the pathway catalog entry that this entry is a past version of. This will only be filled out for entries that are past versions of a pathway catalog entry.
VERSION_TEXT_ID DOUBLE N User entered description of the changes made to a reference pathway when creating a new version.



Relationship Detail - PATHWAY_CATALOG


Child Column in PATHWAY_CATALOG(FK) Parent Table Name Parent Column Name
Parents: COMP_FORMS_REF_ID DCP_FORMS_REF DCP_FORM_INSTANCE_ID
PW_FORMS_REF_ID DCP_FORMS_REF DCP_FORM_INSTANCE_ID




Parent Column in PATHWAY_CATALOG (PK) Child Table Name Child Column Name
Children: PATHWAY_CATALOG_ID ALT_SEL_LIST PATHWAY_CATALOG_ID
ORDERS PATHWAY_CATALOG_ID
PATHWAY PATHWAY_CATALOG_ID
PATHWAY PW_CAT_GROUP_ID
PATHWAY_ACTION PATHWAY_CATALOG_ID
PATHWAY_COMP PATHWAY_CATALOG_ID
PATHWAY_CUSTOMIZED_NOTIFY PATHWAY_CATALOG_ID
PATHWAY_CUSTOMIZED_NOTIFY VERSION_PW_CAT_ID
PATHWAY_CUSTOMIZED_PLAN PATHWAY_CATALOG_ID
PRECOMPONENT_ORDER_RELTN VERSION_PW_CAT_ID
PW_CAT_FLEX PATHWAY_CATALOG_ID
PW_CAT_RELTN PW_CAT_S_ID
PW_CAT_RELTN PW_CAT_T_ID
PW_CAT_SYNONYM PATHWAY_CATALOG_ID
PW_COMP_CAT_RELTN PATHWAY_CATALOG_ID
PW_COMP_GROUP PATHWAY_CATALOG_ID
PW_COMP_RELTN PATHWAY_CATALOG_ID
PW_EVIDENCE_RELTN PATHWAY_CATALOG_ID
PW_MAINTENANCE_CRITERIA VERSION_PW_CAT_ID
PW_PT_RELTN PATHWAY_CATALOG_ID
SURG_REQ_PLAN_R PATHWAY_CATALOG_ID


PATHWAY_COMP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pathway Comp
Definition: Table that is used to define all of the components for a pathway catalog entry
Table Type: REFERENCE





Column Detail - PATHWAY_COMP


Column Name Type Null? Definition
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.
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
CAPTURE_VARIANCE_IND DOUBLE Y Indicator used to define if a variance will be captured at result entry time for result outcome component types
CARE_CATEGORY_ID DOUBLE N The id of the care_category this component belongs to
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_TYPE_CD DOUBLE N Component type code
COND_DESC VARCHAR(100) Y Textual description of the condition associated with this component
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
CROSS_PHASE_GROUP_DESC VARCHAR(40) N Name of a cross phase component group that the component belongs to.
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_OS_IND DOUBLE N Indicates whether pre-defined order sentences should be considered as the default order sentence for the order component.
DISPLAY_FORMAT_XML VARCHAR(1000) N Contains the display format attributes 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
EVENT_CD DOUBLE N Event code of the outcome if the component is a Result Outcome.Column
EXPAND_QTY DOUBLE Y Range value to be used to set the limit of evaluating the outcomes past their target
EXPAND_UNIT_CD DOUBLE N Unit code to be used together with the range value to set the limit of evaluating the outcomes past their target
INCLUDE_IND DOUBLE Y Indicator that controls if this component will be included in the pathway by default
LINKED_TO_TF_IND DOUBLE Y Indicates that the component is linked to the time frame for it's duration.Column
LOCK_TARGET_DOSE_FLAG DOUBLE N Lock target dose flag. A flag to lock the target dose in the dose calculator.
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.
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 id for this order create or outcome create type component
OUTCOME_FORMS_REF_ID DOUBLE N Id of the form that will be used to chart the outcome directly.Column
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 Holds the id of the reference item that this component relates to (order_synonym, discrete task assay, long_text)
PARENT_ENTITY_NAME VARCHAR(32) Y Name of the parent entity table that relates to this component
PATHWAY_CATALOG_ID DOUBLE N Id of the pathway catalog entry this component is associated with
PATHWAY_COMP_ID DOUBLE N Unique id of the pathway comp table entry
PATHWAY_UUID VARCHAR(255) N The pathway unique universal identifier
PERSISTENT_IND DOUBLE Y Note components will be shown prior to a phase being initiated. After initiation, since the usefulness of any note is gone, the system will auto hide all the notes. The persistent indicator allows clients wanted to use note components to show information about administration of an order as well, The persistent indicator was added so that the system would keep showing the note component after initiation.
REFERENCE_TASK_ID DOUBLE N Id of the reference task used to capture a result outcome. This is only used for result outcome type components.
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
TARGET_TYPE_CD DOUBLE N Target type codeColumn
TASK_ASSAY_CD DOUBLE N Id of the discrete task assay used to define a result outcome
TIME_FRAME_ID DOUBLE N Id of the time frame the component is associated with
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 - PATHWAY_COMP


Child Column in PATHWAY_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
ORDER_SENTENCE_ID ORDER_SENTENCE ORDER_SENTENCE_ID
REFERENCE_TASK_ID ORDER_TASK REFERENCE_TASK_ID
PATHWAY_CATALOG_ID PATHWAY_CATALOG PATHWAY_CATALOG_ID




Parent Column in PATHWAY_COMP (PK) Child Table Name Child Column Name
Children: PATHWAY_COMP_ID ACT_PW_COMP PATHWAY_COMP_ID
PW_COMP_CAT_RELTN PATHWAY_COMP_ID
PW_COMP_GROUP PATHWAY_COMP_ID
PW_COMP_OS_RELTN PATHWAY_COMP_ID
PW_COMP_RELTN PATHWAY_COMP_S_ID
PW_COMP_RELTN PATHWAY_COMP_T_ID
PW_DEF_DOSE_CALC_METHOD PATHWAY_COMP_ID


PATHWAY_CUSTOMIZED_NOTIFY



Column Section Relationship Section Top of Page


Table-level Detail

Description: PATHWAY CUSTOMIZED NOTIFICATIONS
Definition: This table stores the notifications for pathway_customized_plan
Table Type: REFERENCE





Column Detail - PATHWAY_CUSTOMIZED_NOTIFY


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.
LONG_TEXT_ID DOUBLE N The long text ID from long text reference of the text for the notification
NOTIFICATION_DT_TM DATETIME N The date and time of the notification
PATHWAY_CATALOG_ID DOUBLE N The pathway catalog ID of the plan that this notification is for.
PATHWAY_CUSTOMIZED_NOTIFY_ID DOUBLE N The primary key of this table
PATHWAY_CUSTOMIZED_PLAN_ID DOUBLE N The pathway customized plan ID of the customized plan that this notification is for.
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.
VERSION_PW_CAT_ID DOUBLE N The version pathway catalog ID of the plan that this notification is for



Relationship Detail - PATHWAY_CUSTOMIZED_NOTIFY


Child Column in PATHWAY_CUSTOMIZED_NOTIFY(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
PATHWAY_CATALOG_ID PATHWAY_CATALOG PATHWAY_CATALOG_ID
VERSION_PW_CAT_ID PATHWAY_CATALOG PATHWAY_CATALOG_ID
PATHWAY_CUSTOMIZED_PLAN_ID PATHWAY_CUSTOMIZED_PLAN PATHWAY_CUSTOMIZED_PLAN_ID