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 |