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 |