aurora_standard.adjpay
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| fac_no | char(3) | YES | ||||
| visit_no | int(11) | YES | MUL | |||
| att_phy | smallint(6) | YES | MUL | |||
| fam_phy | smallint(6) | YES | ||||
| pay_adj | char(1) | YES | ||||
| tr_date | date | YES | ||||
| tr_type | char(3) | YES | MUL | |||
| fin_class | char(5) | YES | ||||
| pat_status | char(3) | YES | ||||
| ins_co | smallint(6) | YES | MUL | |||
| patname | char(30) | YES | ||||
| totchrgs | decimal(16,2) | YES | ||||
| pay_amt | decimal(16,2) | YES | ||||
| adj_amt | decimal(16,2) | YES |