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