1. Public Sector Guide
  2. Creating and Updating the Business Components for One-to-Many Effective Dating Records

Creating and Updating the Business Components for One-to-Many Effective Dating Records

After you create and update the tables for effective dating records, you create a history business component for the history table, and you update the child business component.

To create and update the business components for effective dating records

  1. Use the wizard to create the history business component in the PUB Effective Dating project using the history table.

    In this example, the name of the history business component is Opportunity History.

    The following table includes the field and column names for the history business component.

    Field Name Column Name Join Type

    Field Name

    FIELD_NAME

    None

    DTYPE_TEXT

    Field Value

    FIELD_VALUE

    None

    DTYPE_TEXT

    Effective Start Date

    EFF_START_DATE

    None

    DTYPE_UTCDATE

    Effective End Date

    EFF_END_DATE

    None

    DTYPE_UTCDATE

    Created By UserName

    LOGIN

    S_USER

    DTYPE_TEXT

  2. In the child business component, add fields.

    The following table includes the values in the columns for the field names in the child business component.

    Name Column Force Active Predefault Value

    ED Deleted Flag

    ED_DELETED_FLG

    True

    N

    ED Enabled Flag

    ED_ENABLED_FLG

    True

    N

    In this example, the child business component is Opportunity.

  3. In the child business component, add the ED BusComp user property with a value of the name of the history business component.

    In this example, the child business component is Opportunity, and the name of the history business component is Opportunity History.

  4. In the PUB Effective Dating project, create a new link between the child business component and the history business component.

  5. Use this link to add the history business component to the business object for the parent business component.

    In this example, the business object for the parent business component is Account.

  6. Deliver the changes to the Integration Branch.