Bookshelf v7.5: Manage the List of Houses for Sale

NREC requires the ability to manage the list of houses that are currently for sale. This includes storing key characteristics, such as price, number of bedrooms, and square feet; keeping a history of appraisals; and pulling in any data about renovation history from an external file that is supplied by a third-party vendor.

Table 2 lists the detailed requirements for the House entity and lists where you can find the tasks in this book that describe how to implement the requirement.

Table 2. Requirements Summary for the House Entity
Requirement	Comment	Cross Reference to Task
Track houses for sale.	Create a new screen for Houses and add to the eChannel application.	See Creating the Houses Screen.
Track the features of each house, such as square feet, number of bedrooms, and so on.	Add columns to S_PROD_IN T to store additional attributes and expose them in the user interface.	See Configuring the House Detail View.
Allow users to enter and Edit records for houses.	Modify Internal Product business component to allow updates and add necessary controls to the Product Form Applet.	See Configuring the Internal Product Business Component and Modify Existing Product Applets to Display NREC Attributes.
Provide users with pre-defined values to select from when entering house features.	Configure static pick lists for fields.	See Configuring Pick Lists.
Track and display previous appraisal information (date, amount, assessor) for each house.	Use standard 1:M table to store appraisal data and expose fields in the user interface.	See Configuring the House Detail - Appraisals View.
Display renovation information for each house.	Create virtual business component to store and display data from flat file. Create new view to display the data.	See Creating a Virtual Business Component.
Display houses to partner users based on ZIP Code.	Use Siebel Personalization to filter the list of houses based on the user's ZIP Code.	See Personalization.