Table Detail Report
MRU_PRIMARY_FACT_EXTENSION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Most Recently Used Primary Fact Extension |
Definition: | Associates an mru fact collection to a primary fact to specify what additional data must be considered in addition to the primary fact when making an mru based decision. |
Table Type: | REFERENCE |
Column Detail - MRU_PRIMARY_FACT_EXTENSION
Column Name | Type | Null? | Definition |
---|---|---|---|
BEST_PRACTICE_IND | DOUBLE | N | Best practices are built in - disable community learning and individualized prompting if set. |
MRU_AREA_CD | DOUBLE | N | MRU area code |
MRU_FACT_COLLECTION_ID | DOUBLE | N | Identify the fact collection associated to this primary mru fact |
MRU_PRIMARY_FACT_EXTENSION_ID | DOUBLE | N | Primary Key |
PRIMARY_FACT_ID | DOUBLE | N | Parent_entity_id for the primary fact |
PRIMARY_FACT_MODIFIER | VARCHAR(50) | N | Additional specification for the primary fact |
PRIMARY_FACT_SOURCE | VARCHAR(30) | N | Parent entity name for the primary fact |
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 - MRU_PRIMARY_FACT_EXTENSION
Child Column in MRU_PRIMARY_FACT_EXTENSION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | MRU_FACT_COLLECTION_ID | MRU_FACT_COLLECTION | MRU_FACT_COLLECTION_ID |
MRU_STATISTIC
Column Section | Top of Page |
Table-level Detail
Description: | Most Recently Used Statistic |
Definition: | Usage statistics for choices/decisions made by users allowing those choices to be defaulted the next time a user encounters the same situation |
Table Type: | ACTIVITY |
Column Detail - MRU_STATISTIC
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. |
MANUAL_DESEL_CNT | DOUBLE | N | Number of times this item was manually deselected |
MANUAL_DESEL_RATIO | DOUBLE | Y | Manual_desel_cnt/sel_cnt |
MANUAL_SEL_CNT | DOUBLE | N | Number of times this item was manually selected |
MANUAL_SEL_RATIO | DOUBLE | Y | Manual_sel_cnt/sel_cnt |
MRU_AREA_CD | DOUBLE | N | Specifies what mru was invoked |
MRU_CNT | DOUBLE | N | Number of times item has recently been selected |
MRU_FACT1_CD | DOUBLE | N | Names and meanings of data items used in MRU Selections |
MRU_FACT1_SOURCE | VARCHAR(30) | N | Parent_entity_name for the mru fact |
MRU_FACT1_VALUE | DOUBLE | N | Parent_entity_id for the mru_fact |
MRU_FACT2_CD | DOUBLE | N | Names and meanings of data items used in MRU Selections |
MRU_FACT2_SOURCE | VARCHAR(30) | N | Parent_entity_name for the mru fact |
MRU_FACT2_VALUE | DOUBLE | N | Parent_entity_id for the mru_fact |
MRU_FACT3_CD | DOUBLE | N | Names and meanings of data items used in MRU Selections |
MRU_FACT3_SOURCE | VARCHAR(30) | N | Parent_entity_name for the mru fact |
MRU_FACT3_VALUE | DOUBLE | N | Parent_entity_id for the mru_fact |
MRU_FACT4_CD | DOUBLE | N | Names and meanings of data items used in MRU Selections |
MRU_FACT4_SOURCE | VARCHAR(30) | N | Parent_entity_name for the mru fact |
MRU_FACT4_VALUE | DOUBLE | N | Parent_entity_id for the mru_fact |
MRU_STATISTIC_ID | DOUBLE | N | Primary key |
PRIMARY_FACT_ID | DOUBLE | N | Parent_entity_id for the primary fact |
PRIMARY_FACT_MODIFIER | VARCHAR(50) | N | Additional specification for the primary fact |
PRIMARY_FACT_SOURCE | VARCHAR(30) | N | Parent_entity_name for the primary fact |
PRSNL_COMMUNITY_ID | DOUBLE | N | Community this mru is associated to |
PRSNL_COMMUNITY_SOURCE | VARCHAR(30) | N | Parent_entity_name for the primary fact |
PRSNL_ID | DOUBLE | N | Link to prsnl.person_id |
SELECTION_ID | DOUBLE | N | Parent_entity_id of the item to select |
SELECTION_SOURCE | VARCHAR(30) | N | Parent_entity_name_of the item to select |
SEL_CNT | DOUBLE | N | Number of times item was selected |
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. |
PAT_ED_DOCUMENT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PAT ED DOCUMENT |
Definition: | This table uniquly holds the patient education document for a patients encounter |
Table Type: | ACTIVITY |
Column Detail - PAT_ED_DOCUMENT
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | 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. |
CREATE_DT_TM | DATETIME | Y | Date the document was createdColumn |
CREATE_ID | DOUBLE | N | ID of the person that created the documentColumn |
ENCNTR_ID | DOUBLE | N | This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number. |
EVENT_ID | DOUBLE | N | Event Id from the clinical events table after the document is signed . |
PAT_ED_DOCUMENT_ID | DOUBLE | N | Primary key to the tables. uniquely holds the each documents for a encounter |
PAT_ED_DOMAIN_CD | DOUBLE | N | This field contains the code value for the patient education domain. A domain is defined as a set of content that is relevant to a clinical context. For instance, the emergency department is a domain that has content that is specific to the ED. And, the acute care domain may have content that is specific to inpatients. |
PAT_ED_SUGGESTED_IND | DOUBLE | Y | This determines if the encounter received any patient education instructions that were suggested by emergency medicine algorithm |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
SIGNED_DT_TM | DATETIME | Y | This indicated the date n time at which the document is signed. |
SIGNED_ID | DOUBLE | N | Signed_id provides the person_id for the prsnl who has signed the document |
STATUS_CD | DOUBLE | N | Staus of the document. Code from Code Set 8. |
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 - PAT_ED_DOCUMENT
Child Column in PAT_ED_DOCUMENT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
PERSON_ID | PERSON | PERSON_ID |
Parent Column in PAT_ED_DOCUMENT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PAT_ED_DOCUMENT_ID | PAT_ED_DOC_ACTIVITY | PAT_ED_DOC_ID |
PAT_ED_DOC_FOLLOWUP | PAT_ED_DOC_ID | ||
PAT_ED_DOC_LEAFLET_ACTIVITY | PAT_ED_DOC_ID |
PAT_ED_DOC_ACTIVITY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PAT ED DOC ACTIVITY |
Definition: | This tables hold the patient education document Instructions activity. |
Table Type: | ACTIVITY |
Column Detail - PAT_ED_DOC_ACTIVITY
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | 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. |
DOC_LANG_ID_VALUE | DOUBLE | N | The language id value that corresponds to the activity instruction. |
DOC_TYPES | VARCHAR(255) | Y | Document types to which this instruction activity belongs. |
INSTRUCTION_DT_TM | DATETIME | Y | The date and time when this instruction was printed. |
INSTRUCTION_NAME | VARCHAR(1000) | N | The instruction name that is displayed to the user |
INSTRUCTION_USER_ID | DOUBLE | N | The user id of who printed this instruction |
KEY_DOC_IDENT | VARCHAR(255) | Y | A unique key that identifies this instruction. |
LONG_TEXT_ID | DOUBLE | N | This column hold the long text id form the long text table where the insruction given to the patient is stored. |
PAT_ED_DOC_ACTIVITY_ID | DOUBLE | N | Primary key to this table. It uniquely stores each instruction given to the patient. |
PAT_ED_DOC_ID | DOUBLE | N | Unique key for each doucment created for a patients encounter.Column |
PAT_ED_DOMAIN_CD | DOUBLE | N | The content domain that the activity instruction was selected from |
PAT_ED_RELTN_ID | DOUBLE | N | Reference to original patient education instructionColumn |
PRINT_IND | DOUBLE | N | 1 if printed and 0 if not. |
REFR_TEXT_ID | DOUBLE | N | Reference to original patient education instructions text if from the ref_text table |
STATUS_CD | DOUBLE | N | Status of the Instruction (from code set 8) |
TYPE_FLAG | DOUBLE | Y | Determines the type of instruction that was saved to the activity. Null = undertermined, 0 = Patient Education instruction not suggested, 1 = Infobutton instruction, 2 = Patient Education instruction suggested |
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 - PAT_ED_DOC_ACTIVITY
Child Column in PAT_ED_DOC_ACTIVITY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LONG_TEXT_ID | LONG_BLOB | LONG_BLOB_ID |
PAT_ED_DOC_ID | PAT_ED_DOCUMENT | PAT_ED_DOCUMENT_ID | |
PAT_ED_RELTN_ID | PAT_ED_RELTN | PAT_ED_RELTN_ID | |
INSTRUCTION_USER_ID | PRSNL | PERSON_ID |
PAT_ED_DOC_FOLLOWUP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PAT ED DOC FOLLOWUP |
Definition: | Store the patients followup information of a document. |
Table Type: | ACTIVITY |
Column Detail - PAT_ED_DOC_FOLLOWUP
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | 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. |
ADDRESS_TYPE_CD | DOUBLE | N | The address type is the code set value which identifies the type of address for the address row (i.e., home, business, etc.) |
ADD_LONG_TEXT_ID | DOUBLE | N | Stores the long text id to the address the patient should go to , to see the provider. |
CMT_LONG_TEXT_ID | DOUBLE | N | Stores the long_text id to the comments that are provided to patient. |
DAYS_OR_WEEKS | DOUBLE | Y | This indicates the days and weeks |
FOLLOWUP_NEEDED_IND | DOUBLE | N | An indicator to show if the follow-up needs to happen only "if needed". Follow up with provider only if needed. |
FOL_WITHIN_DAYS | DOUBLE | Y | The number of days the patient should follow up. |
FOL_WITHIN_DT_TM | DATETIME | Y | %followup% |
FOL_WITHIN_RANGE | VARCHAR(100) | Y | Store the date and time range to follow-upin. |
LOCATION_CD | DOUBLE | N | Follow up location if the follow up is in a clinic. |
ORGANIZATION_ID | DOUBLE | N | Organization used for follow-upinstructions. |
PAT_ED_DOC_FOLLOWUP_ID | DOUBLE | N | Primary key .Uniqe id of the follow-up information |
PAT_ED_DOC_ID | DOUBLE | N | Identifier to the unique patient education document |
PROVIDER_ID | DOUBLE | N | Person id of the provider. |
PROVIDER_NAME | VARCHAR(4000) | Y | Name of the provider |
QUICK_PICK_CD | DOUBLE | N | Code value of the selected follow-upquick pick selected. |
RECIPIENT_LONG_TEXT_ID | DOUBLE | N | Stores the long text ID to the external recipient email |
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 - PAT_ED_DOC_FOLLOWUP
Child Column in PAT_ED_DOC_FOLLOWUP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ADD_LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID |
CMT_LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID | |
RECIPIENT_LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID | |
ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID | |
PAT_ED_DOC_ID | PAT_ED_DOCUMENT | PAT_ED_DOCUMENT_ID |