Employee badges
When importing these fields, the format is:
EMP_BADGE_NUMBER~EMPBDG_SUP_LEVEL~EMPBDG_ENABLE_BIO~EMPBDG_ENFORCE_SKD
Supervisor level
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.
Enable Biometrics
By default, all employee badges are inserted or updated with EMPBDG_ENABLE_BIO=N.
Accepted values are:
- Y: Enable biometrics
- N: Disable biometrics (default value)
Enforce Schedule
By default, all employee badges are inserted or updated with EMPBDG_ENFORCE_SKD=N.
Accepted values are:
- Y: Enforce schedule
- N: Do not enforce schedule (default value)
Employee Badge User Defined Fields
Use the EMP_BADGE_UDF field to assign user defined badge values to an employee badge.
The default value for the UDFs is null.
Separate each EMP_BADGE_UDF field with the tilde symbol (~
).
This table lists the specifications for the EMP_BADGE_UDF field. This field is optional.
Input Value | Field Name | Type | Size | Description |
---|---|---|---|---|
{UDF[1..5]} | EMP_BADGE_UDF [1..10] | Varchar | 40 | UDF fields, 1 through 5. An ampersand ( A percentage
( |
Employee Badge Flags
Use the EMP_BADGE_FLAG field to assign user defined badge flags to an employee badge.
The default value for the UDFs is null.
Separate each EMP_BADGE_FLAG field with the tilde symbol (~
).
This table lists the specifications for the EMP_BADGE_FLAG field. This field is optional.
Input Value | Field Name | Type | Size | Description |
---|---|---|---|---|
{FLAG[1..5]} | EMP_BADGE_FLAG[1..10] | Varchar | 1 | Flag fields, 1 through 5 Accepted values:
A percentage ( |