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

Creating and Updating the Tables for Effective Dating Fields

First, you create a history table for the table for the base business component, and you update the table for the base business component.

To create and update the tables for effective dating fields

  1. Log in to Siebel Tools or Web Tools as an administrator and create a new workspace.

  2. Determine the table for the base business component that contains the fields for which you want to set up effective dating.

    In this example, the name of the table for the appropriate fields in the Account business component is S_PARTY. (For party-based business components, such as Account, Contact, and Household, the name for the table is S_PARTY.)

    Note: To determine this table name, navigate to Business Component in Object Explorer, and find the base business component. This table name appears in the Table column for the base business component.

  3. Lock the PUB Effective Dating project, and create a history table in this project with a name that is consistent with the name of the table for the base business component.

    In this example, the name of the history table is S_ORG_EXT_ED. For party-based business components, use a history table name that is consistent with the extension table name for the party-based business component.

    The following table includes the values in the columns for the column names in the history table.

    Name User Name User Key Seq Null-able Re-quired Physical Type Length Default

    PAR_ROW_ID

    Parent Id

    1

    N

    Y

    Varchar

    15

    None

    FIELD_NAME

    Field Name

    2

    N

    Y

    Varchar

    75

    None

    FIELD_VALUE

    Field Value

    None

    Y

    N

    Varchar

    250

    None

    EFF_START_DATE

    Effective StartDate

    3

    N

    Y

    Date

    7

    None

    EFF_END_DATE

    Effective EndDate

    None

    Y

    N

    Date

    7

    NULL

    LINK_ED_FLG

    Link ED Flag

    None

    N

    Y

    Character

    1

    N

    LAST_RECONCILED_NUM

    Eligibility Processed

    None

    N

    Y

    Integer

    None

    -1

    INTER_ROW_ID

    Intersection Table Row Id

    4

    Y

    N

    Varchar

    15

    None
    Note: For the PAR_ROW_ID column name, the Foreign Key Table column value is S_PARTY.

  4. Add column names to the table for the base business component.

    The following table includes the values in the columns for the additional column names in the table for the base business component.

    Name User Name Nullable Required Physical Type Length Default

    ED_DELETED_FLG

    ED Deleted

    N

    Y

    Character

    1

    N

    ED_ENABLED_FLG

    ED Enabled

    N

    Y

    Character

    1

    Y

  5. Apply the changes to the tables to the Siebel database.

  6. Deliver the changes to the Integration Branch.