Table Detail Report

PW_CAT_SYNONYM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pathway Catalog Synonym
Definition: This table holds the synonyms for a given catalog pathway catalog.
Table Type: REFERENCE





Column Detail - PW_CAT_SYNONYM


Column Name Type Null? Definition
PATHWAY_CATALOG_ID DOUBLE N Pathway catalog identification. Unique id of the pathway catalog entry referenced by an entry on this table.
PRIMARY_IND DOUBLE N Indicate whether the entry is a primary synonym entry
PW_CAT_SYNONYM_ID DOUBLE N Primary Key
SYNONYM_NAME VARCHAR(100) N Alternate name for a treatment phase, plan or protocol stored on PATHWAY_CATALOG table.
SYNONYM_NAME_KEY VARCHAR(100) N Synonym key of the field synonym. This field has all capital letters and punctuation removed. It is used for indexing and searching for a pathway catalog.
SYNONYM_NAME_KEY_A_NLS VARCHAR(400) N KEY Value field for NLS support
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_SYNONYM


Child Column in PW_CAT_SYNONYM(FK) Parent Table Name Parent Column Name
Parents: PATHWAY_CATALOG_ID PATHWAY_CATALOG PATHWAY_CATALOG_ID




Parent Column in PW_CAT_SYNONYM (PK) Child Table Name Child Column Name
Children: PW_CAT_SYNONYM_ID ALT_SEL_LIST PW_CAT_SYNONYM_ID


PW_COMP_ACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: pw_comp_action
Definition: Pathway component action
Table Type: ACTIVITY





Column Detail - PW_COMP_ACTION


Column Name Type Null? Definition
ACTION_DT_TM DATETIME N Date and time of the action
ACTION_PRSNL_ID DOUBLE N Id of the person who performed the action
ACTION_TYPE_CD DOUBLE N Action type code
ACTION_TZ DOUBLE Y Time zone associated with the corresponding dt_tm column.
ACT_PW_COMP_ID DOUBLE N Id of the pathway component the action is associated with
COMP_STATUS_CD DOUBLE N Status code of the component after the action was perfomed
PARENT_ENTITY_ID DOUBLE N Id of the parent entity of the pathway component.Column
PARENT_ENTITY_NAME VARCHAR(32) Y Name of the table that the pathway component references.Column
PW_COMP_ACTION_SEQ DOUBLE N Sequence of the action the component
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_ACTION


Child Column in PW_COMP_ACTION(FK) Parent Table Name Parent Column Name
Parents: ACT_PW_COMP_ID ACT_PW_COMP ACT_PW_COMP_ID


PW_COMP_ACT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pathway component phase activity relation
Definition: This table holds the relationship between component and the phase
Table Type: ACTIVITY





Column Detail - PW_COMP_ACT_RELTN


Column Name Type Null? Definition
ACT_PW_COMP_ID DOUBLE N Pathway component identification. Unique id of the pathway comp entry referenced by an entry on this table.
PATHWAY_ID DOUBLE N Pathway catalog identification. Unique id of the pathway catalog entry referenced by an entry on this table.
PW_COMP_ACT_RELTN_ID DOUBLE N PRIMARY KEY
TYPE_MEAN VARCHAR(12) N Indicates the type of relationship between the component and pathway catalog. Possible values - SCHEDANCHOR.
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_ACT_RELTN


Child Column in PW_COMP_ACT_RELTN(FK) Parent Table Name Parent Column Name
Parents: ACT_PW_COMP_ID ACT_PW_COMP ACT_PW_COMP_ID
PATHWAY_ID PATHWAY PATHWAY_ID


PW_COMP_CAT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pathway component phase reference relation
Definition: This table holds the relationship between component and the phase
Table Type: REFERENCE





Column Detail - PW_COMP_CAT_RELTN


Column Name Type Null? Definition
PATHWAY_CATALOG_ID DOUBLE N Pathway catalog identification. Unique id of the pathway catalog entry referenced by an entry on this table.
PATHWAY_COMP_ID DOUBLE N Pathway component identification. Unique id of the pathway comp entry referenced by an entry on this table.
PW_COMP_CAT_RELTN_ID DOUBLE N PRIMARY KEY
TYPE_MEAN VARCHAR(12) N Indicates the type of relationship between the component and pathway catalog. Possible values - SCHEDANCHOR
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_CAT_RELTN


Child Column in PW_COMP_CAT_RELTN(FK) Parent Table Name Parent Column Name
Parents: PATHWAY_CATALOG_ID PATHWAY_CATALOG PATHWAY_CATALOG_ID
PATHWAY_COMP_ID PATHWAY_COMP PATHWAY_COMP_ID


PW_COMP_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: PW COMP GROUP
Definition: Used to define groups of components within a pathway.
Table Type: REFERENCE





Column Detail - PW_COMP_GROUP


Column Name Type Null? Definition
ANCHOR_COMPONENT_IND DOUBLE N Designates a component group member as the anchor component for the group. Only used by groups with a LINKEDCOMP type_mean.
COMP_SEQ DOUBLE Y Sequence of the component within the group.
DESCRIPTION VARCHAR(99) Y A description of the component group.
LINKING_RULE_FLAG DOUBLE N A flag that determines the type of linking rule to be used for the component group. Only used by groups with a LINKEDCOMP type_mean. 0 - Not Set, 1 - At Least, 2 - Exactly, and 3 - At Most.
LINKING_RULE_QUANTITY DOUBLE N A quantity to be applied in conjunction with the linking_rule_flag. Only used by groups with a LINKEDCOMP type_mean.
OVERRIDE_REASON_FLAG DOUBLE N Controls the manner in which override reasons are harvested for plan component linking groups. 0 - Tooltip only; 1 - Dialog - optional; 2 - Dialog - required
PATHWAY_CATALOG_ID DOUBLE N Pathway catalog entry id from the pathway_catalog table that this group belongs to.
PATHWAY_COMP_ID DOUBLE N Pathway component id from the pathway_comp table.
PW_COMP_GROUP_ID DOUBLE N Unique id of the component group.
TYPE_MEAN VARCHAR(12) N Meaning that identifies the type of group.
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.



Relationship Detail - PW_COMP_GROUP


Child Column in PW_COMP_GROUP(FK) Parent Table Name Parent Column Name
Parents: PATHWAY_CATALOG_ID PATHWAY_CATALOG PATHWAY_CATALOG_ID
PATHWAY_COMP_ID PATHWAY_COMP PATHWAY_COMP_ID