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 |