Distribution Automated Meter Reading
Field Name |
Caption |
Mask |
Description |
Field Type |
AR_AMDL_NO |
Model Number |
25x |
AMR Model Number |
Text |
AR_AMFG_CD |
Manufacturer |
nnn |
AMR Manufacturer:code |
Integer |
AR_AMFG_TY |
Manufacturer Text |
25x |
AMR Manufacturer Txt |
Text |
AR_AMR_N2 |
AMR No 2 |
25x |
AMR No 2 |
Text |
AR_AMR_N3 |
AMR No 3 |
25x |
AMR No 3 |
Text |
AR_AMR_SN |
Serial Number |
25x |
AMR Serial Number |
Text |
AR_AUTO_CD |
Autoreader |
nnn |
Autoreader: code |
Integer |
AR_AUTO_TY |
Autoreader Text |
25x |
Autoreader Text |
Text |
AR_AZONE_CD |
Alternate Zone |
10x |
Alternate Zone |
String |
AR_AZONE_TY |
Alternate Zone Text |
60x |
Alternate Zone Text |
String |
AR_BAT_CD |
Battery Type |
nnn |
Battery Type Code |
Integer |
AR_BAT_TY |
Battery Type Text |
25x |
Battery Type Text |
Text |
AR_BATTERY |
Battery ID |
50x |
Battery |
Text |
AR_BINS_DT |
Battery Install Date |
mm/dd/yyyy |
Battery Install Date |
Date/Time |
AR_BR_CD |
Default WO Cat |
10x |
Default Category Code |
Text |
AR_BR_TY |
Default WO Cat Text |
60x |
Default Category Text |
Text |
AR_BREP_DT |
Battery Replace Date |
mm/dd/yyyy |
Battery Replacement Date |
Date/Time |
AR_COF |
Consequence of Failure |
nnnn.nn |
Consequence of Failure |
Double |
AR_COND_CD |
Condition |
nnn |
Meter Condition |
Integer |
AR_COND_TY |
Condition Text |
25x |
Meter Cond Text |
Text |
AR_CRT_BY |
Created By |
25x |
Created By |
Text |
AR_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
AR_DOC_FLG |
Document Available |
|
Doc Available: Doc Flag |
Boolean |
AR_ELEV |
Elevation |
-nnnnn.nn |
Elevation |
Double |
AR_ELEV1 |
Alt Elevation |
-nnnnn.nn |
Alternate Elev |
Double |
AR_FASSET |
Fixed Asset ID |
nnnnnnnn |
Fixed Asset ID |
Long Integer |
AR_GPS_DT |
GPS Date |
mm/dd/yyyy |
GPS Date |
Date/Time |
AR_GPS_FLG |
GPS Located |
|
GPS Located |
Boolean |
AR_ID |
AMR Rec # |
nnnnnnnn |
|
Long Integer |
AR_IFREQ |
Inspection Freq |
nnn |
Inspection Freq |
Integer |
AR_IFRQ_CD |
Inspection Freq Units |
nnn |
Inspection Freq Units |
Integer |
AR_IFRQ_TY |
Inspection Freq Units Text |
10x |
Inspection Freq Units Text |
String |
AR_INMAP |
In Map Flag |
|
In Map Flag |
Boolean |
AR_INSP_DT |
Inspection Date |
mm/dd/yyyy |
Inspection Date |
Date/Time |
AR_INST_CD |
Install Type |
nnn |
Install Type |
Integer |
AR_INST_DT |
Date Installed |
mm/dd/yyyy |
Date Installed |
Date/Time |
AR_INST_TY |
Install Type Text |
25x |
Install Type Text |
Text |
AR_LOCATE |
General Location |
100x |
General Location |
Text |
AR_MD_ID |
Meter Device Rec # |
nnnnnnnn |
Long Integer |
|
AR_MITIGAT |
Mitigation |
nnnnnnnn.nn |
Mitigation |
Double |
AR_MOD_BY |
Last Modified By |
25x |
Modified By |
Text |
AR_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Date Modified |
Date/Time |
AR_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
AR_MT_ID |
Meter Loc Rec # |
nnnnnnnn |
Long Integer |
|
AR_MZONE_CD |
Maintenance Zone |
10x |
Maintenance Zone |
String |
AR_MZONE_TY |
Maintenance Zone Text |
60x |
Maintenance Zone Text |
String |
AR_NMNT_DT |
Next Insp Date |
mm/dd/yyyy |
Next Inspection Date |
Date/Time |
AR_NOWORK |
No WO/PM/Req |
|
No WO/PM/Req |
Boolean |
AR_NUMBER |
AMR Number |
30x |
AMR Number |
Text |
AR_POF |
Probability of Failure |
nnn.nn |
Probability of Failure |
Double |
AR_PVALUE |
Present Value |
nnnnnnnnn.nn |
Present Value |
Double |
AR_RCOST |
Replacement Cost |
nnnnn.nn |
Replacement Cost |
Double |
AR_REPL_DT |
Replacement Date |
mm/dd/yyyy |
Replacement Date |
Date/Time |
AR_RISK |
Risk |
nnnn.nn |
Risk = COF * POF |
Double |
AR_RLIFE |
Remaining Life |
nnnn.nn |
Remaining Life |
Double |
AR_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
AR_RTYP_CD |
Reading Type |
nnn |
Reading Type - Designates what type of reading it is taking from the attached meter device |
Integer |
AR_RTYP_TY |
Reading Type Text |
25x |
Reading Type Text |
Text |
AR_RVALUE |
Replacement Value |
nnnnnnnnn.nn |
Replacement Value |
Double |
AR_SRC_CD |
GPS Source |
nnn |
GPS Source: code |
Integer |
AR_SRC_TY |
GPS Source Text |
25x |
GPS Source Text |
Text |
AR_STAT_CD |
Operating Status |
nnn |
Operating Status |
Integer |
AR_STAT_TY |
Operating Status Text |
25x |
Operating Status Text |
Text |
AR_TYPE_CD |
Type |
nnn |
Type: code |
Integer |
AR_TYPE_TY |
Type Text |
25x |
Type Text |
Text |
AR_USER1CD |
User 1 |
nnn |
User 1: code |
Integer |
AR_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
AR_USER2CD |
User 2 |
nnn |
User 2: code |
Integer |
AR_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
AR_USER3CD |
User 3 |
nnn |
User 3: code |
Integer |
AR_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
AR_USER4 |
User 4 |
30x |
User 4 - alphanumeric |
Text |
AR_USER5 |
User 5 |
30x |
User 5 - alphanumeric |
Text |
AR_USER6 |
User 6 |
30x |
User 6 - alphanumeric |
Text |
AR_USER7 |
User 7 |
-nnnnnnnnn.nn |
User 7 - numeric |
Double |
AR_USER8 |
User 8 |
-nnnnnnnnn.nn |
User 8 - numeric |
Double |
AR_USER9 |
User 9 |
-nnnnnnnnn.nn |
User 9 - numeric |
Double |
AR_USER10 |
User 10 |
mm/dd/yyyy |
User 10 - date |
Date/Time |
AR_USER11 |
User 11 |
mm/dd/yyyy |
User 11 - date |
Date/Time |
AR_USER12 |
User 12 |
mm/dd/yyyy |
User 12 - date |
Date/Time |
AR_USER13 |
User 13 |
|
User 13 - logical |
Boolean |
AR_USER14 |
User 14 |
|
User 14 - logical |
Boolean |
AR_USER15 |
User 15 |
|
User 15 - logical |
Boolean |
AR_USER16CD |
User 16 |
nnn |
User 16 |
Integer |
AR_USER16TY |
User 16 Text |
50x |
User 16 Text |
String |
AR_USER17CD |
User 17 |
nnn |
User 17 |
Integer |
AR_USER17TY |
User 17 Text |
50x |
User 17 Text |
String |
AR_USER18CD |
User 18 |
nnn |
User 18 |
Integer |
AR_USER18TY |
User 18 Text |
50x |
User 18 Text |
String |
AR_USER19CD |
User 19 |
nnn |
User 19 |
Integer |
AR_USER19TY |
User 19 Text |
50x |
User 19 Text |
String |
AR_USER20CD |
User 20 |
nnn |
User 20 |
Integer |
AR_USER20TY |
User 20 Text |
50x |
User 20 Text |
String |
AR_USER21 |
User 21 |
50x |
User 21 |
String |
AR_USER22 |
User 22 |
50x |
User 22 |
String |
AR_USER23 |
User 23 |
50x |
User 23 |
String |
AR_USER24 |
User 24 |
50x |
User 24 |
String |
AR_USER25 |
User 25 |
50x |
User 25 |
String |
AR_USER26 |
User 26 |
nnnnnnnn.nn |
User 26 |
Double |
AR_USER27 |
User 27 |
nnnnnnnn.nn |
User 27 |
Double |
AR_USER28 |
User 28 |
nnnnnnnn.nn |
User 28 |
Double |
AR_USER29 |
User 29 |
nnnnnnnn.nn |
User 29 |
Double |
AR_USER30 |
User 30 |
nnnnnnnn.nn |
User 30 |
Double |
AR_USER31 |
User 31 |
mm/dd/yyyy hh:mm am |
User 31 |
DateTime |
AR_USER32 |
User 32 |
mm/dd/yyyy hh:mm am |
User 32 |
DateTime |
AR_USER33 |
User 33 |
mm/dd/yyyy hh:mm am |
User 33 |
DateTime |
AR_USER34 |
User 34 |
mm/dd/yyyy hh:mm am |
User 34 |
DateTime |
AR_USER35 |
User 35 |
mm/dd/yyyy hh:mm am |
User 35 |
DateTime |
AR_USER36 |
User 36 |
|
User 36 |
Boolean |
AR_USER37 |
User 37 |
|
User 37 |
Boolean |
AR_USER38 |
User 38 |
|
User 38 |
Boolean |
AR_USER39 |
User 39 |
|
User 39 |
Boolean |
AR_USER40 |
User 40 |
|
User 40 |
Boolean |
AR_WO_COMM |
WO Comment |
255x |
This short comment gets copied to work orders |
Text |
AR_X1 |
X Coordinate |
-nnnnnnnnn.nnnnnnnn |
X Coordinate: |
Double |
AR_Y1 |
Y Coordinate |
-nnnnnnnnn.nnnnnnnn |
Y Coordinate: |
Double |