Table Detail Report

MP_VIEWPOINT_ENCNTR



Column Section Relationship Section Top of Page


Table-level Detail

Description: MPages Viewpoint Encounter
Definition: Stores views that are associated with a viewpoint with specific encounter types. For example, for the Inpatient encounter type, the Inpatient Summary is associated
Table Type: REFERENCE





Column Detail - MP_VIEWPOINT_ENCNTR


Column Name Type Null? Definition
ENCNTR_TYPE_CD DOUBLE N The encounter type associated to this viewpoint.
MP_VIEWPOINT_ENCNTR_ID DOUBLE N Unique generated number that identifies a single row on the MP_VIEWPOINT_ENCNTR table.
MP_VIEWPOINT_RELTN_ID DOUBLE N The viewpoint relation row that this encounter type code pertains to.
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_VIEWPOINT_ENCNTR


Child Column in MP_VIEWPOINT_ENCNTR(FK) Parent Table Name Parent Column Name
Parents: MP_VIEWPOINT_RELTN_ID MP_VIEWPOINT_RELTN MP_VIEWPOINT_RELTN_ID


MP_VIEWPOINT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: MPages Viewpoint Relation
Definition: Stores the components that are a part of the MPages Viewpoint. Shows the relationship between a viewpoint and the views that are associated with the viewpoint (For Viewpoint X; Ambulatory Summary, Inpatient Summary, ICU Summary and a View Builder page are associated)
Table Type: REFERENCE





Column Detail - MP_VIEWPOINT_RELTN


Column Name Type Null? Definition
BR_DATAMART_CATEGORY_ID DOUBLE N The Bedrock category that is related to this Viewpoint.
MP_VIEWPOINT_ID DOUBLE N The MPages Viewpoint that is associated with this Bedrock Category.
MP_VIEWPOINT_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the MP_VIEWPOINT_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.
VIEW_SEQ DOUBLE N Sequences the tabs within a view. The tab is a Bedrock category.



Relationship Detail - MP_VIEWPOINT_RELTN


Child Column in MP_VIEWPOINT_RELTN(FK) Parent Table Name Parent Column Name
Parents: BR_DATAMART_CATEGORY_ID BR_DATAMART_CATEGORY BR_DATAMART_CATEGORY_ID
MP_VIEWPOINT_ID MP_VIEWPOINT MP_VIEWPOINT_ID




Parent Column in MP_VIEWPOINT_RELTN (PK) Child Table Name Child Column Name
Children: MP_VIEWPOINT_RELTN_ID MP_VIEWPOINT_ENCNTR MP_VIEWPOINT_RELTN_ID