aurora_standard.chlswbhd
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| rec_id | varchar(2) | YES | ||||
| fed_id | varchar(12) | YES | ||||
| st_id | varchar(15) | YES | ||||
| fac_id | varchar(16) | YES | ||||
| fac_name | varchar(30) | YES | ||||
| fac_addr_1 | varchar(30) | YES | ||||
| fac_addr_2 | varchar(30) | YES | ||||
| fac_city | varchar(20) | YES | ||||
| fac_st | varchar(2) | YES | ||||
| fac_zip | varchar(11) | YES | ||||
| fac_cntct | varchar(30) | YES | ||||
| fac_phone | varchar(10) | YES | ||||
| fac_exten | varchar(5) | YES | ||||
| agt_id | varchar(9) | YES | ||||
| agt_name | varchar(30) | YES | ||||
| agt_addr_1 | varchar(30) | YES | ||||
| agt_addr_2 | varchar(30) | YES | ||||
| agt_city | varchar(20) | YES | ||||
| agt_st | varchar(2) | YES | ||||
| agt_zip | varchar(11) | YES | ||||
| agt_cntct | varchar(30) | YES | ||||
| agt_phone | varchar(10) | YES | ||||
| agt_exten | varchar(5) | YES | ||||
| sfw_id | varchar(9) | YES | ||||
| sfw_name | varchar(30) | YES | ||||
| sfw_addr_1 | varchar(30) | YES | ||||
| sfw_addr_2 | varchar(30) | YES | ||||
| sfw_city | varchar(20) | YES | ||||
| sfw_st | varchar(2) | YES | ||||
| sfw_zip | varchar(11) | YES | ||||
| sfw_cntct | varchar(30) | YES | ||||
| sfw_phone | varchar(10) | YES | ||||
| sfw_exten | varchar(5) | YES | ||||
| file_dt | varchar(8) | YES | ||||
| test_sw | varchar(1) | YES | ||||
| hdr_fl1 | varchar(200) | YES | ||||
| hdr_fl2 | varchar(200) | YES | ||||
| hdr_fl3 | varchar(200) | YES | ||||
| hdr_fl4 | varchar(200) | YES | ||||
| hdr_fl5 | varchar(200) | YES | ||||
| hdr_fl6 | varchar(200) | YES | ||||
| hdr_fl7 | varchar(35) | YES | ||||
| data_end | varchar(1) | YES | ||||
| crg_rtn | varchar(1) | YES | ||||
| ln_fd | varchar(1) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |
References
| Local Column | References | ||||
|---|---|---|---|---|---|
| file_dt |
| ||||
| fac_name |
|