aurora_standard.chmhid4d
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| rec_type | char(1) | YES | ||||
| fac_npi | char(15) | YES | ||||
| visit_no | char(24) | YES | MUL | |||
| rec_seq_no | char(2) | YES | ||||
| c_code1 | char(2) | YES | ||||
| c_code2 | char(2) | YES | ||||
| c_code3 | char(2) | YES | ||||
| c_code4 | char(2) | YES | ||||
| c_code5 | char(2) | YES | ||||
| c_code6 | char(2) | YES | ||||
| c_code7 | char(2) | YES | ||||
| c_code8 | char(2) | YES | ||||
| c_code9 | char(2) | YES | ||||
| c_code10 | char(2) | YES | ||||
| c_code11 | char(2) | YES | ||||
| o_code1 | char(2) | YES | ||||
| o_code2 | char(2) | YES | ||||
| o_code3 | char(2) | YES | ||||
| o_code4 | char(2) | YES | ||||
| o_code5 | char(2) | YES | ||||
| o_code6 | char(2) | YES | ||||
| o_code7 | char(2) | YES | ||||
| o_code8 | char(2) | YES | ||||
| o_date1 | char(8) | YES | ||||
| o_date2 | char(8) | YES | ||||
| o_date3 | char(8) | YES | ||||
| o_date4 | char(8) | YES | ||||
| o_date5 | char(8) | YES | ||||
| o_date6 | char(8) | YES | ||||
| o_date7 | char(8) | YES | ||||
| o_date8 | char(8) | YES | ||||
| o_scode1 | char(2) | YES | ||||
| o_scode2 | char(2) | YES | ||||
| o_scode3 | char(2) | YES | ||||
| o_scode4 | char(2) | YES | ||||
| o_sfrom_date1 | char(8) | YES | ||||
| o_sfrom_date2 | char(8) | YES | ||||
| o_sfrom_date3 | char(8) | YES | ||||
| o_sfrom_date4 | char(8) | YES | ||||
| o_sthru_date1 | char(8) | YES | ||||
| o_sthru_date2 | char(8) | YES | ||||
| o_sthru_date3 | char(8) | YES | ||||
| o_sthru_date4 | char(8) | YES | ||||
| v_code1 | char(2) | YES | ||||
| v_code2 | char(2) | YES | ||||
| v_code3 | char(2) | YES | ||||
| v_code4 | char(2) | YES | ||||
| v_code5 | char(2) | YES | ||||
| v_code6 | char(2) | YES | ||||
| v_code7 | char(2) | YES | ||||
| v_code8 | char(2) | YES | ||||
| v_code9 | char(2) | YES | ||||
| v_code10 | char(2) | YES | ||||
| v_amount1 | char(9) | YES | ||||
| v_amount2 | char(9) | YES | ||||
| v_amount3 | char(9) | YES | ||||
| v_amount4 | char(9) | YES | ||||
| v_amount5 | char(9) | YES | ||||
| v_amount6 | char(9) | YES | ||||
| v_amount7 | char(9) | YES | ||||
| v_amount8 | char(9) | YES | ||||
| v_amount9 | char(9) | YES | ||||
| v_amount10 | char(9) | YES | ||||
| pri_name | char(23) | YES | ||||
| sec_name | char(23) | YES | ||||
| ter_name | char(23) | YES | ||||
| filler_5 | char(5) | YES | ||||
| chs_rowID | int(11) unsigned | NO | PRI | auto_increment |
References
| Local Column | References | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| visit_no |
|