aurora_standard.chmmbc50
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| visit_no | int(11) | YES | ||||
| claim_type | varchar(1) | YES | ||||
| assignment_code | varchar(1) | YES | ||||
| subscriber_ind | varchar(1) | YES | ||||
| provider_signature | varchar(1) | YES | ||||
| addl_info | varchar(1) | YES | ||||
| condition_empl | varchar(1) | YES | ||||
| condition_auto | varchar(1) | YES | ||||
| condition_other | varchar(1) | YES | ||||
| injury_date | date | YES | ||||
| date_first_consult | date | YES | ||||
| approved_amt | decimal(7,2) | YES | ||||
| total_charges | decimal(7,2) | YES | ||||
| paid_amt | decimal(7,2) | YES | ||||
| balance_due | decimal(7,2) | YES | ||||
| resource_code | varchar(1) | YES | ||||
| other_ins_ind | varchar(1) | YES | ||||
| date_other_claim | date | YES | ||||
| multiple_diagnosis | varchar(1) | YES | ||||
| related_to_physicl | varchar(1) | YES | ||||
| source_of_payment | varchar(1) | YES | ||||
| privacy_flag | varchar(1) | YES | ||||
| beneficiary_death | varchar(1) | YES | ||||
| prior_authorizatin | varchar(10) | YES | ||||
| payor_number | int(11) | YES | ||||
| claim_office_no | varchar(4) | YES | ||||
| secondary_ins | varchar(1) | YES | ||||
| claim_type_ind | varchar(1) | YES | ||||
| group_provider_cde | varchar(8) | YES | ||||
| other_carrier_emp | varchar(15) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |