Name: WHCAssistanceApplication

Display Field: WhcApplicationID

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 2000

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: sqlTypeOther, length: 0, nullable: false, editable: false)
• WhcApplicationID (type: esriFieldTypeString, alias: Assistance Application ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• LandAddressTXT (type: esriFieldTypeString, alias: Land address, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• OwnerNM (type: esriFieldTypeString, alias: Owner name as it appears on the property deed, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• ApplicantNM (type: esriFieldTypeString, alias: Applicant name, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• OwnerADDRESS (type: esriFieldTypeString, alias: Applicant address, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• OwnerPHONE (type: esriFieldTypeString, alias: Applicant phone, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• OwnerEMAIL (type: esriFieldTypeString, alias: Applicant email, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• TypeOwnershipCD (type: esriFieldTypeString, alias: Type of ownership, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [IND: Individual], [FBS: Family Business], [FTR: Family Trust], ... 2 more ...)
• NewPropertyIND (type: esriFieldTypeString, alias: New Property, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• TransferPropertyIND (type: esriFieldTypeString, alias: Transferred Property, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• ApplicationDT (type: esriFieldTypeDate, alias: Applicant Signature Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ApplicationStatusCD (type: esriFieldTypeString, alias: Application status, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true, Coded Values: [PIR: Pending review of initial landowner request], [PSV: Landowner contacted, pending site visit], [PSR: Site visit completed, pending supervisor review], ... 2 more ...)
• BiologistNM (type: esriFieldTypeString, alias: Biologist or Consultant assigned to, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• BiologistEMAIL (type: esriFieldTypeString, alias: WRC Biologist (Principal contact) email, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• LandownerContactDT (type: esriFieldTypeDate, alias: Landowner contacted date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SiteVisitDT (type: esriFieldTypeDate, alias: Site visit completion date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• WhcaSubmitDT (type: esriFieldTypeDate, alias: WHCA Draft Submitted, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SupervisorNM (type: esriFieldTypeString, alias: Supervising Biologist, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• SupervisorEMAIL (type: esriFieldTypeString, alias: Supervising Biologist email, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ApplicationApprovedIND (type: esriFieldTypeString, alias: Application approved?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• SupervisorApprovalDT (type: esriFieldTypeDate, alias: Supervising Biologist approval date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• WhcaID (type: esriFieldTypeString, alias: WHCA ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• QcStatusCD (type: esriFieldTypeString, alias: Data review status for this record, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [UNV: Unverified, data submission requires manual review.], [PND: Pending, data entered but not reviewed.], [AVR: Automated data validation required.], ... 5 more ...)
• QcByCD (type: esriFieldTypeString, alias: Who reviewed this record, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [JRI: John Isenhour])
• QcDT (type: esriFieldTypeDate, alias: Date the review was complete, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• QcCommentsTXT (type: esriFieldTypeString, alias: Data review comments, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• edited_user (type: esriFieldTypeString, alias: edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• edited_date (type: esriFieldTypeDate, alias: edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• CityTownCD (type: esriFieldTypeString, alias: Land City/Town, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• StateCD (type: esriFieldTypeString, alias: Land State, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ZipCD (type: esriFieldTypeString, alias: Land ZIP/Postal Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• applicant_signature (type: esriFieldTypeString, alias: Applicant Signature, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• OwnerCityTownCD (type: esriFieldTypeString, alias: Applicant City/Town, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OwnerStateCD (type: esriFieldTypeString, alias: Applicant State, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [AL: Alabama], [AK: Alaska], [AZ: Arizona], ... 47 more ...)
• OwnerZipCD (type: esriFieldTypeString, alias: Applicant ZIP/Postal Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TransferDT (type: esriFieldTypeDateOnly, alias: Date property was transferred, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: WHCAssistanceApplication
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• WHCApplication_WHCAppParcel (2) -- Related To: WHCApplicationParcels (15)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/18/2026 7:36:53 PM

Schema Last Edit Date: 7/10/2026 12:29:51 PM

Data Last Edit Date: 8/18/2026 7:36:53 PM

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