Manhole Inventory
Field Name |
Caption |
Mask |
Description |
Field Type |
MA_ABVSURF |
Grade +/- (in) |
-nnn |
Grade +/- (in) |
Integer |
MA_ACTIVE |
Active |
|
Active Flag |
Boolean |
MA_ADR_B2 |
Street Post Bldg No |
8x |
Street Post Building No |
Text |
MA_ADR_BDG |
Address |
nnnnnn |
Address - Building Number |
Long Integer |
MA_ADR_DIR |
Street Direction |
2x |
Address - Street Direction |
Text |
MA_ADR_PT |
Street Prefix Type |
5x |
Street Prefix Type |
Text |
MA_ADR_SFX |
Street Suffix |
5x |
Address - Street Suffix |
Text |
MA_ADR_STR |
Street Name |
50x |
Address - Street Name |
Text |
MA_ADR_TY |
Street Type |
5x |
Address - Street Type |
Text |
MA_ATT_SIZ |
Attribute Size |
nnnn |
Attribute Size |
Integer |
MA_ATT_TYP |
Attribute Type |
n |
Attribute Type |
Integer |
MA_ATT_X |
Attri X Offset (ft) |
-nnnn.nn |
Attribute X Offset from Manhole (ft) |
Double |
MA_ATT_Y |
Attri Y Offset (ft) |
-nnnn.nn |
Attribute Y Offset from Manhole (ft) |
Double |
MA_AZONE_CD |
Alternate Zone |
10x |
Alternate Zone |
String |
MA_AZONE_TY |
Alternate Zone Text |
60x |
Alternate Zone Text |
String |
MA_BASIN |
Flow Basin |
25x |
Flow Basin |
Text |
MA_BNCH_CD |
Bench |
nnn |
Bench Code |
Integer |
MA_BNCH_TY |
Bench Text |
25x |
Bench Text |
Text |
MA_BR_CD |
Default WO Cat |
10x |
Default Category Code |
Text |
MA_BR_TY |
Default WO Cat Text |
60x |
Default Category Code |
Text |
MA_CFIT_CD |
Cover Fit |
nnn |
Cover Fit Code |
Integer |
MA_CFIT_TY |
Cover Fit Text |
25x |
Cover Fit Text |
Text |
MA_CFREQ |
Cleaning Freq |
nnn |
Cleaning Freq |
Integer |
MA_CFRQ_CD |
Cleaning Freq Units |
nnn |
Cleaning Freq Units |
Integer |
MA_CFRQ_TY |
Cleaning Freq Units Tex |
10x |
Cleaning Freq Units Tex |
Text |
MA_CITY_CD |
Facility |
nnn |
Facility Code |
Integer |
MA_CITY_TY |
Facility Text |
50x |
Facility Text |
Text |
MA_COF |
Consequence of Failure |
nnnn. |
Consequence of Failure |
Double |
MA_CONE_CD |
Cone/Top |
nnn |
Cone/Top Code |
Integer |
MA_CONE_TY |
Cone/Top Text |
25x |
Cone/Top Text |
Text |
MA_COUT_CD |
Cleanout Type |
nnn |
Cleanout Type Code |
Integer |
MA_COUT_TY |
Cleanout Type Text |
30x |
Cleanout Type Text |
Text |
MA_COVR_CD |
Cover Type |
nnn |
Cover Type Code |
Integer |
MA_COVR_TY |
Cover Type Text |
25x |
Cover Type Text |
Text |
MA_CREW |
Collected By |
30x |
Collected By |
Text |
MA_CRT_BY |
Created By |
25x |
Created By |
Text |
MA_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
MA_CSIZ_CD |
Cover Size |
nnn |
Cover Size |
Integer |
MA_CSIZ_TY |
Cover Size Text |
25x |
Cover Size Text |
Text |
MA_CUTDEPTH |
Pavement Cut Depth |
-nnnnnnnnn.nn |
Pavement Cut Depth |
Double |
MA_CV_HOLE |
# Holes in Cover |
nnn |
# Holes in Cover |
Integer |
MA_DAREA |
Drainage Area |
30x |
Drainage Area |
String |
MA_DEPTH |
Structure Depth (ft) |
nnn.nn |
Manhole Depth (ft) |
Double |
MA_DIA |
Dia/Length (in) |
nnn.n |
Dia/Length (in) |
Double |
MA_DISH_CD |
Inflow Dish |
nnn |
Inflow Dish Code |
Integer |
MA_DISH_TY |
Inflow Dish Text |
25x |
Inflow Dish Text |
Text |
MA_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
MA_FASSET |
Fixed Asset ID |
nnnnnnnn |
Fixed Asset ID |
Long Integer |
MA_FLOWD_CD |
Flow Direction |
nnn |
Flow Direction Code |
Integer |
MA_FLOWD_TY |
Flow Direction Text |
25x |
Flow Direction Text |
Text |
MA_FRM_OFF |
Frame Offset (in) |
nnn.n |
Frame Offset (in) |
Double |
MA_GPS |
GPS Flag |
|
GPS Flag |
Boolean |
MA_GPS_DT |
GPS Date |
mm/dd/yyyy |
GPS Date |
Date/Time |
MA_GRAD_CD |
Grade Adjustment |
nnn |
Grade Adjustment Code |
Integer |
MA_GRAD_TY |
Grade Adj Text |
25x |
Grade Adjustment Text |
Text |
MA_GRD_DEP |
Grade Adj Depth (in) |
nnn |
Grade Adjustment Depth (in) |
Integer |
MA_GRD_DIA |
Grd Adj Min Dia (in) |
nnn |
Grade Adjust Min Dia (in) |
Integer |
MA_HIGHELE |
High Pipe Elevation |
-nnnnnnnnn.nn |
High Pipe Elevation |
Double |
MA_IFREQ |
Inspection Freq |
nnn |
Inspection Freq |
Integer |
MA_IFRQ_CD |
Inspection Freq Units |
nnn |
Inspection Freq Units |
Integer |
MA_IFRQ_TY |
Inspection Freq Units Text |
10x |
Inspection Freq Units Text |
String |
MA_IMG_FLG |
|
|
Image Available |
Boolean |
MA_IMPR_CD |
Improve Method |
nnn |
Improvement Method |
Integer |
MA_IMPR_TY |
Improve Method Text |
40x |
Improvement Method Text |
Text |
MA_IN |
# of In Pipes |
nn |
# of In Pipes |
Integer |
MA_INDROP |
# of In Drops |
nn |
# of In Drops |
Integer |
MA_INMAP |
In Map? |
|
Flag indicating this feature is in the map |
Boolean |
MA_INSC_CD |
Last Condition |
nnn |
Inspection Condition |
Integer |
MA_INSC_TY |
Last Condition Text |
25x |
Inspection Condition Text |
Text |
MA_INSN_DT |
Next Inspection |
mm/dd/yyyy |
Next Inspection Date |
Date/Time |
MA_INSP_DT |
Last Inspection |
mm/dd/yyyy |
Last Inspection Date |
Date/Time |
MA_INST1 |
Instructions 1 |
254x |
Instructions 1 |
Text |
MA_INST2 |
Instructions 2 |
254x |
Instructions 2 |
Text |
MA_INST3 |
Instructions 3 |
254x |
Instructions 3 |
Text |
MA_INST4 |
Instructions 4 |
254x |
Instructions 4 |
Text |
MA_INST5 |
Instructions 5 |
254x |
Instructions 5 |
Text |
MA_INVELE |
Invert Elevation |
-nnnnnnnnn.nn |
Invert Elevation |
Double |
MA_IS_CD |
Illicit Status |
nnn |
Illicit Status |
Integer |
MA_IS_TY |
Illicit Status Text |
25x |
Illicit Status Text |
String |
MA_IT_CD |
Illicit Type |
nnn |
Illicit Type |
Integer |
MA_IT_TY |
Illicit Type Text |
25x |
Illicit Type Text |
String |
MA_LCLN_DT |
Last Cleaning Date |
mm/dd/yyyy |
Last Cleaning Date |
Date/Time |
MA_LINED_CD |
Lined |
nnn |
Lined Code |
Integer |
MA_LINED_TY |
Lined Text |
25x |
Lined Text |
Text |
MA_LINR_CD |
Liner |
nnn |
Liner Code |
Integer |
MA_LINR_TY |
Liner Text |
25x |
Liner Text |
Text |
MA_LOC_CD |
Location |
nnn |
Location Code |
Integer |
MA_LOC_TY |
Location Text |
25x |
Location Text |
Text |
MA_LOCATIO |
Gen Location |
200x |
General Location |
Text |
MA_LUSE_CD |
Land Use |
nnn |
Land Use |
Integer |
MA_LUSE_TY |
Land Use Text |
30x |
Land Use Text |
String |
MA_LWOT_DT |
Last WO Task Date |
mm/dd/yyyy |
Last WO Task Date |
DateTime |
MA_MAIFREQ |
MACP Inspection Freq |
nnn |
MACP Inspection Freq |
Integer |
MA_MAIFRQ_CD |
MACP Inspection Freq Units |
nnn |
MACP Inspection Freq Units |
Integer |
MA_MAIFRQ_TY |
MACP Inspection Freq Units Text |
10x |
MACP Inspection Freq Units Text |
String |
MA_MACP_DT |
MACP Date |
mm/dd/yyyy |
Last MACP Date |
Date/Time |
MA_MANG_CD |
Managed By |
nnn |
Managed By Code |
Integer |
MA_MANG_TY |
Managed By Text |
25x |
Managed By Text |
Text |
MA_MANHOLE |
Network Structure |
30x |
Manhole Number |
Text |
MA_MANX_DT |
Next MACP |
mm/dd/yyyy |
Next MACP Date |
Date/Time |
MA_MAPPAGE |
Map Page No. |
15x |
Map Page Number |
Text |
MA_MATR_CD |
Wall Material |
nnn |
Wall Material Code |
Integer |
MA_MATR_TY |
Wall Material Text |
25x |
Wall Material Text |
Text |
MA_MHID |
Structure Rec # |
nnnnnnnn |
Unique ID |
Long Integer |
MA_MITIGAT |
Mitigation |
nnnnnnnn.nn |
Mitigation |
Double |
MA_MOD_BY |
Modified By |
25x |
Modified By |
Text |
MA_MOD_DT |
Modified Date |
mm/dd/yyyy |
Modified Date |
Date/Time |
MA_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
MA_MOV_FLG |
|
|
Movie Available |
Boolean |
MA_MPST_CD |
Map Status |
nnn |
Map Status |
Integer |
MA_MPST_TY |
Map Status Text |
25x |
Map Status Text |
Text |
MA_MZONE_CD |
Maintenance Zone |
10x |
Maintenance Zone |
String |
MA_MZONE_TY |
Maintenance Zone Text |
60x |
Maintenance Zone Text |
String |
MA_NCLN_DT |
Next Cleaning Date |
mm/dd/yyyy |
Next Cleaning Date |
Date/Time |
MA_NOWORK |
No WO/PM/Req |
|
No WO/PM/Req |
Boolean |
MA_NXTS_DT |
Next Sampling Date |
mm/dd/yyyy hh:mm am |
Next Sampling Date |
DateTime |
MA_OT_CD |
Outfall Type |
nnn |
Outfall Type |
Integer |
MA_OT_TY |
Outfall Type Text |
25x |
Outfall Type Text |
String |
MA_OUT |
# of Out Pipes |
nn |
# of Out Pipes |
Integer |
MA_OUTDIA |
Outfall Diameter |
nnnnnnnn.nn |
Outfall Diameter |
Double |
MA_OUTDROP |
# of Out Drops |
nn |
# of Out Drops |
Integer |
MA_OUTFALL |
Outfall Location |
100x |
Outfall Location |
String |
MA_OUTHEI |
Outfall Height |
nnnnnnnn.nn |
Outfall Height |
Double |
MA_OUTWID |
Outfall Width |
nnnnnnnn.nn |
Outfall Width |
Double |
MA_OWN_CD |
Owner |
nnn |
Owner |
Integer |
MA_OWN_TY |
Owner Text |
25x |
Owner Text |
Text |
MA_PA_ID |
Plant Rec # |
nnnnnnnn |
Long Integer |
|
MA_PARENTOFFLINE |
Parent Off-Line Flag |
|
Parent Off-Line Flag |
Boolean |
MA_PND_CD |
Cover Ponding |
nnn |
Ponding Type Code |
Integer |
MA_PND_DEP |
Ponding Depth (in) |
nnn |
Ponding Depth (in) |
Integer |
MA_PND_TY |
Cover Ponding Text |
25x |
Ponding Type Text |
Text |
MA_POF |
Probability of Failure |
nnn.nn |
Probability of Failure |
Double |
MA_POSTAL |
Zip Code |
15x |
Zip Code |
Text |
MA_PP_ID |
Process Rec # |
nnnnnnnn |
Long Integer |
|
MA_PRE952_CD |
Pre 952 Status |
|
Pre 952 Status |
Small Integer |
MA_PRE952_TY |
Pre 952 Status Text |
25x |
Pre 952 Status Text |
String |
MA_PROM |
Structure O&&M |
nnn.n |
MACP Ratings O&M |
Double |
MA_PROPTAG |
|
52x |
Property ID Tag |
Text |
MA_PRS |
Structure Structural |
nnn.n |
MACP Ratings Structural |
Double |
MA_PRT |
Structure Total |
nnn.n |
MACPRatings Total |
Double |
MA_PVALUE |
Present Value |
nnnnnnnn.nn |
Present Value |
Double |
MA_QROM |
Quick O&&M |
30x |
MACP Quick Rating O&M |
Text |
MA_QRS |
Quick Structural |
30x |
MACP Quick Rating Structural |
Text |
MA_QRT |
Quick Total |
30x |
MACP Quick Rating Total |
Text |
MA_RCOST |
Replacement Cost |
nnnnn.nn |
Replacement Cost |
Double |
MA_REAS_CD |
Sampling Reason |
nnn |
Sampling Reason |
Integer |
MA_REAS_TY |
Sampling Reason Text |
25x |
Sampling Reason Text |
String |
MA_REG_CD |
Sampling Regulation Type |
nnn |
Sampling Regulation Type |
Integer |
MA_REG_TY |
Sampling Regulation Type Text |
25x |
Sampling Regulation Type Text |
String |
MA_REPL_DT |
Replacement Date |
mm/dd/yyyy |
Replacement Date |
Date/Time |
MA_RIM_CD |
Rim Status |
nnn |
Rim Status Code |
Integer |
MA_RIM_ELE |
Rim Elevation |
nnnn.nn |
Rim Elevation |
Double |
MA_RIM_TY |
Rim Status Text |
25x |
Rim Status Text |
Text |
MA_RISK |
Risk |
nnnn. |
Risk - COF * POF |
Double |
MA_RISR_HT |
Riser Height (in) |
nn.nn |
Riser Height (in) |
Double |
MA_RLIFE |
Remaining Life |
nnnn.nn |
Remaining Life |
Double |
MA_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
MA_RVALUE |
Replacement Value |
nnnnnnnnn.nn |
Replacement Value |
Double |
MA_SEAL_CD |
Pipe Seal |
nnn |
Pipe Seal Code |
Integer |
MA_SEAL_TY |
Pipe Seal Text |
25x |
Pipe Seal Text |
Text |
MA_SHAP_CD |
Cone/Top Shape |
nnn |
Cone/Top Shape Code |
Integer |
MA_SHAP_TY |
Cone/Top Shape Text |
25x |
Cone/Top Shape Text |
Text |
MA_SIFREQ |
Sampling Inspection Freq |
nnn |
Sampling Inspection Freq |
Integer |
MA_SIFRQ_CD |
Sampling Inspection Freq Units |
nnn |
Sampling Inspection Freq Units |
Integer |
MA_SIFRQ_TY |
Sampling Inspection Freq Units Text |
10x |
Sampling Inspection Freq Units Text |
String |
MA_SLST_DT |
Last Sampling Date |
mm/dd/yyyy hh:mm am |
Last Sampling Date |
DateTime |
MA_ST_C_CD |
Steps Condition |
nnn |
Steps Condition Code |
Integer |
MA_ST_C_TY |
Step Condition Text |
25x |
Steps Condition Text |
Text |
MA_STAT_CD |
Status |
nnn |
Status Code |
Integer |
MA_STAT_TY |
Status Text |
25x |
Status Text |
Text |
MA_STEP_CD |
Steps |
nnn |
Steps Type Code |
Integer |
MA_STEP_TY |
Steps Text |
25x |
Steps Type Text |
Text |
MA_STRC_CD |
Component Type |
nnn |
Structure Type Code |
Integer |
MA_STRC_TY |
Component Type Text |
25x |
Structure Type Text |
Text |
MA_STRM_CD |
Receiving Stream |
6x |
Receiving Stream |
String |
MA_STRM_TY |
Receiving Stream Text |
50x |
Receiving Stream Text |
String |
MA_STYPE_CD |
Subtype |
nnn |
GIS Subtype Code |
Integer |
MA_STYPE_TY |
Subtype Text |
25x |
GIS Subtype Text |
Text |
MA_SUMFLOW |
Flow Summary |
-nnnnnnnnn.nn |
Flow Summary |
Double |
MA_SURCHG |
Surcharge Evid (ft) |
nn.n |
Surcharge Evidence (ft) |
Double |
MA_SURF_CD |
Surface Type |
nnn |
Surface Type Code |
Integer |
MA_SURF_TY |
Surface Type Text |
25x |
Surface Type Text |
Text |
MA_TAKEOFFLINE |
Take Off-Line Flag |
|
Take Off-Line Flag |
Boolean |
MA_TRACKNO |
Sampling Tracking No |
30x |
Sampling Tracking No |
String |
MA_TRGH_CD |
Trough |
nnn |
Trough Type Code |
Integer |
MA_TRGH_TY |
Trough Text |
25x |
Trough Type Text |
Text |
MA_TYPE_CD |
Structure Type |
nnn |
Manhole Type Code |
Integer |
MA_TYPE_TY |
Structure Type Text |
25x |
Manhole Type Text |
Text |
MA_US_LOC |
Lot Location |
2x |
Lot Location |
Text |
MA_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
MA_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
MA_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
MA_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
MA_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
MA_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
MA_USER4 |
User 4 |
nnnnnnnnn.nn |
User 4 |
Double |
MA_USER5 |
User 5 |
30x |
User 5 |
Text |
MA_USER6 |
User 6 |
|
User 6 |
Boolean |
MA_USER7 |
User 7 |
|
User 7 |
Boolean |
MA_USER8 |
User 8 |
|
User 8 |
Boolean |
MA_USER9 |
User 9 |
mm/dd/yyyy |
User 9 |
Date/Time |
MA_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
MA_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
MA_USER12 |
User 12 |
-nnnnnnnnn.nn |
User 12 |
Double |
MA_USER13 |
User 13 |
-nnnnnnnnn.nn |
User 13 |
Double |
MA_USER14 |
User 14 |
30x |
User 14 |
Text |
MA_USER15 |
User 15 |
30x |
User 15 |
Text |
MA_USER16 |
User 16 |
nnnnnnnn |
User 16 |
Long Integer |
MA_USER17CD |
User 17 |
nnn |
User 17 |
Integer |
MA_USER17TY |
User 17 Text |
25x |
User 17 Text |
Text |
MA_USER18CD |
User 18 |
nnn |
User 18 |
Integer |
MA_USER18TY |
User 18 Text |
25x |
User 18 Text |
Text |
MA_USER19 |
User 19 |
30x |
User 19 |
Text |
MA_USER20 |
User 20 |
30x |
User 20 |
Text |
MA_USER21 |
User 21 |
-nnnnnnnnn.nn |
User 21 |
Double |
MA_USER22 |
User 22 |
mm/dd/yyyy |
User 22 |
Date/Time |
MA_USER23 |
User 23 |
mm/dd/yyyy |
User 23 |
Date/Time |
MA_USER24 |
User 24 |
|
User 24 |
Boolean |
MA_USER25 |
User 25 |
|
User 25 |
Boolean |
MA_USER26 |
User 26 |
60x |
User 26 |
Text |
MA_USER27 |
User 27 |
60x |
User 27 |
Text |
MA_USER28CD |
User 28 |
nnn |
User 28 |
Integer |
MA_USER28TY |
User 28 Text |
50x |
User 28 Text |
String |
MA_USER29CD |
User 29 |
nnn |
User 29 |
Integer |
MA_USER29TY |
User 29 Text |
50x |
User 29 Text |
String |
MA_USER30CD |
User 30 |
nnn |
User 30 |
Integer |
MA_USER30TY |
User 30 Text |
50x |
User 30 Text |
String |
MA_USER31 |
User 31 |
50x |
User 31 |
String |
MA_USER32 |
User 32 |
50x |
User 32 |
String |
MA_USER33 |
User 33 |
50x |
User 33 |
String |
MA_USER34 |
User 34 |
50x |
User 34 |
String |
MA_USER35 |
User 35 |
50x |
User 35 |
String |
MA_USER36 |
User 36 |
nnnnnnnn.nn |
User 36 |
Double |
MA_USER37 |
User 37 |
nnnnnnnn.nn |
User 37 |
Double |
MA_USER38 |
User 38 |
nnnnnnnn.nn |
User 38 |
Double |
MA_USER39 |
User 39 |
nnnnnnnn.nn |
User 39 |
Double |
MA_USER40 |
User 40 |
nnnnnnnn.nn |
User 40 |
Double |
MA_USER41 |
User 41 |
mm/dd/yyyy hh:mm am |
User 41 |
DateTime |
MA_USER42 |
User 42 |
mm/dd/yyyy hh:mm am |
User 42 |
DateTime |
MA_USER43 |
User 43 |
mm/dd/yyyy hh:mm am |
User 43 |
DateTime |
MA_USER44 |
User 44 |
mm/dd/yyyy hh:mm am |
User 44 |
DateTime |
MA_USER45 |
User 45 |
mm/dd/yyyy hh:mm am |
User 45 |
DateTime |
MA_USER46 |
User 46 |
|
User 46 |
Boolean |
MA_USER47 |
User 47 |
|
User 47 |
Boolean |
MA_USER48 |
User 48 |
|
User 48 |
Boolean |
MA_USER49 |
User 49 |
|
User 49 |
Boolean |
MA_USER50 |
User 50 |
|
User 50 |
Boolean |
MA_USER51CD |
User 51 |
nnn |
User 51 |
Integer |
MA_USER51TY |
User 51 Text |
50x |
User 51 Text |
String |
MA_USER52CD |
User 52 |
nnn |
User 52 |
Integer |
MA_USER52TY |
User 52 Text |
50x |
User 52 Text |
String |
MA_USER53CD |
User 53 |
10x |
User 53 |
String |
MA_USER53TY |
User 53 Text |
60x |
User 53 Text |
String |
MA_USER54CD |
User 54 |
10x |
User 54 |
String |
MA_USER54TY |
User 54 Text |
60x |
User 54 Text |
String |
MA_USER55CD |
User 55 |
10x |
User 55 |
String |
MA_USER55TY |
User 55 Text |
60x |
User 55 Text |
String |
MA_USER56CD |
User 56 |
10x |
User 56 |
String |
MA_USER56TY |
User 56 Text |
60x |
User 56 Text |
String |
MA_USER57CD |
User 57 |
10x |
User 57 |
String |
MA_USER57TY |
User 57 Text |
60x |
User 57 Text |
String |
MA_WIDTH |
Width (in) |
nnn.n |
Width (in) |
Double |
MA_WIDTH |
Width (in) |
nnn.n |
Width (in) |
Double |
MA_WO_COMM |
Short Comment |
255x |
This short comment gets copied to work orders |
Text |
MA_X |
X Coordinate |
-nnnnnnnnn.nnnnnnnn |
X Coordinate |
Double |
MA_Y |
Y Coordinate |
-nnnnnnnnn.nnnnnnnn |
Y Coordinate |
Double |