1 / 16

ATFS Database Reports

ATFS Database Reports. A cheat sheet for seeing which fields will be on your report. TF Reports: State Program. You will see three types of information in this report. State Number TreeFarmName TreeFarmStatus County Acres Location OwnershipType Action Notes. CertDecertDate

mazurek
Download Presentation

ATFS Database Reports

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ATFS Database Reports A cheat sheet for seeing which fields will be on your report

  2. TF Reports: State Program You will see three types of information in this report • State • Number • TreeFarmName • TreeFarmStatus • County • Acres • Location • OwnershipType • Action • Notes • CertDecertDate • InitialCertDate • Approval Date • InspectDate • Inspector • InspectStatus • Opt • NS • AssignedInspector • AssignedDate • DecertReason • Member ID • Prefix • FirstName • MI • LastName • Suffix • Organization • AddressLine1 • AddressLine2 • AddressLine3 • City • State • Zip • County • Phone • Email • ContactStatus • Absentee

  3. TF Reports: Other • State • Number • TreeFarmName • TreeFarmType • County • Acres • ThirdPartCertName • InitialAuditDate • LastAuditDate • AuditorName • Member ID • Prefix • FirstName • MI • LastName • Suffix • Organization • AddressLine1 • AddressLine2 • AddressLine3 • City • State • Zip • County • Phone • Email • Absentee

  4. TF Reports: Optional 6 Year Reinspections • State • Number • TreeFarmName • County • Acres • TreeFarmStatus • InitialCertDate • ApprovalDate • InspectDate • Inspector • InspectStatus • Opt • NS • AssignedInspector • AssignedDate • Member ID • Prefix • FirstName • MI • LastName • Suffix • Organization • AddressLine1 • AddressLine2 • AddressLine3 • City • State • Zip • County • Phone • Email • Absentee

  5. TF Reports: Required Inspections • State • Number • TreeFarmName • County • Acres • TreeFarmStatus • DecertReason • InitialCertDate • ApprovalDate • InspectDate • Inspector • InspectionType • Type • InspectionStatus • SampleYear • Outstanding • Member ID • Prefix • FirstName • MI • LastName • Suffix • Organization • AddressLine1 • AddressLine2 • AddressLine3 • City • State • Zip • County • Phone • Email • Absentee

  6. TF Reports:Assigned Inspections • State • Number • TreeFarmName • County • Acres • TreeFarmType • TreeFarmStatus • InitialCertDate • ApprovalDate • InspectDate • Inspector • InspectStatus • Opt • NS • AssignedInspector • AssignedDate • Member ID • Prefix • FirstName • MI • LastName • Suffix • Organization • AddressLine1 • AddressLine2 • AddressLine3 • City • State • Zip • County • Phone • Email • Absentee

  7. TFer Reports: State Program Member ID Prefix FirstName MI LastName Suffix Organization AddressLine1 AddressLine2 AddressLine3 City State Zip County Phone Email ContactStatus TreeFarms

  8. TFer Reports: Mailing List Member ID FullName Prefix FirstName MI LastName Suffix Organization AddressLine1 AddressLine2 AddressLine3 City State Zip County Phone Email ContactStatus Owner Absentee TotalAcres TreeFarms

  9. Admin Reports: Inspectors • TrainingType • TrainingDate • TrainingExpDate • Company • Status2 • States • Member ID • Prefix • FirstName • MI • LastName • Suffix • Organization • AddressLine1 • AddressLine2 • AddressLine3 • City • State • Zip • County • Phone • Email • Status1

  10. Admin Reports: Inspector Activity • State • TreeFarmNumber • TreeFarmAcres • FormVersion • InspectionType • InspectionStatus • InspectionDate • Authorized Member ID Prefix FirstName MI LastName Suffix TrainingDate Status

  11. Admin Reports:Facilitators • TrainingDate • TrainingExpDate • Company • Status2 Member ID Prefix FirstName MI LastName Suffix Organization AddressLine1 AddressLine2 AddressLine3 City State Zip County Phone Email Status1

  12. Admin Reports:Duplicate Tree Farms • State • Number • TreeFarmName • County • Acres • InitialCertDate • ApprovalDate • InspectDate • Inspector • Status • Opt • NS • AssignedInspector • AssignedDate • Member ID • Prefix • FirstName • MI • LastName • Suffix • Organization • AddressLine1 • AddressLine2 • AddressLine3 • City • State • Zip • County • Phone • Email • Absentee

  13. Admin Reports:All State Program Tree Farms • State • Number • TreeFarmName • County • Acres • CertDecertDate • InitialCertDate • Opt • NS • ApprovalDate • InspectDate • Inspector • InspectStatus • TreeFarmStatus • AssignedInspector • AssignedDate • Member ID • Prefix • FirstName • MI • LastName • Suffix • Organization • AddressLine1 • AddressLine2 • AddressLine3 • City • State • Zip • County • Phone • Email • ContactStatus • Absentee

  14. Admin Reports:Tree Farm Owners/Contacts Except Decerts • Member ID • Prefix • FirstName • MI • LastName • Suffix • Organization • AddressLine1 • AddressLine2 • AddressLine3 • City • State • Zip • County • Phone • Email • Status • IsOwner • IsContact • Certified

  15. Admin Reports:Tree Farm Owners/Contacts • Member ID • Prefix • FirstName • MI • LastName • Suffix • Organization • AddressLine1 • AddressLine2 • AddressLine3 • City • State • Zip • County • Phone • Email • Status • IsOwner • IsContact • Certified

  16. Admin Reports:Everyone • Member ID • Prefix • FirstName • MI • LastName • Suffix • Organization • AddressLine1 • AddressLine2 • AddressLine3 • City • State • Zip • County • Phone • Email • Status • IsOwner • IsContact • Certified

More Related