ECCM users can potentially log on to many different products at the same time. For every logon through the web page, ECCM Configuration ID identifies a combination by storing the provider names and the corresponding product codes. So if User A logged on to Endevor (Provider-Usmbess1) and Harvest (Provider-Kauai), then the entries in the table will be 1, Usmbess1, 1 AND 1,Kauai, 2.
Only when a user logs into more than one provider should an Enterprise Configuration entry be made, and only if there isn't already one for the provider combination.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| eccm_configurationid | integer | not null | For every logon to multiple providers through the web page,
ECCM Configuration ID identifies a combination by storing
the provider names and the corresponding product codes.
There should only be one instance of a product per configuration. This should be enforced by the application. |
| provider_name | char(20) | not null | Provider Name is the product specific location (machine name for Endevor/broker for Harvest) to which the user logs on. |
| product_code | integer | not null | A numeric field to identify products. 0 for ECCM, 1 for Harvest and 2 for Endevor |
| provider_number | integer | not null | Provider number is the number of providers that are in use for this configuration. For example, if this configuration represents a Harvest and an Endevor logon provider number would equal 2. |
| datetime_updated | date | not null | Datetime of the last update |
Product Name: AllFusion Change Manager Enterprise Workbench
Table Type: Table