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 |