Common - Addresses Table
Field Name |
Default Caption |
Mask |
Description |
Field Type |
AD_ADR_APT |
Apartment Number |
8x |
Apartment Number |
Text |
AD_ADR_B2 |
Street Post Bldg No |
8x |
Street Post Building No |
Text |
AD_ADR_B22 |
Street Post Bldg No 2 |
8x |
Street Post Building No 2 |
Text |
AD_ADR_BDG |
Address |
nnnnnn |
Address - Building Number |
Long Integer |
AD_ADR_DIR |
Address - Direction |
2x |
Address - Direction |
Text |
AD_ADR_PT |
Address Prefix Type |
5x |
Address - Prefix Type |
Text |
AD_ADR_SFX |
Address - Suffix |
5x |
Address - Suffix |
Text |
AD_ADR_STR |
Address - Street Name |
50x |
Address - Street Name |
Text |
AD_ADR_TY |
Address - Street Typ |
5x |
Address - Street Type |
Text |
AD_ADR2_PT |
Address 2 Prefix Type |
5x |
Address 2 - Prefix Type |
Text |
AD_ADR2APT |
Apartment 2 |
8x |
Apartment Number 2 |
Text |
AD_ADRBDG2 |
Address 2 |
nnnnnn |
Address 2 |
Long Integer |
AD_ADRDIR2 |
Street 2 |
2x |
Street Direction 2 |
Text |
AD_ADRSFX2 |
Req Street Suffix 2 |
5x |
Street Suffix 2 |
Text |
AD_ADRSTR2 |
Req Street Name 2 |
50x |
Street Name 2 |
Text |
AD_ADRTY2 |
Req Street Type 2 |
5x |
Street Type 2 |
Text |
AD_ASTAT_CD |
Status |
nnn |
Status |
Short Integer |
AD_ASTAT_TY |
Status Text |
30x |
Status Text |
Text |
AD_BLDG_CD |
Building Type |
nnn |
Building Type Code |
Short Integer |
AD_BLDG_TY |
Building Type Text |
25x |
Building Type Text |
Text |
AD_BR_CD |
Default WO Cat |
10x |
Category |
Text |
AD_BR_TY |
Default WO Cat Text |
60x |
Category Text |
Text |
AD_BTYP_CD |
Billing Type |
nnnn |
Billing Type |
Short Integer |
AD_BTYP_TY |
Billing Type Text |
25x |
Billing Type Text |
Text |
AD_CITY |
City |
25x |
City |
Text |
AD_CITY_CD |
Facility |
nnn |
Facility Code |
Short Integer |
AD_CITY_TY |
Facility Text |
50x |
Facility Text |
Text |
AD_CN_ID |
Storm Conduit Rec # |
nnnnnnnn |
Long Integer |
|
AD_COMM |
Commercial |
|
Commercial |
Boolean |
AD_COUNTRY |
Country |
15x |
Country |
Text |
AD_CRAT_CD |
Current Rating |
nnnn |
Current Rating |
Short Integer |
AD_CRAT_TY |
Current Rating Text |
25x |
Current Rating Text |
Text |
AD_CRT_BY |
Created By |
25x |
Created By |
Text |
AD_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
AD_CTYP_CD |
Connection Type |
nnnn |
Connection Type |
Short Integer |
AD_CTYP_TY |
Connection Type Text |
25x |
Connection Type Text |
Text |
AD_DESC_CD |
Description |
nnn |
Description |
Short Integer |
AD_DESC_TY |
Description Text |
30x |
Description Text |
Text |
AD_DOC_FLG |
Document Available |
|
Doc Available: Doc Flag |
Boolean |
AD_DOWN_CD |
Delivery to Owner |
nnnn |
Delivery to Owner |
Short Integer |
AD_DOWN_TY |
Delivery to Owner Text |
25x |
Delivery to Owner Text |
Text |
AD_ELCCID |
Elec Circuit Rec # |
nnnnnnnnn |
Long Integer |
|
AD_ESN |
Emergency Service # |
5x |
Emergency Service Number |
Text |
AD_FEED |
Feeder ID |
30x |
Feeder ID |
Text |
AD_FEED2 |
Feeder 2 ID |
30x |
Feeder 2 ID |
Text |
AD_FI_CD |
Feeder Info |
nnnn |
Feeder Info |
Short Integer |
AD_FI_TY |
Feeder Info Text |
25x |
Feeder Info Text |
Text |
AD_ID |
Address Rec # |
nnnnnnnn |
Unique ID |
Long Integer |
AD_IMG_FLG |
|
|
Image available |
Boolean |
AD_INMAP |
In Map |
|
In Map Flag |
Boolean |
AD_INST_DT |
Installation Date |
mm/dd/yyyy |
Installation Date |
Date/Time |
AD_INVALID |
Invalid Address |
|
Invalid Address |
Boolean |
AD_LOCATE |
General Location |
75x |
General Location |
Text |
AD_LOCATION |
Location |
75x |
Location |
Text |
AD_LOT |
Lot Number |
20x |
Lot Number |
Text |
AD_MIND_CD |
Meter Indicator |
nnnn |
Meter Indicator |
Short Integer |
AD_MIND_TY |
Meter Indicator Text |
25x |
Meter Indicator Text |
Text |
AD_MOD_BY |
Last Mod By |
25x |
Modified By |
Text |
AD_MOD_DT |
Last Mod Date |
mm/dd/yyyy |
Modified Date |
Date/Time |
AD_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
AD_MOV_FLG |
|
|
Movie available |
Boolean |
AD_MSAG |
MSAG Community |
35x |
MSAG Community |
Text |
AD_MT_ID |
Water Meter Rec # |
nnnnnnnnn |
Long Integer |
|
AD_MZONE_CD |
Maintenance Zone |
10x |
Maintenance zone |
Text |
AD_MZONE_TY |
Maintenance Zone Text |
60x |
Maintenance zone text |
Text |
AD_AZONE_CD |
Alternate Zone |
10x |
Alternate zone |
Text |
AD_AZONE_TY |
Alternate Zone Text |
60x |
Alternate zone text |
Text |
AD_NAME |
Business Name |
50x |
Business Name |
Text |
AD_NETID |
Pipe Rec # |
nnnnnnnn |
Long Integer |
|
AD_NOTE |
Note |
254x |
Note |
Text |
AD_NOWORK |
No WO/PM/Req |
|
No WO/PM/Req |
Boolean |
AD_OADDR1 |
Owner Address 1 |
50x |
Owner Address 1 |
Text |
AD_OADDR2 |
Owner Address 2 |
50x |
Owner Address 2 |
Text |
AD_OADDR3 |
Owner Address 3 |
50x |
Owner Address 3 |
Text |
AD_OBUS |
Owner Business |
50x |
Owner Business |
Text |
AD_OEMAIL |
Owner E-mail |
150x |
Owner E-Mail |
Text |
AD_ONAME |
Owner Name |
50x |
Owner Name |
Text |
AD_OPHONE1 |
Owner Phone 1 |
25x |
Owner Phone 1 |
Text |
AD_OPHONE2 |
Owner Phone 2 |
25x |
Owner Phone 2 |
Text |
AD_OPHONE3 |
Owner Phone 3 |
25x |
Owner Phone 3 |
Text |
AD_OPHONE4 |
Owner Phone 4 |
25x |
Owner Phone 4 |
Text |
AD_OUTOFAREA |
Out of Area |
|
Out of area address. Only out of area addresses can be saved as invalid. |
Boolean |
AD_PCOL_CD |
Capture Method |
nnn |
Capture Method |
Short Integer |
AD_PCOL_TY |
Capture Method Text |
30x |
Capture Method Text |
Text |
AD_PHAS_CD |
Phase Designation |
nnnn |
Phase Designation |
Short Integer |
AD_PHAS_TY |
Phase Designation Text |
25x |
Phase Designation Text |
Text |
AD_PNAME |
Place Name |
250x |
Place Name |
Text |
AD_POSTAL |
Zip |
15x |
Zip Code |
Text |
AD_PROPTAG |
Property ID Tag |
20x |
Property ID Tag |
Text |
AD_PSAP |
PS Answering Point |
4x |
Public Service Answering Point |
Text |
AD_ROWVER |
|
mm/dd/yyyy hh:mm am |
Rowversion for optimistic locking |
Date/Time |
AD_SC_ID |
Water Service Rec # |
nnnnnnnnn |
Long Integer |
|
AD_SERVID |
Sewer Service Rec # |
nnnnnnnnn |
Long Integer |
|
AD_SN_ID |
Storm Structure Rec # |
nnnnnnnn |
Long Integer |
|
AD_STAT_CD |
Electrical Status |
nnnn |
Electrical Status |
Short Integer |
AD_STAT_TY |
Electrical Status Text |
25x |
Electrical Status Text |
Text |
AD_STATE |
State |
25x |
State |
Text |
AD_STSTID |
Street Rec # |
nnnnnnnn |
Long Integer |
|
AD_STYPE_CD |
GIS SubType |
nnnn |
GIS SubType |
Short Integer |
AD_STYPE_TY |
GIS SubType Text |
40x |
GIS SubType Text |
Text |
AD_SUBD_CD |
Subdivision |
10x |
Subdivision |
Text |
AD_SUBD_TY |
Subdivision Text |
60x |
Subdivision Text |
Text |
AD_SYMBR |
Symbol Rotation |
nnnnnnnnn.nn |
Symbol Rotation |
Double |
AD_TW_CD |
Trace Weight |
nnnn |
Trace Weight |
Short Integer |
AD_TW_TY |
Trace Weight Text |
25x |
Trace Weight Text |
Text |
AD_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
AD_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
AD_USER12 |
User 12 |
-nnnnnnnnn.nn |
User 12 |
Double |
AD_USER13 |
User 13 |
-nnnnnnnnn.nn |
User 13 |
Double |
AD_USER14 |
User 14 |
100x |
User 14 |
Text |
AD_USER15 |
User 15 |
30x |
User 15 |
Text |
AD_USER16CD |
User 16 |
nnnn |
User 16 |
Short Integer |
AD_USER16TY |
User 16 Text |
25x |
User 16 Text |
Text |
AD_USER17CD |
User 17 |
nnnn |
User17 |
Short Integer |
AD_USER17TY |
User 17 Text |
25x |
User 17 Text |
Text |
AD_USER18CD |
User 18 |
nnnn |
User 18 |
Short Integer |
AD_USER18TY |
User 18 Text |
25x |
User 18 Text |
Text |
AD_USER19CD |
User 19 |
nnnn |
User 19 |
Short Integer |
AD_USER19TY |
User 19 Text |
25x |
User 19 Text |
Text |
AD_USER1CD |
User 1 |
nnn |
User 1 |
Short Integer |
AD_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
AD_USER20CD |
User 20 |
nnnn |
User 20 |
Short Integer |
AD_USER20TY |
User 20 Text |
25x |
User 20 Text |
Text |
AD_USER21CD |
User 21 |
10x |
User 21 |
Text |
AD_USER21TY |
User 21 Text |
60x |
User 21 Text |
Text |
AD_USER22CD |
User 22 |
10x |
User 22 |
Text |
AD_USER22TY |
User 22 Text |
60x |
User 22 Text |
Text |
AD_USER23CD |
User 23 |
10x |
User 23 |
Text |
AD_USER23TY |
User 23 Text |
60x |
User 23 Text |
Text |
AD_USER24CD |
User 24 |
10x |
User 24 |
Text |
AD_USER24TY |
User 24 Text |
60x |
User 24 Text |
Text |
AD_USER25CD |
User 25 |
10x |
User 25 |
Text |
AD_USER25TY |
User 25 Text |
60x |
User 25 Text |
Text |
AD_USER26 |
User 26 |
30x |
User 26 |
Text |
AD_USER27 |
User 27 |
30x |
User 27 |
Text |
AD_USER28 |
User 28 |
30x |
User 28 |
Text |
AD_USER29 |
User 29 |
30x |
User 29 |
Text |
AD_USER2CD |
User 2 |
nnn |
User 2 |
Short Integer |
AD_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
AD_USER30 |
User 30 |
30x |
User 30 |
Text |
AD_USER31 |
User 31 |
nnnnnnnnn.nn |
User 31 |
Double |
AD_USER32 |
User 32 |
nnnnnnnnn.nn |
User 32 |
Double |
AD_USER33 |
User 33 |
nnnnnnnnn.nn |
User 33 |
Double |
AD_USER34 |
User 34 |
nnnnnnnnn.nn |
User 34 |
Double |
AD_USER35 |
User 35 |
nnnnnnnnn.nn |
User 35 |
Double |
AD_USER36 |
User 36 |
mm/dd/yyyy |
User 36 |
Date/Time |
AD_USER37 |
User 37 |
mm/dd/yyyy |
User 37 |
Date/Time |
AD_USER38 |
User 38 |
mm/dd/yyyy |
User 38 |
Date/Time |
AD_USER39 |
User 39 |
mm/dd/yyyy |
User 39 |
Date/Time |
AD_USER3CD |
User 3 |
nnn |
User 3 |
Short Integer |
AD_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
AD_USER4 |
User 4 |
nnnnnnnnn.nn |
User 4 |
Double |
AD_USER40 |
User 40 |
mm/dd/yyyy |
User 40 |
Date/Time |
AD_USER41 |
User 41 |
|
User 41 |
Boolean |
AD_USER42 |
User 42 |
|
User 42 |
Boolean |
AD_USER43 |
User 43 |
|
User 43 |
Boolean |
AD_USER44 |
User 44 |
|
User 44 |
Boolean |
AD_USER45 |
User 45 |
|
User 45 |
Boolean |
AD_USER5 |
User 5 |
30x |
User 5 Text |
Text |
AD_USER6 |
User 6 |
|
User 6 |
Boolean |
AD_USER7 |
User 7 |
|
User 7 |
Boolean |
AD_USER8 |
User 8 |
|
User 8 |
Boolean |
AD_USER9 |
User 9 |
mm/dd/yyyy |
User 9 |
Date/Time |
AD_USNG |
USNG Coordinate |
50x |
USNG Coordinate |
Text |
AD_WO_COMM |
WO Comment |
255x |
Short Work Order Comment |
Text |
AD_WTPID |
Water Pipe Rec # |
nnnnnnnn |
Long Integer |
|
AD_X |
X Coordinate |
-nnnnnnnnn.nnnnnnnn |
X Coordinate |
Double |
AD_Y |
Y Coordinate |
-nnnnnnnnn.nnnnnnnn |
Y Coordinate |
Double |
AD_Z |
Elevation |
nnnnnnnn.nn |
Elevation |
Double |
AD_ZONING |
|
nnn |
Zoning Radio button telling Residential or Commercial |
Short Integer |