Table Detail Report
DO_MAPPING_NOMENCLATURE
Column Section | Top of Page |
Table-level Detail
Description: | DO_MAPPING_NOMENCLATURE |
Definition: | Discern Ontology Nomenclature Mappings |
Table Type: | REFERENCE |
Column Detail - DO_MAPPING_NOMENCLATURE
Column Name | Type | Null? | Definition |
---|---|---|---|
DO_CODE | VARCHAR(100) | Y | Code from the code system. |
DO_CODE_SYSTEM_URI | VARCHAR(200) | Y | URI of the code system. |
DO_MAPPING_NOMENCLATURE_ID | DOUBLE | N | Unique generated number that identifies a single row on the DO_MAPPING_NOMENCLATURE table. |
DO_MAPPING_SEQ | DOUBLE | N | Global sequence of the mapping. |
NOMENCLATURE_ID | DOUBLE | N | Unique generated number that identifies a single row on the NOMENCLATURE 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. |
DO_MAP_SET
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Discern Ontology Map Valuesets |
Definition: | Defines a mapping between two valuesets. |
Table Type: | REFERENCE |
Column Detail - DO_MAP_SET
Column Name | Type | Null? | Definition |
---|---|---|---|
DO_MAPPING_PARTITION_FLAG | DOUBLE | Y | Unique non-generated number that defines where the mappings for the specific map set needs to be written to. A value of 0, indicates that mappings for this map set can be found in the DO_MAPPING table. A value of 1, indicates that mappings for this map set can be found in the DO_MAP_SET_MAPPING table. |
DO_MAP_SET_ID | DOUBLE | N | Unique generated number that identifies a single row on the DO_MAP_SET table.; |
DO_MAP_SET_IDENT | DOUBLE | N | Holds the Ontology Cloud identifier for this mapping definition. |
DO_MAP_SET_NAME | VARCHAR(1000) | Y | The unique user visible display of the map set. For example: "Healthe Intent", "All Rx Norm to Pharmacy Order Synonyms". |
DO_SOURCE_VALUE_SET_ID | DOUBLE | N | Unique number that identifies a single row on the VALUE_SETS table. This Id represents the source Value Set in the mapping relationship. |
DO_TARGET_VALUE_SET_ID | DOUBLE | N | Unique number that identifies a single row on the VALUE_SETS table. This Id represents the target Value Set in the mapping relationship. |
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 - DO_MAP_SET
Child Column in DO_MAP_SET(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DO_SOURCE_VALUE_SET_ID | DO_VALUE_SET | DO_VALUE_SET_ID |
DO_TARGET_VALUE_SET_ID | DO_VALUE_SET | DO_VALUE_SET_ID |
Parent Column in DO_MAP_SET (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | DO_MAP_SET_ID | DO_MAP_SET_MAPPING | DO_MAP_SET_ID |
DO_SCOPE_MAP_SET | DO_MAP_SET_ID |
DO_MAP_SET_MAPPING
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Discern Ontology Map Valuesets Mappings |
Definition: | Defines the code/identifier mappings between two different valuesets. |
Table Type: | REFERENCE |
Column Detail - DO_MAP_SET_MAPPING
Column Name | Type | Null? | Definition |
---|---|---|---|
DO_MAPPING_VERSION | DOUBLE | N | The Cloud Version Number for the mapping entry. This is used to synchronize data between the cloud and the Millennium Databases. |
DO_MAP_SET_ID | DOUBLE | N | This number ties the mapping back to a row in the DO_MAP_SET DB Table. It lets you what set the identifier comes from. |
DO_MAP_SET_MAPPING_ID | DOUBLE | N | Unique generated number that identifies a single row on the DO_MAP_SET_MAPPING table. |
DO_SOURCE_IDENTIFIER | VARCHAR(512) | N | Based on the type of the mapping i.e. Proprietary to Standard or Standard to Proprietary Or Proprietary to Proprietary, this uniquely identifies an Cerner or industry idenfier for a code within a value set. |
DO_SOURCE_NAMESPACE | VARCHAR(128) | N | "Based on the type of the mapping i.e. Proprietary to Standard or Standard to Proprietary Or Proprietary to Proprietary, this uniquely identifies a well known identifier for the valueset (ex. FHIR code representing the set).; this uniquely identifies a single row in the VOCABULARIES or CODE_SYSTEMS table." |
DO_TARGET_DISPLAY | VARCHAR(2048) | Y | Based on the type of the mapping i.e. Proprietary to Standard or Standard to Proprietary Or Proprietary to Proprietary, this column contains the display name of the CONCEPT or IDENTITY_CODE. |
DO_TARGET_IDENTIFIER | VARCHAR(512) | N | Based on the type of the mapping i.e. Proprietary to Standard or Standard to Proprietary Or Proprietary to Proprietary, this uniquely identifies an Cerner or industry idenfier for the item being mapped. |
DO_TARGET_NAMESPACE | VARCHAR(128) | N | Based on the type of the mapping i.e. Proprietary to Standard or Standard to Proprietary Or Proprietary to Proprietary, this uniquely identifies a well known identifier for the valueset (ex. FHIR code representing the set).; Based on the type of the mapping i.e. Proprietary to Standard or Standard to Proprietary Or Proprietary to Proprietary, this uniquely identifies a single row in the VOCABULARIES or CODE_SYSTEMS table. |
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 - DO_MAP_SET_MAPPING
Child Column in DO_MAP_SET_MAPPING(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DO_MAP_SET_ID | DO_MAP_SET | DO_MAP_SET_ID |
DO_RELATIONSHIP_TYPE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Discern Ontology Relationship Type |
Definition: | Defines a discern ontology relationship type. |
Table Type: | REFERENCE |
Column Detail - DO_RELATIONSHIP_TYPE
Column Name | Type | Null? | Definition |
---|---|---|---|
DO_RELATIONSHIP_TYPE_ID | DOUBLE | N | Unique generated number that identifies a single row on the DO_RELATIONSHIP_TYPE table. |
DO_RELATIONSHIP_TYPE_IDENT | DOUBLE | N | Discern Ontology relationship type identifier. It will be consistent across domains. |
DO_RELATIONSHIP_TYPE_MEAN | VARCHAR(100) | N | A globally unique identifier for others to write code against. It is like a CDF meaning. |
DO_RELATIONSHIP_TYPE_NAME | VARCHAR(100) | N | Name of the relationship type. |
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 - DO_RELATIONSHIP_TYPE
Parent Column in DO_RELATIONSHIP_TYPE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | DO_RELATIONSHIP_TYPE_ID | DO_CONCEPT_EXPLODE | DO_RELATIONSHIP_TYPE_ID |
DO_SCOPE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Discern Ontolology Scope |
Definition: | Defines the scope names and their descriptions. |
Table Type: | REFERENCE |
Column Detail - DO_SCOPE
Column Name | Type | Null? | Definition |
---|---|---|---|
DO_SCOPE_ID | DOUBLE | N | Unique generated number that identifies a single row on the DO_SCOPE table. |
DO_SCOPE_IDENT | DOUBLE | N | Holds the Ontology Cloud Identifier for the Scope. This is used when synching data between the cloud and Millennium domain. |
DO_SCOPE_NAME | VARCHAR(1000) | N | This is the unique name for a scope as defined by FHIR. |
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 - DO_SCOPE
Parent Column in DO_SCOPE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | DO_SCOPE_ID | DO_SCOPE_ALIAS | DO_SCOPE_ID |
DO_SCOPE_MAP_SET | DO_SCOPE_ID | ||
DO_SCOPE_NAMESPACE_ALIAS | DO_SCOPE_ID |