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