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.