Table Detail Report

PATHWAY_CUSTOMIZED_PLAN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pathway Customized Plan
Definition: This table defines a set of pathway rules that can be used to alter a catalog PowerPlan when it is being added.
Table Type: REFERENCE





Column Detail - PATHWAY_CUSTOMIZED_PLAN


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.
CREATE_DT_TM DATETIME N The date and time the customized plan was created
PATHWAY_CATALOG_ID DOUBLE N The pathway catalog id of the plan that this customized plan is based on.
PATHWAY_CUSTOMIZED_PLAN_ID DOUBLE N PRIMARY KEY
PLAN_NAME VARCHAR(100) N The name of the customized plan.
PLAN_NAME_KEY VARCHAR(100) N The name key field used to search the table for entries.
PLAN_NAME_KEY_A_NLS VARCHAR(400) Y NAME_KEY field for national language support
PRSNL_ID DOUBLE N The personnel that owns this customized plan.
STATUS_FLAG DOUBLE N The status of the customized plan. 0 - No Restriction. 1 - In Review - The customized plan has been marked as needing review. 2 - Restricted - The customized plan is restricted and it should not be used, but it should still be visible.
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 - PATHWAY_CUSTOMIZED_PLAN


Child Column in PATHWAY_CUSTOMIZED_PLAN(FK) Parent Table Name Parent Column Name
Parents: PATHWAY_CATALOG_ID PATHWAY_CATALOG PATHWAY_CATALOG_ID
PRSNL_ID PRSNL PERSON_ID




Parent Column in PATHWAY_CUSTOMIZED_PLAN (PK) Child Table Name Child Column Name
Children: PATHWAY_CUSTOMIZED_PLAN_ID PATHWAY PATHWAY_CUSTOMIZED_PLAN_ID
PATHWAY_CUSTOMIZED_NOTIFY PATHWAY_CUSTOMIZED_PLAN_ID
PATHWAY_RULE PATHWAY_CUSTOMIZED_PLAN_ID
SURG_REQ_PLAN_R PATHWAY_CUSTOMIZED_PLAN_ID


PATHWAY_NOTIFICATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pathway Notification
Definition: This table holds the notifications related to pathway data.
Table Type: ACTIVITY





Column Detail - PATHWAY_NOTIFICATION


Column Name Type Null? Definition
FORWARDING_PRSNL_GROUP_ID DOUBLE N Forwarding personnel group id. Unique id of the personnel group that the pathway notification was forwarded from.
FORWARDING_PRSNL_ID DOUBLE N Forwarding personnel id. Unique id of the person who forwarded the pathway notification.
FROM_PRSNL_GROUP_ID DOUBLE N The identifier of the personnel group which a personnel acted from when forwarding an pathway notification.
FROM_PRSNL_ID DOUBLE N The identifier of the personnel which created the notification by acting on a pathway or forwarding an existing notification.
NOTIFICATION_COMMENT VARCHAR(255) Y The free text comment that is supplied by the user to communicate details of the notification.
NOTIFICATION_CREATED_DT_TM DATETIME Y The date/time when the notification was created.
NOTIFICATION_CREATED_TZ DOUBLE N Time zone associated with the notification creation date/time.
NOTIFICATION_RESOLVED_DT_TM DATETIME Y The date/time when the notification was resolved (accepted, rejected, forwarded, or is no longer needed).
NOTIFICATION_RESOLVED_TZ DOUBLE N Time zone associated with the notification resolved date/time.
NOTIFICATION_STATUS_FLAG DOUBLE N Illustrates the current status of the notification. Valid flag values are: 1 - pending, 2 - accepted, 3 - rejected, 4 - forwarded, 5 - no longer needed, 6 - Planning
NOTIFICATION_TYPE_FLAG DOUBLE N Illustrates the type of the notification. Valid flag values are: 1 - phase protocol review.
PARENT_PATHWAY_NOTIFICATION_ID DOUBLE N The identifier of the parent pathway notification if the notification originated from a forward action.
PATHWAY_ID DOUBLE N The identifier of the pathway which is associated to the notification.
PATHWAY_NOTIFICATION_ID DOUBLE N The primary key of this table. It is internally assigned by the system.
PW_ACTION_SEQ DOUBLE N The action sequence of the pathway that generated this notification.
TO_PRSNL_GROUP_ID DOUBLE N The identifier of the personnel group which the notification is intended for.
TO_PRSNL_ID DOUBLE N The identifier of the personnel which the notification is intended 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 - PATHWAY_NOTIFICATION


Child Column in PATHWAY_NOTIFICATION(FK) Parent Table Name Parent Column Name
Parents: PATHWAY_ID PATHWAY PATHWAY_ID
PARENT_PATHWAY_NOTIFICATION_ID PATHWAY_NOTIFICATION PATHWAY_NOTIFICATION_ID
FORWARDING_PRSNL_ID PRSNL PERSON_ID
FORWARDING_PRSNL_GROUP_ID PRSNL_GROUP PRSNL_GROUP_ID
FROM_PRSNL_GROUP_ID PRSNL_GROUP PRSNL_GROUP_ID
TO_PRSNL_GROUP_ID PRSNL_GROUP PRSNL_GROUP_ID




Parent Column in PATHWAY_NOTIFICATION (PK) Child Table Name Child Column Name
Children: PATHWAY_NOTIFICATION_ID PATHWAY_NOTIFICATION PARENT_PATHWAY_NOTIFICATION_ID
TASK_SUBACTIVITY PATHWAY_NOTIFICATION_ID


PATHWAY_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pathway relationship
Definition: Used to define relationships between pathway table entries.
Table Type: ACTIVITY





Column Detail - PATHWAY_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.
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.
BEG_EFFECTIVE_DT_TM DATETIME Y 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 Y 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.
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).
PATHWAY_S_ID DOUBLE N Relationship source pathway id from the pathway table.
PATHWAY_T_ID DOUBLE N Relationship target pathway id from the pathway 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 - PATHWAY_RELTN


Child Column in PATHWAY_RELTN(FK) Parent Table Name Parent Column Name
Parents: PATHWAY_S_ID PATHWAY PATHWAY_ID
PATHWAY_T_ID PATHWAY PATHWAY_ID


PATHWAY_REVIEW



Column Section Relationship Section Top of Page


Table-level Detail

Description: PATHWAY_REVIEW
Definition: Contains review information for PowerPlan phases (pathway).
Table Type: ACTIVITY





Column Detail - PATHWAY_REVIEW


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.
PATHWAY_ID DOUBLE N The unique identifier for the PowerPlan phase to which the pathway review belongs.
PATHWAY_REVIEW_ID DOUBLE N Unique generated number that identifies a single row on the PATHWAY_REVIEW table.
PW_ACTION_SEQ DOUBLE N The pathway action sequence for the PowerPlan phase that created the review.
REVIEW_STATUS_FLAG DOUBLE N The status of the review.
REVIEW_TYPE_FLAG DOUBLE N The type of the review.
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 - PATHWAY_REVIEW


Child Column in PATHWAY_REVIEW(FK) Parent Table Name Parent Column Name
Parents: PATHWAY_ID PATHWAY PATHWAY_ID


PATHWAY_RULE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pathway Rule
Definition: This table defines pathway rules. A pathway rule describe an atomic action that can be done on an object in a PowerPlan.
Table Type: REFERENCE





Column Detail - PATHWAY_RULE


Column Name Type Null? Definition
ACTION_TYPE_FLAG DOUBLE N Enumeration that describes the action part of the rule. 1 - Include Component 2 - Exclude Component 3 - Select Order Sentence (Pharmacy Type, Comment) 4 - Ad hoc Order Component 5 - Ad hoc Outcome Component 6 - Custom IV Set
ENTITY_ID DOUBLE N The id of the entity that the rule will use.
ENTITY_NAME VARCHAR(32) Y The name of the table that is referenced by the entity identification.
ENTITY_UUID VARCHAR(255) Y The string UUID of the new entity.
ENTITY_VALUE DOUBLE N The value that the rule will apply.
PATHWAY_CUSTOMIZED_PLAN_ID DOUBLE N The customized plan that this rule is associated with
PATHWAY_RULE_ID DOUBLE N The Primary Key of the table
RULE_SEQUENCE DOUBLE N The sequence number of the row.
TARGET_DESCRIPTION VARCHAR(500) Y The target description
TARGET_PARENT_UUID VARCHAR(255) Y The target's parent UUID. This will be the sub phase component UUID if the rule is acting on a component inside a sub phase.
TARGET_UUID VARCHAR(255) N The target UUID that the rule is acting on.
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 - PATHWAY_RULE


Child Column in PATHWAY_RULE(FK) Parent Table Name Parent Column Name
Parents: PATHWAY_CUSTOMIZED_PLAN_ID PATHWAY_CUSTOMIZED_PLAN PATHWAY_CUSTOMIZED_PLAN_ID