Table Detail Report

DD_REF_TEMPLATE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dynamic Documentation - Reference Template
Definition: This table contains the reference template used in documentation sections of the workflow components and for creating new documents in Dynamic Documentation.
Table Type: REFERENCE





Column Detail - DD_REF_TEMPLATE


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.
AUTHOR_ID DOUBLE N Uniquely identifies the author of the reference template.
DD_REF_TEMPLATE_ID DOUBLE N Uniquely identifies the reference template which will be used to create new documents in Dynamic Documentation.
DESCRIPTION_TXT VARCHAR(255) Y Contains a brief description of the contents.
LONG_BLOB_REF_ID DOUBLE N Long blob reference id. The reference template XHTML.
SOURCE_TXT VARCHAR(255) N Identifies where the template originated.
TITLE_TXT VARCHAR(255) Y Contains the actual textual title of the reference template.
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_REF_TEMPLATE


Child Column in DD_REF_TEMPLATE(FK) Parent Table Name Parent Column Name
Parents: LONG_BLOB_REF_ID LONG_BLOB_REFERENCE LONG_BLOB_ID
AUTHOR_ID PRSNL PERSON_ID




Parent Column in DD_REF_TEMPLATE (PK) Child Table Name Child Column Name
Children: DD_REF_TEMPLATE_ID CV_STEP CV_DOC_TEMPLATE_ID
CV_STEP_REF DOC_TEMPLATE_ID
DD_REF_TEMPLATE_CONTENT_R DD_REF_TEMPLATE_ID
DD_REF_TMPLT_CN_TMPLT_R DD_REF_TEMPLATE_ID
DD_REF_TMPLT_LBL_R DD_REF_TEMPLATE_ID


DD_REF_TEMPLATE_CONTENT_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dynamic Documentation - Template Content Relationship
Definition: This table describes the EMR content and text/smart templates used in the reference template.
Table Type: REFERENCE





Column Detail - DD_REF_TEMPLATE_CONTENT_R


Column Name Type Null? Definition
DD_REF_EMR_CONTENT_ID DOUBLE N Uniquely identifies the related reference EMR content.
DD_REF_TEMPLATE_CONTENT_R_ID DOUBLE N Uniquely identifies the EMR content and text/smart templates contained in the reference template XHTML..
DD_REF_TEMPLATE_ID DOUBLE N Uniquely identifies the related reference template.
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_REF_TEMPLATE_CONTENT_R


Child Column in DD_REF_TEMPLATE_CONTENT_R(FK) Parent Table Name Parent Column Name
Parents: DD_REF_EMR_CONTENT_ID DD_REF_EMR_CONTENT DD_REF_EMR_CONTENT_ID
DD_REF_TEMPLATE_ID DD_REF_TEMPLATE DD_REF_TEMPLATE_ID


DD_REF_TMPLT_CN_TMPLT_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dynamic Documentation Reference Template Clinical Note Template Relationship
Definition: This table describes the standard and smart templates used in the reference template.
Table Type: REFERENCE





Column Detail - DD_REF_TMPLT_CN_TMPLT_R


Column Name Type Null? Definition
CLINICAL_NOTE_TEMPLATE_ID DOUBLE N Uniquely identifies the related clinical note template.
DD_REF_TEMPLATE_ID DOUBLE N Uniquely identifies the related dd_ref_template record.
DD_REF_TMPLT_CN_TMPLT_R_ID DOUBLE N Uniquely identifies the standard and smart templates used in the reference template XHTML.
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_REF_TMPLT_CN_TMPLT_R


Child Column in DD_REF_TMPLT_CN_TMPLT_R(FK) Parent Table Name Parent Column Name
Parents: CLINICAL_NOTE_TEMPLATE_ID CLINICAL_NOTE_TEMPLATE TEMPLATE_ID
DD_REF_TEMPLATE_ID DD_REF_TEMPLATE DD_REF_TEMPLATE_ID


DD_REF_TMPLT_LBL_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dynamic Documentation Reference Template Label Relationship
Definition: This table relates a label to a reference template. This is used for grouping related templates together.
Table Type: REFERENCE





Column Detail - DD_REF_TMPLT_LBL_R


Column Name Type Null? Definition
DD_REF_LABEL_ID DOUBLE N Uniquely identifies the related reference label.
DD_REF_TEMPLATE_ID DOUBLE N Uniquely identifies the related reference template.
DD_REF_TMPLT_LBL_R_ID DOUBLE N Uniquely identifies a relationship between a reference template and label.
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_REF_TMPLT_LBL_R


Child Column in DD_REF_TMPLT_LBL_R(FK) Parent Table Name Parent Column Name
Parents: DD_REF_LABEL_ID DD_REF_LABEL DD_REF_LABEL_ID
DD_REF_TEMPLATE_ID DD_REF_TEMPLATE DD_REF_TEMPLATE_ID


DD_SESSION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dynamic Documentation - Session
Definition: This table is used to store session level information, such as the lock status of a note, related to Dynamic Documentation.
Table Type: ACTIVITY





Column Detail - DD_SESSION


Column Name Type Null? Definition
DD_SESSION_ID DOUBLE N Uniquely identifies a session lock that is being held by a row in one of the dynamic document tables. This must be supplied by a consumer when attempting to save a document.
PARENT_ENTITY_ID DOUBLE N Uniquely identifies the locked row on the table.
PARENT_ENTITY_NAME VARCHAR(30) N The name of the table in which the locked row exists.
SESSION_DT_TM DATETIME N Contains the date and time the lock was obtained.
SESSION_USER_ID DOUBLE N Uniquely identifies the person holding the lock.
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_SESSION


Child Column in DD_SESSION(FK) Parent Table Name Parent Column Name
Parents: SESSION_USER_ID PRSNL PERSON_ID




Parent Column in DD_SESSION (PK) Child Table Name Child Column Name
Children: DD_SESSION_ID DD_SESSION_DATA DD_SESSION_ID