aurora_standard.bhtparr
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| mrno | char(20) | NO | PRI | |||
| full_name | char(50) | YES | ||||
| rev_cycle | varchar(20) | YES | ||||
| adm_dt | varchar(10) | NO | PRI | |||
| adm_hr | varchar(2) | NO | PRI | |||
| dis_dt | char(10) | YES | ||||
| tos | varchar(10) | YES | ||||
| f_cd | char(10) | YES | ||||
| subf_cd | varchar(10) | YES | ||||
| pri_ins_nm | varchar(30) | YES | ||||
| last_pmt | varchar(10) | YES | ||||
| stmt_dt | varchar(10) | YES | ||||
| cyc_cd | varchar(10) | YES | ||||
| tot_chrgs | decimal(16,2) | YES | ||||
| tot_pmts | decimal(16,2) | YES | ||||
| tot_adjs | decimal(16,2) | YES | ||||
| curbal | decimal(16,2) | NO | 0.00 | |||
| fac | varchar(3) | YES |