Table Detail Report
NOMENCLATURE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Nomenclature |
Definition: | Each row in the Nomenclature table represents a string that appears in a source vocabulary. Any variation in upper-lower case is a separate string. |
Table Type: | REFERENCE |
Column Detail - NOMENCLATURE
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | Y | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | 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) | Y | The Global Unique Identifier from an outside source |
CONCEPT_CKI | VARCHAR(255) | Y | Cki from the concept table which is the functional Concept. |
CONCEPT_IDENTIFIER | VARCHAR(242) | Y | A unique identifier supplied from Cerner or other external database and is persistent once it is assigned to a concept. All Cerner assigned concept identifiers are created from the CONCEPT_SEQ. The sequence number is formatted to an 8-byte number padded |
CONCEPT_SOURCE_CD | DOUBLE | N | Represents the external source that owns the concept_identifier. |
CONTRIBUTOR_SYSTEM_CD | DOUBLE | N | Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed. |
DATA_STATUS_CD | DOUBLE | N | Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED. |
DATA_STATUS_DT_TM | DATETIME | Y | The date and time that the data_status_cd was set. |
DATA_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the data_status_cd to be set or change. |
DISALLOWED_IND | DOUBLE | N | An indicator of whether the term is allowed for selection. |
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. |
LANGUAGE_CD | DOUBLE | N | The language that the string is expressed. |
MNEMONIC | VARCHAR(25) | Y | A terse description of the source string. |
NOMENCLATURE_ID | DOUBLE | N | This is the value of the unique primary identifier of the nomenclature table. It is an internal system assigned number. |
NOM_VER_GRP_ID | DOUBLE | N | Uniquely defines a nomenclature item within the nomenclature table. The nom_ver_grp_id is associated with multiple nomenclature rows. The nom_ver_grp_id is assigned the nomenclature_id when a code is added. All subsequent updates to the code retain the |
PRIMARY_CTERM_IND | DOUBLE | N | Identifies the source string as the 'official', primary term. |
PRIMARY_VTERM_IND | DOUBLE | Y | Identifies the source_string as the "official", or primary, term for the source_identifier. |
PRINCIPLE_TYPE_CD | DOUBLE | N | A general category used to group strings. |
SHORT_STRING | VARCHAR(60) | Y | A short description of the source string. |
SOURCE_IDENTIFIER | VARCHAR(50) | Y | The code, or key, from the source vocabulary that contributed the string to the nomenclature. |
SOURCE_IDENTIFIER_KEYCAP | VARCHAR(50) | Y | The source identifier that is in upper case. |
SOURCE_STRING | VARCHAR(255) | Y | Variable length string that may include alphanumeric characters and punctuation. |
SOURCE_STRING_KEYCAP | VARCHAR(255) | Y | The source string that is in upper case. |
SOURCE_STRING_KEYCAP_A_NLS | VARCHAR(1020) | Y | this field will help facilitate accent insensitive searches/sorts on the SOURCE_STRING_KEYCAP field (National Language Support) |
SOURCE_VOCABULARY_CD | DOUBLE | N | The external vocabulary or lexicon that contributed the string, e.g. ICD9, SNOMED, etc. |
STRING_IDENTIFIER | CHAR(18) | Y | A unique identifier supplied from Cerner or other external database and is persistent once it is assigned to a string. |
STRING_SOURCE_CD | DOUBLE | N | Represents the external source that owns the string_identifier. |
STRING_STATUS_CD | DOUBLE | N | An indication of whether the string is the preferred form of a term or a variant of that form, e.g. by case, plurality, word order. |
TERM_ID | DOUBLE | N | This is the value of the unique primary identifier of the term table. It is an internal system assigned number. |
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. |
VOCAB_AXIS_CD | DOUBLE | N | Vocabulary AXIS codes related to SNOMEDColumn |
Relationship Detail - NOMENCLATURE
Child Column in NOMENCLATURE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PRINCIPLE_TYPE_CD | CODE_VALUE | CODE_VALUE |
VOCAB_AXIS_CD | CODE_VALUE | CODE_VALUE | |
NOM_VER_GRP_ID | NOMENCLATURE | NOMENCLATURE_ID | |
TERM_ID | TERM | TERM_ID |
Parent Column in NOMENCLATURE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | NOMENCLATURE_ID | ALERT_AUDIT_ALLERGY_DOM | NOMENCLATURE_ID |
ALLERGY | SUBSTANCE_NOM_ID | ||
ALLERGY_EXT_DATA | NOMENCLATURE_ID | ||
AOAV_CONDITION | NOMENCLATURE_ID | ||
BATCH_TRANS_FILE | DRG_NOMENCLATURE_ID | ||
BB_QC_EXPECTED_RESULT_R | NOMENCLATURE_ID | ||
BB_QC_RESULT | NOMENCLATURE_ID | ||
BB_RH_PHENOTYPE | FR_NOMENCLATURE_ID | ||
BB_RH_PHENOTYPE | W_NOMENCLATURE_ID | ||
BMDI_DEVICE_NOMENCLATURE | NOMENCLATURE_ID | ||
BT_COND_CRIT_GRP_RELTN | NOMENCLATURE_ID | ||
CAC_NOMENCLATURE | MAPPED_NOMENCLATURE_ID | ||
CAC_NOMENCLATURE | NOMENCLATURE_ID | ||
CHARGE | ALPHA_NOMEN_ID | ||
CHARGE_EVENT_ACT | ALPHA_NOMEN_ID | ||
CNT_DCP_INTERP_STATE | NOMENCLATURE_ID | ||
CNT_DCP_INTERP_STATE | RESULT_NOMENCLATURE_ID | ||
CONCEPT_PRSNL_CROSSMAP | SOURCE_NOMEN_ID | ||
CONCEPT_PRSNL_CROSSMAP | TARGET_NOMEN_ID | ||
CV_CASE_ABSTR_DATA | NOMENCLATURE_ID | ||
CV_DEV_ABSTR_DATA | NOMENCLATURE_ID | ||
CYTO_STANDARD_RPT_R | NOMENCLATURE_ID | ||
DIAGNOSIS | MOD_NOMENCLATURE_ID | ||
DIAGNOSIS | NOMENCLATURE_ID | ||
DIAGNOSIS | ORIGINATING_NOMENCLATURE_ID | ||
DIAGNOSIS_HIST | NOMENCLATURE_ID | ||
DRG | NOMENCLATURE_ID | ||
DRG_SPECIALTY | NOMENCLATURE_ID | ||
DSM_COMPONENT | NOMENCLATURE_ID | ||
EEM_ABN_CHECK | DIAG_NOMEN_ID | ||
EEM_ABN_CHECK | PROC_NOMEN_ID | ||
EEM_ABN_DIAG | DIAG_NOMEN_ID | ||
EEM_ABN_MOD | MOD_NOMEN_ID | ||
EEM_BENEFIT_QUAL | BEG_NOMEN_ID | ||
EEM_BENEFIT_QUAL | END_NOMEN_ID | ||
EEM_SERVICE_LIST | CAUSE_BEG_NOMEN_ID | ||
EEM_SERVICE_LIST | CAUSE_END_NOMEN_ID | ||
EEM_SERVICE_LIST | TYPE_BEG_NOMEN_ID | ||
EEM_SERVICE_LIST | TYPE_END_NOMEN_ID | ||
ENCNTR_INFO | VALUE_NOMENCLATURE_ID | ||
ENCNTR_INFO_HIST | VALUE_NOMENCLATURE_ID | ||
ENCNTR_PLAN_ELIGIBILITY | PROC_NOMEN_ID | ||
EXPEDITE_CODED_RESP | NOMENCLATURE_ID | ||
FHX_ACTIVITY | NOMENCLATURE_ID | ||
FHX_SECTION_DEF | NOMENCLATURE_ID | ||
FILL_PRINT_ORD_HX | ICD9_ID | ||
FN_EV_SURVEY_ELEMENT_ACT | NOMENCLATURE_ID | ||
FN_EV_SURVEY_ELEMENT_REF | NOMENCLATURE_ID | ||
HEALTH_CONCERN | NOMENCLATURE_ID | ||
HIM_HAC_CRITERIA | COMPARE_DX_NOMEN_ID | ||
HIM_HAC_CRITERIA | COMPARE_PX_NOMEN_ID | ||
HIM_HAC_CRITERIA | HAC_NOMENCLATURE_ID | ||
HLA_AB_SCREEN_HISTORY_MAP | DILUTION_NOM_ID | ||
HLA_AB_SCREEN_HISTORY_MAP | METHODOLOGY_NOM_ID | ||
HLA_NOMEN_CODE_R | NOMENCLATURE_ID | ||
HLA_XM_HISTORY_MAP | XM_TYPE_NOM_ID | ||
HM_EXPECT_SAT | NOMENCLATURE_ID | ||
HM_EXPECT_SAT_HIST | NOMENCLATURE_ID | ||
IB_RX_REQ_DIAGNOSIS | NOMENCLATURE_ID | ||
IMPLANT_HISTORY | PROCEDURE_NOMEN_ID | ||
INTERP_RESULT | RESULT_NOMENCLATURE_ID | ||
LH_CNT_LTD_DATA_DETAIL | NOMEN_ID | ||
MEDICATION_DEFINITION | MDX_GFC_NOMEN_ID | ||
NOMENCLATURE | NOM_VER_GRP_ID | ||
NOMENCLATURE_ENCNTR_DESC | NOMENCLATURE_ID | ||
NOMENCLATURE_OUTBOUND | NOMENCLATURE_ID | ||
NOMEN_ENTITY_RELTN | NOMENCLATURE_ID | ||
NOMEN_GROUP_RELTN | NOMEN_ID | ||
OMF_ENCNTR_ST | DRG_NOMEN_ID | ||
OMF_ENCNTR_ST | ICD9_ADMIT_DIAG_NOMEN_ID | ||
OMF_ENCNTR_ST | ICD9_PRIN_DIAG_NOMEN_ID | ||
OMF_ENCNTR_ST | ICD9_PRIN_PROC_NOMEN_ID | ||
OMF_ENCNTR_ST | ICD9_SECONDARY1_DIAG_NOMEN_ID | ||
OMF_ENCNTR_ST | MRD_NOMEN_ID | ||
ONC_MTUITIVE_WORKSHEET | NOMENCLATURE_ID | ||
ONC_NOMEN_DOCSETREF_R | NOMENCLATURE_ID | ||
ONC_NOMEN_TERM_RELTN | NOMENCLATURE_ID | ||
ORDER_POTENTIAL_DIAGNOSIS | NOMENCLATURE_ID | ||
ORDER_POTENTIAL_DIAGNOSIS | ORIGINATING_NOMENCLATURE_ID | ||
OUTCOME_CAT_CRITERIA | NOMENCLATURE_ID | ||
OUTCOME_CRITERIA | NOMENCLATURE_ID | ||
PDOC_ASSESSPLAN_CONTENT | NOMENCLATURE_ID | ||
PERFORM_RESULT | NOMENCLATURE_ID | ||
PERSON_HLA_AB_SCN_AUDIT | DILUTION_NOM_ID | ||
PERSON_HLA_AB_SCN_AUDIT | METHODOLOGY_NOM_ID | ||
PERSON_HLA_AB_SCN_AUDIT | REACTION_NOM_ID | ||
PERSON_HLA_AB_SCREEN | DILUTION_NOM_ID | ||
PERSON_HLA_AB_SCREEN | METHODOLOGY_NOM_ID | ||
PERSON_HLA_AB_SCREEN | REACTION_NOM_ID | ||
PERSON_HLA_AB_SPEC | HLA_TYPE_NOM_ID | ||
PERSON_HLA_TYPE | HLA_TYPE_NOM_ID | ||
PERSON_HLA_TYPE_AUDIT | HLA_TYPE_NOM_ID | ||
PERSON_HLA_XM | B_CELL_RESULT_NOM_ID | ||
PERSON_HLA_XM | MONO_CELL_RESULT_NOM_ID | ||
PERSON_HLA_XM | TB_CELL_RESULT_NOM_ID | ||
PERSON_HLA_XM | T_CELL_RESULT_NOM_ID | ||
PERSON_HLA_XM | XM_TYPE_NOM_ID | ||
PERSON_HLA_XM_AUDIT | B_CELL_RESULT_NOM_ID | ||
PERSON_HLA_XM_AUDIT | MONO_CELL_RESULT_NOM_ID | ||
PERSON_HLA_XM_AUDIT | TB_CELL_RESULT_NOM_ID | ||
PERSON_HLA_XM_AUDIT | T_CELL_RESULT_NOM_ID | ||
PERSON_HLA_XM_AUDIT | XM_TYPE_NOM_ID | ||
PERSON_ORG_RELTN | EMPL_OCCUPATION_NOMEN_ID | ||
PERSON_ORG_RELTN | EMPL_OCC_INDUSTRY_NOMEN_ID | ||
PERSON_ORG_RELTN_HIST | EMPL_OCCUPATION_NOMEN_ID | ||
PERSON_ORG_RELTN_HIST | EMPL_OCC_INDUSTRY_NOMEN_ID | ||
PERSON_RH_PHENO_RESULT | NOMENCLATURE_ID | ||
PERSON_TRIBAL_AFLTN | TRIBAL_ENTITY_NOMENCLATURE_ID | ||
PERSON_TRIBAL_AFLTN_HIST | TRIBAL_ENTITY_NOMENCLATURE_ID | ||
PFT_CHARGE_GLOBAL_DAYS | MOD_NOMEN_ID | ||
PFT_CHARGE_GLOBAL_DAYS | PROC_NOMEN_ID | ||
PFT_CM_EVENT_LOG | NOMENCLATURE_ID | ||
PFT_REVENUE_SUMMARY | CPT_NOMEN_ID | ||
PFT_REVENUE_SUMMARY | DRG_NOMEN_ID | ||
PFT_REVENUE_SUMMARY | HCPCS_NOMEN_ID | ||
PFT_REVENUE_SUMMARY | ICD9_NOMEN_ID | ||
PFT_RVU_CONTENT | MOD_NOMEN_ID | ||
PFT_RVU_CONTENT | PROC_NOMEN_ID | ||
PHA_DISP_OBS_ST | ICD9_NOMEN_ID | ||
PHA_ORD_ACT_OBS_ST | ICD9_NOMEN_ID | ||
PHA_PROD_DISP_OBS_ST | ICD9_NOMEN_ID | ||
PI_LEAFLET | NOMENCLATURE_ID | ||
PL_PC_ORG_DIAG_XREF | NOMENCLATURE_ID | ||
PROBLEM | NOMENCLATURE_ID | ||
PROBLEM | ORIGINATING_NOMENCLATURE_ID | ||
PROBLEM_EXT_DATA | ORIGINATING_NOMENCLATURE_ID | ||
PROBLEM_EXT_DATA | TARGET_NOMENCLATURE_ID | ||
PROCEDURE | DIAG_NOMENCLATURE_ID | ||
PROCEDURE | MOD_NOMENCLATURE_ID | ||
PROCEDURE | NOMENCLATURE_ID | ||
PROCEDURE_EXT_DATA | NOMENCLATURE_ID | ||
PROCEDURE_HIST | NOMENCLATURE_ID | ||
PROP_RESULT | NOMENCLATURE_ID | ||
PT_PROT_REG | NOMENCLATURE_ID | ||
QC_RESULT | NOMENCLATURE_ID | ||
RCR_TRANS_DIST | NOMENCLATURE_ID | ||
REF_CD_MAP_DETAIL | NOMENCLATURE_ID | ||
RESULT_HASH | NOMENCLATURE_ID | ||
SA_ANESTHESIA_REC_FIELD_VALUES | DIAGNOSIS_NOMENCLATURE_ID | ||
SA_ANESTHESIA_REC_FIELD_VALUES | PROBLEM_NOMENCLATURE_ID | ||
SA_ANESTHESIA_REC_FIELD_VALUES | PROCEDURE_NOMENCLATURE_ID | ||
SA_PARAMETER_VALUE | NOMENCLATURE_ID | ||
SCH_ABN_CROSS | PROC_NOMEN_ID | ||
SCH_NOMEN_LIST | BEG_NOMENCLATURE_ID | ||
SCH_NOMEN_LIST | END_NOMENCLATURE_ID | ||
SHX_ALPHA_RESPONSE | NOMENCLATURE_ID | ||
SN_NOMEN_ST | NOMENCLATURE_ID | ||
SN_PROC_CPT_R | NOMENCLATURE_ID | ||
SN_SURG_CASE_PROC_CPT | NOMENCLATURE_ID | ||
UCMR_KARYOTYPE_CONCEPT | NOMENCLATURE_ID | ||
UCM_KARYOTYPE_CONCEPT | NOMENCLATURE_ID | ||
UKR_SACT | NOMENCLATURE_ID | ||
VISITCODING_AUDIT | APPLIED_CHARGE_ID | ||
VISITCODING_AUDIT | APPLIED_MODIFIER_ID | ||
VISITCODING_AUDIT | PRIMARY_NOMENCLATURE_ID | ||
VISITCODING_AUDIT | SUGGESTED_CHARGE_ID | ||
VISITCODING_DX | NOMENCLATURE_ID |
NOMENCLATURE_LOAD
Column Section | Top of Page |
Table-level Detail
Description: | Nomenclature Load |
Definition: | This table is just going to be a temporary table we use to store nomenclature data (temporarily) and then compare that data with the nomenclature table. Then update or insert into the nomenclature table based on those comparisons. |
Table Type: | REFERENCE |
Column Detail - NOMENCLATURE_LOAD
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_FLAG | DOUBLE | Y | Determines action to be taken on row 0 = Need to be processed 1 = Insert Needed 2 = Already Processed |
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | 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(250) | N | the global unique identifier from an outside source |
CONCEPT_CKI | VARCHAR(255) | Y | cki from the concept table which is the functional concept. |
CONTRIBUTOR_SYSTEM_CD | DOUBLE | N | Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed. |
CONTRIBUTOR_SYSTEM_MEAN | VARCHAR(12) | Y | contributor system identifies the source feed of data from which a row was populated. this is mainly used to determine how to update a set of data that may have originated from more than one source feed. |
DISALLOWED_IND | DOUBLE | Y | an indicator of whether the term is allowed for selection. |
END_EFFECTIVE_DT_TM | DATETIME | Y | 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. |
LANGUAGE_CD | DOUBLE | N | Language Code from code set 36 |
LANGUAGE_MEAN | VARCHAR(12) | Y | the language that the string is expressed |
MNEMONIC | VARCHAR(25) | Y | A terse description of the source string. |
PRIMARY_CTERM_IND | DOUBLE | Y | identifies the source string as the 'official', primary term. |
PRIMARY_VTERM_IND | DOUBLE | Y | identifies the source_string as the "official", or primary, term for the source_identifier. |
PRINCIPLE_TYPE_CD | DOUBLE | N | Principle Type Code from Code Set 401 |
PRINCIPLE_TYPE_MEAN | VARCHAR(12) | Y | a general category used to group strings. |
SHORT_STRING | VARCHAR(60) | Y | Short String representation |
SOURCE_IDENTIFIER | VARCHAR(50) | Y | the code, or key, from the source vocabulary that contributed the string to the nomenclature. |
SOURCE_STRING | VARCHAR(255) | Y | variable length string that may include alphanumeric characters and punctuation. |
SOURCE_VOCABULARY_CD | DOUBLE | N | Source Vocabulary Code from code set 400 |
SOURCE_VOCABULARY_MEAN | VARCHAR(12) | Y | the external vocabulary or lexicon that contributed the string, e.g. icd9, snomed, etc. |
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. |
VOCAB_AXIS_CD | DOUBLE | N | Vocabulary Axis Code from code set 15849 |
VOCAB_AXIS_MEAN | VARCHAR(12) | Y | vocabulary axis means related to snomed |
NOMENCLATURE_LOAD_NS
Column Section | Top of Page |
Table-level Detail
Description: | Nomenclature Load NS |
Definition: | This table is just going to be a temporary table we use to store NON-SNOMED nomenclature data (temporarily) to support the load process. |
Table Type: | REFERENCE |
Column Detail - NOMENCLATURE_LOAD_NS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_FLAG | DOUBLE | Y | Determines action to be taken on row 0 = Need to be processed 1 = Insert Needed 2 = Already Processed |
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | 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(250) | N | the global unique identifier from an outside source |
CONCEPT_CKI | VARCHAR(255) | Y | cki from the concept table which is the functional concept. |
CONTRIBUTOR_SYSTEM_CD | DOUBLE | N | Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed. |
CONTRIBUTOR_SYSTEM_MEAN | VARCHAR(12) | Y | contributor system identifies the source feed of data from which a row was populated. this is mainly used to determine how to update a set of data that may have originated from more than one source feed. |
DISALLOWED_IND | DOUBLE | Y | an indicator of whether the term is allowed for selection. |
END_EFFECTIVE_DT_TM | DATETIME | Y | 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. |
LANGUAGE_CD | DOUBLE | N | Language Code from code set 36 |
LANGUAGE_MEAN | VARCHAR(12) | Y | the language that the string is expressed |
MNEMONIC | VARCHAR(25) | Y | Mnemonic for Source String |
PRIMARY_CTERM_IND | DOUBLE | Y | identifies the source string as the 'official', primary term. |
PRIMARY_VTERM_IND | DOUBLE | Y | identifies the source_string as the "official", or primary, term for the source_identifier. |
PRINCIPLE_TYPE_CD | DOUBLE | N | Principle Type Code from Code Set 401 |
PRINCIPLE_TYPE_MEAN | VARCHAR(12) | Y | a general category used to group strings. |
SHORT_STRING | VARCHAR(60) | Y | Short String representation of Source String |
SOURCE_IDENTIFIER | VARCHAR(50) | Y | the code, or key, from the source vocabulary that contributed the string to the nomenclature. |
SOURCE_STRING | VARCHAR(255) | Y | variable length string that may include alphanumeric characters and punctuation. |
SOURCE_VOCABULARY_CD | DOUBLE | N | Source Vocabulary Code from code set 400 |
SOURCE_VOCABULARY_MEAN | VARCHAR(12) | Y | the external vocabulary or lexicon that contributed the string, e.g. icd9, snomed, etc. |
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. |
VOCAB_AXIS_CD | DOUBLE | N | Vocabulary Axis Code from code set 15849 |
VOCAB_AXIS_MEAN | VARCHAR(12) | Y | vocabulary axis means related to snomed |
NOMENCLATURE_OUTBOUND
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Nomenclature Outbound |
Definition: | This table is used to translate a nomenclature_id to a source identifier of another source vocabulary for outbound interfaces. |
Table Type: | REFERENCE |
Column Detail - NOMENCLATURE_OUTBOUND
Column Name | Type | Null? | Definition |
---|---|---|---|
ALIAS | VARCHAR(255) | N | The outbound alias to the nomenclature_id. |
ALIAS_TYPE_MEANING | VARCHAR(255) | Y | The meaning of the alias. Used when alias is not unique enough within a source vocabulary. |
NOMENCLATURE_ID | DOUBLE | N | This is the value of the unique primary identifier of the nomenclature table. It is an internal system assigned number |
SOURCE_VOCABULARY_CD | DOUBLE | N | The external vocabulary or lexicon that the nomenclature_id is being aliased. |
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. |
Relationship Detail - NOMENCLATURE_OUTBOUND
Child Column in NOMENCLATURE_OUTBOUND(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | NOMENCLATURE_ID | NOMENCLATURE | NOMENCLATURE_ID |
NOMEN_CATEGORY
Column Section | Top of Page |
Table-level Detail
Description: | Nomenclature Category |
Definition: | Allows client to create pick lists, or favorites to assist in nomenclature lookups. |
Table Type: | REFERENCE |
Column Detail - NOMEN_CATEGORY
Column Name | Type | Null? | Definition |
---|---|---|---|
CATEGORY_NAME | VARCHAR(100) | N | The description of the category that displays in a lookup. |
CATEGORY_NAME_A_NLS | VARCHAR(400) | Y | CATEGORY_NAME_A_NLS column |
CATEGORY_NAME_NLS | VARCHAR(202) | Y | This is the description used for non-English based strings for the NLSSORT function. |
CATEGORY_TYPE_CD | DOUBLE | N | Defines the available nomenclature category types to assign to each nomenclature category. |
CONTRIBUTOR_SYSTEM_CD | DOUBLE | N | Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed. |
NOMEN_CATEGORY_ID | DOUBLE | N | The unique identifier for a row in the Nomenclature Category table. |
PARENT_ENTITY_ID | DOUBLE | N | The unique identifier of the table specified in the parent_entity_name column. |
PARENT_ENTITY_NAME | VARCHAR(32) | Y | Defines the parent entity that the owner of nomenclature category belongs. |
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. |