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