aurora_standard.newicd10

Field Type Null Default Key Extra Comment
cd_type varchar(1) YES
code10 varchar(10) YES UNI
eff_dt varchar(8) YES
termination_dt varchar(8) YES
short_title varchar(60) YES
long_title varchar(280) YES
cm1 varchar(1) YES
cm2 varchar(1) YES
cm3 varchar(1) YES
cm4 varchar(1) YES
cm5 varchar(1) YES
cm6 varchar(1) YES
cm7 varchar(1) YES
p1 varchar(1) YES
p2 varchar(1) YES
p3 varchar(1) YES
p4 varchar(1) YES
p5 varchar(1) YES
p6 varchar(1) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
code10
TableColumn
aurora_standard.chltrandndc_code10
aurora_standard.chmarstee_code10
aurora_standard.chmcostdc_code10
aurora_standard.chmhid4dc_code10
aurora_standard.chmhid4dv_code10
p1
TableColumn
aurora_standard.chmbenedi_coins_p1
aurora_standard.chmbenedo_coins_p1
aurora_standard.chmibendi_coins_p1
aurora_standard.chmibendo_coins_p1
p2
TableColumn
aurora_standard.chmbenedi_coins_p2
aurora_standard.chmbenedo_coins_p2
aurora_standard.chmibendi_coins_p2
aurora_standard.chmibendo_coins_p2
eff_dt
TableColumn
aurora_standard.hl7gt1guar_hire_eff_dt
aurora_standard.lngdrgdesi_eff_dt
aurora_standard.lngdrgwac_cur_eff_dt
aurora_standard.lngdrgawp_curr_eff_dt
aurora_standard.lngdrgdp_cur_eff_dt
aurora_standard.lngdrgfur_cur_eff_dt
aurora_standard.lngdrgsrp_curr_eff_dt