Configure the Payroll Import for Healthcare Productivity

Caution: Import integrations accept only UTF-8 encoded input files.

Note: Multiple files are not supported for this integration, that is, it can run only one file at a time from the SFTP server.

• EMP_NBR (Required): Employee Number

  Must be unique across all payroll source files from which data is loaded. Example: 54321

  Data type: Character

  Maximum length: 15

• EMP_NAM (Optional but helpful for validation or troubleshooting): Employee Name

  Example: LastName, FirstName

  Data type: Character

  Maximum length: 70

• HM_FCLTY_COD (Required): Home Facility Code

  Employee's work location based on the business structure

  Example: Fac_1

  Data type: Character

  Maximum length: 50

• HM_DEPT_COD (Required): Home Department Code

  Must contain a distinct value for each employee and pay period combination. Example: Dept_01

  Employee's department code based on the business structure; you can map the department to the Cost Center and level.

  Data type: Character

  Maximum length: 50

• JOB_COD (Required): Job Code

  Examples: RN, CN

  Data type: Character

  Maximum length: 50

• STD_HRS (Required): Standard Hours Non-overtime hours that each employee is expected to work. for the pay period

  Cannot be empty; must contain a distinct value for each employee and pay period combination.

  If this field does not apply to a record, use 0 for the value.

  Example: The number of hours the employee was hired for a pay period. Typically for a biweekly pay period, the standard hours for a full time employee is 80 hours.

  Maximum length: 20 digits.

  Data type: Number(16:6)

  Maximum:

  • 10 digits before the decimal

    and

  • 6 digits after the decimal

    Caution: If the imported data contains more than 6 digits after the decimal, an exception occurs and an error message is shown.

    Note: If the imported data contains 3 to 6 digits after the decimal, the data is valid. If you open the file in Excel, you may not see all of the decimal values. Instead, open the file in Notepad to confirm that the actual values were imported.

• PAYROLL_EMPLMT_STAT_COD (Required): Payroll Employment Status Code

  Examples: FT, PT

  Data type: Character

  Maximum length: 30

• PAY_RATE_AMT (Required): Pay Rate

  Cannot be empty.

  If this field does not apply to a record, use 0 for the value.

  Data type: Number(16:6)

  Maximum:

  • 10 digits before the decimal

    and

  • 6 digits after the decimal

    Caution: If the imported data contains more than 6 digits after the decimal, an exception occurs and an error message is shown.

    Note: If the imported data contains 3 to 6 digits after the decimal, the data is valid. If you open the file in Excel, you may not see all of the decimal values. Instead, open the file in Notepad to confirm that the actual values were imported.

• FCLTY_COD (Required): Worked Facility Code

  Example: Fac_3

  Data type: Character

  Maximum length: 50

• DEPT_COD (Required): Worked Department Code

  Example: Dept_02

  Data type: Character

  Maximum length: 50

• PAYROLL_PAYCD (Required): Payroll Paycode

  Examples: REG, OT

  Data type: Character

  Maximum length: 32

• PAYROLL_PAYCD_HRS (Required): Payroll Paycode Hours

  Cannot be empty.

  If this field does not apply to a record, use 0 for the value.

  Data type: Number(16:6)

  Data type: Number(16:6)

  Maximum:

  • 10 digits before the decimal

    and

  • 6 digits after the decimal

    Caution: If the imported data contains more than 6 digits after the decimal, an exception occurs and an error message is shown.

    Note: If the imported data contains 3 to 6 digits after the decimal, the data is valid. If you open the file in Excel, you may not see all of the decimal values. Instead, open the file in Notepad to confirm that the actual values were imported.

• PAYROLL_PAYCD_AMT (Required): Payroll Paycode Amount

  Cannot be empty.

  If this field does not apply to a record, use 0 for the value.

  Data type: Number(16:6)

  Data type: Number(16:6)

  Maximum:

  • 10 digits before the decimal

    and

  • 6 digits after the decimal

    Caution: If the imported data contains more than 6 digits after the decimal, an exception occurs and an error message is shown.

    Note: If the imported data contains 3 to 6 digits after the decimal, the data is valid. If you open the file in Excel, you may not see all of the decimal values. Instead, open the file in Notepad to confirm that the actual values were imported.

• ASSGND_SHIFT_NAM (Optional): Assigned Shift Name

  Examples: DAY, EVE, NIGHT

  Data type: Character

  Maximum length: 50

• PRI_JOB_COD (Required): Primary Job Code

  Must contain a distinct value for each employee and pay period combination.

  Examples: RN, CN

  Data type: Character

  Maximum length: 50

• HIRE_DAT (Optional): Employee Hire Date

  Data type: Date

  Use the format MM-DD-YYYY.

  Maximum length: n/a

• TERM_DAT (Optional): Employee Termination Date

  Data type: Date

  Use the format MM-DD-YYYY.

  Maximum length: n/a

• PPEND_DAT (Required): Pay Period End Date

  Data type: Date

  Use the format MM-DD-YYYY.

  Maximum length: n/a

• SRC_COD (Required): Payroll Source Code

  Must be a unique code that identifies the payroll source file.

  Data type: Character

  Maximum length: 40

Note: For detailed instructions and use cases, see the Run and Test Integrations for Healthcare Productivity topic > Payroll Import section.

1. Select Main Menu  > Maintenance > Integrations.
2. Click Tap Run an Integration . 
3. Select the Payroll Import integration. Click Tap Select.