Table Detail Report

DD_SDOC_SECTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dynamic Documentation - Structured Documentation Section
Definition: Structured Documentation top-level activity data is stored here. One row on this table is written per conceptual section of documentation. For example, there is one row for a Physical Exam section, and a different row for a Review of Systems section.
Table Type: ACTIVITY





Column Detail - DD_SDOC_SECTION


Column Name Type Null? Definition
AUTHOR_ID DOUBLE N Author/owner of the section.
DD_SDOC_SECTION_ID DOUBLE N Uniquely identifies a conceptual section of documentation.
DD_SREF_SECTION_ID DOUBLE N The reference section this activity corresponds to. An example may be the id for the Physical Exam reference section.
ENCNTR_ID DOUBLE N Uniquely identifies the related encounter.
ENTRY_MODE_CD DOUBLE N Indicates the ui mechanism used for data entry on this section.
PARENT_DD_SDOC_SECTION_ID DOUBLE N Uniquely identifies the parent key for this row. A top-level section will have no parent, and thus will have a value of 0 in this column. A child section (for example, a subsection in History of Present Illness, which should be saved independently of its sibling tabs and not merged together) would have the DD_SDOC_SECTION_ID of its parent stored in this column.
PARENT_ENTITY_ID DOUBLE N Unique identifier related to the parent entity name. May be 0 if the section stands alone.
PARENT_ENTITY_NAME VARCHAR(40) N The referenced table name for which the section is applicable. May be blank if the section stands alone.
PERSON_ID DOUBLE N Uniquely identifies the related person.
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_SDOC_SECTION


Child Column in DD_SDOC_SECTION(FK) Parent Table Name Parent Column Name
Parents: PARENT_DD_SDOC_SECTION_ID DD_SDOC_SECTION DD_SDOC_SECTION_ID
DD_SREF_SECTION_ID DD_SREF_SECTION DD_SREF_SECTION_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
AUTHOR_ID PRSNL PERSON_ID




Parent Column in DD_SDOC_SECTION (PK) Child Table Name Child Column Name
Children: DD_SDOC_SECTION_ID DD_SDOC_ATTR_MENU_ITEM DD_SDOC_SECTION_ID
DD_SDOC_DATA DD_SDOC_SECTION_ID
DD_SDOC_GROUPBY DD_SDOC_SECTION_ID
DD_SDOC_ITEM DD_SDOC_SECTION_ID
DD_SDOC_SECTION PARENT_DD_SDOC_SECTION_ID
DD_SDOC_SECT_TEMPL_RELTN DD_SDOC_SECTION_ID


DD_SDOC_SECT_TEMPL_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dynamic Documentation Structured Documentation Section Template Reltationship
Definition: Relation table which links a documented section to one or more structured documentation reference templates used in that section.
Table Type: ACTIVITY





Column Detail - DD_SDOC_SECT_TEMPL_RELTN


Column Name Type Null? Definition
DD_SDOC_SECTION_ID DOUBLE N Uniquely identifies the relation Structured Documentation Section.
DD_SDOC_SECT_TEMPL_RELTN_ID DOUBLE N Uniquely identifies a relationship between a structured documentation section and its related template.
DD_SREF_CHF_CMPLNT_CRIT_ID DOUBLE N Relates to the row on DD_SREF_CHF_CMPLNT_CRIT table which resulted in the selection of this particular template. May be 0 if the template was not selected via DD_SREF_CHF_CMPLNT_CRIT criteria.
DD_SREF_TEMPL_INSTANCE_IDENT VARCHAR(255) N Identifier of the structured documentation template which should be linked to a particular documented section.
PARENT_ENTITY_ID DOUBLE N Contains the identifier of the parent entity which caused this template to be chosen for this section. For example, this may be the diagnosis_group value from the Diagnosis table when a diagnosis was used as the starting point for determining a template to show for this section.
PARENT_ENTITY_NAME VARCHAR(30) N The name of the parent entity table which caused this template to be chosen for documentation of this section. For example, this would be Diagnosis when a diagnosis was used to find a template. When Diagnosis is present here, the value in the parent_entity_id field would be the value of the diagnosis_group column of the diagnosis table since diagnosis_group doesn't change between versions of a diagnosis on that table.
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_SDOC_SECT_TEMPL_RELTN


Child Column in DD_SDOC_SECT_TEMPL_RELTN(FK) Parent Table Name Parent Column Name
Parents: DD_SDOC_SECTION_ID DD_SDOC_SECTION DD_SDOC_SECTION_ID
DD_SREF_CHF_CMPLNT_CRIT_ID DD_SREF_CHF_CMPLNT_CRIT DD_SREF_CHF_CMPLNT_CRIT_ID


DD_SREF_CHF_CMPLNT



Column Section Top of Page


Table-level Detail

Description: Dynamic Documentation - Structured Reference Chief Complaint
Definition: This table is a starting point for identifying a structured documentation reference template to use for a patient's chief complaint, when that complaint is coded in a standard terminology such as SNOMED-CT. Many code values may point to the same template, so this table maps many of its rows to a single row on DD_SREF_CHF_CMPLNT_CRIT.
Table Type: REFERENCE





Column Detail - DD_SREF_CHF_CMPLNT


Column Name Type Null? Definition
CONCEPT_CKI VARCHAR(255) Y The concept_cki that this complaint is associated with. SNOMED!440028005 for example. Intended as a way to identify chief complaints based on industry standard vocabularies.
DD_SREF_CHF_CMPLNT_ID DOUBLE N This table is a starting point for identifying a structured documentation reference template to use for a patient's chief complaint is coded in a standard terminology such as SNOMED-CT. Many code values may point to the same template, so this table maps many of its rows to a single row on DD_SREF_CHF_CMPLNT_CRIT.
OCID_IDENT VARCHAR(255) N The chief complaint concept that should be used to identify criteria to evaluate further for a match to the CONCEPT_CKI identified in this row. This is an internal (non-industry standard) id to identify a group of criteria to evaluate.
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.


DD_SREF_CHF_CMPLNT_CRIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dynamic Documentation - Structured Reference Chief Complaint Criteria
Definition: Each row on this table contains various criteria which should match when querying / looking up which structured documentation reference templates apply to a given patient and their current situation. This table provides the basis for flexing content intelligently.
Table Type: REFERENCE





Column Detail - DD_SREF_CHF_CMPLNT_CRIT


Column Name Type Null? Definition
CHF_CMPLNT_IDENT VARCHAR(255) N External identifier for this combination of criteria.
CHF_CMPLNT_NAME VARCHAR(255) Y Name to display when identifying the reason why a given template was matched / chosen for a given clinical scenario (patient, provider, setting).
DD_SREF_CHF_CMPLNT_CRIT_ID DOUBLE N Uniquely identifies a row on this table contains various criteria which should match when querying / looking up which structured documentation reference templates apply to a given patient and their current situation. This table provides the basis for flexing content intelligently.
MAX_AGE_MONTHS DOUBLE N The maximum age in months which this criteria is applicable for. The value not inclusive on the maximum side, allowing for contiguous ranges which will not return two rows for a specific aged patient.
MIN_AGE_MONTHS DOUBLE N The minimum age in months which this criteria is applicable for. The value is inclusive on the minimum side, so that if a patient's age is unknown, and is thus passed in as zero, this criteria should match.
OCID_IDENT VARCHAR(255) N DD_SREF_CHF_CMPLNT_CRIT may share the same OCID, but differ in their other parameters like age, sex, position and encounter type. This is a non-industry standard id to identify a group of criteria that share the same conceptual basis.
SEX_CD DOUBLE N The sex cd for which this criteria is applicable. A value of zero indicates that this criteria is not specific to any sex, and thus patients of any sex should match.
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_SREF_CHF_CMPLNT_CRIT




Parent Column in DD_SREF_CHF_CMPLNT_CRIT (PK) Child Table Name Child Column Name
Children: DD_SREF_CHF_CMPLNT_CRIT_ID DD_SDOC_SECT_TEMPL_RELTN DD_SREF_CHF_CMPLNT_CRIT_ID
DD_SREF_CRIT_ENC_TYP_RELTN DD_SREF_CHF_CMPLNT_CRIT_ID
DD_SREF_CRIT_POS_RELTN DD_SREF_CHF_CMPLNT_CRIT_ID
DD_SREF_CRIT_TEMPL_RELTN DD_SREF_CHF_CMPLNT_CRIT_ID


DD_SREF_CRIT_ENC_TYP_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dynamic Documenation Structured Documenation Criteria Encounter Type Relationshi
Definition: Relation table which links a particular chief complaint criteria row to one or more structured documentation reference templates.
Table Type: REFERENCE





Column Detail - DD_SREF_CRIT_ENC_TYP_RELTN


Column Name Type Null? Definition
DD_SREF_CHF_CMPLNT_CRIT_ID DOUBLE N Identifier of the chief complaint criteria entry which is linked to one or more encounter types.
DD_SREF_CRIT_ENC_TYP_RELTN_ID DOUBLE N Uniquely identifies a relationship between a chief complaint criteria and a related encounter type.
ENCNTR_TYPE_CD DOUBLE N Encounter type class or encounter type which should be linked to a particular chief complaint criteria entry. Values come from codeset 71 or codeset 69. A value of 0.0 indicates the criteria is valid for all encounter types.
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_SREF_CRIT_ENC_TYP_RELTN


Child Column in DD_SREF_CRIT_ENC_TYP_RELTN(FK) Parent Table Name Parent Column Name
Parents: DD_SREF_CHF_CMPLNT_CRIT_ID DD_SREF_CHF_CMPLNT_CRIT DD_SREF_CHF_CMPLNT_CRIT_ID