Table Detail Report

PAT_ED_DOC_LEAFLET_ACTIVITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Patient Education Medication Leaflet Activity
Definition: This table stores Patient Education Medication Leaflet from Multum given to Patients from Fistnet Patient Education Module
Table Type: ACTIVITY





Column Detail - PAT_ED_DOC_LEAFLET_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.
INSTRUCTION_DT_TM DATETIME N Date and time when instruction given
INSTRUCTION_PRSNL_ID DOUBLE N Prsnl_id of the user who educated patient from prsnl table
LEAFLET_NAME VARCHAR(150) N Stores the name of the medication for instruction is given
MED_LEAFLET_CKI VARCHAR(255) N Stores the CKI value for the Medication Leaflet
PAT_ED_DOC_ID DOUBLE N Foreign key stores the PAT_ED_DOCUMENT row from the parent table
PAT_ED_DOC_LEAFLET_ACTIVITY_ID DOUBLE N Primary Key of the table
PRINT_IND DOUBLE N Indicator to show if the instruction is printed
SUGGESTED_IND DOUBLE N Determines if the leaflet instruction was suggested during selection.
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_LEAFLET_ACTIVITY


Child Column in PAT_ED_DOC_LEAFLET_ACTIVITY(FK) Parent Table Name Parent Column Name
Parents: PAT_ED_DOC_ID PAT_ED_DOCUMENT PAT_ED_DOCUMENT_ID
INSTRUCTION_PRSNL_ID PRSNL PERSON_ID


PAT_ED_DX_RELTN



Column Section Top of Page


Table-level Detail

Description: Patient Education DX Relation
Definition: This table stores mapped ICD9s to Patient Education Content.
Table Type: REFERENCE





Column Detail - PAT_ED_DX_RELTN


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.
KEY_DOC_IDENT VARCHAR(255) N Indicates content provider unique instruction key identifier
KEY_DOC_ID_VALUE DOUBLE N Unique key identifier per content domain. This is storing an identifier - unique to an instruction and content domain used.
PAT_ED_DX_RELTN_ID DOUBLE N Primary Key for table
PAT_ED_RELTN_DESC_KEY VARCHAR(1000) N key from pat_ed_reltn tableColumn
SOURCE_IDENTIFIER VARCHAR(50) N Source identifier string from nomenclature table.
SOURCE_VOCABULARY_CD DOUBLE N Type of source identifier as icd9 or snomed
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_FAVORITES



Column Section Relationship Section Top of Page


Table-level Detail

Description: PAT ED FAVORITES
Definition: Contains patient education favorites
Table Type: ACTIVITY





Column Detail - PAT_ED_FAVORITES


Column Name Type Null? Definition
FAVORITE_TYPE_CD DOUBLE N Defines what type of Favorite from code set 20531
PAT_ED_FAVR_ID DOUBLE N Primary Field
PAT_ED_RELTN_ID DOUBLE N Contains patient education relation idColumn
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
TRACKING_GROUP_CD DOUBLE N Tracking Group Code from code set 16370
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_FAVORITES


Child Column in PAT_ED_FAVORITES(FK) Parent Table Name Parent Column Name
Parents: PAT_ED_RELTN_ID PAT_ED_RELTN PAT_ED_RELTN_ID
PERSON_ID PRSNL PERSON_ID


PAT_ED_FOLLOWUP_FAVORITES



Column Section Relationship Section Top of Page


Table-level Detail

Description: pat_ed_followup_favorites
Definition: This will store the patient education followup favorites for clinicians to have easier access to.
Table Type: ACTIVITY





Column Detail - PAT_ED_FOLLOWUP_FAVORITES


Column Name Type Null? Definition
COMMENT_TXT_ID DOUBLE N Comment text added to the follow-up- FK from LONG_TEXT table
PAT_ED_FOLLOWUP_FAVORITES_ID DOUBLE N %followup%
PRSNL_ID DOUBLE N Provider Identifier
RECIPIENT_TXT_ID DOUBLE N External recipient email added to the follow-up- FK from long text 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.
WHEN_DT_TM DATETIME Y %followup%
WHEN_IN_TYPE_FLAG DOUBLE Y Value to identify in selection
WHEN_IN_VAL DOUBLE Y Integer of the In value associated with when_in_type_flag
WHEN_NEEDED_IND DOUBLE Y %followup%
WHEN_WITHIN_CD DOUBLE N WHEN WITHIN SELECTION CODE FROM CODESET 27980
WHERE_TXT_ID DOUBLE N Where text added to the follow-up FK from LONG_TEXT table
WHO_ID DOUBLE N Id value of the who context
WHO_NAME VARCHAR(30) Y NAME OF THE TABLE PROVIDING VALUE FOR THE WHO_ID Field
WHO_STRING VARCHAR(255) Y String value of the who context



Relationship Detail - PAT_ED_FOLLOWUP_FAVORITES


Child Column in PAT_ED_FOLLOWUP_FAVORITES(FK) Parent Table Name Parent Column Name
Parents: COMMENT_TXT_ID LONG_TEXT LONG_TEXT_ID
RECIPIENT_TXT_ID LONG_TEXT LONG_TEXT_ID
WHERE_TXT_ID LONG_TEXT LONG_TEXT_ID
PRSNL_ID PRSNL PERSON_ID


PAT_ED_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Patient Education Relationship table
Definition: Contains the relationship between the individual instructions and the instruction hierarchy
Table Type: REFERENCE





Column Detail - PAT_ED_RELTN


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.
CONTENT_SUPPLIER_CD DOUBLE N Content Supplier Code
CUSTOM_IND DOUBLE N 0 - Indicates the row is Standard Content 1 - Indicates the row is a Custom Instruction
DOC_LANG_ID_VALUE DOUBLE N Language identifier that corresponds to the language of the instruction. This is storing an id that relates to the language for the instruction content.
DOC_TYPES VARCHAR(255) Y A list of document types that this instruction content is related to. Relates the instruction to different document types.
KEY_DOC_IDENT VARCHAR(255) Y Indicates content provider unique instruction key identifier
KEY_DOC_ID_VALUE DOUBLE N Unique key identifier per content domain. This is storing an identifier - unique to an instruction and content domain used. Value comes from an outside source.
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_RELTN_DESC VARCHAR(1000) Y This is the Title of the Instruction that is displayed in the hierarchy.
PAT_ED_RELTN_DESC_KEY VARCHAR(1000) N INDEXED FIELD for the Title of the Instruction that is displayed in the hierarchy.
PAT_ED_RELTN_DESC_KEY_A_NLS VARCHAR(4000) Y PAT_ED_RELTN_DESC_KEY_A_NLS column
PAT_ED_RELTN_DESC_KEY_NLS VARCHAR(2002) Y Corresponding Non-English character set for the Title of the Instruction that is displayed in the hierarchy. (no longer used - replaced by the _A_NLS version of this column).
PAT_ED_RELTN_ID DOUBLE N Identifier used to uniquely identify Patient Education Relation records.
PAT_ED_RELTN_PARENT_ID DOUBLE N Parent PAT_ED_RELTN_ID to this row used to define the hierarchy of instructions
PRSNL_ID DOUBLE N Personnel ID from the PRSNL table that identifies the owner of the custom instruction. PRNSL_ID of 0 indicates public instruction.
REFR_TEXT_ID DOUBLE N As of early 2007 - This column now contains a foreign key value from the LONG_BLOB_REFERENCE table. That is when patient education content began to incorporate images. As a result, long_text_reference no longer had the capacity to save an entire document
SHORTCUT_NAME VARCHAR(1000) Y This column will become obsolete when new table (PAT_ED_SHORTCUT) is implemented. New logic allows for multiple shortcut names -- shortcut name of an instruction that is given by the content domain.
TRACK_GROUP_CD DOUBLE N Identifies the TRACK_GROUP_CD for Instructions
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_RELTN


Child Column in PAT_ED_RELTN(FK) Parent Table Name Parent Column Name
Parents: PAT_ED_RELTN_PARENT_ID PAT_ED_RELTN PAT_ED_RELTN_ID
PRSNL_ID PRSNL PERSON_ID




Parent Column in PAT_ED_RELTN (PK) Child Table Name Child Column Name
Children: PAT_ED_RELTN_ID MRU_LOOKUP_ED_DOC PAT_ED_RELTN_ID
PAT_ED_DOC_ACTIVITY PAT_ED_RELTN_ID
PAT_ED_FAVORITES PAT_ED_RELTN_ID
PAT_ED_RELTN PAT_ED_RELTN_PARENT_ID
PAT_ED_SHORTCUT PAT_ED_RELTN_ID