1. Open Visual Integrator, Main menu, Import Job Maintenance and enter a desired Job Name
   • Example: PR_IMPORT or PAYROLL
2. For Table Name, use the lookup to select PR.DATAENT
3. Click Accept
4. Click Yes when prompted with "Is this a new Job?"
5. For Description, enter a brief description of the import job if desired (optional)
6. For File Type, select a file type
   • Note: Delimited is most common and simplest to work with, with Comma as the default delimiter
7. For Import File, click the Browse button to select the source (file) to be imported from
8. Select the "Header Information Included in Detail Line" check box if the Import File contains employee numbers and hours on the same record
   • Note: This is most common format of source files
9. Access the Data tab and enter all required fields
   • To determine required fields, refer to the attached document "How to determine required fields for Legacy import jobs"
10. Some fields may not be in the Import File, so they may either need to be calculated, assigned or file assigned. For example, EARNING_TYPE can be file assigned to the field TYPE_OF_EARNING from the file PR.EARN
11. RATE for hourly employees may use the following calculation:
    • {PR.EMPL:PAY_RATE1}*{PR.EARN:PAY_RATE_MULTIP}
12. RATE for salary employees may use the following calculation if salary is stored in Pay Rate 1 field:
    • PRC(PR.EMPL:PAY_RATE1}/80,3)
13. If importing for both Salary and Hourly Employees, then a condition will be needed for the 2 different Rate fields:
    • For Hourly Employees, use the condition {PR.EMPL:PAY_METHOD}="H"
    • For Salary Employees, use the condition {PR.EMPL:PAY_METHOD}="S"
14. AMOUNT can have the following calculation:
    • PRC({PR.DATAENT:RATE}*{PR.DATAENT:HOURS_RECPT_AMT},2)
15. Select the Records tab and define the type of records that are being imported.
16. • Line Type E for Earning records
      • De-select Perform Logic Only
      • Enter values for Field, Start and Length so that it knows what records in the sourcefile are Earnings records.
        • If all records in sourcefile are earnings records and the first position has a value, set Field=1, Start=1, Length=1, Relation = Not Equal (<>), Value= (leave blank)
    • Line Type D for Deduction records