DD_CONTRIBUTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dynamic Documentation Contribution
Definition: Represents a contribution to a document. The contribution can have a single unique session (i.e. lock) and groups multiple sections in DD_SECTION.
Table Type: ACTIVITY





Column Detail - DD_CONTRIBUTION


Column Name Type Null? Definition
AUTHOR_ID DOUBLE N Uniquely identifies the author of the document
DD_CONTRIBUTION_ID DOUBLE N Uniquely identifies a contribution to a document.
DOC_EVENT_ID DOUBLE N Uniquely identifies the related clinical event, doc, to which this contribution is associated. Note that the DOC links to the document text.
ENCNTR_ID DOUBLE N Uniquely identifies the related encounter. Patient level documents have an encounter ID of 0.
MDOC_EVENT_ID DOUBLE N Uniquely identifies the related clinical event to which the MDOC this contribution is associated.
PERSON_ID DOUBLE N Uniquely identifies the patient associated to the document.
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 - DD_CONTRIBUTION


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




Parent Column in DD_CONTRIBUTION (PK) Child Table Name Child Column Name
Children: DD_CONTRIBUTION_ID DD_EMR_EXTRACT DD_CONTRIBUTION_ID


DD_REF_EMR_CONTENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dynamic Documentation - EMR Content
Definition: This table associates an XML blob from DD_REF_FILTER, for filtering data, and an XSLT blob from DD_REF_FORMAT, for formatting the output from Data Retieval services, together into an EMR item that can be used in a Dynamic Documentation Template.
Table Type: REFERENCE





Column Detail - DD_REF_EMR_CONTENT


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.
DD_REF_EMR_CONTENT_ID DOUBLE N Uniquely identifies an association of an XML blob for filtering data and an XSLT blob for formatting the output of a list of EMR content inserted into a document.
DD_REF_FILTER_ID DOUBLE N Identifies the XML blob used to filter the data.
DD_REF_FORMAT_ID DOUBLE N Uniquely identifies the XSLT blob used the format the data.
DESCRIPTION_TXT VARCHAR(255) Y Contains a brief description of the content.
EMR_CONTENT_TYPE_CD DOUBLE N Contains the EMR content type.
REF_CONTENT_INSTANCE_IDENT VARCHAR(255) N Embedded in reference template XHTML. Used to refresh EMR content in a document.
SOURCE_TXT VARCHAR(255) N Identifies where the EMR content originated.
TITLE_TXT VARCHAR(255) Y Contains the EMR content title.
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_EMR_CONTENT


Child Column in DD_REF_EMR_CONTENT(FK) Parent Table Name Parent Column Name
Parents: DD_REF_FILTER_ID DD_REF_FILTER DD_REF_FILTER_ID
DD_REF_FORMAT_ID DD_REF_FORMAT DD_REF_FORMAT_ID




Parent Column in DD_REF_EMR_CONTENT (PK) Child Table Name Child Column Name
Children: DD_REF_EMR_CONTENT_ID DD_REF_TEMPLATE_CONTENT_R DD_REF_EMR_CONTENT_ID


DD_REF_FILTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dynamic Documentation - Reference Filter
Definition: This table refers to an XML blob that describes how EMR content should be queried. The blob adheres to XSD schemas defined by the Dynamic Documentation service.
Table Type: REFERENCE





Column Detail - DD_REF_FILTER


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.
DD_REF_FILTER_ID DOUBLE N Uniquely identifies an XML blob that describes how EMR content should be queried.
DESCRIPTION_TXT VARCHAR(255) N Contains a brief description of the XML.
EMR_CONTENT_TYPE_CD DOUBLE N Contains the EMR content types.
LONG_BLOB_REF_ID DOUBLE N Long blob reference ID. Points to the actual XML blob.
SOURCE_TXT VARCHAR(255) N Identifies where the filter originated.
TITLE_TXT VARCHAR(255) N Contains the data retrieval title.
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_FILTER


Child Column in DD_REF_FILTER(FK) Parent Table Name Parent Column Name
Parents: LONG_BLOB_REF_ID LONG_BLOB_REFERENCE LONG_BLOB_ID




Parent Column in DD_REF_FILTER (PK) Child Table Name Child Column Name
Children: DD_REF_FILTER_ID DD_REF_EMR_CONTENT DD_REF_FILTER_ID


DD_REF_FORMAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dynamic Documentation - Reference Format
Definition: This table refers to an XSLT blob used to format raw data returned by the Data Retrieval Services. The raw data is returned in XML format that adheres to an XSD defined by Data Retrieval Services.
Table Type: REFERENCE





Column Detail - DD_REF_FORMAT


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.
DD_REF_FORMAT_ID DOUBLE N Uniquely identifies an XSLT blob used to format raw data returned by queries made to CDG.
DESCRIPTION_TXT VARCHAR(255) Y Contains a brief description of the XSLT.
EMR_CONTENT_TYPE_CD DOUBLE N Contains the EMR content type. A 0 indicates a reusable format.
LONG_BLOB_REF_ID DOUBLE N Long blob reference ID. Points to the actual XSLT blob.
NAME_TXT VARCHAR(255) Y Contains the XSLT file name and path.
SOURCE_TXT VARCHAR(255) N Identifies where the format originated.
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_FORMAT


Child Column in DD_REF_FORMAT(FK) Parent Table Name Parent Column Name
Parents: LONG_BLOB_REF_ID LONG_BLOB_REFERENCE LONG_BLOB_ID




Parent Column in DD_REF_FORMAT (PK) Child Table Name Child Column Name
Children: DD_REF_FORMAT_ID DD_REF_EMR_CONTENT DD_REF_FORMAT_ID


DD_REF_LABEL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dynamic Documentation - Reference Label
Definition: This table contains labels used to group related reference templates together.
Table Type: REFERENCE





Column Detail - DD_REF_LABEL


Column Name Type Null? Definition
DD_REF_LABEL_ID DOUBLE N Uniquely identifies a label used to group related reference templates together.
DESCRIPTION_TXT VARCHAR(255) Y Describes the label used to group related reference templates.
DISPLAY_TXT VARCHAR(255) N The display of the label.
LABEL_TYPE_CD DOUBLE N Types of labels used in documentation.
SYSTEM_IND DOUBLE N Indicates the system generated this label. Allows user created labels to coexist with reserved system labels.
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.
USER_ID DOUBLE N The user id is the user who created the label. An example of a label is "FAVORITE", a user may have marked multiple reference templates to display in a favorite templates list.



Relationship Detail - DD_REF_LABEL


Child Column in DD_REF_LABEL(FK) Parent Table Name Parent Column Name
Parents: USER_ID PRSNL PERSON_ID




Parent Column in DD_REF_LABEL (PK) Child Table Name Child Column Name
Children: DD_REF_LABEL_ID DD_REF_TMPLT_LBL_R DD_REF_LABEL_ID