Developing and Deploying Siebel eBusiness Applications > Configuring the House and Opportunity Entities > Configuring the House Detail - Appraisals View >

Creating the Appraisals Business Component

To display data from a one-to-many extension table you must define a new business component with fields that map to the generic columns in the extension table (ATTRIB_01, ATTRIB_02, and so on), as well as three fields that provide the user key and map to the following columns.

• PAR_ROW_ID. This column should map to the foreign key field using in the one-to-many link.
• NAME. This column should map to the field being tracked in the business component. The value in the name needs to make the record unique for each parent record.
• TYPE. This column is used to group records in the extension table. This column should be mapped to the Type field. 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.

NOTE:  The combination of NAME, PAR_ROW_ID, and TYPE must be unique to satisfy the U1 index of the _XM table.

The following procedure guides you through creating the appraisals business component for the NREC example.

To create the Appraisals business component

1. Choose File > New Object.

   The New Object Wizards dialog box appears.

2. Under the General tab, select the BusComp icon and then click OK.

   The New Business Component wizard appears.

3. Enter the information from the following table, and then click Next.

   Field	Value
   Project	Product (SSE)
   Name	Appraisals
   Table	S_PROD_INT_XM

   The Single Value Fields dialog box appears.

4. Enter the columns and field names as shown in the following table, and then click Add for each one.

   Column in Base Table	Field Name	Description
   ATTRIB_01	Date	Date the appraisal is done.
   ATTRIB_02	Appraisal Value	Appraised value of the property.
   ATTRIB_03	Comments	Comments.
   PAR_ROW_ID	Par Row Id	Parent Row ID.
   NAME	Name	Used to store the name of the Appraiser.
   TYPE	Type	Used to group records. Will be set to a unique predefault value.

5. When done adding all the fields, click Finish.

   The Business Component Wizard creates the business component based on the information you entered.

Because the combination of NAME, PAR_ROW_ID, and TYPE must be unique to satisfy the U1 index of the _XM table, these fields must be marked as Required in the Appraisals business component.

To set the unique fields to be required

1. In the Object Explorer, expand the Business Component object type.

   The Business Component window appears in the Object List Editor.

2. In the Business Component window, select the Appraisals business component.
3. In the Object Explorer, select the Field object type (child of Business Component).

   The list of fields that you created in a previous procedure appear in the Fields window of the Object List Editor.

4. For each of the following fields, set the check mark on the Required property.
   • Name
   • Par Row Id
   • Type

To set the search specification for the business component and the Predefault Value of the Type field

1. In the Object Explorer, expand the Business Component object type.

   The Business Component window appears in the Object List Editor.

2. In the Business Component window, select the Appraisals business component.
3. In the Appraisals business component's Search Specification field, enter the following text:

   [Type]= 'Appraisals'

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

4. In the Object Explorer, select the Field object type (child of Business Component).

   The list of fields that you created in a previous procedure appear in the Fields window of the Object List Editor.

5. Select the Type field and then enter Appraisals as the Predefault Value.

   The Type field always defaults to Appraisals, as shown in the following illustration.