aurora_standard.catots
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| fac_no | char(3) | YES | ||||
| coll_agency | char(10) | YES | ||||
| visit_no | int(11) | YES | ||||
| pri_fc | char(2) | YES | ||||
| fin_class | char(5) | YES | ||||
| pat_status | char(3) | YES | ||||
| spec_hand | char(2) | YES | ||||
| last_name | char(20) | YES | ||||
| first_name | char(20) | YES | ||||
| mid_name | char(20) | YES | ||||
| admit_date | date | YES | ||||
| dischg_date | date | YES | ||||
| attend_phy | smallint(6) | YES | ||||
| date_forwarded | date | YES | ||||
| report_it | char(1) | YES | ||||
| tot_chrgs | decimal(16,2) | YES | ||||
| tot_pmts | decimal(16,2) | YES | ||||
| tot_adjs | decimal(16,2) | YES | ||||
| los | smallint(6) | YES | ||||
| tot_fromca | decimal(16,2) | YES | ||||
| tot_cur_bal | decimal(16,2) | YES |