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 |