aurora_standard.chmcostrc
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| rec_type | char(1) | YES | ||||
| hos_no | char(3) | YES | ||||
| filler_11 | char(11) | YES | ||||
| visit_no | char(25) | YES | MUL | |||
| rec_seq_no | char(2) | YES | ||||
| dx_version | char(1) | YES | ||||
| admit_dx | char(7) | YES | ||||
| reason_dx1 | char(7) | YES | ||||
| reason_dx2 | char(7) | YES | ||||
| reason_dx3 | char(7) | YES | ||||
| e_code1 | char(8) | YES | ||||
| e_code2 | char(8) | YES | ||||
| e_code3 | char(8) | YES | ||||
| principal_dx | char(8) | YES | ||||
| proc_code_p | char(7) | YES | ||||
| proc_date_p | char(8) | YES | ||||
| diag_1 | char(8) | YES | ||||
| diag_2 | char(8) | YES | ||||
| diag_3 | char(8) | YES | ||||
| diag_4 | char(8) | YES | ||||
| diag_5 | char(8) | YES | ||||
| diag_6 | char(8) | YES | ||||
| diag_7 | char(8) | YES | ||||
| diag_8 | char(8) | YES | ||||
| diag_9 | char(8) | YES | ||||
| diag_10 | char(8) | YES | ||||
| diag_11 | char(8) | YES | ||||
| diag_12 | char(8) | YES | ||||
| diag_13 | char(8) | YES | ||||
| diag_14 | char(8) | YES | ||||
| diag_15 | char(8) | YES | ||||
| diag_16 | char(8) | YES | ||||
| diag_17 | char(8) | YES | ||||
| proc_code_1 | char(7) | YES | ||||
| proc_date_1 | char(8) | YES | ||||
| proc_code_2 | char(7) | YES | ||||
| proc_date_2 | char(8) | YES | ||||
| proc_code_3 | char(7) | YES | ||||
| proc_date_3 | char(8) | YES | ||||
| proc_code_4 | char(7) | YES | ||||
| proc_date_4 | char(8) | YES | ||||
| proc_code_5 | char(7) | YES | ||||
| proc_date_5 | char(8) | YES | ||||
| proc_code_6 | char(7) | YES | ||||
| proc_date_6 | char(8) | YES | ||||
| proc_code_7 | char(7) | YES | ||||
| proc_date_7 | char(8) | YES | ||||
| proc_code_8 | char(7) | YES | ||||
| proc_date_8 | char(8) | YES | ||||
| proc_code_9 | char(7) | YES | ||||
| proc_date_9 | char(8) | YES | ||||
| filler2_11 | char(11) | YES |
References
| Local Column | References | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| visit_no |
|