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 |