Orange County NC Website
Browse       Search
Discovery Phase with Orange County — AMCAD Interface <br />Project Name: Orange County AMCAD Project <br />Project Managers: Kristen O'Connor - Patriot Properties <br />Anita Sundaram — Orange County <br />Project Scope: Implement an interface with AMCAD to PIN History. <br />Project Specifications: The following is a list of enhancements that Patriot will <br />--=-- - - - - -- <br />AmCad will make available the following fields from <br />AMCAD: Date & Time Rec., Type, Revenue <br />Stamps,Name (where role = Grantee), Grantee, Bk/Pg, <br />and First Legal (once imported County will modify <br />First Legal and Name if needed and also add more <br />information that is required). The Grantee field will <br />need to be a list to show all owners associated.We need <br />to handle multiple owners associated. <br />1. 1. We need a stored procedure to read the data from <br />AMCAD interface to a staging area.Make this a view so <br />that all of the data is the ,same. <br />2. 2. Once the data is available (loaded or viewed within <br />AMCAD), we need an interactive Ul to facilitate the <br />ability tomodify the Grantee and Legal Description in <br />separate fields for the tax owner. Leaving AMCAD <br />untouched.We will display infromation from PIN and <br />the County will be able to adjust or accept the data from <br />AMCAD. <br />3. 3. Once Data is edited we need a stored procedure to <br />update PIN Application <br />4. We will also need a job to provide feedback to <br />AMCAD on changes they made, this would be report. <br />Will they require a report for the data in the staging area? The County will <br />require a report to give back to AMCAD to show the changes made in the data <br />that was pulled over. <br />4. Upon pushing the job to pin history the succesfull entry <br />will be cleared out. <br />5. <br />Timing: How often does the County want this data pushed into Pin <br />History? Or does the County want it in a report first and <br />then push? We would want the data to be held in a report or <br />a temporary holding area till the issue is resolved. Upon <br />resolution, it should be pushed into PIN History. <br />October 7, 2008 <br />Version 1.0 <br />