TBL: MISCBANK - Misc Bank Adjustments

MISCBANK table

CONTAINS: Miscellaneous pay codes. Particularly time bank deposits

LENGTH: Up to 8 characters.

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

SUPPLEMENTARY INFO

TBLC1 - DESTINATION.

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 time bank entitlement deposits

A - The hours or amount is DEPOSITED into the RESERVE (next year's) bank balance. This is used primarily for vacation entitlements when the vacation is deposited this year for use next year only.

B - The hours or amount is WITHDRAWN from the RESERVE (next year's) bank balance. Primarily used to pay out of next year's bank when an employee is terminated.

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

A = 1-letter code indicating if these transactions have hours or just dollars

H = Hours (and dollars)
D = Dollars only

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)