aurora_standard.acensus
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| fac_no | varchar(3) | YES | ||||
| ps | varchar(3) | YES | ||||
| fc | varchar(5) | YES | ||||
| ps_desc | varchar(20) | YES | ||||
| fc_desc | varchar(20) | YES | ||||
| beg_census | smallint(6) | YES | ||||
| admits_today | smallint(6) | YES | ||||
| dischg_today | smallint(6) | YES | ||||
| mtd_admits | smallint(6) | YES | ||||
| mtd_avg_dly | smallint(6) | YES | ||||
| mtd_pat_days | smallint(6) | YES | ||||
| ytd_admits | smallint(6) | YES | ||||
| ytd_avg_dly | smallint(6) | YES | ||||
| ytd_pat_days | smallint(6) | YES | ||||
| census_today | smallint(6) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |