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 |