Table Detail Report

PW_COMP_OS_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pathway component order sentence relationship.
Definition: Used to define relationships between a pathway component and order sentences.
Table Type: REFERENCE





Column Detail - PW_COMP_OS_RELTN


Column Name Type Null? Definition
IV_COMP_SYN_ID DOUBLE N IV Component Synonym ID. Represents the synonym-id of the COMP_ID field from the CS_COMPONENT table. This is not a FK because COMP_ID is not a PK field it that table.
MISSING_REQUIRED_IND DOUBLE N Indicates whether the order sentence in the OS_DISPLAY_LINE column on the table has all the reuired fields populated based on the component format.
NORMALIZED_DOSE_UNIT_IND DOUBLE N Indicates whether the order sentence contains a strength dose unit or volume dose unit that is a normalized unit as defined within the code-value extension (field value bitmask includes a value of 32) of CodeSet 54. Examples of normalized dose units are weight-based, mg/kg, or body surface area (BSA)-based, mg/m2.
ORDER_SENTENCE_ID DOUBLE N Order sentence id from the order_sentence table.
ORDER_SENTENCE_SEQ DOUBLE Y Sequence of the order sentence for the component.
OS_DISPLAY_LINE VARCHAR(255) Y Order Sentence Display LineColumn
PATHWAY_COMP_ID DOUBLE N Pathway component id from the pathway_comp 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 - PW_COMP_OS_RELTN


Child Column in PW_COMP_OS_RELTN(FK) Parent Table Name Parent Column Name
Parents: ORDER_SENTENCE_ID ORDER_SENTENCE ORDER_SENTENCE_ID
PATHWAY_COMP_ID PATHWAY_COMP PATHWAY_COMP_ID


PW_COMP_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: PW COMP RELTN
Definition: Used to define relationships between pathway components.
Table Type: REFERENCE





Column Detail - PW_COMP_RELTN


Column Name Type Null? Definition
OFFSET_QTY DOUBLE Y Obsolete - replaced by 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_CATALOG_ID DOUBLE N FK value from PATHWAY CATALOG row that owns this relationship.
PATHWAY_COMP_S_ID DOUBLE N Relationship source pathway component id from the pathway_comp table.
PATHWAY_COMP_T_ID DOUBLE N Relationship target pathway component id from the pathway_comp table.
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 - PW_COMP_RELTN


Child Column in PW_COMP_RELTN(FK) Parent Table Name Parent Column Name
Parents: PATHWAY_CATALOG_ID PATHWAY_CATALOG PATHWAY_CATALOG_ID
PATHWAY_COMP_S_ID PATHWAY_COMP PATHWAY_COMP_ID
PATHWAY_COMP_T_ID PATHWAY_COMP PATHWAY_COMP_ID


PW_EVIDENCE_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pathway evidence relation
Definition: Used to store links between plan components and evidence (reference text & Zynx content)
Table Type: REFERENCE





Column Detail - PW_EVIDENCE_RELTN


Column Name Type Null? Definition
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 code set 29700 that identifies the clinical sub category of the component within the plan
EVIDENCE_LOCATOR VARCHAR(255) N Zynx URL when type_mean is ZYNX
EVIDENCE_SEQUENCE DOUBLE N Sequence number for the relation
PATHWAY_CATALOG_ID DOUBLE N Unique identifier from pathway_catalog table, which is used to store plan/phase definitions
PATHWAY_COMP_ID DOUBLE N Unique identifier for a component of a plan
PW_EVIDENCE_RELTN_ID DOUBLE N Unique identifier for pathway/evidence relation row
REF_TEXT_RELTN_ID DOUBLE N Unique identifier from ref_text_reltn table
TYPE_MEAN CHAR(12) Y Meaning that indicates the type of entry on the pw_evidence_reltn 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 - PW_EVIDENCE_RELTN


Child Column in PW_EVIDENCE_RELTN(FK) Parent Table Name Parent Column Name
Parents: PATHWAY_CATALOG_ID PATHWAY_CATALOG PATHWAY_CATALOG_ID


PW_MAINTENANCE_CRITERIA



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pathway maintenance criteria
Definition: Stores the maintenance criteria for PowerPlans.
Table Type: REFERENCE





Column Detail - PW_MAINTENANCE_CRITERIA


Column Name Type Null? Definition
ENCOUNTER_TYPE_FLAG DOUBLE N Denotes the encounter type that this criterion applies to 0 - All 1 - Inpatient 2 - Non-Inpatient
PW_MAINTENANCE_CRITERIA_ID DOUBLE N Primary Key
TIME_QTY DOUBLE N Denotes the amount of time for a criterion.
TIME_UNIT_CD DOUBLE N Denotes the time unit for the specified time quantity. Code Set 340
TYPE_MEAN VARCHAR(12) N Indicates the type of maintenance criterion
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 Identifies all versions of a plan in reference that this criterion applies to. This field corresponds to a version_pw_cat_id from the pathway_catalog table.



Relationship Detail - PW_MAINTENANCE_CRITERIA


Child Column in PW_MAINTENANCE_CRITERIA(FK) Parent Table Name Parent Column Name
Parents: VERSION_PW_CAT_ID PATHWAY_CATALOG PATHWAY_CATALOG_ID


PW_PROCESSING_ACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table is used to track pathways that are being processed by the pw server
Definition: pathway processing action
Table Type: ACTIVITY





Column Detail - PW_PROCESSING_ACTION


Column Name Type Null? Definition
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
PATHWAY_CATALOG_ID DOUBLE N Pathway catalog id of the pathway that is being processed.Column
PATHWAY_ID DOUBLE N Id of the pathway that is being created or updated.Column
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PROCESSING_START_DT_TM DATETIME Y Date and time that processing started on the pathway.Column
PROCESSING_UPDT_CNT DOUBLE N The value of the update count on the pathway table after the processing is complete.
PW_GROUP_NBR DOUBLE Y Unique id from pathway table used to group multiple phases as a group to form a multi-phase pathway.
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.
WORKFLOW_BLOB_ID DOUBLE N The LONG_BLOB_ID for all workflows on the phase and are signed (from the LONG_BLOB table).



Relationship Detail - PW_PROCESSING_ACTION


Child Column in PW_PROCESSING_ACTION(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
WORKFLOW_BLOB_ID LONG_BLOB LONG_BLOB_ID
PATHWAY_ID PATHWAY PATHWAY_ID
PERSON_ID PERSON PERSON_ID