All Layers and Tables (coa_wHydrantMeter_View

Layers:

Layer: coa_wHydrantMeter (0)

Name:

Display Field:

Type:

Geometry Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"renderer":{"type":"simple","label":"","description":"","symbol":{"color":[0,168,73,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[0,0,0,255],"width":1,"type":"esriSLS","style":"esriSLSSolid"}}},"transparency":0}

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
HYD_FUID (type: esriFieldTypeString, alias: Hydrant FUID N/A, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
OLD_HydMeterAddress (type: esriFieldTypeString, alias: OLD Hydrant Meter Address - N/A, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
HydMeterLocationDescription (type: esriFieldTypeString, alias: Hydrant Meter Location Description, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
Contractor (type: esriFieldTypeString, alias: Contractor, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
ContactPerson (type: esriFieldTypeString, alias: Contact Person, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
ContactBusinessPhone (type: esriFieldTypeString, alias: Contact Business Phone, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
ContactCellPhone (type: esriFieldTypeString, alias: Contact Cell Phone, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
DateSet (type: esriFieldTypeDate, alias: Date Set - N/A, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
AnticipatedDateRemoved (type: esriFieldTypeDate, alias: Anticipated Date Removed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
DateRemoved (type: esriFieldTypeDate, alias: Date Removed - N/A, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Action (type: esriFieldTypeString, alias: Meter Action Needed - N/A, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Install: Hydrant Meter Install], [Remove: Hydrant Meter Remove], [Complete: Complete])
VolUsed_Jun30_CF (type: esriFieldTypeInteger, alias: Vol Used Jun 30 (CF) - N/A, SQL Type: sqlTypeOther, nullable: true, editable: true)
TotalVolUsed_CF (type: esriFieldTypeInteger, alias: Total Vol Used (CF) - N/A, SQL Type: sqlTypeOther, nullable: true, editable: true)
PostDate (type: esriFieldTypeDate, alias: Posting Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
A_Date (type: esriFieldTypeDate, alias: Application Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
A_BillingStreet (type: esriFieldTypeString, alias: Billing Street, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
A_BillingCity (type: esriFieldTypeString, alias: Billing City, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
A_BillingState (type: esriFieldTypeString, alias: Billing State, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
A_BillingZip (type: esriFieldTypeString, alias: Billing Zip, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
A_Comments (type: esriFieldTypeString, alias: Application Comments, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
A_ReqInstallDate (type: esriFieldTypeDate, alias: Date Requested to Install meter, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
A_ReqRemoveDate (type: esriFieldTypeDate, alias: Date Requested to Remove Meter, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
A_ReqMeterSize (type: esriFieldTypeInteger, alias: Requested Meter Size, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1"], [2: 2"])
A_BFDeviceSerNo (type: esriFieldTypeString, alias: Back Flow Device Serial Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
A_HydMtrNo (type: esriFieldTypeString, alias: Hydrant Mtr Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
A_InstalledBy (type: esriFieldTypeString, alias: Installed By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [John Sanderson: John Sanderson], [Josh DeVos: Josh DeVos], [Other: Other], ... 1 more ...)
A_RemBy (type: esriFieldTypeString, alias: Removed By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [John Sanderson: John Sanderson], [Josh DeVos: Josh DeVos], [Other: Other], ... 1 more ...)
A_InstallRemovalFee (type: esriFieldTypeInteger, alias: Install/Removal Fee, SQL Type: sqlTypeOther, nullable: true, editable: true)
A_CapacityChg (type: esriFieldTypeInteger, alias: Service Charge - N/A, SQL Type: sqlTypeOther, nullable: true, editable: true)
A_RepOthChg (type: esriFieldTypeInteger, alias: Rep/Oth Charge, SQL Type: sqlTypeOther, nullable: true, editable: true)
A_WaterChg (type: esriFieldTypeInteger, alias: Water Charge - N/A, SQL Type: sqlTypeOther, nullable: true, editable: true)
A_SentToFinance_Text (type: esriFieldTypeString, alias: Sent To Finance, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
MeterSize (type: esriFieldTypeInteger, alias: Meter Size, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2])
InRead_PreJul1_ (type: esriFieldTypeInteger, alias: In Read Pre Jul 1, SQL Type: sqlTypeOther, nullable: true, editable: true)
Read_June30_ (type: esriFieldTypeInteger, alias: Read June 30, SQL Type: sqlTypeOther, nullable: true, editable: true)
InRead_PostJul1_ (type: esriFieldTypeInteger, alias: In Read Post Jul 1, SQL Type: sqlTypeOther, nullable: true, editable: true)
OutRead_ (type: esriFieldTypeInteger, alias: Out Read, SQL Type: sqlTypeOther, nullable: true, editable: true)
TotalBilled_ (type: esriFieldTypeDouble, alias: Total Billed - N/A, SQL Type: sqlTypeOther, nullable: true, editable: true)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
H_HouseNum (type: esriFieldTypeInteger, alias: Hydrant Location House Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
H_StreetName (type: esriFieldTypeString, alias: Hydrant Location Street Name, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true, Coded Values: [10TH ST: 10TH ST], [11TH ST: 11TH ST], [12TH ST: 12TH ST], ... 738 more ...)
DB_WaChg100CF (type: esriFieldTypeInteger, alias: Water Chg 100 CF - N/A, SQL Type: sqlTypeOther, nullable: true, editable: true)
DB_BillDate (type: esriFieldTypeDate, alias: Bill Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
A_InstallHrs (type: esriFieldTypeDouble, alias: Install Hrs, SQL Type: sqlTypeOther, nullable: true, editable: true)
A_RemHrs (type: esriFieldTypeDouble, alias: Rem Hrs, SQL Type: sqlTypeOther, nullable: true, editable: true)
Project (type: esriFieldTypeString, alias: Water Use & Purpose, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DB_MeterNoOut (type: esriFieldTypeString, alias: Meter Num Out, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
DB_LID (type: esriFieldTypeString, alias: DB_LID, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
DB_SODescription (type: esriFieldTypeString, alias: Svc Order Description, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true, Coded Values: [Set 1 Hydrant Meter: Set 1" Hydrant Meter], [Set 2 Hydrant Meter: Set 2" Hydrant Meter], [Remove 1 Hydrant Meter: Remove 1" Hydrant Meter], ... 7 more ...)
Comments (type: esriFieldTypeString, alias: Meter Dept Comments, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
A_IAgree (type: esriFieldTypeString, alias: I hereby agree and understand that I am responsible for payment for all charges and any damages caused to the water meter, the backflow prevention assembly, the fire hydrant or any other City of Ames property or facilities., SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [I Agree and Understand: I Agree and Understand], [I Disagree: I Disagree])
A_IHaveRead (type: esriFieldTypeString, alias: I have read and understand the City of Ames Hydrant Meter Policy., SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [I Agree and Understand: I Agree and Understand], [I Disagree: I Disagree])
A_IAgreePresence (type: esriFieldTypeString, alias: *A REPRESENTATIVE OF YOUR COMPANY MUST BE PRESENT AT TIME OF INSTALLATION*, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [I Agree and Understand: I Agree and Understand], [I Disagree: I Disagree])
AppInf (type: esriFieldTypeString, alias: Applicant Information, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
SOInf (type: esriFieldTypeString, alias: Service Order Information, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
BillingInf (type: esriFieldTypeString, alias: Billing Information, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
AuthorizedBy (type: esriFieldTypeString, alias: Authorized By, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true)
Nov1_read (type: esriFieldTypeInteger, alias: Nov 1 Read, SQL Type: sqlTypeOther, nullable: true, editable: true)
A_InstalledBy_2 (type: esriFieldTypeString, alias: Installed By 2, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [John Sanderson: John Sanderson], [Josh DeVos: Josh DeVos], [Other: Other], ... 1 more ...)
A_RemBy2 (type: esriFieldTypeString, alias: Removed By 2, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [John Sanderson: John Sanderson], [Josh DeVos: Josh DeVos], [Other: Other], ... 1 more ...)
DateTime_Removed (type: esriFieldTypeDate, alias: Date and Time Removed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
DateTime_Installed (type: esriFieldTypeDate, alias: Date and Time Installed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Status (type: esriFieldTypeString, alias: Meter Status, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [In Field: In Field], [In Shop: In Shop])
DB_MeterFees (type: esriFieldTypeString, alias: Meter Move Fees - N/A, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
A_MovedBy_1 (type: esriFieldTypeString, alias: Moved By 1, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [John Sanderson: John Sanderson], [Josh DeVos: Josh DeVos], [Other: Other], ... 1 more ...)
A_MoveHrs (type: esriFieldTypeDouble, alias: Move Hrs, SQL Type: sqlTypeOther, nullable: true, editable: true)
DateTime_Moved (type: esriFieldTypeDate, alias: Date and Time Moved, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Move_Read (type: esriFieldTypeInteger, alias: Move Read, SQL Type: sqlTypeOther, nullable: true, editable: true)
Move_OriginalLocation (type: esriFieldTypeString, alias: Move Original Location, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
A_Movedby_2 (type: esriFieldTypeString, alias: Moved By 2, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [John Sanderson: John Sanderson], [Josh Devoss: Josh DeVoss], [Other: Other], ... 1 more ...)
ContactEmail (type: esriFieldTypeString, alias: ContactEmail, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)

Templates:

A_InstallRemovalFee: 260

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

All Layers and Tables (coa_wHydrantMeter_View_HydrantMeterApplication)

Layers:

Layer: coa_wHydrantMeter (0)