1.2+Scope

This document describes three layers of the system. At the outermost layer (the local store level), the store interface system processes data files from cash registers, POS scanners, Internet orders, manual clerk input, etc. These data files are stored and managed on the local store servers by the TeRP v.1.0 system. At the next layer (the warehouse level), the warehouse interface system processes data files from the local store databases, other warehouse databases, supplier databases (if the supplier has a compatible electronic database) and manual clerk input. These data files are stored and managed on the warehouse servers by the TeRP v.1.0 system. At the core of the system (the headquarters level), the corporate interface system processes data files primarily from the warehouse databases, and if necessary, the local store databases as well. These data files are stored and managed on the corporate servers by the TeRP v.1.0 system.
 * 1.2. Scope**

The core system at the corporate level is responsible for assembling the data from all sites and generating reports. After report files are compiled, the core system is used to print the files locally and send an electronic copy to leadership in the organization.

The TeRP system architecture is a standard database format. Corporate leadership users and other authorized non-technical users can access its data through forms that interconnect to the different layers of the system. Technical users such as IT Specialists and Database Administrators will have the ability to directly access the underlying SQL database and run advanced queries (i.e: select * from TeRP where item_number like ‘1094%’ and lower (product_mnfctr) = ‘purina’;