Field Name |
Length |
Type |
Description |
Comments |
ad_city |
20 |
char |
City |
|
ad_addr1 |
30 |
char |
Address Line 1 |
|
ad_addr2 |
30 |
char |
Address Line 2 |
|
ad_state |
2 |
char |
State |
|
ad_zip |
5 |
char |
Zip Code |
|
ad_zip4 |
4 |
char |
Zip Code (Extended) |
|
ad_first |
30 |
char |
Name - Last |
|
ad_last |
30 |
char |
Name - First |
|
ad_first2 |
30 |
char |
|
|
ad_last2 |
30 |
char |
|
|
ad_name |
70 |
char |
|
|
ad_inactive |
1 |
bit |
|
|
ad_phonalt |
10 |
char |
Phone Number - Alternate |
|
ad_phonpri |
10 |
char |
Primary Phone Number |
|
ad_ptypalt |
2 |
char |
Alternate Phone Number Type |
|
ad_ptyppri |
2 |
char |
Primary Phone Number Type |
|
ad_udate |
8 |
datetime |
Record Updated (Date) |
|
ad_utime |
8 |
char |
Record Updated (Time) |
|
ad_uid |
9 |
char |
Record Updated (User ID) |
|
ad_adid |
10 |
char |
Adult ID |
Key Field - System Generated |
ad_comment |
254 |
char |
Comments |
|
ad_letter |
1 |
bit |
Suppress from Mailing List |
|
ad_old |
1 |
bit |
Old Address |
|
ad_email |
50 |
varchar |
|
|