Table Detail Report

DO_SCOPE_ALIAS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discern Ontology Scope Alias
Definition: Defines an alias for the scope.
Table Type: REFERENCE





Column Detail - DO_SCOPE_ALIAS


Column Name Type Null? Definition
DO_SCOPE_ALIAS VARCHAR(1000) N An alias name for the Scope identified by the DO_SCOPE_ID. This name is used as input to mapping requests.
DO_SCOPE_ALIAS_ID DOUBLE N Unique generated number that identifies a single row on the DO_SCOPE_ALIAS table.
DO_SCOPE_ID DOUBLE N References the identifier in the DO_SCOPE 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_SCOPE_ALIAS


Child Column in DO_SCOPE_ALIAS(FK) Parent Table Name Parent Column Name
Parents: DO_SCOPE_ID DO_SCOPE DO_SCOPE_ID


DO_SCOPE_MAP_SET



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discern Ontology Map Value Sets
Definition: Discern Ontology Map Value Sets.
Table Type: REFERENCE





Column Detail - DO_SCOPE_MAP_SET


Column Name Type Null? Definition
DO_MAP_SET_ID DOUBLE N The associated row from the DO_MAP_SET table.
DO_SCOPE_ID DOUBLE N The associated row from the DO_SCOPE table.
DO_SCOPE_MAP_SET_ID DOUBLE N Unique generated number that identifies a single row on the DO_SCOPE_MAP_SET 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_SCOPE_MAP_SET


Child Column in DO_SCOPE_MAP_SET(FK) Parent Table Name Parent Column Name
Parents: DO_MAP_SET_ID DO_MAP_SET DO_MAP_SET_ID
DO_SCOPE_ID DO_SCOPE DO_SCOPE_ID




Parent Column in DO_SCOPE_MAP_SET (PK) Child Table Name Child Column Name
Children: DO_SCOPE_MAP_SET_ID DO_SCOPE_VALUE_SET_ALIAS DO_SCOPE_MAP_SET_ID


DO_SCOPE_NAMESPACE_ALIAS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discern Ontology Scope Namespace Alias
Definition: Defines an alias for a namespace within a scope.
Table Type: REFERENCE





Column Detail - DO_SCOPE_NAMESPACE_ALIAS


Column Name Type Null? Definition
DO_SCOPE_ID DOUBLE N Reference to the Scope, a row in the DO_SCOPE table.
DO_SCOPE_NAMESPACE VARCHAR(128) N A string that represents the Namespace.
DO_SCOPE_NAMESPACE_ALIAS VARCHAR(128) N The Scope Alias to use when making mapping requests.
DO_SCOPE_NAMESPACE_ALIAS_ID DOUBLE N Unique generated number that identifies a single row on the DO_SCOPE_NAMESPACE_ALIAS 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_SCOPE_NAMESPACE_ALIAS


Child Column in DO_SCOPE_NAMESPACE_ALIAS(FK) Parent Table Name Parent Column Name
Parents: DO_SCOPE_ID DO_SCOPE DO_SCOPE_ID


DO_SCOPE_VALUE_SET_ALIAS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discern Ontology Scope Value Set Alias
Definition: Defines an alias for a valueset with in a scope and a mapset combination. The valueset could either be a source or a target.
Table Type: REFERENCE





Column Detail - DO_SCOPE_VALUE_SET_ALIAS


Column Name Type Null? Definition
DO_SCOPE_MAP_SET_ID DOUBLE N The identifier of the scoped map set, a row in the DO_SCOPE_MAP_SET database table.
DO_SCOPE_VALUE_SET_ALIAS_ID DOUBLE N Unique generated number that identifies a single row on the DO_SCOPE_VALUE_SET_ALIAS table.
DO_VALUE_SET_ALIAS VARCHAR(128) N The Scoped Map Set Alias for a value set. This is the Alias to use when making a map request for a scope.
DO_VALUE_SET_ID DOUBLE N The identifier of a value set definition, a row in the DO_VALUE_SET 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_SCOPE_VALUE_SET_ALIAS


Child Column in DO_SCOPE_VALUE_SET_ALIAS(FK) Parent Table Name Parent Column Name
Parents: DO_SCOPE_MAP_SET_ID DO_SCOPE_MAP_SET DO_SCOPE_MAP_SET_ID
DO_VALUE_SET_ID DO_VALUE_SET DO_VALUE_SET_ID


DO_VALUE_SET



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discern Ontology Value Set
Definition: Defines a value set.
Table Type: REFERENCE





Column Detail - DO_VALUE_SET


Column Name Type Null? Definition
DO_VALUE_SET_ID DOUBLE N Unique generated number that identifies a single row on the DO_VALUE_SET table.
DO_VALUE_SET_IDENT DOUBLE N This is the Ontology Cloud Indentifier for the Value Set. It is used when synching data from the Ontology Mapping database into the Millennium DB.
DO_VALUE_SET_NAME VARCHAR(128) N The unique user visible display of the value set. For example: "All LOINC", "FHIR AllergyIntoleranceStatus v1.0.2".
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




Parent Column in DO_VALUE_SET (PK) Child Table Name Child Column Name
Children: DO_VALUE_SET_ID DO_MAP_SET DO_SOURCE_VALUE_SET_ID
DO_MAP_SET DO_TARGET_VALUE_SET_ID
DO_SCOPE_VALUE_SET_ALIAS DO_VALUE_SET_ID
DO_VALUE_SET_CODE DO_VALUE_SET_ID
DO_VALUE_SET_NAMESPACE DO_VALUE_SET_ID