Element import - current period

Element Import imports a .TXT or .CSV file into IRIS Cascade Payroll and inputs values against pay elements for processing within that pay period. Customers who have T&A, or other tracking systems, usually use it to record the number of hours employees work, but you can also use it in different circumstances.

There are two accepted formats for the Current Period imports.

File Format One

Element Import accepts information in a simple, set file format of either .txt or .csv. You can create these using a third-party system or manually. File format one allows you to import changes to the Element Input Value only.

The required format is Employee ID, Pay Element Id, Amount, E or D (to indicate an Earning or Deduction).

Each of these fields must be comma-separated in the file.

If you leave column D blank and do not indicate whether the element is an Earning or Deduction, the system assumes that you are importing an Earning element.

There is no specific naming convention required for the import file. The file, once complete, should be saved on your PC or network in a location that is accessible to you.

File Format Two

File format two allows you to import changes to Rate Values for unformulated elements in addition to the Input Value for all other element types. To import against the input value for both formulated rate elements and non-rate elements, the rate value field must be left blank.

The required format is: Employee ID, Pay Element Id, Amount, Rate Value, E or D (to indicate an Earning or Deduction)

Each of these fields must be comma-separated in the file. See examples of file layouts below.

If you leave column D blank and do not indicate whether the element is an Earning or Deduction, the system assumes that you are importing an Earning element.

There is no specific naming convention required for the import file. The file, once complete, should be saved on your PC or network in a location that is accessible to you.