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