[en] Varicent Incentive Compensation Management Documentation

[en] TS002076059 — Able to create a custom table with 13 primary key columns

[en] Fixed: Resolved an issue where users can create a custom table with more than 12 primary key columns by making the table effective dated.

[en] Reproduction Steps

[en] 1. In Composer, open the component that you want to add the new table to.

[en] 2. From the Palette tab, drag the Table object into the component.

[en] 3. From the Table type drop-down list, select Custom and click Next.

[en] 4. Type a name and description for the table and click Save. The table name cannot contain spaces.

[en] 5. Type a name for the primary key field and select the column type from the Type drop-down list.

[en] 6. Click 'Add a column' to add more fields to the table.

[en] 7. For each field that you add, perform the following steps:

[en]   a. If the field is a primary key field, select the ID check box to make the field a primary key.

[en]   b. Type a name for the new field.

[en] 8. Repeat steps 6 and 7 until you have 12 primary key columns.

[en] 9. Select the 'Effective dated' check box.

[en] The result is making the table effective dated adds an additional primary key column when users should not be able to create tables with more than 12 primary key columns.