ALEX_CHARGE_ROLE (Staging table)
| Column name | Data type | Required | Default updateable | Data target | Comments |
|---|---|---|---|---|---|
| EXTERNAL_KEY** | NVARCHAR (255) | Yes* | No | ALCO_EXTERNAL_KEY.EXTERNAL_KEY | External key - primary key |
| CHARGE_ROLE_NAME | NVARCHAR (255) | No | Yes | ALCO_CHARGE_ROLE.CHARGE_ROLE_NAME | Stores the charge role name |
| CHARGE_ROLE_ACTIVE_STATUS | NUMERIC(5) | Yes* | Yes | ALCO_CHARGE_ROLE.CHARGE_ROLE_ACTIVE_STATUS | For checking the status |
| CHARGE_ROLE_CODE | NVARCHAR(255) | No | Yes | ALCO_CHARGE_ROLE.CHARGE_ROLE_CODE | Stores the charge role code. |
* System required field
** Value must be unique