01/29/22 04:20PM CLIFTON town02 PRC System VER 5 PRC Information Screens Other Screens 1 - Mod IV Information 11 - Commercial Income Approach 2 - Residential PRC Information 12 - Commercial Cost Appr 3 - Historical Sale Information 13 - Added Assessments 4 - Building Permits 14 - Codes Table 5 - Residential Data Entry 15 - Land Data Entry 16 - Chapter 91 17 - Tax Appeals System and Administration Reports & Misc 21 - Utilities 31 - Print Property Record Card 22 - Codes & Cost Values 32 - Reports & Misc Printing 23 - Backup This Town 33 - Assessment History 24 - Global Updates Menu 34 - Copy/Demolish a Residential PRC 25 - Message System 35 - Download Forms to Laser Printer Type a Number and Press Enter or type q to exit this menu: 24 Password: camera Global Update Menu 1. Edit Misc Updates (informer) 16. Tax Field Update Screen 2. Run Misc Updates Only 17. Copy .txt File to Local Drive 3. Edit Ace Reports 18. Copy .csv File to Local Drive 4. Run Ace Report 19. Appeals Mod4 Update 5. COE Over-Rides 20. Reassessment Menu 6. Print Total of Each Update Code 21. SqFt Units YrBlt Mod4 Update 7. Block/Lot ID Change 22. Add History Records 8. Update Zones or Neighborhoods 23. Copy to Work or Reval File 9. Copy Record from Another File 24. Send informer.txt 10. Globally Change Bank Codes 25. Run informer.txt 11. Bank Codes Entry Screen 26. Sample informer xls File 12. Add Note Record for Every Record 27. Send Records to FTP Site 13. Update Additional PRC's From Main 28. Update Records from FTP Site 14. Update PRC Date/Code From Commercial 29. Redact Information 15. Add/Remove Reap R01 Code Type a Number and Press Enter or type q to exit this menu: 1 ------------------------------------------------------------------Screen:1 of 1 ENTRY/MODIFICATION OF INFORMER COMMANDS NUMBER:[14 ] NOTES: [create list of class 15f records ] [1-29-22 bkr ] COMMANDS: [select database prc5 ] [ ] [unload ascii ] [h00 h01 h02 i18 i19 i20 i24 ] [h58 h85 h76 ] [l31b l31l l34g ] [ ] [where h03="M" ] [and i24="15F" ] [ ] [to "informer.txt" ] [ ] [ ] Global Update Menu 1. Edit Misc Updates (informer) 16. Tax Field Update Screen 2. Run Misc Updates Only 17. Copy .txt File to Local Drive 3. Edit Ace Reports 18. Copy .csv File to Local Drive 4. Run Ace Report 19. Appeals Mod4 Update 5. COE Over-Rides 20. Reassessment Menu 6. Print Total of Each Update Code 21. SqFt Units YrBlt Mod4 Update 7. Block/Lot ID Change 22. Add History Records 8. Update Zones or Neighborhoods 23. Copy to Work or Reval File 9. Copy Record from Another File 24. Send informer.txt 10. Globally Change Bank Codes 25. Run informer.txt 11. Bank Codes Entry Screen 26. Sample informer xls File 12. Add Note Record for Every Record 27. Send Records to FTP Site 13. Update Additional PRC's From Main 28. Update Records from FTP Site 14. Update PRC Date/Code From Commercial 29. Redact Information 15. Add/Remove Reap R01 Code Type a Number and Press Enter or type q to exit this menu: 2 Command Number: 14 INFORMER Relational Query Language INFORMIX Version 3.30.14 Copyright (C) 1981, 1982, 1983, 1984 Relational Database Systems, Inc. Software Serial Number ALT-R268201 Type help for sample commands. Database "prc" has been selected successfully. > {NUMBER 14} >> select database prc5 Database "prc5" has been selected successfully. > > unload ascii >> h00 h01 h02 i18 i19 i20 i24 >> h58 h85 h76 >> l31b l31l l34g >> >> where h03="M" >> and i24="15F" >> >> to "informer.txt" >> >> >> ; A sequential search will be used to satisfy the WHERE clause. > bye Program over. Press ENTER: Global Update Menu 1. Edit Misc Updates (informer) 16. Tax Field Update Screen 2. Run Misc Updates Only 17. Copy .txt File to Local Drive 3. Edit Ace Reports 18. Copy .csv File to Local Drive 4. Run Ace Report 19. Appeals Mod4 Update 5. COE Over-Rides 20. Reassessment Menu 6. Print Total of Each Update Code 21. SqFt Units YrBlt Mod4 Update 7. Block/Lot ID Change 22. Add History Records 8. Update Zones or Neighborhoods 23. Copy to Work or Reval File 9. Copy Record from Another File 24. Send informer.txt 10. Globally Change Bank Codes 25. Run informer.txt 11. Bank Codes Entry Screen 26. Sample informer xls File 12. Add Note Record for Every Record 27. Send Records to FTP Site 13. Update Additional PRC's From Main 28. Update Records from FTP Site 14. Update PRC Date/Code From Commercial 29. Redact Information 15. Add/Remove Reap R01 Code Type a Number and Press Enter or type q to exit this menu: 17 1=CSV/Excel 2=Tab-Delimited :1 Text files available for download: informer.txt pdflist.txt Enter File Name:informer.txt The above file has been copied to your local drive C:\TMP folder. Use Excel to open file file. Remember to change "Files of Type" to "Text".