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	SMALLINT	Yes*	Yes	ALCO_CHARGE_ROLE.CHARGE_ROLE_ACTIVE_STATUS	For checking the status

* System required field

** Value must be unique