Field

Description

Version

BREAKID

The break ID

6.5

EMPLOYEE

Employee ID

6.5

AGE

Employee age on the day of the shift

6.5

EXPORTID

Employee Export ID (SEC_NUM from EMP.DBF)

6.5

JOBCODE

Employee Job Code

6.5

DATE

The Date of Business (DOB).

6.5

SYSDATEBEG

The system beginning date

6.5

SYSDATEEND

The system ending date

6.5

PERIOD

Period ID (SuperSite)

6.5

OCCASION

Occasion ID (SuperSite)

6.5

UNIT

The Store number

6.5

SHFT_ID

Shift ID (Note: Same as in ADJTIME)

6.5

SHFT_INHR

Shift Start Hour (Note: Same as in ADJTIME)

6.5

SHFT_INMIN

Shift Start Minutes (Note: Same as in ADJTIME)

6.5

SHFT_OTHR

Shift End Hour (Note: Same as in ADJTIME)

6.5

SHFT_OTMIN

Shift End Minutes (Note: Same as in ADJTIME)

6.5

SHFT_MIN

The shift total worked time represented in minutes (Note: Same as in ADJTIME)

6.5

SHFT_HOURS

Total shift total worked time represented in hours (Note: Same as in ADJTIME)

6.5

SHFT_EDDAT

The date the shift was edited.

6.5

SHFT_EDTIM

The time the shift was edited.

6.5

SHFT_EDMGR

The user’s lastname firstname
EOD will indicate that the shift was ended by the EOD process.

6.5

SHFT_OPEN

Employee was clocked out by the manager or by EOD process?
Y = Employee was clocked out by the manager of by EOD process
N = Employee clocked himself out

6.5

SHFT_CKMGR

The user’s ID who ended the shift.
A NULL value and the SHFT_OPEN = Y, indicates auto-clockout by EOD process.

6.5

BRK_PAID

Is the break paid?
Y = Break is paid according to the break rule
N = Break is unpaid according to the break rule
See PAID in BRKRULE.dbf

6.5

BRK_INVALD

Is the break invalid?
Y = Break is invalid
N = Break is valid

6.5

BRK_EDIT

Was the break edited from the FOH?
Y = Break was edited from FOH
N = Break was not edited form FOH

6.5

BRK_EDMGR

The user’s lastname firstname, same as the MANAGER field in GNDBREAK.
EOD will indicate that the shift was ended by the EOD process.

6.5

BRK_EDDATE

The date the break was edited.

6.5

BRK_EDTIME

The time the break was edited.

6.5

BRK_MINMIN

This is the earned break minutes also known as the minimum break minutes in the Break Rule setting.
See MINBREAK in BRKRDT.dbf

6.5

BRK_INHR

Break Start Hour

6.5

BRK_INMIN

Break Start Minutes

6.5

BRK_OUTHR

Break End Hour

6.5

BRK_OUTMIN

Break End Minute

6.5

BRK_MIN

Total minutes for break duration

6.5

BRK_HOURS

Total break in hours

6.5

BRK_RULEID

Break Rule ID for the break
Note: Same as in BREKRULE.dbf

6.5

BRK_RDTID

Break Rule Detail

6.5

BRK_WAVBLE

Is the break eligible to be waived?
Break Rule is set to Waivable and employee worked inside consensual threshold.
Y/N
Note: Hours worked are between the MINHOURS MAXHOURS in the BRKRDT.dbf

6.5

BRK_WAIVED

0 = BREAKNOTWAIVED: Break is set to “Not waivable”, or break is mandatory and did not prompt to waive.
1 = BREAKAUTOWAIVED                                 
2 = BREAKWAIVED_ATCLOCKIN                        
3 = BREAKWAIVED_ATCLOCKOUT                    
4 = BREAKWAIVED_REFUSED_ATCLOCKIN    
5 = BREAKWAIVED_REFUSED_ATCLOCKOUT 
6 = BREAKWAIVED_NOTPROMPTED            

6.5

BRK_WINMIS

Y = Break Start window is enforced in the break rule and the employee started the break outside the defined and enforced break start window. Or the employee did not take the break. (Defined window was missed).
Employee did not take the break.
N = Break Start window is enforced in the break rule and the employee started the break inside the defined and enforced break start window. Or the Break Start window is NOT enforced. (Defined window was not missed).
Note: The break start window is found in BRKRDT.dbf / WINDSTART and WINDEND

6.5

BRK_PENLTY

Did employee earn a penalty pay?
Y/N
Y = Employee earned a penalty pay
N = Employee did not earn a penalty pay or penalty pay is not applicable
Note that penalty earned would be per shift per Break Rule.

6.5

BRK_COMPL

Y/N
The Yes and No will be based on the following conditions:
YES:

1. BRK_TOTAL = OR > BRK_MINMIN
2. BRK_TOTAL  < BRK_MINMIN and

BRK_WAVBLE = Y and

BRK_WAIVED = 1, 2 OR 3

3. BRK_TOTAL IS GREATER OR EQUAL TO BRK_MINMIN

              And BRK_WINMIS  = Y

              And BRK_WAVBLE = Y

  And BRK_WAIVED = 1, 2 OR 3

4. BRK_TOTAL IS GREATER OR EQUAL TO BRK_MINMIN

              And BRK_WINMIS  = N

              And BRK_WAVBLE  = N

NO:

1. BRK_TOTAL IS LESS THAN BRK_MINMIN

    And BRK_WAVBLE  = N

2. BRK_TOTAL IS LESS THAN BRK_MINMIN

And BRK_WAVBLE  = Y

And BRK_WAIVED DOES NOT = 1, 2 OR 3

3. BRK_TOTAL IS EQUAL OR GREATER THAN BRK_MINMIN

And BRK_WINMIS  = Y

And BRK_WAVBLE  = N

4. BRK_TOTAL IS EQUAL OR GREATER THAN BRK_MINMIN

And BRK_WINMIS  = Y

And BRK_WAVBLE  = Y

And BRK_WAIVED is DIFFERENT THAN 1, 2 OR 3

6.5