Name: Replacement

Display Field:

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)
• InventoryID (type: esriFieldTypeString, alias: Inventory ID (link), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• lcrr_AppFlagReplaceRecordType (type: esriFieldTypeString, alias: App Flag – Replacement Record Type [LCRR], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Replacement Interest: Replacement Interest], [Replacement ROE Form: Replacement ROE Form], [Replacement Refusal Form: Replacement Refusal Form], ... 2 more ...)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• roe_StartTime (type: esriFieldTypeDate, alias: Start Time [ROE], SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• roe_EndTime (type: esriFieldTypeDate, alias: End Time [ROE], SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• roe_LocAddressType (type: esriFieldTypeString, alias: Location – Address Type [ROE], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [lookup: Select from our list of service addresses (preferred method)], [geocode: Search for any Norfolk address (alternative method)], [manual: Enter your full address (alternative method)])
• roe_LocStreetNameLookup (type: esriFieldTypeString, alias: Location – Street Name Lookup [ROE], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• roe_LocBuildingNumberLookup (type: esriFieldTypeString, alias: Location – Building Number Lookup [ROE], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• roe_LocUnitNumberLookup (type: esriFieldTypeString, alias: Location – Unit Number Lookup [ROE], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• roe_LocGeocodedAddress (type: esriFieldTypeString, alias: Location – Geocoded Address [ROE], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• roe_LocManualAddress (type: esriFieldTypeString, alias: Location – Manual Address [ROE], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• roe_LocXY (type: esriFieldTypeString, alias: Location – XY [ROE], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• roe_InventoryIDLookup (type: esriFieldTypeString, alias: Inventory ID Lookup [ROE], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• roe_PropertyAddressLookup (type: esriFieldTypeString, alias: Property Address Lookup [ROE], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• roe_PropertyOwnerLookup (type: esriFieldTypeString, alias: Property Owner Lookup [ROE], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• roe_SignerAlternateOwner (type: esriFieldTypeString, alias: Signer – Name [ROE], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• roe_SignerCompanyName (type: esriFieldTypeString, alias: Signer – Company Name [ROE], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• roe_SignerAuthorizedSigner (type: esriFieldTypeString, alias: Signer – Authorized Signer [ROE], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• roe_SignerAuthorizedSignerTitle (type: esriFieldTypeString, alias: Signer – Authorized Signer Title [ROE], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• roe_SignerPropertyAddress (type: esriFieldTypeString, alias: Signer – Property Address [ROE], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• roe_SignerMailingAddress (type: esriFieldTypeString, alias: Signer – Mailing Address [ROE], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• roe_SignerPhoneNumberHome (type: esriFieldTypeString, alias: Signer – Phone Number - Home [ROE], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• roe_SignerPhoneNumberCell (type: esriFieldTypeString, alias: Signer – Phone Number - Cell [ROE], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• roe_SignerPhoneNumberWork (type: esriFieldTypeString, alias: Signer – Phone Number - Work [ROE], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• roe_SignerEmailAddress (type: esriFieldTypeString, alias: Signer – Email Address [ROE], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• roe_SignerLSLRRefuseReason (type: esriFieldTypeString, alias: Signer – LSLR Refusal Reason [ROE], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Not Concerned: I am not concerned about lead or certain galvanized steel in drinking water.], [Own Contractor: I want to hire my own contractor.], [Other: Other])
• roe_SignerLSLRRefuseReasonOther (type: esriFieldTypeString, alias: Signer – LSLR Refusal Reason Other [ROE], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• roe_TrackingStatus (type: esriFieldTypeString, alias: Tracking – Status [ROE], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Pending: Pending], [Queued: Queued], [Reported: Reported], ... 3 more ...)
• roe_TrackingDate (type: esriFieldTypeDate, alias: Tracking – Date [ROE], SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• roe_TrackingNote (type: esriFieldTypeString, alias: Tracking – Note [ROE], SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• roe_FormVersion (type: esriFieldTypeString, alias: Form Version [ROE], SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [ROE Form, English: ROE Form, English], [ROE Form, Spanish: ROE Form, Spanish], [ROE Form, Mandarin: ROE Form, Mandarin], ... 3 more ...)
• roe_FormVersionNumber (type: esriFieldTypeString, alias: Form Version Number [ROE], SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• roe_InfoCorrect (type: esriFieldTypeString, alias: Signer – Form Info Correct [ROE], SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• roe_SignerComment (type: esriFieldTypeString, alias: Signer – Form Info Comments [ROE], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• roe_ContactAtt_Number (type: esriFieldTypeString, alias: Contact Attempt Number [ROE], SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• roe_ContactAtt_Date (type: esriFieldTypeDate, alias: Contact Attempt Date [ROE], SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• roe_ContactAtt_Method (type: esriFieldTypeString, alias: Contact Attempt Method [ROE], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Property visit, no contact made, left doorhanger/docs: Property visit, no contact made, left doorhanger/docs], [Property visit, customer contact made, left docs: Property visit, customer contact made, left docs], [Property visit, customer contact made, refused documents: Property visit, customer contact made, refused documents], ... 7 more ...)
• roe_ContactAtt_PropOwner (type: esriFieldTypeString, alias: Contact Attempt Property Owner [ROE], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• roe_ContactAtt_Username (type: esriFieldTypeString, alias: Person Attempting Contact [ROE], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• roe_ContactAtt_Notes (type: esriFieldTypeString, alias: Contact Attempt Notes [ROE], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• roe_SignerDate (type: esriFieldTypeDate, alias: Signer – Date [ROE], SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/24/2026 12:32:58 AM

Schema Last Edit Date: 9/18/2026 3:59:55 PM

Data Last Edit Date: 9/24/2026 12:32:58 AM

Supported Operations:   Add Features   Apply Edits   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat