MP_CONTENT_CONFIG



Column Section Top of Page


Table-level Detail

Description: MPages Content Configuration
Definition: Location for MPages configuration information.
Table Type: REFERENCE





Column Detail - MP_CONTENT_CONFIG


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.
BEGIN_EFFECTIVE_DT_TM DATETIME Y Date and time the record started to be effective.
CONFIG_KEY VARCHAR(255) N MPages configuration within a given type.
CONFIG_TXT VARCHAR(4000) N MPages configuration value for a given key.
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.
MP_CONTENT_CONFIG_ID DOUBLE N Unique generated number that identifies a single row on the MP_CONTENT_CONFIG table.
MP_CONTENT_CONFIG_TYPE_CD DOUBLE N The type of content being configured.
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.


MP_NOTIFICATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: MPages Notification
Definition: Track notification actions needed or taken within MPages.
Table Type: ACTIVITY





Column Detail - MP_NOTIFICATION


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.
ENCNTR_ID DOUBLE N The encounter on which the communication has been posted.
MP_NOTIFICATION_ID DOUBLE N Unique generated number that identifies a single row on the MP_NOTIFICATION table.
NOTIFICATION_SEQ DOUBLE N Sequences the notification type flag values with an encounter and personnel group.
NOTIFICATION_TYPE_FLAG DOUBLE N Indicates what type of notification has been created.
PERSON_ID DOUBLE N The person for which the communication has been posted.
PRSNL_ID DOUBLE N The personnel who has posted the communication.
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 - MP_NOTIFICATION


Child Column in MP_NOTIFICATION(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
PRSNL_ID PRSNL PERSON_ID




Parent Column in MP_NOTIFICATION (PK) Child Table Name Child Column Name
Children: MP_NOTIFICATION_ID MP_NOTIFICATION_DETAIL MP_NOTIFICATION_ID


MP_NOTIFICATION_ACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: MPages Notification Action
Definition: Store details of notification actions taken on a notification message.
Table Type: ACTIVITY





Column Detail - MP_NOTIFICATION_ACTION


Column Name Type Null? Definition
ACTION_DT_TM DATETIME N The date and time the action was taken.
ACTION_PRSNL_ID DOUBLE N The personnel who took the action.
ACTION_TYPE_CD DOUBLE N The type of action that was taken
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.
BEGIN_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.
MP_NOTIFICATION_ACTION_ID DOUBLE N Unique, generated number that identifies a single row on the MP_NOTIFICATION_ACTION table.
MP_NOTIFICATION_DETAIL_ID DOUBLE N This is the notification detail that this action was for.
ORIG_MP_NOTIFICATION_ACTION_ID DOUBLE N This field is used to track versions of the Notification actdions. This field will always point back to the initial value created. This may be used to find the correct version when combined with begin and end effective dates and times.
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 - MP_NOTIFICATION_ACTION


Child Column in MP_NOTIFICATION_ACTION(FK) Parent Table Name Parent Column Name
Parents: ORIG_MP_NOTIFICATION_ACTION_ID MP_NOTIFICATION_ACTION MP_NOTIFICATION_ACTION_ID
MP_NOTIFICATION_DETAIL_ID MP_NOTIFICATION_DETAIL MP_NOTIFICATION_DETAIL_ID
ACTION_PRSNL_ID PRSNL PERSON_ID




Parent Column in MP_NOTIFICATION_ACTION (PK) Child Table Name Child Column Name
Children: MP_NOTIFICATION_ACTION_ID MP_NOTIFICATION_ACTION ORIG_MP_NOTIFICATION_ACTION_ID


MP_NOTIFICATION_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: MPages Notification Detail
Definition: Store details of notification actions needed or taken within MPages.
Table Type: ACTIVITY





Column Detail - MP_NOTIFICATION_DETAIL


Column Name Type Null? Definition
BEGIN_EFFECTIVE_DT_TM DATETIME N The date that the row becomes or became effective.
CONSUMER_IDENT VARCHAR(60) N A value meaningful to the source of the notification.
CONSUMER_IDENT_SOURCE_NAME VARCHAR(60) N Indicates the source of the notification.
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.
MP_NOTIFICATION_DETAIL_ID DOUBLE N Unique generated number that identifies a single row on the MP_NOTIFICATION_DETAIL table.
MP_NOTIFICATION_ID DOUBLE N The notification that this detail applies to.
ORIG_MP_NOTIFICATION_DETAIL_ID DOUBLE N Column that groups a set of notification details together.
PARENT_ENTITY_EXT_ID DOUBLE N the secondary entity on which the notification is dependent. So for communication notification type this id is the code value of the communication message group.
PARENT_ENTITY_EXT_NAME VARCHAR(30) N The name of the table that contains the secoundary entity on which the notification is dependent upon.
PARENT_ENTITY_ID DOUBLE N The id of the source of a notification action.
PARENT_ENTITY_NAME VARCHAR(30) N The table name of the notification action referred to in the parent_entity_id column.
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 - MP_NOTIFICATION_DETAIL


Child Column in MP_NOTIFICATION_DETAIL(FK) Parent Table Name Parent Column Name
Parents: MP_NOTIFICATION_ID MP_NOTIFICATION MP_NOTIFICATION_ID
ORIG_MP_NOTIFICATION_DETAIL_ID MP_NOTIFICATION_DETAIL MP_NOTIFICATION_DETAIL_ID




Parent Column in MP_NOTIFICATION_DETAIL (PK) Child Table Name Child Column Name
Children: MP_NOTIFICATION_DETAIL_ID MP_NOTIFICATION_ACTION MP_NOTIFICATION_DETAIL_ID
MP_NOTIFICATION_DETAIL ORIG_MP_NOTIFICATION_DETAIL_ID


MP_QOC_ALIAS



Column Section Relationship Section Top of Page


Table-level Detail

Description: MPages Quick Orders and Charges Alias
Definition: Reference data used to alias or abreviate existing PowerOrder items used in the Quick Orders and Charges Mpage
Table Type: REFERENCE





Column Detail - MP_QOC_ALIAS


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.
ALIAS_DISP_NAME VARCHAR(255) Y Shortened display for a given entity.
ALIAS_THEME_COLOR_CD DOUBLE N The color display theme associated to the alias.
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.
FUNC_GROUPER_ALIAS_ID DOUBLE N %mechinisi
MP_QOC_ALIAS_ID DOUBLE N Unique, generated number that identifies a single row on the MP_QOC_ALIAS table.
ORIG_MP_QOC_ALIAS_ID DOUBLE N This field is used to track versions of the aliases. This field will always point back to the initial value created. This may be used to find the correct version when combined with begin and end effective dates and times.
PARENT_ENTITY_ID DOUBLE N Unique primary identifier of the parent table.
PARENT_ENTITY_NAME VARCHAR(32) N The name of the parent table. Possible values: ORDER_CATALOG_SYNONYM, ORDER_SENTENCE, PATHWAY_CATALOG,PW_CAT_SYNONYM.
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_QOC_ALIAS


Child Column in MP_QOC_ALIAS(FK) Parent Table Name Parent Column Name
Parents: FUNC_GROUPER_ALIAS_ID MP_QOC_ALIAS MP_QOC_ALIAS_ID
ORIG_MP_QOC_ALIAS_ID MP_QOC_ALIAS MP_QOC_ALIAS_ID




Parent Column in MP_QOC_ALIAS (PK) Child Table Name Child Column Name
Children: MP_QOC_ALIAS_ID MP_QOC_ALIAS FUNC_GROUPER_ALIAS_ID
MP_QOC_ALIAS ORIG_MP_QOC_ALIAS_ID