aurora_standard.chmcmhed
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| ref_no | varchar(16) | YES | ||||
| debtor_name_1 | varchar(30) | YES | ||||
| debtor_name_2 | varchar(30) | YES | ||||
| debtor_1_ecoa | varchar(1) | YES | ||||
| debtor_2_ecoa | varchar(1) | YES | ||||
| debtor_1_ssn | varchar(11) | YES | ||||
| debtor_2_ssn | varchar(11) | YES | ||||
| debtor_addr | varchar(30) | YES | ||||
| debtor_city | varchar(20) | YES | ||||
| debtor_state | varchar(2) | YES | ||||
| debtor_zip | varchar(10) | YES | ||||
| principal | varchar(9) | YES | ||||
| date_ser | varchar(10) | YES | ||||
| debtor_phone | varchar(10) | YES | ||||
| debtor_wphone | varchar(10) | YES | ||||
| guar_dob | varchar(10) | YES | ||||
| pat_dob | varchar(10) | YES | ||||
| empl_name | varchar(30) | YES | ||||
| empl_addr | varchar(30) | YES | ||||
| empl_c_s_z | varchar(30) | YES | ||||
| pat_last_name | varchar(20) | YES | ||||
| pat_first_name | varchar(20) | YES | ||||
| pat_addr | varchar(20) | YES | ||||
| pat_city | varchar(20) | YES | ||||
| pat_state | varchar(20) | YES | ||||
| pat_zip | varchar(20) | YES | ||||
| pat_phone | varchar(20) | YES | ||||
| pat_ssn | varchar(20) | YES | ||||
| pat_sex | varchar(20) | YES | ||||
| admit_date | varchar(10) | YES | ||||
| dischg_date | varchar(10) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |