How to Create/Import Timesheet & Absence Files for the K212 HRP Web Tables

This process will read an SFE ‘Job Information’ file and create an Hourly Timesheet file, a Daily Timesheet file and an Absence file in a format suitable for importing into K212 HRP.  It will then optionally (based on the parameters selected before submitting) import the Hourly Timesheets, Daily Timesheets and/or Absence Transactions into the Web tables in K212 HRP.

•The Import Profiles SFE_HRLY, SFE_DLY and SFE_ABS are required to perform these imports.  These profiles are created automatically during installation of K212 HRP and should not be modified (re: Board Control > General Tables > Import Profile Maintenance).

This information is used by the SmartFindExpress Job Translation process when importing timesheets and absences from the SmartFindExpress Job Information file.

Use the following steps to Create/Import Timesheet & Absence Files for the K212 HRP Web Tables:

          1. Click on System

          2. Click on SmartFindExpress Interface

          3. Click on SmartFindExpress Job Translation

          4. Select a Use Default File?  value (i.e Yes)

                              IF Selected Yes, Select a SmartFindExpress Job Information File Name location

          5. Select a Import Hourly Timesheet? value

          6. Select a Submit Mode value (i.e Trial)

                              Selecting 'Trial' mode will generate a test document of all updated records when submitted, but will not actually update the records within the database until submitted in 'Update' Mode.

          7. Select a Import Daily Timesheet? value

          8. Select a Submit Mode value (i.e Trial)

                              Selecting 'Trial' mode will generate a test document of all updated records when submitted, but will not actually update the records within the database until submitted in 'Update' Mode.

          9. Select a Import Absences? value

          10. Select a Submit Mode value (i.e Trial)

                              Selecting 'Trial' mode will generate a test document of all updated records when submitted, but will not actually update the records within the database until submitted in 'Update' Mode.

          11. Select a Use Substitute GL Account?  value (i.e No)

                              IF Selected Yes, Select a Substitute GL Account value

          12. Select a Create Timesheet Even If Absence Has Error? value

          13. Select a Create Absence Even If Timesheet Has Error? value

          14. Select a SmartFindExpress Location Code Mapping value

          15. Select a Choose Random Position? value

          16. Click on the Submit button to generate the file. (The file will be generated at the default logfile location)