Name: FireInsuranceEscrowReport_DEC3120_Flagged020921

Display Field: Assessor_Taxpayer_Name

Type: Table

Description: <div><b><u><i>Information</i></u></b></div><div><div>The City of Detroit receives Fire Insurance Escrow (FIE) funds pursuant to the <a href="https://www.michigan.gov/difs/0,5269,7-303-13648_60666_77179---,00.html" target="_blank">Fire Insurance Withholding Program, administered by The State of Michigan</a>  Under the program, the City of Detroit receives a portion of the insured's insurance payment to be held in an escrow account until the relevant structure is repaired, replaced, or demolished, at which time The FIE funds would be released by the City of Detroit to the insured. </div><div><br /></div><div>All Current property owners may be eligible to receive the balance on their property. To inquire, please contact the Buildings, Safety Engineering, and Environmental Department (BSEED).</div><div><br /></div><div><div><b><u><i>Contact</i></u></b></div><div>(313) 224-2733</div><div><br /></div><div><a href="https://detroitmi.gov/departments/buildings-safety-engineering-and-environmental-department" target="_blank">Buildings, Safety Engineering, and Environmental Department (BSEED</a>)</div><div>Coleman A. Young Municipal Center</div><div>2 Woodward Avenue, 4th Floor</div><div>Detroit, MI 48226</div></div></div>

Copyright Text: City of Detroit, BSEED, OFCO, DoIT

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

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: sqlTypeOther, length: 0, nullable: false, editable: false)
• ID (type: esriFieldTypeDouble, alias: ID, SQL Type: sqlTypeOther, nullable: true, editable: false)
• File_Number (type: esriFieldTypeString, alias: File Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• Insured_Party (type: esriFieldTypeString, alias: Insured Party, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• Parcel_ID (type: esriFieldTypeString, alias: Parcel ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• Assessor_Address (type: esriFieldTypeString, alias: Assessor Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• Loss_Address (type: esriFieldTypeString, alias: Loss Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• Date_Of_Loss (type: esriFieldTypeString, alias: Date Of Loss, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• Claim_Number (type: esriFieldTypeString, alias: Claim Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• Amount_Withheld (type: esriFieldTypeDouble, alias: Amount Withheld, SQL Type: sqlTypeOther, nullable: true, editable: false)
• Updated_Balance (type: esriFieldTypeDouble, alias: Updated Balance, SQL Type: sqlTypeOther, nullable: true, editable: false)
• Date_Check_Received (type: esriFieldTypeString, alias: Date Check Received, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• No_of_Days_Outstanding (type: esriFieldTypeDouble, alias: No of Days Outstanding, SQL Type: sqlTypeOther, nullable: true, editable: false)
• Property_Class (type: esriFieldTypeString, alias: Property Class, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• BSEED_Legal_Authority (type: esriFieldTypeString, alias: BSEED Legal Authority, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• BSEED_EMG_Letter_Date (type: esriFieldTypeString, alias: BSEED EMG Letter Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• DNG_Number (type: esriFieldTypeString, alias: DNG Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• DNG_CC_Hearing_Date (type: esriFieldTypeString, alias: DNG CC Hearing Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• DLBA_Ownership (type: esriFieldTypeString, alias: DLBA Ownership, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• DLBA_Status (type: esriFieldTypeString, alias: DLBA Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• DLBA_Program (type: esriFieldTypeString, alias: DLBA Program, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• Assessor_Taxpayer_Name (type: esriFieldTypeString, alias: Assessor Taxpayer Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Assessor_Taxpayer_Address (type: esriFieldTypeString, alias: Assessor Taxpayer Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• Assessor_Taxpayer_City (type: esriFieldTypeString, alias: Assessor Taxpayer City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• Assessor_Taxpayer_State (type: esriFieldTypeString, alias: Assessor Taxpayer State, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• Assessor_Taxpayer_Zip (type: esriFieldTypeString, alias: Assessor Taxpayer Zip, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: FireEscrowReport_DEC3120_Flagged020921
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/12/2021 9:26:10 PM

Schema Last Edit Date: 3/12/2021 9:26:10 PM

Data Last Edit Date: 3/12/2021 9:26:10 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat