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