ALEX_EXTERNAL_USER (Staging table)
| Column name | Data type | Required | Default update able | Data target | Comments |
|---|---|---|---|---|---|
| EMPLOYEE_NUMBER** | VARCHAR (255) | Yes* | No | ALCO_EXTERNAL_USER.USER_ID | Employee number |
| PARTNER_NAME** | VARCHAR (255) | Yes* | No | ALCO_EXTERNAL_USER.PARTNER_ID | Name of partner identifying external system |
| EXT_USER_LOGIN | VARCHAR (255) | Yes | Yes | ALCO_EXTERNAL_USER.EXT_USER_LOGIN | User login ID for external system |
| EXT_PASSWORD | VARCHAR (255) | No | Yes | ALCO_EXTERNAL_USER.EXT_PASSWORD | User password for external system |
| ACTIVE_STATUS | SMALLINT | Yes* | Yes | ALCO_EXTERNAL_USER.ACTIVE_STATUS | Determines whether the external user data is active.
|
* System required field
** Combination of (employee_number, partner_name) must be unique