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 |