Name: Financial Assistance Review

Display Field: ApplicationNumber

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 029c6afe997645b7b3193b6e4d8916e7

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• ApplicationNumber ( type: esriFieldTypeString, alias: ApplicationNumber, length: 255 )
• ReviewStatus ( type: esriFieldTypeString, alias: ReviewStatus, length: 255 , Coded Values: [Approved: Approved] , [Denied: Denied] , [Incomplete: Incomplete] )
• NoticeNonCompliance ( type: esriFieldTypeString, alias: Received Notice of Non-Compliance, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• RecentMortgagePayment ( type: esriFieldTypeString, alias: Recent Mortgage Payment Received, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• CurrentPropertyTaxStatement ( type: esriFieldTypeString, alias: Current Year Property Tax Statement Provided, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• SepticDesign ( type: esriFieldTypeString, alias: Valid Septic Design, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• TwoBids ( type: esriFieldTypeString, alias: Two Bids from Licensed Contractors, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• NoViolations ( type: esriFieldTypeString, alias: Are Violations Present on the Property, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 1073741822 )
• ApplicationFilledOutCorrectly ( type: esriFieldTypeString, alias: Has the Application Been Filled Out Correctly, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• AllPropertyOwners ( type: esriFieldTypeString, alias: Are all Property Owners Listed & Valid, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• ValidLocationContactInfo ( type: esriFieldTypeString, alias: Valid Location & Contact Information, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• ValidSepticYearInstalled ( type: esriFieldTypeString, alias: Valid Year Septic System Was Installed, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• ValidDatePumped ( type: esriFieldTypeString, alias: Valid Date of Last System Pump, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• ValidProjectCost ( type: esriFieldTypeString, alias: Received a Valid Total Cost of Repair or Replace of Non-Compliant System, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• CityConnection ( type: esriFieldTypeString, alias: Property Eligible to Connect to City Sewer & Water, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• ProgramEligible ( type: esriFieldTypeString, alias: Application Eligible For The Program, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• SSTSWithinShoreland ( type: esriFieldTypeString, alias: SSTS Within 1,000 Feet of Lake OR 300 Feet of River, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• NoticeOfViolationReceived ( type: esriFieldTypeString, alias: Copy of the Notice of Violation Received, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• SingleFamilyResidence ( type: esriFieldTypeString, alias: Property is a Single Family Residence, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• YearStructureBuilt ( type: esriFieldTypeString, alias: Provided Year Structure was Built, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• YearApplicantPurchased ( type: esriFieldTypeString, alias: Provided Year Poperty was Purchased, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• PropertyTaxCurrent ( type: esriFieldTypeString, alias: Applicant Current on Property Taxes, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• CurrentMortgagesLiens ( type: esriFieldTypeString, alias: Current on Property Morgages and Liens, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• ValidEstimate ( type: esriFieldTypeString, alias: Valid Estimate, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• LocatedNearWetland ( type: esriFieldTypeString, alias: Located Near Wetland or Waters of the State, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• ValidDisposalInfo ( type: esriFieldTypeString, alias: Waste Disposal Selection Valid, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• ValidMaterialsPresent ( type: esriFieldTypeString, alias: Valid Selection of Materials, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• VerifyDumpsiteGenerator ( type: esriFieldTypeString, alias: Verify Dumpsite Generator, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• VerifyYearsOfActivity ( type: esriFieldTypeString, alias: Verify Years of Activity , length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• VerifyPaymentCanBeMade ( type: esriFieldTypeString, alias: Verify Payment Can Be Made, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• DumpsiteResidential ( type: esriFieldTypeString, alias: Dumpsite Residential Property, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• ApplicantBeneficiary ( type: esriFieldTypeString, alias: Is the Applicant a Beneficiary, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• SubdividePropertyFiveYears ( type: esriFieldTypeString, alias: Plans to Subdivide Property Within Next Five Years, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• SubdivideLastTwoYears ( type: esriFieldTypeString, alias: Has Property Been Subdivided Last Two Years, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• InitalInspectionEnvThreat ( type: esriFieldTypeString, alias: Inital Inspection Env Threat, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• InitalInspectionNotAware ( type: esriFieldTypeString, alias: Inital Inspection Not Aware of Dump Site, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• InitalInspectionNotContributed ( type: esriFieldTypeString, alias: Inital Inspection Not Contributed, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• DetermineScope ( type: esriFieldTypeString, alias: Determine Scope of Clean-up, length: 1073741822 )
• FinalInspectionNotes ( type: esriFieldTypeString, alias: Final Inspection Notes, length: 1073741822 )
• ValidBusinessType ( type: esriFieldTypeString, alias: Valid Business Type, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• CorrectPropertyTaxClass ( type: esriFieldTypeString, alias: Correct Property Tax Classification Provided, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• VerifyNumberOfEmployees ( type: esriFieldTypeString, alias: Verify Number Of Employees, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• CheckOwnLease ( type: esriFieldTypeString, alias: Verify Own or Lease Property, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• CurrentTaxLiens ( type: esriFieldTypeString, alias: Current Tax Liens on Record, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• LicensePermitsGoodStanding ( type: esriFieldTypeString, alias: License Permits Good Standing, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• ProvidedDetailedProjectDesc ( type: esriFieldTypeString, alias: Provided Detailed Project Description, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• IdentifiedTimeFrames ( type: esriFieldTypeString, alias: Identified Time Frames, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• IdentifiedSuccessMeasured ( type: esriFieldTypeString, alias: Identified Success Measured, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• IdentifiedLimitedContamination ( type: esriFieldTypeString, alias: Identified Limited Contamination, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• IdentifiedProjectSustained ( type: esriFieldTypeString, alias: Identified How Project Sustained, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• IdentifiedCurrentWastePractices ( type: esriFieldTypeString, alias: Identified Current Waste Practices, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• ProvidedTotalProjectCost ( type: esriFieldTypeString, alias: Provided Total Project Cost, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• OrderFormFilledOut ( type: esriFieldTypeString, alias: Order Form Supplied, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• OrderedMaterialMailedSignage ( type: esriFieldTypeString, alias: Ordered Material and Mailed Signage, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• FinalInspectionComplete ( type: esriFieldTypeString, alias: FinalInspectionComplete, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• Type ( type: esriFieldTypeString, alias: Type, length: 255 , Coded Values: [LIC: Solid Waste Facility License & Checklist] , [QUA: Solid Waste Facility Quarterly Report] , [COD: Co-Disposal] , ...13 more... )
• CurrentTaxesAssessments ( type: esriFieldTypeString, alias: Current on All County Taxes and Special Assessments, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• TaxAmount ( type: esriFieldTypeString, alias: Property Tax Amount Provided and Accurate, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• BedBathProvided ( type: esriFieldTypeString, alias: Number of Bedrooms and Bathrooms Provided, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• ValidAgeofSeptic ( type: esriFieldTypeString, alias: Valid Septic System Age, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• ReviewHowSepticFailing ( type: esriFieldTypeString, alias: Review How Septic System is Failing, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• LicSepticEvaluator ( type: esriFieldTypeString, alias: Licensed Septic Site Evaluator Reviewed System, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• ReviewHeardAboutProject ( type: esriFieldTypeString, alias: Reviewed How They Heard About Project, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• InitialReviewDate ( type: esriFieldTypeDate, alias: Initial Review Date, length: 8 )
• MainReviewDate ( type: esriFieldTypeDate, alias: Main Review Date, length: 8 )
• SupportDocsSubmitted ( type: esriFieldTypeString, alias: Has any supporting documentation been submitted, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• DollarAmountAppropriate ( type: esriFieldTypeString, alias: Is the dollar amount appropriate for the submitted application, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• AdditionalInfoNeeded ( type: esriFieldTypeString, alias: Is additional information needed from applicant, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• DateApprovalSent ( type: esriFieldTypeDate, alias: Date of Letter of Approval Sent, length: 8 )
• GrantReviewedBySWAC ( type: esriFieldTypeString, alias: Has the grant been reviewed by SWAC, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• ProjectAlignStatute ( type: esriFieldTypeString, alias: Does the project or program align with Minn Statute, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• OnlyWithinSherburneCounty ( type: esriFieldTypeString, alias: Does the project or program offer services only within Sherburne County, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• CapitalImprovement ( type: esriFieldTypeString, alias: Is request for Capital improvement, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• MatchRequired ( type: esriFieldTypeString, alias: Match Required, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• ComplianceInspection ( type: esriFieldTypeString, alias: Compliance Inspection Needed, length: 5 , Coded Values: [Yes: Yes] , [No: No] )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata