aurora_standard.stmtypec

Field	Type	Null	Key	Extra
type_code	char(30)	YES
type_desc	char(60)	YES
chs_rowID	bigint(20) unsigned	NO	PRI	auto_increment

References

Local Column

References

type_desc

Table	Column
Snomed.types	sno_type_desc
Snomed_Dev_Orig.types	sno_type_desc
_1.patients_icd9_problems_dx_modifiers	pipdm_type_desc
_1188.patients_icd9_problems_dx_modifiers	pipdm_type_desc
_1218.patients_icd9_problems_dx_modifiers	pipdm_type_desc
_1548.patients_icd9_problems_dx_modifiers	pipdm_type_desc
_435.patients_icd9_problems_dx_modifiers	pipdm_type_desc
_436.patients_icd9_problems_dx_modifiers	pipdm_type_desc
_436_archive_testing.patients_icd9_problems_dx_modifiers	pipdm_type_desc
_437.patients_icd9_problems_dx_modifiers	pipdm_type_desc
_8.patients_icd9_problems_dx_modifiers	pipdm_type_desc
_81.patients_icd9_problems_dx_modifiers	pipdm_type_desc
_999.patients_icd9_problems_dx_modifiers	pipdm_type_desc
common.cqm_conditions	cqc_value_type_desc

type_code

Table	Column
_1.hl7_accessions	acc_type_code
_1.patients_icd9_problems_dx_modifiers	pipdm_type_code
_1188.hl7_accessions	acc_type_code
_1188.patients_icd9_problems_dx_modifiers	pipdm_type_code
_1218.hl7_accessions	acc_type_code
_1218.patients_icd9_problems_dx_modifiers	pipdm_type_code
_1548.hl7_accessions	acc_type_code
_1548.patients_icd9_problems_dx_modifiers	pipdm_type_code
_435.hl7_accessions	acc_type_code
_435.patients_icd9_problems_dx_modifiers	pipdm_type_code
_436.hl7_accessions	acc_type_code
_436.patients_icd9_problems_dx_modifiers	pipdm_type_code
_436_archive_testing.hl7_accessions	acc_type_code
_436_archive_testing.patients_icd9_problems_dx_modifiers	pipdm_type_code
_437.hl7_accessions	acc_type_code
_437.patients_icd9_problems_dx_modifiers	pipdm_type_code
_8.hl7_accessions	acc_type_code
_8.patients_icd9_problems_dx_modifiers	pipdm_type_code
_81.hl7_accessions	acc_type_code
_81.patients_icd9_problems_dx_modifiers	pipdm_type_code
_999.hl7_accessions	acc_type_code
_999.patients_icd9_problems_dx_modifiers	pipdm_type_code
aurora_standard.stmaintd	maint_type_code
aurora_standard.stmnoted	note_type_code
aurora_standard.stmwarrd	warr_type_code
common.clients	cli_service_type_code