aurora_standard.ainsrvw
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| fac_no | varchar(3) | YES | ||||
| visit_no | bigint(20) | YES | MUL | |||
| pat_name | varchar(30) | YES | ||||
| pat_status | char(3) | YES | ||||
| pri_fc | char(2) | YES | ||||
| fin_class | char(2) | YES | ||||
| spec_hand | char(2) | YES | ||||
| admit_date | date | YES | ||||
| dischg_date | date | YES | ||||
| att_phy | smallint(6) | YES | ||||
| fam_phy | smallint(6) | YES | ||||
| payor_code | char(1) | YES | ||||
| priority_no | char(1) | YES | ||||
| ins_co | smallint(6) | YES | MUL | |||
| company_name | varchar(30) | YES | ||||
| totchrgs | decimal(16,2) | YES | ||||
| adj_amt | decimal(16,2) | YES | ||||
| pay_amt | decimal(16,2) | YES | ||||
| self_amt | decimal(16,2) | YES |