aurora_standard.chmbillc
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| pat_status | varchar(3) | YES | ||||
| fin_class | varchar(5) | YES | ||||
| ins_rec_no | smallint(6) | YES | ||||
| descrip | varchar(30) | YES | ||||
| pos_code | varchar(2) | YES | ||||
| type_bill | varchar(3) | YES | ||||
| medicare_ub | varchar(20) | YES | ||||
| medicaid_ub | varchar(20) | YES | ||||
| champus_ub | varchar(20) | YES | ||||
| bcbs_ub | varchar(20) | YES | ||||
| other_ub | varchar(20) | YES | ||||
| medicare_1500 | varchar(20) | YES | ||||
| medicaid_1500 | varchar(20) | YES | ||||
| champus_1500 | varchar(20) | YES | ||||
| bcbs_1500 | varchar(20) | YES | ||||
| other_1500 | varchar(20) | YES | ||||
| series_type | varchar(1) | YES | ||||
| form_1500 | varchar(1) | YES | ||||
| form_ub92 | varchar(1) | YES | ||||
| form_other | varchar(1) | YES | ||||
| form_other_desc | varchar(30) | YES | ||||
| ub_emc_type | varchar(3) | YES | ||||
| fac_no | varchar(3) | YES | MUL | |||
| npi_no | int(10) | YES | ||||
| taxonomy | varchar(10) | YES | ||||
| form_15new | varchar(1) | YES | ||||
| form_ub04 | varchar(1) | YES | ||||
| control_no | bigint(20) unsigned | NO | PRI | auto_increment |