All Layers and Tables (Wildlife_Conservation_Land_Program_Application_(Submit_View

Layers:

Tables:

WHCAssistanceApplication (10)

Name:

Display Field:

Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

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:

Relationships:

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

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

WHCApplicationParcels (15)