Name: Financial Assistance Review

Display Field: ApplicationNumber

Type: Table

Geometry Type: N/A

Description:

Service Item Id: d5be49c436f248eea3afb5685e150b7f

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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:

Fields:

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

Templates:

• Name: Financial Assistance Review
  Description:
  Prototype:
  MatchRequired: null
  ApplicationNumber: null
  ReviewStatus: null
  NoticeNonCompliance: null
  RecentMortgagePayment: null
  CurrentPropertyTaxStatement: null
  SepticDesign: null
  TwoBids: null
  NoViolations: null
  Notes: null
  ApplicationFilledOutCorrectly: null
  AllPropertyOwners: null
  ValidLocationContactInfo: null
  ValidSepticYearInstalled: null
  ValidDatePumped: null
  ValidProjectCost: null
  CityConnection: null
  ProgramEligible: null
  SSTSWithinShoreland: null
  ComplianceInspection: null
  OnlyWithinSherburneCounty: null
  ProjectAlignStatute: null
  GrantReviewedBySWAC: null
  DateApprovalSent: null
  CapitalImprovement: null
  NoticeOfViolationReceived: null
  SingleFamilyResidence: null
  YearStructureBuilt: null
  YearApplicantPurchased: null
  PropertyTaxCurrent: null
  CurrentMortgagesLiens: null
  ValidEstimate: null
  LocatedNearWetland: null
  ValidDisposalInfo: null
  ValidMaterialsPresent: null
  VerifyDumpsiteGenerator: null
  VerifyYearsOfActivity: null
  VerifyPaymentCanBeMade: null
  DumpsiteResidential: null
  ApplicantBeneficiary: null
  SubdividePropertyFiveYears: null
  SubdivideLastTwoYears: null
  InitalInspectionEnvThreat: null
  InitalInspectionNotAware: null
  InitalInspectionNotContributed: null
  DetermineScope: null
  FinalInspectionNotes: null
  ValidBusinessType: null
  CorrectPropertyTaxClass: null
  VerifyNumberOfEmployees: null
  CheckOwnLease: null
  CurrentTaxLiens: null
  LicensePermitsGoodStanding: null
  ProvidedDetailedProjectDesc: null
  IdentifiedTimeFrames: null
  IdentifiedSuccessMeasured: null
  IdentifiedLimitedContamination: null
  IdentifiedProjectSustained: null
  IdentifiedCurrentWastePractices: null
  ProvidedTotalProjectCost: null
  OrderFormFilledOut: null
  OrderedMaterialMailedSignage: null
  FinalInspectionComplete: null
  Type: null
  CurrentTaxesAssessments: null
  TaxAmount: null
  BedBathProvided: null
  ValidAgeofSeptic: null
  ReviewHowSepticFailing: null
  LicSepticEvaluator: null
  ReviewHeardAboutProject: null
  InitialReviewDate: null
  MainReviewDate: null
  SupportDocsSubmitted: null
  DollarAmountAppropriate: null
  AdditionalInfoNeeded: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Extract,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Ownership Based Access Control:

• Allow Others to Update: true
• Allow Others to Delete: true
• Allow Others to Query: true

Supports Query With Historic Moment: true

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata