MP_PRIMED_VIEW_ACT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Mpages Primed Views Activity
Definition: Used to store primed data for Patients based on population and reference views.
Table Type: ACTIVITY





Column Detail - MP_PRIMED_VIEW_ACT


Column Name Type Null? Definition
DATA_BLOB LONGBLOB Y The JSON blob that is consumed by the Mpages front end.
ENCNTR_ID DOUBLE N Encounter ID from Encounter Table.
LOAD_DT_TM DATETIME N Time Data was loaded into the table
LONG_BLOB_ID DOUBLE N *** OBSOLETE ***
MP_PRIMED_VIEW_ACT_ID DOUBLE N Unique generated number that identifies a single row on the MP_PRIMED_VIEW_ACT table.
MP_PRIMED_VIEW_REF_ID DOUBLE N Unique ID from MP_DPV_REF table
PENDING_UPDT_IND DOUBLE N Indicates if this row is pending for the update script to complete execution.
PERSON_ID DOUBLE N Person ID from person 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_PRIMED_VIEW_ACT


Child Column in MP_PRIMED_VIEW_ACT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
MP_PRIMED_VIEW_REF_ID MP_PRIMED_VIEW_REF MP_PRIMED_VIEW_REF_ID
PERSON_ID PERSON PERSON_ID


MP_PRIMED_VIEW_POP



Column Section Relationship Section Top of Page


Table-level Detail

Description: MP_PRIMED_VIEW_POP
Definition: Contains the patients currently active in Primed view Population
Table Type: ACTIVITY





Column Detail - MP_PRIMED_VIEW_POP


Column Name Type Null? Definition
MP_PRIMED_VIEW_POP_ID DOUBLE N Unique generated number that identifies a single row on the MP_PRIMED_VIEW_POP table.
PERSON_ID DOUBLE N PERSON_ID from person table
POP_NAME VARCHAR(20) N The named population.
POP_PARENT_ENTITY_ID DOUBLE N Contains ID from referenced table e.g. TRACK_GROUP_ID
POP_PARENT_ENTITY_NAME VARCHAR(30) N Contains table name of referenced table e.g. TRACK_GROUP. This identifies for a patient what caused them to be added to population
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_ERROR_IND DOUBLE N Indicates if an error in priming has occurred for the patient.



Relationship Detail - MP_PRIMED_VIEW_POP


Child Column in MP_PRIMED_VIEW_POP(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID


MP_PRIMED_VIEW_REF



Column Section Relationship Section Top of Page


Table-level Detail

Description: Mpages Primed Views Reference
Definition: Used to store Reference information about views. These views will be applied to the patients in the population table and then loaded into the activity table
Table Type: REFERENCE





Column Detail - MP_PRIMED_VIEW_REF


Column Name Type Null? Definition
CATEGORY_CONFIG_TXT VARCHAR(100) N String to identify overall view. For summary Mpages this will be the category_mean from the br_datamart_category table.
COMPONENT_CONFIG_TXT VARCHAR(100) N String to identify what settings are used to load data. For summary Mpages this will be the report_mean from br_datamart_report table.
DATA_GROUP_NAME VARCHAR(100) N Name of sequence used to identify a view with multiple different types of data loads
DATA_OBJECT_NAME VARCHAR(100) N Name of CCL object used to load data for this view
ENABLED_IND DOUBLE N Indicates if the reference view is enabled for priming.
MP_PRIMED_VIEW_REF_ID DOUBLE N Unique generated number that identifies a single row on the MP_PRIMED_VIEW_REF table.
POP_NAME VARCHAR(30) N The named population.
POP_PARENT_ENTITY_ID DOUBLE N Contains ID from referenced table e.g. TRACK_GROUP_ID
POP_PARENT_ENTITY_NAME VARCHAR(30) N Contains table name of referenced table e.g. TRACK_GROUP. This identifies for a patient what caused them to be added to population
PROXY_PRSNL_ID DOUBLE N Personnel Id to be used as template when applying privs
PRSNL_GROUP_ID DOUBLE N The ID of the personnel group category related to this view.
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_PRIMED_VIEW_REF


Child Column in MP_PRIMED_VIEW_REF(FK) Parent Table Name Parent Column Name
Parents: PROXY_PRSNL_ID PRSNL PERSON_ID
PRSNL_GROUP_ID PRSNL_GROUP PRSNL_GROUP_ID




Parent Column in MP_PRIMED_VIEW_REF (PK) Child Table Name Child Column Name
Children: MP_PRIMED_VIEW_REF_ID MP_PRIMED_VIEW_ACT MP_PRIMED_VIEW_REF_ID


WL_ACTIVITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: MP WORKLIST ACTIVITY
Definition: This table will be used to create activity data for mp worklist rows.
Table Type: ACTIVITY





Column Detail - WL_ACTIVITY


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.
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.
ENCNTR_ID DOUBLE N The ENCOUNTER related to this ACTIVITY
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.
PERSON_ID DOUBLE N The PERSON for which this Worklist is being created
SCH_APPT_ID DOUBLE N The Scheduling Appointment for this worklist activity
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.
WL_ACTIVITY_ID DOUBLE N PRIMARY KEY
WL_CRITERIA_ID DOUBLE N Identifies the Critera for why an ACTIVITY row was created. FK Value from table WL_CRITERIA.
WORKLIST_CD DOUBLE N Identifies which Worklist type we are working with for this activity



Relationship Detail - WL_ACTIVITY


Child Column in WL_ACTIVITY(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
SCH_APPT_ID SCH_APPT SCH_APPT_ID
WL_CRITERIA_ID WL_CRITERIA WL_CRITERIA_ID




Parent Column in WL_ACTIVITY (PK) Child Table Name Child Column Name
Children: WL_ACTIVITY_ID WL_ACTIVITY_DETAIL WL_ACTIVITY_ID


WL_ACTIVITY_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: MP WORKLIST ACTIVITY DETAIL
Definition: This table will be used to store details off of the mp_worklist_act table. An example would be adding rows for clinical_events, while the parent table is the person/encounter.
Table Type: ACTIVITY





Column Detail - WL_ACTIVITY_DETAIL


Column Name Type Null? Definition
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.
PARENT_ENTITY_ID DOUBLE N Number is a primary key id on a different table, identified by PARENT_ENTITY_NAME.
PARENT_ENTITY_NAME VARCHAR(30) N Name of the table being used for the parent_entity_id.
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.
WL_ACTIVITY_DETAIL_CD DOUBLE N This code will identify the different details associated with an activity
WL_ACTIVITY_DETAIL_ID DOUBLE N PRIMARY KEY
WL_ACTIVITY_ID DOUBLE N Identifies the ACTIVITY for this detail record.



Relationship Detail - WL_ACTIVITY_DETAIL


Child Column in WL_ACTIVITY_DETAIL(FK) Parent Table Name Parent Column Name
Parents: WL_ACTIVITY_ID WL_ACTIVITY WL_ACTIVITY_ID