Table Detail Report
PRECOMPONENT_ORDER_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PRECOMPONENT_ORDERS_RELTN |
Definition: | A set of relationships between orders and reference plan data for use in linking orders to an activity plan at a later date. |
Table Type: | ACTIVITY |
Column Detail - PRECOMPONENT_ORDER_RELTN
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. |
COMPONENT_UUID | VARCHAR(255) | Y | A PATHWAY_UUID from the PATHWAY_COMP table. This is a plan version independent reference component ID. |
CYCLE_NBR | DOUBLE | N | A cycle number that will correspond to the CYCLE_NBR field on the PATHWAY table. |
ORDER_ID | DOUBLE | N | An ORDER_ID from the ORDERS table. Should be unique in this table. |
PERSON_ID | DOUBLE | N | A patient ID. |
PRECOMPONENT_ORDER_RELTN_ID | DOUBLE | N | PRIMARY KEY |
REGIMEN_ID | DOUBLE | N | A REGIMEN_ID from the REGIMEN 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. |
VERSION_PW_CAT_ID | DOUBLE | N | A VERSION_PW_CAT_ID from the PATHWAY_CATALOG table. This represents a plan version independent reference plan ID. |
Relationship Detail - PRECOMPONENT_ORDER_RELTN
Child Column in PRECOMPONENT_ORDER_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORDER_ID | ORDERS | ORDER_ID |
VERSION_PW_CAT_ID | PATHWAY_CATALOG | PATHWAY_CATALOG_ID | |
PERSON_ID | PERSON | PERSON_ID | |
REGIMEN_ID | REGIMEN | REGIMEN_ID |
PRSNL_NOTIFY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PRSNL NOTIFY |
Definition: | This table contains the rules for personnel notification of task activity. |
Table Type: | REFERENCE |
Column Detail - PRSNL_NOTIFY
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. |
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 | Y | 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. |
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. |
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. |
NOTIFY_FLAG | DOUBLE | Y | Defines the notification function. |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
PRSNL_NOTIFY_ID | DOUBLE | N | The ID of the personnel row. |
QUERY_IND | DOUBLE | Y | Indicator used by the Clinical Event server to query for physician data |
TASK_ACTIVITY_CD | DOUBLE | N | Task Activity Code |
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 - PRSNL_NOTIFY
Child Column in PRSNL_NOTIFY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PERSON_ID | PRSNL | PERSON_ID |
Parent Column in PRSNL_NOTIFY (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PRSNL_NOTIFY_ID | PRSNL_NOTIFY_PPR | PRSNL_NOTIFY_ID |
PRSNL_NOTIFY_PPR
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Personnel Notify PPR Relation table |
Definition: | This table relates personnel notifications with PPRs for InBox. |
Table Type: | REFERENCE |
Column Detail - PRSNL_NOTIFY_PPR
Column Name | Type | Null? | Definition |
---|---|---|---|
PPR_CD | DOUBLE | N | The provider/person relationship code. |
PPR_FLAG | DOUBLE | Y | Defines whether the relationship is person or encounter based. |
PRSNL_NOTIFY_ID | DOUBLE | N | The ID of the personnel row. |
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 - PRSNL_NOTIFY_PPR
Child Column in PRSNL_NOTIFY_PPR(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PRSNL_NOTIFY_ID | PRSNL_NOTIFY | PRSNL_NOTIFY_ID |
PW_CAT_FLEX
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Pathway catalog flex |
Definition: | Table to define relationships used to flex selection of entries on the pathway_catalog table |
Table Type: | REFERENCE |
Column Detail - PW_CAT_FLEX
Column Name | Type | Null? | Definition |
---|---|---|---|
DISPLAY_DESCRIPTION_KEY | VARCHAR(100) | N | Description key field used to search the table for entries. |
DISPLAY_DESCRIPTION_KEY_A_NLS | VARCHAR(400) | Y | DISPLAY_DESCRIPTION_KEY_A_NLS column |
DISPLAY_DESCRIPTION_KEY_NLS | VARCHAR(202) | Y | Description key field used to search the table for entries. NLS field. |
PARENT_ENTITY_ID | DOUBLE | N | Unique id of the entity this flex entry is related to. |
PARENT_ENTITY_NAME | VARCHAR(30) | N | Name of the table that is referenced by the parent entity identification. |
PATHWAY_CATALOG_ID | DOUBLE | N | Unique id of the pathway catalog entry referenced by an entry on this 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_CAT_FLEX
Child Column in PW_CAT_FLEX(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PATHWAY_CATALOG_ID | PATHWAY_CATALOG | PATHWAY_CATALOG_ID |
PW_CAT_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Pathway catalog relationship |
Definition: | Used to define relationships between pathway catalog entries. |
Table Type: | REFERENCE |
Column Detail - PW_CAT_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
OFFSET_QTY | 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). |
PW_CAT_S_ID | DOUBLE | N | Relationship source pathway catalog id from the pathway_catalog table. |
PW_CAT_T_ID | DOUBLE | N | Relationship target pathway catalog id from the pathway_catalog 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_CAT_RELTN
Child Column in PW_CAT_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PW_CAT_S_ID | PATHWAY_CATALOG | PATHWAY_CATALOG_ID |
PW_CAT_T_ID | PATHWAY_CATALOG | PATHWAY_CATALOG_ID |