TF Reports State Program State Number TreeFarmName TreeFarmStatus County Acres Location OwnershipType Action Notes CertDecertDate InitialCertDate Approval Date InspectDate Inspector InspectStatus ID: 742993
Download Presentation The PPT/PDF document "ATFS Database Reports A cheat sheet for ..." is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
ATFS Database Reports
A cheat sheet for seeing which fields will be on your reportSlide2
TF Reports: State Program
State
Number
TreeFarmName
TreeFarmStatus
CountyAcresLocationOwnershipTypeActionNotes
CertDecertDateInitialCertDateApproval DateInspectDateInspectorInspectStatusOptNSAssignedInspectorAssignedDateDecertReason
Member IDPrefixFirstNameMILastNameSuffixOrganizationAddressLine1AddressLine2AddressLine3CityStateZipCountyPhoneEmailContactStatusAbsentee
You will see three types of information in this reportSlide3
TF Reports: Other
State
Number
TreeFarmName
TreeFarmType
CountyAcresThirdPartCertName
InitialAuditDateLastAuditDateAuditorNameMember IDPrefixFirstNameMILastNameSuffix
OrganizationAddressLine1AddressLine2AddressLine3CityStateZipCountyPhoneEmailAbsenteeSlide4
TF Reports:
Optional 6 Year
Reinspections
State
Number
TreeFarmNameCountyAcresTreeFarmStatus
InitialCertDateApprovalDateInspectDateInspectorInspectStatusOptNSAssignedInspectorAssignedDate
Member IDPrefixFirstNameMILastNameSuffixOrganizationAddressLine1AddressLine2AddressLine3CityStateZipCountyPhoneEmailAbsenteeSlide5
TF Reports:
Required Inspections
DecertReason
InitialCertDate
ApprovalDate
InspectDateInspectorInspectionTypeTypeInspectionStatusSampleYear
OutstandingStateNumberTreeFarmNameCountyAcresTreeFarmStatusMember ID
PrefixFirstNameMILastNameSuffixOrganizationAddressLine1AddressLine2AddressLine3CityStateZipCountyPhoneEmailAbsenteeSlide6
TF Reports:
Assigned Inspections
State
Number
TreeFarmName
CountyAcresTreeFarmTypeTreeFarmStatus
InitialCertDateApprovalDateInspectDateInspectorInspectStatusOptNSAssignedInspectorAssignedDateMember IDPrefix
FirstNameMILastNameSuffixOrganizationAddressLine1AddressLine2AddressLine3CityStateZipCountyPhoneEmailAbsenteeSlide7
TFer
Reports: State Program
Member ID
Prefix
FirstName
MILastNameSuffixOrganizationAddressLine1AddressLine2AddressLine3CityStateZip
CountyPhoneEmailContactStatusTreeFarmsSlide8
TFer
Reports: Mailing List
Member ID
FullName
Prefix
FirstNameMILastNameSuffixOrganizationAddressLine1AddressLine2AddressLine3City
StateZipCountyPhoneEmailContactStatusOwnerAbsenteeTotalAcresTreeFarmsSlide9
Admin Reports:
Inspectors
Member ID
Prefix
FirstName
MILastNameSuffixOrganizationAddressLine1AddressLine2AddressLine3CityStateZipCountyPhoneEmail
Status1TrainingTypeTrainingDateTrainingExpDateCompanyStatus2StatesSlide10
Admin Reports:
Inspector Activity
Member ID
Prefix
FirstName
MILastNameSuffixTrainingDateStatus
StateTreeFarmNumberTreeFarmAcres
FormVersionInspectionTypeInspectionStatusInspectionDateAuthorizedSlide11
Admin Reports:
Facilitators
Member ID
Prefix
FirstName
MILastNameSuffixOrganizationAddressLine1AddressLine2AddressLine3CityStateZipCountyPhoneEmail
Status1TrainingDateTrainingExpDate
CompanyStatus2Slide12
Admin Reports:
Duplicate Tree Farms
State
Number
TreeFarmName
CountyAcresInitialCertDateApprovalDateInspectDate
InspectorStatusOptNSAssignedInspectorAssignedDateMember IDPrefixFirstNameMI
LastNameSuffixOrganizationAddressLine1AddressLine2AddressLine3CityStateZipCountyPhoneEmailAbsenteeSlide13
Admin Reports:
All State Program Tree Farms
State
Number
TreeFarmName
CountyAcresCertDecertDateInitialCertDateOptNS
ApprovalDateInspectDateInspectorInspectStatusTreeFarmStatusAssignedInspectorAssignedDateMember ID
PrefixFirstNameMILastNameSuffixOrganizationAddressLine1AddressLine2AddressLine3CityStateZipCountyPhoneEmailContactStatusAbsenteeSlide14
Admin Reports:
Tree Farm Owners/Contacts Except
Decerts
Member ID
Prefix
FirstNameMILastNameSuffixOrganizationAddressLine1AddressLine2
AddressLine3CityStateZipCountyPhoneEmailStatusIsOwnerIsContactCertifiedSlide15
Admin Reports:
Tree Farm Owners/Contacts
Member ID
Prefix
FirstName
MILastNameSuffixOrganizationAddressLine1AddressLine2AddressLine3
CityStateZipCountyPhoneEmailStatusIsOwnerIsContactCertifiedSlide16
Admin Reports:
Everyone
Member ID
Prefix
FirstName
MILastNameSuffixOrganizationAddressLine1AddressLine2AddressLine3
CityStateZipCountyPhoneEmailStatusIsOwnerIsContactCertified