Table Detail Report
CMT_TERM_MAP
Column Section | Top of Page |
Table-level Detail
Description: | CMT TERM MAP |
Definition: | Table used to store mappings between NOMENCLATURE terms of different sources |
Table Type: | REFERENCE |
Column Detail - CMT_TERM_MAP
Column Name | Type | Null? | Definition |
---|---|---|---|
BEG_EFFECTIVE_DT_TM | DATETIME | N | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
CMTI | VARCHAR(255) | N | The link to NOMENCLATURE for a given term |
CMT_TERM_MAP_ID | DOUBLE | N | Sequence Generated ID |
END_EFFECTIVE_DT_TM | DATETIME | N | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
MAP_SOURCE_MEAN | VARCHAR(12) | N | Indicates the originating source of the term mapping. |
TARGET_CMTI | VARCHAR(255) | N | The link to NOMENCLATURE for a given mapped term. |
TERM_MAP_TYPE_MEAN | VARCHAR(12) | Y | Used to indicate the specificity of the mapping relationship. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
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. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
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. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
CMT_TERM_MAP_LOAD
Column Section | Top of Page |
Table-level Detail
Description: | CMT TERM MAP LOAD |
Definition: | Table used to facilitate loading of CMT_TERM_MAP (stores mappings between NOMENCLATURE terms of different sources) |
Table Type: | REFERENCE |
Column Detail - CMT_TERM_MAP_LOAD
Column Name | Type | Null? | Definition |
---|---|---|---|
BEG_EFFECTIVE_DT_TM | DATETIME | N | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
CMTI | VARCHAR(255) | N | The link to NOMENCLATURE for a given term |
END_EFFECTIVE_DT_TM | DATETIME | N | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
MAP_SOURCE_MEAN | VARCHAR(12) | N | Indicates the originating source of the term mapping. |
TARGET_CMTI | VARCHAR(255) | N | The link to NOMENCLATURE for a given mapped term. |
TERM_MAP_TYPE_MEAN | VARCHAR(12) | Y | Used to indicate the specificity of the mapping relationship. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
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. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
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. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
CMT_WORDEQIV
Column Section | Top of Page |
Table-level Detail
Description: | CMT WORKEQUIV |
Definition: | This table contains word equivalents to be used when searching nomenclature terms. |
Table Type: | REFERENCE |
Column Detail - CMT_WORDEQIV
Column Name | Type | Null? | Definition |
---|---|---|---|
CMT_WORDEQIV_ID | DOUBLE | N | PRIMARY KEY |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
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. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
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. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
WORDEQIV_NBR | DOUBLE | N | The words, phrases and abbreviations that share a common Wordequiv_nbr value are interchangeable for the purposes of searches. Example: An equivalent block could contain the following: "TB", "tuberculosis", "tuberculous" Note: Wordequiv_nbr is not maintained as a unique identifier across releases. It should only be regarded as an index to link equivalents in the context of a particular release. |
WORDROLE_MEAN | VARCHAR(12) | N | MEANING |
WORDTEXT_NAME | VARCHAR(100) | N | A word, phrase or abbreviation that is equivalent to the WordText of other rows that share the same Wordequiv_nbr. Note: If a word or phrase has two or more possible meanings it may be represented by more than one row in this table. Each row containing the same WordText must be associated with a different Wordequiv_nbr value. |
WORDTYPE_MEAN | VARCHAR(12) | N | MEANING |
CMT_WORDEQIV_LOAD
Column Section | Top of Page |
Table-level Detail
Description: | CMT WORDEQIV |
Definition: | LOAD TABLE FOR CMT_WORDEQIV |
Table Type: | REFERENCE |
Column Detail - CMT_WORDEQIV_LOAD
Column Name | Type | Null? | Definition |
---|---|---|---|
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
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. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
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. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
WORDEQIV_NBR | DOUBLE | N | The words, phrases and abbreviations that share a common Wordequiv_nbr value are interchangeable for the purposes of searches. Example: An equivalent block could contain the following: "TB", "tuberculosis", "tuberculous" Note: Wordequiv_nbr is not maintained as a unique identifier across releases. It should only be regarded as an index to link equivalents in the context of a particular release. |
WORDROLE_MEAN | VARCHAR(12) | N | MEANING |
WORDTEXT_NAME | VARCHAR(100) | N | A word, phrase or abbreviation that is equivalent to the WordText of other rows that share the same Wordequiv_nbr. Note: If a word or phrase has two or more possible meanings it may be represented by more than one row in this table. Each row containing the same WordText must be associated with a different Wordequiv_nbr value. |
WORDTYPE_MEAN | VARCHAR(12) | N | MEANING |
CMT_WORDKEY_EXCLUDE
Column Section | Top of Page |
Table-level Detail
Description: | CMT WORDKEY EXCLUDE |
Definition: | Each row in the Excluded Words Table is a word excluded from the list of possible keywords. Words are excluded if they are frequently used and are so limited in semantic specificity that they impair rather than enhance searches. |
Table Type: | REFERENCE |
Column Detail - CMT_WORDKEY_EXCLUDE
Column Name | Type | Null? | Definition |
---|---|---|---|
CMT_WORDKEY_EXCLUDE_ID | DOUBLE | N | PRIMARY KEY |
KEYWORD_NAME | VARCHAR(8) | N | A word used in source_strings in the nomenclature table but excluded from keyword generation. Words are represented using only upper case letters and words of more than eight characters are represented as their first eight characters only. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
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. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
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. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |