Staging table alex_external_key

External keys for any data type can be specified in the system using the alex_external_key staging table. For more information, see Standard External Key Import table. Often, this is convenient to generate the external key from one or more of the other columns. You can then use SQL to generate the key and populate the staging table.

As an example, consider Timesheet profile. A good choice for timesheet profile external key is the code column. This Oracle SQL statement demonstrates usage of external key in the code column:

insert into alex_external_key (bus_obj_type_id, bob_id, new_external_key) select 56700, ts_profile_id, ltrim(rtrim(code)) from alts_timesheet_profile;

For additional sample SQL, see Sample SQL for generating external keys.