aurora_standard.chmvtotd
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| fac_no | char(3) | NO | ||||
| attend_phy | smallint(6) | YES | ||||
| visit_flag | char(1) | YES | ||||
| visit_no | int(11) | YES | ||||
| pat_status | char(3) | YES | ||||
| est_drg | smallint(6) | YES | ||||
| ins_co | smallint(6) | YES | ||||
| network_no | char(6) | YES | ||||
| los | smallint(6) | YES | ||||
| dischg_service | char(4) | YES | ||||
| pri_fc | char(2) | YES | ||||
| fin_class | char(2) | YES | ||||
| spec_hand | char(2) | YES | ||||
| admit_date | date | YES | ||||
| dischg_date | date | YES | ||||
| charges | decimal(12,2) | YES | ||||
| pmts | decimal(12,2) | YES | ||||
| adjs | decimal(12,2) | YES | ||||
| cur_bal | decimal(12,2) | YES | ||||
| network_paid_1 | char(6) | YES | ||||
| network_paid_2 | char(6) | YES | ||||
| fam_phy | smallint(6) | YES |