Table Detail Report

DO_VALUE_SET_CODE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discern Ontology Value Set Code
Definition: Defines a code/identifier within a value set.
Table Type: REFERENCE





Column Detail - DO_VALUE_SET_CODE


Column Name Type Null? Definition
DO_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.; 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.
DO_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).
DO_VALUE_SET_CODE_ID DOUBLE N Unique generated number that identifies a single row on the DO_VALUE_SET_CODE table.
DO_VALUE_SET_ID DOUBLE N The Value Set Identifier, a row in the DO_SCOPE database 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_VALUE_SET_CODE


Child Column in DO_VALUE_SET_CODE(FK) Parent Table Name Parent Column Name
Parents: DO_VALUE_SET_ID DO_VALUE_SET DO_VALUE_SET_ID


DO_VALUE_SET_NAMESPACE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discern Ontology Value Set Namespace
Definition: The namespace this valueset represents.
Table Type: REFERENCE





Column Detail - DO_VALUE_SET_NAMESPACE


Column Name Type Null? Definition
DO_NAMESPACE VARCHAR(128) N The Namepace that identifies the Value Set. Typically this is an industry standard FHIR identifier that represents the Set.
DO_VALUE_SET_ID DOUBLE N The Value Set Identifier, unique row in the DO_VALUE_SET database table.
DO_VALUE_SET_NAMESPACE_ID DOUBLE N Unique generated number that identifies a single row on the DO_VALUE_SET_NAMESPACE 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_VALUE_SET_NAMESPACE


Child Column in DO_VALUE_SET_NAMESPACE(FK) Parent Table Name Parent Column Name
Parents: DO_VALUE_SET_ID DO_VALUE_SET DO_VALUE_SET_ID