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 |