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 |