Table Detail Report

MP_MPAGE_DEF



Column Section Relationship Section Top of Page


Table-level Detail

Description: Mpage Definition
Definition: Base information about an MPage. Used by MPage Definition Manager application and the Specialty Experience Manager.
Table Type: REFERENCE





Column Detail - MP_MPAGE_DEF


Column Name Type Null? Definition
APPLICATION_NUMBER DOUBLE N Contains the application number that the definition is associated with.
DEF_TYPE_FLAG DOUBLE N This flag will distinguish which application (Definition Manager/Specialty Manager) is using saved record/definition.
DISPLAY_TXT VARCHAR(100) N Display string for the MPages definition.
DRIVER_SCRIPT_NAME VARCHAR(255) N The script that controls the rendering of the MPage.
MPAGE_MEANING VARCHAR(30) N A short description of the MPage
MP_MPAGE_DEF_ID DOUBLE N Unique generated number that identifies a single row on the MP_MPAGE_DEF table.
PARAMETER_TXT VARCHAR(255) N The parameters used by the driver script when rendering the MPage.
POSITION_CD DOUBLE N The position code of the user at the time the row was created.
PRSNL_ID DOUBLE N Used in Specialty Manager. The person for which the definition was saved.
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.
VIEW_SEQ DOUBLE N Specialty Manager saves the definition for specific PowerChart tabs(Org/Chart level). view_seq will be used to identify that tab.



Relationship Detail - MP_MPAGE_DEF


Child Column in MP_MPAGE_DEF(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID




Parent Column in MP_MPAGE_DEF (PK) Child Table Name Child Column Name
Children: MP_MPAGE_DEF_ID MP_MPAGE_GROUP_RELTN MP_MPAGE_DEF_ID


MP_MPAGE_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: MPage Group
Definition: Defines a group of MPages.
Table Type: REFERENCE





Column Detail - MP_MPAGE_GROUP


Column Name Type Null? Definition
GROUP_NAME VARCHAR(100) N The name to be displayed for a group.
MP_MPAGE_GROUP_ID DOUBLE N Unique generated number that identifies a single row on the MP_MPAGE_GROUP 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 - MP_MPAGE_GROUP




Parent Column in MP_MPAGE_GROUP (PK) Child Table Name Child Column Name
Children: MP_MPAGE_GROUP_ID MP_MPAGE_GROUP_RELTN MP_MPAGE_GROUP_ID


MP_MPAGE_GROUP_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: MPage Group Relation
Definition: Defines the MPages that belong to an MPage group.
Table Type: REFERENCE





Column Detail - MP_MPAGE_GROUP_RELTN


Column Name Type Null? Definition
MP_MPAGE_DEF_ID DOUBLE N The MPage that belongs to this group
MP_MPAGE_GROUP_ID DOUBLE N The group that this MPage is part of.
MP_MPAGE_GROUP_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the MP_MPAGE_GROUP_RELTN 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 - MP_MPAGE_GROUP_RELTN


Child Column in MP_MPAGE_GROUP_RELTN(FK) Parent Table Name Parent Column Name
Parents: MP_MPAGE_DEF_ID MP_MPAGE_DEF MP_MPAGE_DEF_ID
MP_MPAGE_GROUP_ID MP_MPAGE_GROUP MP_MPAGE_GROUP_ID