aurora_standard.chmmbc51
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| visit_no | int(11) | YES | ||||
| previous_control | varchar(14) | YES | ||||
| payment_other_than | varchar(1) | YES | ||||
| previous_rejected | varchar(1) | YES | ||||
| resubmitted | varchar(1) | YES | ||||
| comp_no_pay | varchar(1) | YES | ||||
| orignial_form_ind | varchar(1) | YES | ||||
| primary_payor_flag | varchar(1) | YES | ||||
| pmt_received_from | decimal(7,2) | YES | ||||
| check_payment_date | date | YES | ||||
| check_number | varchar(10) | YES | ||||
| np_code | varchar(3) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |
References
| Local Column | References | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| visit_no |
|