TBL: PRIME - Premiums

PRIME (premiums) table

CONTAINS: Premiums

LENGTH: Up to 8 characters.

USED: On TIMEDT (Attendance Detail) records in T_OPT field.

On JOBHIST (Employment history) records in H_PRIME field (multiple choice)

SUPPLEMENTARY INFO

TBLC1 - DESTINATION.

Up to 2 characters. The destination is copied to the T_DEST field on TIMEDT whenever a TIMEDT record is created.

It may contain first a digit 1-9 representing the time bank 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 absence is a paid absence (implies a bank withdrawal), and indicates to the net pay system that the absence is paid. (There might be unpaid absences you want to track.)

W The hours or amount is WITHDRAWN from the time bank, 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.

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)