aurora_standard.chmphyne
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| fac_no | varchar(3) | YES | MUL | |||
| payor_code | varchar(1) | YES | ||||
| phys_no | smallint(6) | YES | ||||
| ins_co | smallint(6) | YES | ||||
| type_patient | varchar(2) | YES | ||||
| box_17_a | varchar(20) | YES | ||||
| box_24k | varchar(20) | YES | ||||
| box_33_pin | varchar(20) | YES | ||||
| box_33_grp | varchar(20) | YES | ||||
| box_25 | varchar(20) | YES | ||||
| input_by | int(11) | YES | ||||
| up_date | date | YES | ||||
| cox_year | varchar(2) | YES | ||||
| pat_status | varchar(2) | YES | ||||
| box_17a_qual | varchar(2) | YES | ||||
| box_17b_npi | int(10) | YES | ||||
| box_24i_qual | varchar(2) | YES | ||||
| box_24j_id | varchar(17) | YES | ||||
| box_24j_npi | int(10) | YES | ||||
| box_33a_npi | int(10) | YES | ||||
| box_33b_qual | varchar(2) | YES | ||||
| box_33b_id | varchar(17) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |