Earnings tables

Earnings code are split into 5 different tables kept in TBL.

• AMTOPT : Payment without hours, such as a bonus amount
• TIMEOPT : Hours worked, paid or banked
• ABSENCE (this table): Absences, paid or unpaid. Possibly from a time bank
• PRIME : Premiums.
• MISCBANK : Miscellanous codes, not usually paid, such as time bank entitlements

These codes, as well as DEDSTAT and BPLAN codes, are Pay codes, used in the gross pay (TIMEDT) and net pay (PAYDT) tables

ADDITIONAL INFO tab

TBLC1 - DESTINATION.

The destination is copied to the T_DEST field on TIMEDT whenever a TIMEDT record is created. Click the [...] button for a builder.

It may contain one or two digits representing the time BANKID to be added to or subtracted from.

Following the bank number (if any) add the letter to indicate the action: P=Paid, D=Deposit, W=Withdrawal.

• P - The hours or amounts are paid to the employee. If proceeded by a number (time bank ID), it implies the are hours are taken from the time bank

• W - The hours or amounts are WITHDRAWN from the time bank (but not paid to the employee), reducing its balance.

• D - The hours or amounts are DEPOSITED to the time bank, increasing it balance. This is used primarily for hours worked and deposited into an overtime bank.

• A - The hours or amounts are ACCRUED (added to the Accrual bucket) , for use next year

• B - The hours or amounts are subtracted from the ACCRUED amount.

EXAMPLES

• P - Paid absence not related to any time bank.
• 1P - Paid and withdrawn from time bank 1 (increases TS_TAKEN)
• 1W - Withdrawn from time bank 1 (increases TS_TAKEN) but not paid
• (blank) Unpaid absence not related to any time bank.

TBLC2 - RATE.

The rate hour at which this code is paid. A fixed rate, a percentage (e.g. 150%), or an expression:

Certain codes in this field have special meanings:

'' (Blank) Use the employee's base rate from JOBHIST. If this is paid from a bank, use the base rate for this bank.

% at the end of a number means a percentage of the normal (base) rate

• at the beginning means ADD the value here to the normal rate, or add to the percentage

• at the beginning means SUBTRACT the value here from the normal rate, or subtract from the percentage

• means that what follows is the key to an entry in the RATE table. Since the rate table is dated, it uses the transactiion date

  (tilde followed by nothing) No calculated rate. Do not calculate retro on this code. Do not attempt to correct rate.

  (tilde followed by an expression) The expression is evaluated to obtain the hourly rate. The expression has access to variables like lnBASERATE and lnHOURS and fields JOBHIST.H_xxx

EXAMPLE

Suppose RATE = 150%, DESTINATION = "1P", and the person is absence 4 hours. Then he will be paid for 4 hours at time and a half. Only 4 hours will be deducted from his time bank.

TBLC3 - TRANCD.

The transaction code used when sending this kind of absence to an external payroll system. If the absence is unpaid and does not need to be transmitted to the bank, leave this field blank. Not used for Carver internal net pay

TBLC4 - G/L accounts.

You can put one or two GL accounts here, separated by commas. The first is the account to DEBIT (the expense account). The second is an optional account to CREDIT. This field is normally left blank. (This is the opposite of BPLAN and DEDSTAT GL-accounts)

TIMESHEET CONTROL

TBLC5 - TIMESHEET FILTER CONDITION.

A filter which limits which employees see this code on their timesheet. If empty, all employee will see this code.

EXAMPLE

inlist(pers.E_PSTAT, "PERM", "PERMA")

TBLC8 - TIMESHEET CONTROL CODES. Various characters which indicate how this code appears on timesheets.

• If the field is empty, the code does not appear at all
• A digit (1-5) indicates which column it is totalled into on the manager's pages
• A number sign (#) indicates it is considered as regular time, as opposed to overtime. Most absences should be treated as regular time.

CARVER NET PAY CONTROL

TBLM1 - APPLICABLE TAXES

A set of statutory deductions (from the DEDSTAT table) which apply to this pay code

TBLM2 - TAX CALC METHOD

• Blank = regular method, used for most pay codes
• ANNUAL - use the ANNUAL calculation method
• LUMPSUM - use the LUMPSUM methods (percentage of amount)