1. Public Sector Guide
  2. Creating and Updating the Business Components for Effective Dating Fields

Creating and Updating the Business Components for Effective Dating Fields

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

To create and update the business components for effective dating fields

  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 Account 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 base business component, add fields.

    The following table includes the values in the columns for the field names in the base 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 base business component is Account.

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

    In this example, the base business component is Account, and the name of the history business component is Account History.

  4. For each field in the base business component for which the Required column is selected, add the ED Control Expr user property and include the following value for this user property:

    Required Field Name IS NOT NULL.

    In this value, Required Field Name is the name of field in the base business component for which the Required column is selected.

    This step ensures that field effective dating is implemented after a user creates a record, and not when the user creates the record.

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

  6. Use this link to add the history business component to the business object for the base business component.

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

  7. Deliver the changes to the Integration Branch.