Earnings tables

Earnings code are split into 5 different tables in TBL.

• AMTOPT (this table) : Payment without hours, such as a bonus amount
• TIMEOPT : Hours worked, paid or banked
• ABSENCE : 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

SUPPLEMENTARY INFO

::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 amount is paid to the employee. If preceeded by a number (time bank ID), it implied are hours are taken from the time bank

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

• D - The hours or amount is 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 amount is ACCRUED (added to the Accrual bucket) , for use next year

• B - The hours or amount is 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 and not related to any time bank.

TBLC2 - AMOUNT.

A fixed amount or "~" followed by an expression, which will be used to fill the amount field on attendance detail when a new transaction is added.

If this field is empty, there is no default calculation.

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 - TAXABLE

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)