Network Management

Power and Cabling

Interfaces

Data Security

eAlerts

IT Services

Home

Aloha AdjTime.dbf and ADJTIMEX.DBF Grind File Contents

Shift data is stored in the ADJTIME.DBF, but ADJTIMEX.DBF exists in the dated folder if a shift from this day was edited, added or deleted.  ADJTIMEX.DBF is copied to ADJTIME.DBF during the next End-of-Day (EOD) process.

Field

Description

Version

EMPLOYEE

Employee ID

-

SHIFT_ID

Employee shift number for the day.  For example, the first time the clock-in for the day is shift one, the second time they clock-in for the same day is shift two, and so on.

-

INVALID

TRUE if this shift has been discarded

-

SSN

Social Security Number

-

DATE

Date Of Business

-

SYSDATEIN

System date at clock-in

5.3.21e

SYSDATEOUT

System date at clock-out

5.3.21e

JOBCODE

Job code ID

-

INHOUR

Clock-in hour

-

INMINUTE

Clock-in minute

-

OUTHOUR

Clock-out hour

-

OUTMINUTE

Clock-out minute

-

MINUTES

Total minutes (including overtime)

-

HOURS

Total hours (including overtime)

-

RATE

Pay rate

-

PAY

Total pay for shift (including overtime)

-

OVERMIN

Overtime minutes

-

OVERHRS

Overtime hours

-

OVERRATE

Overtime rate

-

OVERPAY

Overtime pay

-

DRIVERFEES

Earned delivery fees

-

CCTIPS

Credit card tips (less any reductions, tip refund)

-

DECTIPS

Declared tips (cash and charge tips less tipshare)

-

SALES

Tippable gross sales closed by server

-

SALESIN

Tippable gross sales closed by server, rung by someone else

-

SALESOUT

Tippable gross sales rung by server, closed by someone else

-

NOTIPSALES

Non-tippable gross sales closed by server

-

MANAGER

Employee Name who created, edited, or deleted the shift

-

PAIDBRK

Paid break minutes

-

PAIDBRKHRS

Paid break hours

-

PAIDBRKPAY

Paid break wages

-

UNPAIDBRK

Unpaid break minutes

-

UNPDBRKHRS

Unpaid break hours

-

UNPBRKPAY

Unpaid break time

-

TIPPED

TRUE if shift was tipped

-

SEEN

TRUE if changes have been reported to employee

-

REGOVMIN

Regular overtime minutes

-

REGOVHRS

Regular overtime hours

-

REGOVPAY

Regular overtime pay

-

DAYOVMIN

Daily overtime minutes

-

DAYOVHRS

Daily overtime hours

-

DAYOVPAY

Daily overtime pay

-

PUNCH_ID

Edited punch unique id

-

UNIT

Unit ID (from the ALOHA.INI)

-

OCCASION

Event ID (SuperSite)

-

STARTMILES

Driver starting miles

-

ENDMILES

Driver ending miles

-

DLVRUNS

Delivery runs

-

DLVORDERS

Delivery orders

-

DLVSALES

Delivery sales

-

CCTIPSALES

Tippable credit card sales

5.2

VIZOR

Total employee contribution to VizorVest program

5.2

REASON

Edit punch reason ID

5.2

TOTCCSLS

Total credit card Sales (after shift edit)

5.2

TNOCSHSLS

Total non-cash sales (after shift edit)

5.2

TNOCSHTIP

Total non-cash tips (after shift edit)

5.2

TIPREFUND

Tip Refund (after shift edit)

5.2

TIPSHCON

Tip share contribution (after shift edit)

5.2

AUTGRTTOT

Total automatic gratuity (after shift edit)

5.2

GROSSTXIN

Gross cash in (after shift edit)

5.2

GROSSTXOUT

Gross cash out (after shift edit)

5.2

GROSSSLS

Gross sales (after shift edit)

5.2

NOOFCHECK

Number of checks (after shift edit)

5.2

NOOFGUEST

Number of guests (after shift edit)

5.2

TOTCOMP

Total comps for employee (after shift edit)

5.2

TOTPROMO

Total promo amount for employee (after shift edit)

5.2

SPECTNDR

Special tender Amount

5.2

MGRNUMBER

Employee ID who created, edited, or deleted the shift

5.2

NOVTBKMIN

Number of minutes on a Paid Meal Break not counting towards Overtime

5.3.25e

NOVTBKHR

Number of hours on a Paid Meal Break not counting towards Overtime

5.3.25e

NOVTBKPY

Pay amount

5.3.25e

EDITDATE

System Date a Punch Edit occurred

5.3.24e

EDITTIME

System Time a Punch edit occurred

5.3.24e

WAIVEBREAK

Waive response made by employee

  • 0 – break is not waived
  • 1 – break is automatically waived
  • 2 – break waived at clock-in
  • 3 – break waived at clock-out
  • 4 – break waived refused at clock-in
  • 5 – break waived refused at clock-out
  • 6 – screen timeout occurred while break waive dialog was up at clock-in
  • 7 – screen timeout occurred while break waive dialog was up at clock-out

6.1

BRKVIOLATD

Employee qualification of penalty pay based on break rules

  • 0 – no break rule violation
  • 1 – employee was scheduled for this shift and earned penalty pay without a manager involvement
  • 2 - employee was scheduled for this shift and earned penalty pay with a manager involvement
  • 3 – employee was scheduled for this shift and waived penalty pay without a manager involvement
  • 4 - employee was scheduled for this shift and waived penalty pay with a manager involvement
  • 5 – employee was not scheduled for this shift but earned penalty pay without a manager involvement
  • 6 - employee was not scheduled for this shift but earned penalty pay with a manager involvement
  • 7 - employee was not scheduled for this shift and waived penalty pay without a manager involvement
  • 8 - employee was not scheduled for this shift and waived penalty pay with a manager involvement

6.1

SCHEDULIN

Employee schedule in time if Labor Scheduler is active

6.1

SCHEDULOUT

Employee schedule out time if Labor Scheduler is active

6.1

OUTMGR

Manager ID approving declared tips that are less than the calculated Tip Threshold

6.1

TIPSTHRESH

Calculated Tip Threshold

6.1

DECCASHTIP

Cash declared tips (Cash tips declared by the employee at clock out)

6.5

 

Abacus. You can count on us.

 

          » Abacus Business Solutions  »  15301 Roosevelt Blvd.  »  Suite 303  »  Clearwater, FL 33760  »  Tel: (727) 524-0177  »  Fax: (727) 524-0188