Developing and Deploying Siebel Business Applications > Configuring the House and Opportunity Entities > Process of Configuring the House Detail - Appraisals View >

Creating the Appraisals Business Component

This task is a step in Process of Configuring the House Detail - Appraisals View.

To display data from a one-to-many extension table, you must define a new business component that includes the following items:

• Fields that reference the generic columns in the extension table. Examples of generic columns include ATTRIB_01, ATTRIB_02, and so forth.
• The following columns that establish the user key:
  • PAR_ROW_ID. Referenced by the foreign key field in the one-to-many link.
  • NAME. Referenced by the field tracked in the business component. The value in the name must make the record unique for each parent record.
  • TYPE. Referenced by the Type field. It groups records in the extension table. You set a default value for the Type field and then configure the business component to search for those records in the extension table that contains this value.

    To satisfy the U1 index of the _XM table, the combination of the NAME, PAR_ROW_ID, and TYPE columns must be unique.

To create the Appraisals business component

1. In Siebel Tools, choose the File menu, and then the New Object menu item.
2. In the General tab of the New Object Wizards dialog box, click BusComp, and then click OK.
3. In the New Business Component dialog box, enter the information from the following table, and then click Next.

   Property	Value
   Project	Product (SSE)
   Name	Appraisals
   Table	S_PROD_INT_XM

4. In the Single Value Fields dialog box, enter a column and field name for each row from the following table.

   Column in Base Table	Field Name
   ATTRIB_01	Date
   ATTRIB_02	Appraisal Value
   ATTRIB_03	Comments
   PAR_ROW_ID	Par Row Id
   NAME	Name
   TYPE	Type

   After you enter a column and field, click Add, and then add the next column and field. Note the following:

   • The Date field stores the date on which the appraiser performed the appraisal.
   • The Appraised Value field stores the value of the property.
   • The Name field stores the name of the appraiser.
   • The Type field groups records.
5. Click Finish.

   The Business Component Wizard creates the business component according to the information you entered.

6. In the Business Components list, modify the following property for the Appraisals business component.

   Property	Value
   Search Specification	[Type]= 'Appraisals'

   This search specification instructs the business component to retrieve only those records in which the Type field contains the value Appraisals.

7. Set the Predefault Value of the Type field:
   1. In the Object Explorer, expand the Business Component tree, and then click Field.
   2. In the Fields list, locate the Type field and then set the following property.

      Property	Value
      Predefault Value	Appraisals

      This property instructs Siebel CRM to always default the Type field in the Siebel client to Appraisals.

8. In the Fields list, make sure the Required property contains a check mark for each of the following fields:
   • Name
   • Par Row Id
   • Type

     Because the combination of the NAME, PAR_ROW_ID, and TYPE columns satisfy the U1 index of the _XM table, you must make sure these fields are required.