Processing manual imports

  1. Select Payroll Administrator > Deduction Maintenance > One Time Deductions > One Time Deduction Import.
  2. From the Actions menu, select Load CSV.
  3. Specify this information:
    CSV Input Data
    Paste standard CSV format data into this field. Only include columns for required values.

    See Creating CSV data for sample data.

    Mapping Source
    This field contains information from LTM_OneTimeDeductionImport_SourceSystem. For example, OneTimeDeduction.
    Run Import
    Select this check box to create OneTimeDeduction records for each import record.
    Purge Completed
    Select this check box to delete the successfully processed import records from the newly created data.
  4. Click Submit.
    EmployeeOneTimeDeductionImport records are populated with provided data from the CSV file. Cross-reference values are located to populate internal key values if data is not also provided.

    Other actions are available for partial processing or error handling:

    • From the Actions menu, select Create All One Time Deductions to load all unprocessed and error records from the specified import group into EmployeeOneTimeDeduction.
      • Use this action when you did not run the import immediately during the Load CSV action.
      • Use this action when some records were in error and the errors have been corrected.

    • On the Error tab or the Not Processed tab, select records. From the Actions menu, select Create Single One Time Deduction to load the records.

      • This action runs in the foreground instead of as an asynchronous background action.
      • Use this action to check one representative record before processing the entire group.

    • From the Actions menu, select Map All Field Values to look up foreign key values and update internal key values. You can also select individual records and then select Map Field Values from the Actions menu.

      • The Map All Field Values action affects all unprocessed records within an import group.
      • Use this action if foreign key values were incorrect and you must reprocess or verify them without fully importing records.
    • From the Actions menu, select Purge Records to delete all records of a specified import status or group.
      • Use this action if the Purge Completed check box was not selected during the Load CSV action.
      • Use this action for unprocessed or erroneous records if the data is corrected in the CSV and reloaded.
    • Right-click a record and select Open or Update to change data for an import record.
      • Use this action to correcting errors in place without returning to the CSV data.
      • Use this action to see more details on the record, such as foreign key values.
    • Click Create to create a new import record without relying on CSV.

      Use this action to create one sample record of data. This data can then be exported from EmployeeOneTimeDeductionImport using dbexport or selecting Administration Console > Database > Export from Database to generate a sample CSV file.

    • Select records and click Delete to delete the selected records.