DD_EMR_EXTRACT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dynamic Documentation Electronic Medical Record Extract
Definition: Stores XML containing details behind chart data referenced in Dynamic Documentation notes.
Table Type: ACTIVITY





Column Detail - DD_EMR_EXTRACT


Column Name Type Null? Definition
DD_CONTRIBUTION_ID DOUBLE N The contribution containing the EMR content place holder described by this XML
DD_EMR_EXTRACT_ID DOUBLE N Uniquely identifies stored XML data which comtains details behind chart data referenced in Dynamic Documentation notes.
EXTRACT_UUID VARCHAR(255) N Identifies EMR content place holder in the contribution described by this XML.
EXTRACT_XML_BLOB_ID DOUBLE N Uniquely identifies the long_blob record that contains XML returned by MSVC data extraction services.
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 - DD_EMR_EXTRACT


Child Column in DD_EMR_EXTRACT(FK) Parent Table Name Parent Column Name
Parents: DD_CONTRIBUTION_ID DD_CONTRIBUTION DD_CONTRIBUTION_ID
EXTRACT_XML_BLOB_ID LONG_BLOB LONG_BLOB_ID


WKF_COMPONENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Workflow Component
Definition: Workflow Documentation Components associated to a Workflow Session.
Table Type: ACTIVITY





Column Detail - WKF_COMPONENT


Column Name Type Null? Definition
COMPONENT_CONCEPT VARCHAR(256) N Identifies which type of documentation component this component this is
COMPONENT_ENTITY_ID DOUBLE N The ID for the data row in the Component Entity Name table for this Component.
COMPONENT_ENTITY_NAME VARCHAR(32) N The Name of the Table that contains the data for this Workflow Component
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.
WKF_COMPONENT_ID DOUBLE N Unique generated number that identifies a single row on the WKF_COMPONENT table.
WKF_WORKFLOW_ID DOUBLE N Foreign Key to the Parent Workflow Session



Relationship Detail - WKF_COMPONENT


Child Column in WKF_COMPONENT(FK) Parent Table Name Parent Column Name
Parents: WKF_WORKFLOW_ID WKF_WORKFLOW WKF_WORKFLOW_ID


WKF_OUTPUT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Workflow Output
Definition: Outputs that were generated as a part of executing a specific workflow.
Table Type: ACTIVITY





Column Detail - WKF_OUTPUT


Column Name Type Null? Definition
OUTPUT_ENTITY_ID DOUBLE N The ID for the data row in the output entity name table for this output.
OUTPUT_ENTITY_NAME VARCHAR(32) N The Name of the Table that contains the data for this Workflow Output
OUTPUT_TYPE_CD DOUBLE N Identifies what type of output the entity is (Document, Refill, ect)
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.
WKF_OUTPUT_ID DOUBLE N Unique generated number that identifies a single row on the WKF_OUTPUT table.
WKF_WORKFLOW_ID DOUBLE N Foreign Key to the Parent Workflow Session



Relationship Detail - WKF_OUTPUT


Child Column in WKF_OUTPUT(FK) Parent Table Name Parent Column Name
Parents: WKF_WORKFLOW_ID WKF_WORKFLOW WKF_WORKFLOW_ID


WKF_WORKFLOW



Column Section Relationship Section Top of Page


Table-level Detail

Description: Workflow Session
Definition: Workflow Session contains details surrounding a user's session working through a particular workflow
Table Type: ACTIVITY





Column Detail - WKF_WORKFLOW


Column Name Type Null? Definition
ENCNTR_ID DOUBLE N Foreign Key to the Encntr table identifying the encounter this work flow session is being executed for.
END_DT_TM DATETIME Y The Date and time the workflow session was closed
PERSON_ID DOUBLE N Foreign Key to the Person Table identifying the Person this work flow session is being executed for.
PRSNL_ID DOUBLE N Identifier for the Perersonnel that owns the work flow session
SERVICE_DT_TM DATETIME Y Date and time that the person was seen by the personnel
SERVICE_TZ DOUBLE Y Time Zone display associated with the Service Date and Time.
START_DT_TM DATETIME Y The Date and time the workflow session was started
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.
WKF_WORKFLOW_ID DOUBLE N Unique generated number that identifies a single row on the WKF_WORKFLOW table.



Relationship Detail - WKF_WORKFLOW


Child Column in WKF_WORKFLOW(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
PRSNL_ID PRSNL PERSON_ID




Parent Column in WKF_WORKFLOW (PK) Child Table Name Child Column Name
Children: WKF_WORKFLOW_ID WKF_COMPONENT WKF_WORKFLOW_ID
WKF_OUTPUT WKF_WORKFLOW_ID