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