User is associated and is unique within a Provider. This table is checked at each login and an entry made if none is present.
Password is stored at the time an Enterprise package is submitted for execution.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| userid | integer | not null | Unique Id for a User Record |
| 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 |
| username | char(40) | not null | User name as identified by the PROVIDER_NAME |
| password | char(64) | with null | Stored for execution of Enterprise packages. Encrypted. |
| datetime_updated | date | not null | Datetime stamp at insert time |
| provider_number | integer | not null | Identify if the userid is registered for a single or a dual configuration |
Product Name: AllFusion Change Manager Enterprise Workbench
Table Type: Table