Table Detail Report

PDOC_TAG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Physician Documentation Tag
Definition: This table captures data about items a user tags, i.e. marks as an item of interest.
Table Type: ACTIVITY





Column Detail - PDOC_TAG


Column Name Type Null? Definition
CATEGORIZATION_XML VARCHAR(3000) Y Defines categorization of tagged item on clipboard
EMR_TYPE_CD DOUBLE N Used to determine the format applied to the tagged item.
ENCNTR_ID DOUBLE N Uniquely identifies the encounter record related to the tagged item.
PDOC_TAG_ID DOUBLE N Uniqiuely identifies a tagged item.
REFERENCE_UUID VARCHAR(255) N Identifier created to uniquely identify a tagged item prior to inserting a row into the TAG table.
TAG_DT_TM DATETIME N The date and time the tag was initially created.
TAG_ENTITY_ID DOUBLE N Identifier used to query for the tagged item.
TAG_ENTITY_NAME VARCHAR(255) N Contains the name of the entity related to the tag.
TAG_USER_ID DOUBLE N Contains the Id of the person that created the tags.
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 - PDOC_TAG


Child Column in PDOC_TAG(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
TAG_USER_ID PRSNL PERSON_ID


PDOC_TAG_HANDLE



Column Section Top of Page


Table-level Detail

Description: Physician Documentation Tag Handle
Definition: This table captures data about blobs stored remotely (such as Images stored via MMF) that a user tags, i.e. marks as an item of interest.
Table Type: ACTIVITY





Column Detail - PDOC_TAG_HANDLE


Column Name Type Null? Definition
BLOB_HANDLE VARCHAR(2000) N Handle to remote blob.
FORMAT_CD DOUBLE N The format of the blob e.g. PNG, JPG
PDOC_TAG_HANDLE_ID DOUBLE N Unique generated number that identifies a single row on the PDOC_TAG_HANDLE table.
STORAGE_CD DOUBLE N Identifies location/device where blob is stored. For example, MMF
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.


PDOC_TAG_TEXT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Physicain Doc Tag Text
Definition: This table captures data about Text items that a user tags, i.e. marks as an item of interest.
Table Type: ACTIVITY





Column Detail - PDOC_TAG_TEXT


Column Name Type Null? Definition
ENCNTR_ID DOUBLE N Contains the encounter ID associated with the tagged item.
FORMAT_CD DOUBLE N The format of the text, e.g. RTF, HTML or ASCII
LONG_BLOB_ID DOUBLE N Uniquely identifies where the text is stored.
PDOC_TAG_TEXT_ID DOUBLE N Uniquely identifies text related to a tag.
REFERENCE_UUID VARCHAR(255) N Created to identify tagged item prior to inserting a row into the TAG_TEXT table.
TAG_DT_TM DATETIME N Date and Time the item was tagged.
TAG_ENTITY_ID DOUBLE N Uniquely identifies the entity related to this tag.
TAG_ENTITY_NAME VARCHAR(255) N Contains the name of the entity related to the tag.
TAG_USER_ID DOUBLE N Uniquely identifies the user that created the tag.
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 - PDOC_TAG_TEXT


Child Column in PDOC_TAG_TEXT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
LONG_BLOB_ID LONG_BLOB LONG_BLOB_ID
TAG_USER_ID PRSNL PERSON_ID


PRSNL_LOC_TEMPLATE_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Personnel, Location, and Template Relationship
Definition: allows for associating textual templates (defined on CLINICAL_NOTE_TEMPLATE) to specific facilities to allow for more focused lists of templates based on the current encounter being used when documenting a note for a patient (in Clinical Notes / PowerNote).
Table Type: REFERENCE





Column Detail - PRSNL_LOC_TEMPLATE_RELTN


Column Name Type Null? Definition
DEFAULT_IND DOUBLE Y An indicator that signifies whether this template is the default template for the location or person.
LOCATION_CD DOUBLE N The location (facility) to which the template is associated.
NOTE_TYPE_TEMPLATE_RELTN_ID DOUBLE N The template to note type relationship identifier from the note_type_template_reltn table.
PRSNL_ID DOUBLE N The person to which the template is associated.
PRSNL_LOC_TEMPLATE_RELTN_ID DOUBLE N A unique identifier for a relationship between a personnel and a template or a location and a template.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - PRSNL_LOC_TEMPLATE_RELTN


Child Column in PRSNL_LOC_TEMPLATE_RELTN(FK) Parent Table Name Parent Column Name
Parents: NOTE_TYPE_TEMPLATE_RELTN_ID NOTE_TYPE_TEMPLATE_RELTN NOTE_TYPE_TEMPLATE_RELTN_ID
PRSNL_ID PRSNL PERSON_ID


RULE_AUDIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table provides an audit trail of the rules that were run for database clean
Definition: This table provides an audit trail of the rules that were run for database cleanups. Tracks changes made by the ExpireEventAction.exe tool (or an Ops job that automatically runs some of the expire rules defined in that tool).
Table Type: ACTIVITY





Column Detail - RULE_AUDIT


Column Name Type Null? Definition
PARAMETER_DEFINITION VARCHAR(250) N Sentence version of the rule
PARENT_ENTITY_ID DOUBLE N Primary key of the Rule_Audit table.
PARENT_ENTITY_NAME VARCHAR(30) N Parent Entity Name is "EXPIRE_RULE"
ROWS_UPDATED DOUBLE N The number of rows that updated as a result of running the rule.
RULE_AUDIT_ID DOUBLE N Unique identifier for the RULE_AUDIT table.
RUN_DT_TM DATETIME N The date and time of the rule execution.
RUN_PRSNL_ID DOUBLE N The id of the personnel that ran the rule.
RUN_TYPE_FLAG DOUBLE N Indicates if the rule was run in an AdHoc mode or through Ops Job. Valid values are 0- operations, 1 - AdHoc



Relationship Detail - RULE_AUDIT


Child Column in RULE_AUDIT(FK) Parent Table Name Parent Column Name
Parents: RUN_PRSNL_ID PRSNL PERSON_ID