Employee badges

The format is EMP_BADGE_NUMBER~EMPBDG_SUP_LEVEL.

By default, all employee badges are inserted or updated with EMPBDG_SUP_LEVEL=0. If the SUP_LEVEL is different, the related SUP_LEVEL must be specified with an appended tilde (~) symbol. Accepted values are as follows:

• 0: Regular employee.
• 1 and higher: Different supervisor levels (most implementations use one supervisor level).

For example:

12345678~0

When updating, if EMPBDG_SUP_LEVEL is not supplied, the column is not processed.