Earnings tables

Earnings code are split into 5 different tables in Umana kept 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 are 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 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. % at the end of a number means of percentage of the normal (base) rate

• at the beginning means ADD the value here to the normal rate, or add 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

  means that what follows is an expression. The expression has access to variable including lnBASERATE and lnHOURS.

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

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

SEE ALSO

TBL: TIMEOPT - Hours Worked TBL: ABSENCE - Absence reasons TBL: AMTOPT - Amount pay options TBL: PRIME - Premiums TBL: MISCBANK - Misc Bank Adjustments TBL: DEDSTAT - Statutory Deductions