Table Detail Report

CP_NODE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Care Planning Node
Definition: Contain definition and links for configuration of a Node in Care Planning workflow
Table Type: REFERENCE





Column Detail - CP_NODE


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.
BEG_EFFECTIVE_DT_TM DATETIME N 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.
CATEGORY_MEAN VARCHAR(30) Y The Category Meaning. This column maps to the CATEGORY_MEAN column in Bedrock trable BR_DATAMART_CATEGORY if Bedrock is in the domain. Otherwise the value is nulls.
COLLATION_SEQ DOUBLE Y Provides the ability to sequence the list of nodes within a pathway for display purposes
CONCEPT_CD DOUBLE N Concept code used to uniquely identify the concept
CP_NODE_ID DOUBLE N Primary Key
CP_PATHWAY_ID DOUBLE N FK Value form CP_PATHWAY table
CREATE_DT_TM DATETIME N Date and time when the NODE record was created
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.
INTENTION_CD DOUBLE N INTENTION CODE
NODE_DISPLAY VARCHAR(255) Y The data that will be displayed on the user interface
NODE_NAME VARCHAR(100) N Name of node for display/linking purposes in build tool
PUBLISH_IND DOUBLE N Used for indicate that the content is ready for display on the user interface.
TREATMENT_LINE_CD DOUBLE N The Treatment Line represented by this node
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_NODE_ID DOUBLE N The originating NODE_ID for this version. Used to support Type-2 Versioning in the table.
VERSION_TEXT VARCHAR(4000) Y Information about a version of the NODE



Relationship Detail - CP_NODE


Child Column in CP_NODE(FK) Parent Table Name Parent Column Name
Parents: VERSION_NODE_ID CP_NODE CP_NODE_ID
CP_PATHWAY_ID CP_PATHWAY CP_PATHWAY_ID




Parent Column in CP_NODE (PK) Child Table Name Child Column Name
Children: CP_NODE_ID CP_COMPONENT CP_NODE_ID
CP_NODE VERSION_NODE_ID
CP_NODE_BEHAVIOR CP_NODE_ID
CP_PATHWAY_ACTION CP_NODE_ID


CP_NODE_BEHAVIOR



Column Section Relationship Section Top of Page


Table-level Detail

Description: CARE PLANNING NODE BEHAVIOR
Definition: Contains behaviors between pathway nodes and the possible reactions from decisions available in the nodes.
Table Type: REFERENCE





Column Detail - CP_NODE_BEHAVIOR


Column Name Type Null? Definition
CP_NODE_BEHAVIOR_ID DOUBLE N PRIMARY KEY
CP_NODE_ID DOUBLE N the node that is currently in context.for a certain node within a pathway what are the responses based on the RESPONSE_IDENT.
INSTANCE_IDENT VARCHAR(255) Y Identifier used to reference correct version of DD_SREF_TEMPLATE.DD_SREF_TMPL_INSTANCE_IDENT
LONG_RESPONSE_IDENT LONGTEXT Y LONG verbose form of the identifier that is generated from a correlating dynamic document being used in the pathway/node.
REACTION_ENTITY_ID DOUBLE N Unique generated number that identifies a reaction type for the REACTION_ENTITY_NAME.
REACTION_ENTITY_NAME VARCHAR(30) N The name of the reaction that is to occur in the pathway/node process (ORDER_CATALOG, NOMENCLATURE, CODE_VALUE, CP_NODE,ORDER_CATALOG_SYNONYM, ORDER_SENTENCE).
REACTION_TYPE_MEAN VARCHAR(100) N A type categorization of the Reaction
RESPONSE_IDENT VARCHAR(1000) N A unique string identifier that is generated from a correlating dynamic document being used in the pathway/node.
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 - CP_NODE_BEHAVIOR


Child Column in CP_NODE_BEHAVIOR(FK) Parent Table Name Parent Column Name
Parents: CP_NODE_ID CP_NODE CP_NODE_ID


CP_PATHWAY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Care Planning Pathway
Definition: Contain definition and configuration of nodes used in Care Planning Pathways.
Table Type: REFERENCE





Column Detail - CP_PATHWAY


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.
CP_CONCEPT_CD DOUBLE N Identifies what concept code the pathway is related to.
CP_PATHWAY_ID DOUBLE N PRIMARY KEY
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
OWNER_PRSNL_ID DOUBLE N Indicates the owner of the pathway if this is a customized pathway (User level bundle). For General bundles, the value will be zero.
PATHWAY_DIAGRAM_URL VARCHAR(1000) Y The URL that points to the overall diagram for this pathway.
PATHWAY_NAME VARCHAR(100) N The name of the pathway being stored.
PATHWAY_STATUS_CD DOUBLE N The status of the pathway being stored.
PATHWAY_TYPE_CD DOUBLE N The type of pathway being stored.
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 - CP_PATHWAY


Child Column in CP_PATHWAY(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
OWNER_PRSNL_ID PRSNL PERSON_ID




Parent Column in CP_PATHWAY (PK) Child Table Name Child Column Name
Children: CP_PATHWAY_ID CP_NODE CP_PATHWAY_ID
CP_PATHWAY_ACTIVITY CP_PATHWAY_ID
CP_PATHWAY_GROUP_R CP_PATHWAY_ID
CP_TRIGGERING_CRITERIA CP_PATHWAY_ID


CP_PATHWAY_ACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Care Planning Action
Definition: Hold information about actions take during care planning workflow.
Table Type: ACTIVITY





Column Detail - CP_PATHWAY_ACTION


Column Name Type Null? Definition
ACTION_DT_TM DATETIME Y Date/Time action was taken
ACTION_TYPE_CD DOUBLE N Action type taken during care planning conversation
CP_COMPONENT_ID DOUBLE N CP Component PK value from the CP_COMPONENT table
CP_NODE_ID DOUBLE N Care Planning node this action was taken from.
CP_PATHWAY_ACTION_ID DOUBLE N PRIMARY KEY
ENCNTR_ID DOUBLE N Provides ability to track actions by the Encounter they were taken on
PATHWAY_INSTANCE_ID DOUBLE N Used to group rows of activity for the same instance of a pathway. The value will be pulled from a sequence (this is not an FK field). Relates to same column in CP_PATHWAY_ACTIVITY
PRSNL_ID DOUBLE N Personnel ID of user which took action
TREATMENT_LINE_CD DOUBLE N Treatment Line this action was taken 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.



Relationship Detail - CP_PATHWAY_ACTION


Child Column in CP_PATHWAY_ACTION(FK) Parent Table Name Parent Column Name
Parents: CP_COMPONENT_ID CP_COMPONENT CP_COMPONENT_ID
CP_NODE_ID CP_NODE CP_NODE_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
PRSNL_ID PRSNL PERSON_ID




Parent Column in CP_PATHWAY_ACTION (PK) Child Table Name Child Column Name
Children: CP_PATHWAY_ACTION_ID CP_PATHWAY_ACTION_DETAIL CP_PATHWAY_ACTION_ID


CP_PATHWAY_ACTION_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Care Planning Action Detail
Definition: Hold detailed information about actions take during an care planning workflow.
Table Type: ACTIVITY





Column Detail - CP_PATHWAY_ACTION_DETAIL


Column Name Type Null? Definition
ACTION_DETAIL_ENTITY_ID DOUBLE N Unique generated number that identifies an action detail for the ACTION_DETAIL_ENTITY_NAME.
ACTION_DETAIL_ENTITY_NAME VARCHAR(30) Y The name of the action detail that the user selected in the pathway/node process (ORDERS, DIAGNOSIS, NODE, etc.)
ACTION_DETAIL_IDENT VARCHAR(255) Y Optional identifier used to differentiate specific details
ACTION_DETAIL_STATUS_CD DOUBLE N Defines the status for the pathway action. Active/Inerror
ACTION_DETAIL_TEXT VARCHAR(1000) Y Text display associated with an action detail
CP_ACTION_DETAIL_TYPE_CD DOUBLE N A code_value to identify the type of action detail
CP_PATHWAY_ACTION_DETAIL_ID DOUBLE N PRIMARY KEY
CP_PATHWAY_ACTION_ID DOUBLE N Parent row identifier on the CP_PATHWAY_ACTION table.
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 - CP_PATHWAY_ACTION_DETAIL


Child Column in CP_PATHWAY_ACTION_DETAIL(FK) Parent Table Name Parent Column Name
Parents: CP_PATHWAY_ACTION_ID CP_PATHWAY_ACTION CP_PATHWAY_ACTION_ID