Name: HMA_Subapplications_by_County

Display Field: applicantName

Type: Table

Description:

Copyright Text:

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)
• subapplicationIdentifier (type: esriFieldTypeString, alias: subapplicationIdentifier, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• county (type: esriFieldTypeString, alias: county, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• stateAbbreviation (type: esriFieldTypeString, alias: stateAbbreviation, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• fips (type: esriFieldTypeString, alias: fips, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• applicantName (type: esriFieldTypeString, alias: applicantName, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• subapplicantName (type: esriFieldTypeString, alias: subapplicantName, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• subapplicantStateAbbreviation (type: esriFieldTypeString, alias: subapplicantStateAbbreviation, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• status (type: esriFieldTypeString, alias: status, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• primaryActivity (type: esriFieldTypeString, alias: primaryActivity, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• primaryHazard (type: esriFieldTypeString, alias: primaryHazard, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• secondaryHazard (type: esriFieldTypeString, alias: secondaryHazard, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• totalObligatedAmount (type: esriFieldTypeDouble, alias: totalObligatedAmount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• selectionFederalShareAmount (type: esriFieldTypeDouble, alias: selectionFederalShareAmount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• include_exclude (type: esriFieldTypeString, alias: include_exclude, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• min_transaction_date (type: esriFieldTypeDate, alias: min_transaction_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FYCloseDate (type: esriFieldTypeDate, alias: FYCloseDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• months_to_obligation (type: esriFieldTypeDouble, alias: months_to_obligation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• timely_obligation (type: esriFieldTypeString, alias: timely_obligation, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• obligation_status (type: esriFieldTypeString, alias: obligation_status, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• county_state (type: esriFieldTypeString, alias: county_state, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• state_wide_flag (type: esriFieldTypeInteger, alias: state_wide_flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• unique_id (type: esriFieldTypeString, alias: unique_id, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• subapplicationTitle (type: esriFieldTypeString, alias: subapplicationTitle, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• mgmtFederalShareAmount (type: esriFieldTypeDouble, alias: mgmtFederalShareAmount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• mgmtNonFederalShareAmount (type: esriFieldTypeDouble, alias: mgmtNonFederalShareAmount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• selectionProgramActivity (type: esriFieldTypeString, alias: selectionProgramActivity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• selectionFundCode (type: esriFieldTypeString, alias: selectionFundCode, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• refresh_date (type: esriFieldTypeString, alias: Refresh Date, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• program (type: esriFieldTypeString, alias: program, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• fiscal_yr_text (type: esriFieldTypeString, alias: fiscal_yr_text, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• subapplicantState (type: esriFieldTypeString, alias: subapplicantState, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)

Templates:

Name: HMA_Subapplications_by_County
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• Subapplications_To_Counties (1) -- Related To: CountyBoundaries (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/31/2025 4:31:47 AM

Schema Last Edit Date: 3/31/2025 4:20:13 AM

Data Last Edit Date: 3/31/2025 4:31:47 AM

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