ALEX_EXTERNAL_KEY (Staging table)

Column name	Data type	Required	Default update able	Data target	Comments
BUS_OBJ_TYPE_ID**	INTEGER	Yes*	No	ALCO_EXTERNAL_KEY.BUS_OBJ_TYPE_ID	The BOb type. Example values: 30000 for users, 80000 for project codes
BOB_ID**	INTEGER	No	No	ALCO_EXTERNAL_KEY.BOB_ID	The BOb ID of the object whose external key must be set.
OLD_EXTERNAL_KEY**	VARCHAR (255)	No	N/A	None	The value of the old external key that must be changed.
NEW_EXTERNAL_KEY	VARCHAR (255)	No	Yes	ALCO_EXTERNAL_KEY.EXTERNAL_KEY	The new external key

*System required field

** Combination of (bus_obj_type_id, bob_id, old_external_key) must be unique