Accrual Adjustment Import

From sbv.wiki
Revision as of 15:49, 4 January 2021 by Stage (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

The accrual adjustment import adds an adjustment to the accrual balance.

An accrual adjustment import is identified by the sheet name or file name containing the words "Accrual Adjustment".

Column Type Identifiers Notes Required
Employee ID Employee ID, Emp ID, ID This is used to uniquely identify the employee. With a multi-facility configuration you must also provide the Facility column. Yes
Accrual Pay Type / Hours Accrual Pay Type ID The column header identifies the accrual pay type. The data in each row represents the starting balance for the accrual pay type. To import into Bank 2, add a " 2" to the column header, e.g. "SICK 2". Yes
Pay Date Date, Pay Date Yes
Adjustment Type Type Values for this column could be any of these 4 adjustment types with the necessary identifier in quotes. Starting-Balance: "balance", Hours Earned: "earned", Hours Used: "used" and Maximum Balance: "maximum". Yes
Note Note No

See also