aurora_standard.chmub04b
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| visit_no | int(11) | YES | MUL | |||
| ub_id | char(3) | YES | ||||
| l_50_a | char(23) | YES | ||||
| l_50_b | char(23) | YES | ||||
| l_50_c | char(23) | YES | ||||
| l_51_a | char(15) | YES | ||||
| l_51_b | char(15) | YES | ||||
| l_51_c | char(15) | YES | ||||
| l_52_a | char(1) | YES | ||||
| l_52_b | char(1) | YES | ||||
| l_52_c | char(1) | YES | ||||
| l_53_a | char(1) | YES | ||||
| l_53_b | char(1) | YES | ||||
| l_53_c | char(1) | YES | ||||
| l_54_a | decimal(10,2) | YES | ||||
| l_54_b | decimal(10,2) | YES | ||||
| l_54_c | decimal(10,2) | YES | ||||
| l_55_a | decimal(10,2) | YES | ||||
| l_55_b | decimal(10,2) | YES | ||||
| l_55_c | decimal(10,2) | YES | ||||
| f_56_npi | int(10) | YES | ||||
| f_57a | char(15) | YES | ||||
| f_57b | char(15) | YES | ||||
| f_57c | char(15) | YES | ||||
| l_58_a | char(32) | YES | ||||
| l_58_b | char(32) | YES | ||||
| l_58_c | char(32) | YES | ||||
| l_59_a | decimal(2,0) | YES | ||||
| l_59_b | decimal(2,0) | YES | ||||
| l_59_c | decimal(2,0) | YES | ||||
| l_60_a | char(20) | YES | ||||
| l_60_b | char(20) | YES | ||||
| l_60_c | char(20) | YES | ||||
| l_61_a | char(14) | YES | ||||
| l_61_b | char(14) | YES | ||||
| l_61_c | char(14) | YES | ||||
| l_62_a | char(17) | YES | ||||
| l_62_b | char(17) | YES | ||||
| l_62_c | char(17) | YES | ||||
| l_63_a | char(30) | YES | ||||
| l_63_b | char(30) | YES | ||||
| l_63_c | char(30) | YES | ||||
| f_64a | char(26) | YES | ||||
| f_64b | char(26) | YES | ||||
| f_64c | char(26) | YES | ||||
| l_65_a | char(25) | YES | ||||
| l_65_b | char(25) | YES | ||||
| l_65_c | char(25) | YES | ||||
| f_66_version | char(1) | YES | ||||
| l_67 | char(8) | YES | ||||
| f_67a | char(8) | YES | ||||
| f_67b | char(8) | YES | ||||
| f_67c | char(8) | YES | ||||
| f_67d | char(8) | YES | ||||
| f_67e | char(8) | YES | ||||
| f_67f | char(8) | YES | ||||
| f_67g | char(8) | YES | ||||
| f_67h | char(8) | YES | ||||
| f_67i | char(8) | YES | ||||
| f_67j | char(8) | YES | ||||
| f_67k | char(8) | YES | ||||
| f_67l | char(8) | YES | ||||
| f_67m | char(8) | YES | ||||
| f_67n | char(8) | YES | ||||
| f_67o | char(8) | YES | ||||
| f_67p | char(8) | YES | ||||
| f_67q | char(8) | YES | ||||
| f_68a | char(8) | YES | ||||
| f_68b | char(9) | YES | ||||
| f_69 | char(7) | YES | ||||
| f_70a | char(7) | YES | ||||
| f_70b | char(7) | YES | ||||
| f_70c | char(7) | YES | ||||
| f_71pps | char(4) | YES | ||||
| f_72a_eci | char(8) | YES | ||||
| f_72b_eci | char(8) | YES | ||||
| f_72c_eci | char(8) | YES | ||||
| f_73 | char(9) | YES | ||||
| f_74_cd | char(7) | YES | ||||
| f_74_dt | date | YES | ||||
| f_74_cd_a | char(7) | YES | ||||
| f_74_dt_a | date | YES | ||||
| f_74_cd_b | char(7) | YES | ||||
| f_74_dt_b | date | YES | ||||
| f_74_cd_c | char(7) | YES | ||||
| f_74_dt_c | date | YES | ||||
| f_74_cd_d | char(7) | YES | ||||
| f_74_dt_d | date | YES | ||||
| f_74_cd_e | char(7) | YES | ||||
| f_74_dt_e | date | YES | ||||
| f_75_1 | char(4) | YES | ||||
| f_75_2 | char(4) | YES | ||||
| f_75_3 | char(4) | YES | ||||
| f_75_4 | char(4) | YES | ||||
| f_76_npi | int(10) | YES | ||||
| f_76_qual | char(2) | YES | ||||
| f_76_id | char(11) | YES | ||||
| f_76_last | char(16) | YES | ||||
| f_76_first | char(12) | YES | ||||
| f_76_mi | char(1) | YES | ||||
| f_77_npi | int(10) | YES | ||||
| f_77_qual | char(2) | YES | ||||
| f_77_id | char(11) | YES | ||||
| f_77_last | char(16) | YES | ||||
| f_77_first | char(12) | YES | ||||
| f_77_mi | char(1) | YES | ||||
| f_78_pt | char(2) | YES | ||||
| f_78_npi | int(10) | YES | ||||
| f_78_qual | char(2) | YES | ||||
| f_78_id | char(11) | YES | ||||
| f_78_last | char(16) | YES | ||||
| f_78_first | char(12) | YES | ||||
| f_78_mi | char(1) | YES | ||||
| f_79_pt | char(2) | YES | ||||
| f_79_npi | int(10) | YES | ||||
| f_79_qual | char(2) | YES | ||||
| f_79_id | char(11) | YES | ||||
| f_79_last | char(16) | YES | ||||
| f_79_first | char(12) | YES | ||||
| f_79_mi | char(1) | YES | ||||
| f_80_1 | char(19) | YES | ||||
| f_80_2 | char(24) | YES | ||||
| f_80_3 | char(24) | YES | ||||
| f_80_4 | char(24) | YES | ||||
| f_81qual_a | char(2) | YES | ||||
| f_81code_a | char(10) | YES | ||||
| f_81valu_a | char(12) | YES | ||||
| f_81qual_b | char(2) | YES | ||||
| f_81code_b | char(10) | YES | ||||
| f_81valu_b | char(12) | YES | ||||
| f_81qual_c | char(2) | YES | ||||
| f_81code_c | char(10) | YES | ||||
| f_81valu_c | char(12) | YES | ||||
| f_81qual_d | char(2) | YES | ||||
| f_81code_d | char(10) | YES | ||||
| f_81valu_d | char(12) | YES | ||||
| billc_no | smallint(6) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |
References
| Local Column | References | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| visit_no |
|