Field Name |
Length |
Type |
Description |
Comments |
ae_addr1 |
50 |
varchar |
Address Line 1 |
|
ae_addr2 |
50 |
varchar |
Address Line 2 |
|
ae_aea |
2 |
char |
AEA Number |
|
ae_agency |
4 |
char |
Agency Code |
|
ae_city |
50 |
varchar |
City |
|
ae_fax |
10 |
char |
Fax Number |
|
ae_medicsn |
9 |
char |
Medicaid Number |
|
ae_medic |
7 |
char |
Medicaid Number |
|
ae_medptc |
7 |
char |
|
|
ae_name |
50 |
varchar |
AEA Name |
|
ae_phonalt |
10 |
char |
Phone Number - Alternate |
|
ae_phonpri |
10 |
char |
Primary Phone Number |
|
ae_ptypalt |
2 |
char |
Alternate Phone Number Type |
|
ae_ptyppri |
2 |
char |
Primary Phone Number Type |
|
ae_state |
2 |
char |
State |
|
ae_udate |
8 |
datetime |
Record Updated (Date) |
|
ae_uid |
9 |
char |
Record Updated (User ID) |
|
ae_utime |
8 |
char |
Record Updated (Time) |
|
ae_watts |
10 |
char |
Phone Number - Watts |
|
ae_zip |
5 |
char |
Zip Code |
|
ae_zip4 |
4 |
char |
Zip Code (Extended) |
|
ae_admin |
30 |
char |
AEA Administrator |
|
ae_data |
30 |
char |
Data Entry Contact Person(s) |
|
ae_directr |
30 |
char |
Director |
|
ae_computr |
30 |
char |
Computer Services Contact Person(s) |
|
ae_medptcs |
7 |
char |
|
|
ae_key |
4 |
int |
|
|