aurora_standard.chmhistd
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| fac_no | char(3) | NO | ||||
| visit_no | int(11) | NO | ||||
| mr_no | char(20) | YES | ||||
| pat_status | char(2) | YES | ||||
| fin_class | char(5) | YES | ||||
| admit_date | date | YES | ||||
| dischg_date | date | YES | ||||
| los | smallint(6) | YES | ||||
| attend_phy | smallint(6) | YES | ||||
| age | smallint(6) | YES | ||||
| final_diag | char(10) | YES | ||||
| prin_proc | char(10) | YES | ||||
| drg | smallint(6) | YES | ||||
| tot_charges | decimal(7,0) | YES | ||||
| admdx | char(30) | YES | ||||
| disreason | char(2) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |