DO_CODE_SYSTEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: DO_CODE_SYSTEM
Definition: Discern Ontology Code System
Table Type: REFERENCE





Column Detail - DO_CODE_SYSTEM


Column Name Type Null? Definition
CONCEPT_SOURCE_MEAN VARCHAR(12) Y CDF meaning for code set 12100.
DO_CODE_SYSTEM_ID DOUBLE N Unique generated number that identifies a single row on the DO_CODE_SYSTEM table.
DO_CODE_SYSTEM_IDENT DOUBLE N Discern Ontology code system identifier. Will be consistent across domains.
DO_CODE_SYSTEM_NAME VARCHAR(100) N Name of the code system
SOURCE_VOCABULARY_MEAN VARCHAR(12) Y CDF meaning from code set 400.
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_CODE_SYSTEM




Parent Column in DO_CODE_SYSTEM (PK) Child Table Name Child Column Name
Children: DO_CODE_SYSTEM_ID DO_CODE_SYSTEM_URI DO_CODE_SYSTEM_ID
DO_CONCEPT_CODE DO_CODE_SYSTEM_ID


DO_CODE_SYSTEM_URI



Column Section Relationship Section Top of Page


Table-level Detail

Description: DO_CODE_SYSTEM_URI
Definition: Discern Ontology Code System URI
Table Type: REFERENCE





Column Detail - DO_CODE_SYSTEM_URI


Column Name Type Null? Definition
DO_CODE_SYSTEM_ID DOUBLE N Unique generated number that identifies a single row on the DO_CODE_SYSTEM table.
DO_CODE_SYSTEM_URI VARCHAR(200) N Uniform resource identifier of the code system. Often an OID in URN form, but sometimes a URL.
DO_CODE_SYSTEM_URI_ID DOUBLE N Unique generated number that identifies a single row on the DO_CODE_SYSTEM_URI 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_CODE_SYSTEM_URI


Child Column in DO_CODE_SYSTEM_URI(FK) Parent Table Name Parent Column Name
Parents: DO_CODE_SYSTEM_ID DO_CODE_SYSTEM DO_CODE_SYSTEM_ID


DO_CONCEPT



Column Section Relationship Section Top of Page


Table-level Detail

Description: DISCERN ONTOLOGY
Definition: A unit of meaning within a context. It can be as fine or coarse grained as needed.
Table Type: REFERENCE





Column Detail - DO_CONCEPT


Column Name Type Null? Definition
DO_CONCEPT_ID DOUBLE N Unique generated number that identifies a single row on the DO_CONCEPT table.
DO_CONCEPT_NAME VARCHAR(100) N Name of the concept.
DO_CONCEPT_UUID VARCHAR(36) N Discern Ontology concept identifier. Will be consistent across domains.
DO_CONTEXT_VERSION_ID DOUBLE N Unique generated number that identifier a single row on the DO_CONTEXT_VERSION 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_CONCEPT


Child Column in DO_CONCEPT(FK) Parent Table Name Parent Column Name
Parents: DO_CONTEXT_VERSION_ID DO_CONTEXT_VERSION DO_CONTEXT_VERSION_ID




Parent Column in DO_CONCEPT (PK) Child Table Name Child Column Name
Children: DO_CONCEPT_ID DO_CONCEPT_ALIAS DO_CONCEPT_ID
DO_CONCEPT_CODE DO_CONCEPT_ID
DO_CONCEPT_EXPLODE DO_CONCEPT1_ID
DO_CONCEPT_EXPLODE DO_CONCEPT2_ID


DO_CONCEPT_ALIAS



Column Section Relationship Section Top of Page


Table-level Detail

Description: DO_CONCEPT_ALIAS
Definition: Each concept has zero to many aliases unique to the context version The aliases are like CDF meanings in that they are what a developer codes against.
Table Type: REFERENCE





Column Detail - DO_CONCEPT_ALIAS


Column Name Type Null? Definition
DO_CONCEPT_ALIAS VARCHAR(200) N Alias of the concept.
DO_CONCEPT_ALIAS_ID DOUBLE N Unique generated number that identifies a single row on the DO_CONCEPT_ALIAS table.
DO_CONCEPT_ID DOUBLE N Unique generated number that identifies a single row on the DO_CONCEPT table.
DO_CONTEXT_VERSION_ID DOUBLE N Unique generated number that identifies a single row on the DO_CONTEXT_VERSION 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_CONCEPT_ALIAS


Child Column in DO_CONCEPT_ALIAS(FK) Parent Table Name Parent Column Name
Parents: DO_CONCEPT_ID DO_CONCEPT DO_CONCEPT_ID
DO_CONTEXT_VERSION_ID DO_CONTEXT_VERSION DO_CONTEXT_VERSION_ID


DO_CONCEPT_CODE



Column Section Relationship Section Top of Page


Table-level Detail

Description: DO_CONCEPT_CODE
Definition: The codes from any standard terminology that are aliases to this contextual unit of meaning.
Table Type: REFERENCE





Column Detail - DO_CONCEPT_CODE


Column Name Type Null? Definition
DO_CODE VARCHAR(100) N Code from the code system.
DO_CODE_SYSTEM_ID DOUBLE N Unique generated number that identifies a single row on the DO_CODE_SYSTEM table.
DO_CONCEPT_CODE_ID DOUBLE N Unique generated number that identifies a single row on the DO_CONCEPT_CODE table.
DO_CONCEPT_ID DOUBLE N Unique generated number that identifies a single row on the DO_CONCEPT table.
DO_CONTEXT_VERSION_ID DOUBLE N Unique generated number that identifies a single row on the DO_CONTEXT_VERSION 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_CONCEPT_CODE


Child Column in DO_CONCEPT_CODE(FK) Parent Table Name Parent Column Name
Parents: DO_CODE_SYSTEM_ID DO_CODE_SYSTEM DO_CODE_SYSTEM_ID
DO_CONCEPT_ID DO_CONCEPT DO_CONCEPT_ID
DO_CONTEXT_VERSION_ID DO_CONTEXT_VERSION DO_CONTEXT_VERSION_ID