Run and Test Integrations for Healthcare Productivity

Uruchom integracje, aby sprawdzić, czy konfiguracja jest prawidłowa.

  • The source files must be in comma-separated values (CSV) format. Any other format fails the integrations.
  • When input parameters are incorrect, the integration fails.
  • When files are missing or fail, the integration fails.
  • Integrations cannot run simultaneously but only one at a time.

Test the integrations

Run each integration to test that the configuration is correct.

Uwaga: Only for integrations that have import and export versions, you can run the import integration, then run the corresponding export integration to check the output file and make sure that the import processed the records correctly. Example: Run Work Unit Work units (WU) define departments, work groups, and combine business structure nodes or jobs into single entities for productivity analysis. All Healthcare Analytics reports require work units. Import, then run Work Unit Export and check the output file.

  1. Select Main Menu  > Maintenance > Integrations. 
  2. Kliknij Dotknij Run an Integration . 
  3. Select the Work Unit Import integration. Kliknij Dotknij Select.
  4. (Optional) Enter a unique Integration Run Name to make it easier to identify the run of the integration. Otherwise, the default name ends with a date and time stamp.

    Example: For test runs, it can be helpful to change the filename.

  5. (Not recommended) You can select a different source file. Kliknij Dotknij Browse and navigate to and select the file.

    Przestroga :
    • (Required) Upewnij się, że tylko jeden Plik o tej nazwie znajduje się jednocześnie na serwerze SFTP. W przeciwnym razie dane mogą zostać uszkodzone.
    • For scheduled runs of the integration, do not select a different source file. The default file was generated from the installation kit, and a scheduled integration cannot run without it.
    • For manual runs of the integration, you must enter the complete filename of the source file. Otherwise if the Inbound folder contains multiple files, the integration cannot distinguish which source file is the correct file to process.
    • The maximum size of source file is 1 MB. However, you can compress a larger file and select the compressed *.zip file as the source file.
    • The format of the file must be .csv, .zip, .pgp, or .gpg.

  6. Select the following:

    • Run Integration: If this is the first time this integration is being run.
    • Re-Run: If this integration has been run before, and the status is not In-Progress, you can run the integration again without entering the parameter settings again. (missing or bad snippet)Yes to run the integration with the previous parameter settings, or No to edit the parameters for this run.

    Wait for the confirmation that the integration completed  or failed . Close the panel.

    Kliknij Dotknij Refresh . 

    To see details, select the integration run. Select Run Summary.

  7. When the integration run starts and when it finishes, notifications go to the Control Center and by email.
  8. If the integration run failed , check for errors in the following:
    • Each Work Unit Code and Work Unit Name is unique.
    • The Work Unit Code cannot be longer than 50 characters.
    • The Work Unit Name cannot be longer than 256 characters.
    • The organizational path in the work unit configuration must correspond to a path in the business structure.
    • The default Service Line is UNK_SVC_LN.
    • FTE Hours has 6 decimal places or less.
    • Each WFD Pay Rule is defined in the database.
    • Work Group Code is optional even if the Work Unit Type is a work group.
    • For errors that are common to all integrations; see Check the results > Troubleshooting.
Uwaga:

The maximum size of a cross-reference table is 1 MB or 10,000 rows.

Examples: You cannot download a table that is larger than 1 MB and has fewer than 10,000 rows; or that is smaller than 1 MB but has more than 10,000 rows.

  1. Select Main Menu  > Maintenance > Integrations. 
  2. Kliknij Dotknij Run an Integration . 
  3. Select the Work Unit Export integration. Kliknij Dotknij Select.
  4. (Optional) Enter a unique Integration Run Name to make it easier to identify the run of the integration. Otherwise, the default name ends with a date and time stamp.

  5. Select the following:

    • Run Integration: If this is the first time this integration is being run.
    • Re-Run: If this integration has been run before, and the status is not In-Progress, you can run the integration again without entering the parameter settings again. (missing or bad snippet)Yes to run the integration with the previous parameter settings, or No to edit the parameters for this run.

    Wait for the confirmation that the integration completed  or failed . Close the panel.

    Kliknij Dotknij Refresh . 

    To see details, select the integration run. Select Run Summary.

    See Check the results.

  6. When the integration run starts and when it finishes, notifications go to the Control Center and by email.
  7. Make sure that the exported data corresponds to the source data:
    1. Open the source (input) and exported (output) files.
    2. Compare the data for accuracy.
  1. Select Main Menu  > Maintenance > Integrations. 
  2. Kliknij Dotknij Run an Integration . 
  3. Select the Work Unit Hyperfinds Import integration. Kliknij Dotknij Select.
  4. (Optional) Enter a unique Integration Run Name to make it easier to identify the run of the integration. Otherwise, the default name ends with a date and time stamp.

  5. (Not recommended) You can select a different source file. Kliknij Dotknij Browse and navigate to and select the file.

    Przestroga :
    • (Required) Upewnij się, że tylko jeden Plik o tej nazwie znajduje się jednocześnie na serwerze SFTP. W przeciwnym razie dane mogą zostać uszkodzone.
    • For scheduled runs of the integration, do not select a different source file. The default file was generated from the installation kit, and a scheduled integration cannot run without it.
    • For manual runs of the integration, you must enter the complete filename of the source file. Otherwise if the Inbound folder contains multiple files, the integration cannot distinguish which source file is the correct file to process.
    • The maximum size of source file is 1 MB. However, you can compress a larger file and select the compressed *.zip file as the source file.
    • The format of the file must be .csv, .zip, .pgp, or .gpg.

  6. Select the following:

    • Run Integration: If this is the first time this integration is being run.
    • Re-Run: If this integration has been run before, and the status is not In-Progress, you can run the integration again without entering the parameter settings again. (missing or bad snippet)Yes to run the integration with the previous parameter settings, or No to edit the parameters for this run.

    Wait for the confirmation that the integration completed  or failed . Close the panel.

    Kliknij Dotknij Refresh . 

    To see details, select the integration run. Select Run Summary.

  7. When the integration run starts and when it finishes, notifications go to the Control Center and by email.
  8. If the integration run failed , check for errors in the following:
    • For errors that are common to all integrations; see Check the results > Troubleshooting.
  1. Select Main Menu  > Maintenance > Integrations. 
  2. Kliknij Dotknij Run an Integration . 
  3. Select the Work Unit Hyperfinds Export integration. Kliknij Dotknij Select.
  4. (Optional) Enter a unique Integration Run Name to make it easier to identify the run of the integration. Otherwise, the default name ends with a date and time stamp.

  5. Select the following:

    • Run Integration: If this is the first time this integration is being run.
    • Re-Run: If this integration has been run before, and the status is not In-Progress, you can run the integration again without entering the parameter settings again. (missing or bad snippet)Yes to run the integration with the previous parameter settings, or No to edit the parameters for this run.

    Wait for the confirmation that the integration completed  or failed . Close the panel.

    Kliknij Dotknij Refresh . 

    To see details, select the integration run. Select Run Summary.

    See Check the results.

  6. When the integration run starts and when it finishes, notifications go to the Control Center and by email.
  7. Make sure that the exported data corresponds to the source data:
    1. Open the source (input) and exported (output) files.
    2. Compare the data for accuracy.
  1. Select Main Menu  > Maintenance > Integrations. 
  2. Kliknij Dotknij Run an Integration . 
  3. Select the Work Unit Hyperfind Wyszukiwarka, która filtruje i wybiera grupy pracowników przy użyciu zapytań określających warunki lub lokalizacje (kryteria). Profiles Import integration. Kliknij Dotknij Select.
  4. (Optional) Enter a unique Integration Run Name to make it easier to identify the run of the integration. Otherwise, the default name ends with a date and time stamp.

  5. (Not recommended) You can select a different source file. Kliknij Dotknij Browse and navigate to and select the file.

    Przestroga :
    • (Required) Upewnij się, że tylko jeden Plik o tej nazwie znajduje się jednocześnie na serwerze SFTP. W przeciwnym razie dane mogą zostać uszkodzone.
    • For scheduled runs of the integration, do not select a different source file. The default file was generated from the installation kit, and a scheduled integration cannot run without it.
    • For manual runs of the integration, you must enter the complete filename of the source file. Otherwise if the Inbound folder contains multiple files, the integration cannot distinguish which source file is the correct file to process.
    • The maximum size of source file is 1 MB. However, you can compress a larger file and select the compressed *.zip file as the source file.
    • The format of the file must be .csv, .zip, .pgp, or .gpg.

  6. Select the following:

    • Run Integration: If this is the first time this integration is being run.
    • Re-Run: If this integration has been run before, and the status is not In-Progress, you can run the integration again without entering the parameter settings again. (missing or bad snippet)Yes to run the integration with the previous parameter settings, or No to edit the parameters for this run.

    Wait for the confirmation that the integration completed  or failed . Close the panel.

    Kliknij Dotknij Refresh . 

    To see details, select the integration run. Select Run Summary.

  7. When the integration run starts and when it finishes, notifications go to the Control Center and by email.
  8. If the integration run failed , check for errors in the following:
    • For errors that are common to all integrations; see Check the results > Troubleshooting.
  1. Select Main Menu  > Maintenance > Integrations. 
  2. Kliknij Dotknij Run an Integration . 
  3. Select the Work Unit Hyperfind Profiles Export integration. Kliknij Dotknij Select.
  4. (Optional) Enter a unique Integration Run Name to make it easier to identify the run of the integration. Otherwise, the default name ends with a date and time stamp.

  5. Select the following:

    • Run Integration: If this is the first time this integration is being run.
    • Re-Run: If this integration has been run before, and the status is not In-Progress, you can run the integration again without entering the parameter settings again. (missing or bad snippet)Yes to run the integration with the previous parameter settings, or No to edit the parameters for this run.

    Wait for the confirmation that the integration completed  or failed . Close the panel.

    Kliknij Dotknij Refresh . 

    To see details, select the integration run. Select Run Summary.

    See Check the results.

  6. When the integration run starts and when it finishes, notifications go to the Control Center and by email.
  7. Make sure that the exported data corresponds to the source data:
    1. Open the source (input) and exported (output) files.
    2. Compare the data for accuracy.
  1. Select Main Menu  > Maintenance > Integrations. 
  2. Kliknij Dotknij Run an Integration . 
  3. Select the Work Group Import integration. Kliknij Dotknij Select.
  4. (Optional) Enter a unique Integration Run Name to make it easier to identify the run of the integration. Otherwise, the default name ends with a date and time stamp.

  5. (Not recommended) You can select a different source file. Kliknij Dotknij Browse and navigate to and select the file.

    Przestroga :
    • (Required) Upewnij się, że tylko jeden Plik o tej nazwie znajduje się jednocześnie na serwerze SFTP. W przeciwnym razie dane mogą zostać uszkodzone.
    • For scheduled runs of the integration, do not select a different source file. The default file was generated from the installation kit, and a scheduled integration cannot run without it.
    • For manual runs of the integration, you must enter the complete filename of the source file. Otherwise if the Inbound folder contains multiple files, the integration cannot distinguish which source file is the correct file to process.
    • The maximum size of source file is 1 MB. However, you can compress a larger file and select the compressed *.zip file as the source file.
    • The format of the file must be .csv, .zip, .pgp, or .gpg.

  6. Select the following:

    • Run Integration: If this is the first time this integration is being run.
    • Re-Run: If this integration has been run before, and the status is not In-Progress, you can run the integration again without entering the parameter settings again. (missing or bad snippet)Yes to run the integration with the previous parameter settings, or No to edit the parameters for this run.

    Wait for the confirmation that the integration completed  or failed . Close the panel.

    Kliknij Dotknij Refresh . 

    To see details, select the integration run. Select Run Summary.

  7. If the integration run failed , check for errors in the following:
    • Each Work Group Code is unique.
    • Each Work Group Code and Work Group Description is not blank.
    • The maximum length of Work Group Code is 50 characters, and Work Group Description is 256 characters.
    • No records are duplicated.
    • For errors that are common to all integrations; see Check the results > Troubleshooting.
  1. Select Main Menu  > Maintenance > Integrations. 
  2. Kliknij Dotknij Run an Integration . 
  3. Select the Work Group Export integration. Kliknij Dotknij Select.
  4. (Optional) Enter a unique Integration Run Name to make it easier to identify the run of the integration. Otherwise, the default name ends with a date and time stamp.

  5. Select the following:

    • Run Integration: If this is the first time this integration is being run.
    • Re-Run: If this integration has been run before, and the status is not In-Progress, you can run the integration again without entering the parameter settings again. (missing or bad snippet)Yes to run the integration with the previous parameter settings, or No to edit the parameters for this run.

    Wait for the confirmation that the integration completed  or failed . Close the panel.

    Kliknij Dotknij Refresh . 

    To see details, select the integration run. Select Run Summary.

    See Check the results.

  6. When the integration run starts and when it finishes, notifications go to the Control Center and by email.
  7. Make sure that the exported data corresponds to the source data:
    1. Open the source (input) and exported (output) files.
    2. Compare the data for accuracy.
  1. Select Main Menu  > Maintenance > Integrations. 
  2. Kliknij Dotknij Run an Integration . 
  3. Select the Job Code Work Group Import integration. Kliknij Dotknij Select.
  4. (Optional) Enter a unique Integration Run Name to make it easier to identify the run of the integration. Otherwise, the default name ends with a date and time stamp.

  5. (Not recommended) You can select a different source file. Kliknij Dotknij Browse and navigate to and select the file.

    Przestroga :
    • (Required) Upewnij się, że tylko jeden Plik o tej nazwie znajduje się jednocześnie na serwerze SFTP. W przeciwnym razie dane mogą zostać uszkodzone.
    • For scheduled runs of the integration, do not select a different source file. The default file was generated from the installation kit, and a scheduled integration cannot run without it.
    • For manual runs of the integration, you must enter the complete filename of the source file. Otherwise if the Inbound folder contains multiple files, the integration cannot distinguish which source file is the correct file to process.
    • The maximum size of source file is 1 MB. However, you can compress a larger file and select the compressed *.zip file as the source file.
    • The format of the file must be .csv, .zip, .pgp, or .gpg.

  6. Select the following:

    • Run Integration: If this is the first time this integration is being run.
    • Re-Run: If this integration has been run before, and the status is not In-Progress, you can run the integration again without entering the parameter settings again. (missing or bad snippet)Yes to run the integration with the previous parameter settings, or No to edit the parameters for this run.

    Wait for the confirmation that the integration completed  or failed . Close the panel.

    Kliknij Dotknij Refresh . 

    To see details, select the integration run. Select Run Summary.

  7. When the integration run starts and when it finishes, notifications go to the Control Center and by email.
  8. If the integration run failed , check for errors in the following:
    • Each combination of Job Name and Work Group Code is unique.
    • A job cannot be mapped to more than one work group.
    • Each Job Name and Work Group Code is not blank.
    • The generic jobs and work groups must be defined in the system.
    • For errors that are common to all integrations; see Check the results > Troubleshooting.
  1. Select Main Menu  > Maintenance > Integrations. 
  2. Kliknij Dotknij Run an Integration . 
  3. Select the Job Code Work Group Export integration. Kliknij Dotknij Select.
  4. (Optional) Enter a unique Integration Run Name to make it easier to identify the run of the integration. Otherwise, the default name ends with a date and time stamp.

  5. Select the following:

    • Run Integration: If this is the first time this integration is being run.
    • Re-Run: If this integration has been run before, and the status is not In-Progress, you can run the integration again without entering the parameter settings again. (missing or bad snippet)Yes to run the integration with the previous parameter settings, or No to edit the parameters for this run.

    Wait for the confirmation that the integration completed  or failed . Close the panel.

    Kliknij Dotknij Refresh . 

    To see details, select the integration run. Select Run Summary.

    See Check the results.

  6. When the integration run starts and when it finishes, notifications go to the Control Center and by email.
  7. Make sure that the exported data corresponds to the source data:
    1. Open the source (input) and exported (output) files.
    2. Compare the data for accuracy.
  1. Select Main Menu  > Maintenance > Integrations. 
  2. Kliknij Dotknij Run an Integration . 
  3. Select the Billing Department Import integration. Kliknij Dotknij Select.
  4. (Optional) Enter a unique Integration Run Name to make it easier to identify the run of the integration. Otherwise, the default name ends with a date and time stamp.

  5. (Not recommended) You can select a different source file. Kliknij Dotknij Browse and navigate to and select the file.

    Przestroga :
    • (Required) Upewnij się, że tylko jeden Plik o tej nazwie znajduje się jednocześnie na serwerze SFTP. W przeciwnym razie dane mogą zostać uszkodzone.
    • For scheduled runs of the integration, do not select a different source file. The default file was generated from the installation kit, and a scheduled integration cannot run without it.
    • For manual runs of the integration, you must enter the complete filename of the source file. Otherwise if the Inbound folder contains multiple files, the integration cannot distinguish which source file is the correct file to process.
    • The maximum size of source file is 1 MB. However, you can compress a larger file and select the compressed *.zip file as the source file.
    • The format of the file must be .csv, .zip, .pgp, or .gpg.

  6. Select the following:

    • Run Integration: If this is the first time this integration is being run.
    • Re-Run: If this integration has been run before, and the status is not In-Progress, you can run the integration again without entering the parameter settings again. (missing or bad snippet)Yes to run the integration with the previous parameter settings, or No to edit the parameters for this run.

    Wait for the confirmation that the integration completed  or failed . Close the panel.

    Kliknij Dotknij Refresh . 

    To see details, select the integration run. Select Run Summary.

  7. When the integration run starts and when it finishes, notifications go to the Control Center and by email.
  8. If the integration run failed , check for errors in the following:
    • The work units must be defined in the system.
    • Work Unit Code, Billing Facility Code, and Billing Department Code must be unique, because the system cannot determine which duplicate record is correct.
    • Only Facility, Department, and Custom type work units are supported; Combination type work units are not supported.
    • For errors that are common to all integrations; see Check the results > Troubleshooting.
  1. Select Main Menu  > Maintenance > Integrations. 
  2. Kliknij Dotknij Run an Integration . 
  3. Select the Billing Department Export integration. Kliknij Dotknij Select.
  4. (Optional) Enter a unique Integration Run Name to make it easier to identify the run of the integration. Otherwise, the default name ends with a date and time stamp.

  5. Select the following:

    • Run Integration: If this is the first time this integration is being run.
    • Re-Run: If this integration has been run before, and the status is not In-Progress, you can run the integration again without entering the parameter settings again. (missing or bad snippet)Yes to run the integration with the previous parameter settings, or No to edit the parameters for this run.

    Wait for the confirmation that the integration completed  or failed . Close the panel.

    Kliknij Dotknij Refresh . 

    To see details, select the integration run. Select Run Summary.

    See Check the results.

  6. When the integration run starts and when it finishes, notifications go to the Control Center and by email.
  7. Make sure that the exported data corresponds to the source data:
    1. Open the source (input) and exported (output) files.
    2. Compare the data for accuracy.
  1. Select Main Menu  > Maintenance > Integrations. 
  2. Kliknij Dotknij Run an Integration . 
  3. Select the Charge Master Import integration. Kliknij Dotknij Select.
  4. (Optional) Enter a unique Integration Run Name to make it easier to identify the run of the integration. Otherwise, the default name ends with a date and time stamp.

  5. (Not recommended) You can select a different source file. Kliknij Dotknij Browse and navigate to and select the file.

    Przestroga :
    • (Required) Upewnij się, że tylko jeden Plik o tej nazwie znajduje się jednocześnie na serwerze SFTP. W przeciwnym razie dane mogą zostać uszkodzone.
    • For scheduled runs of the integration, do not select a different source file. The default file was generated from the installation kit, and a scheduled integration cannot run without it.
    • For manual runs of the integration, you must enter the complete filename of the source file. Otherwise if the Inbound folder contains multiple files, the integration cannot distinguish which source file is the correct file to process.
    • The maximum size of source file is 1 MB. However, you can compress a larger file and select the compressed *.zip file as the source file.
    • The format of the file must be .csv, .zip, .pgp, or .gpg.

  6. Select the following:

    • Run Integration: If this is the first time this integration is being run.
    • Re-Run: If this integration has been run before, and the status is not In-Progress, you can run the integration again without entering the parameter settings again. (missing or bad snippet)Yes to run the integration with the previous parameter settings, or No to edit the parameters for this run.

    Wait for the confirmation that the integration completed  or failed . Close the panel.

    Kliknij Dotknij Refresh . 

    To see details, select the integration run. Select Run Summary.

  7. When the integration run starts and when it finishes, notifications go to the Control Center and by email.
  8. If the integration run failed , check for errors in the following:
    • Billing Facility Code, Billing Department Code, and Procedure Code must be unique, because the system cannot determine which duplicate record is correct.
    • For errors that are common to all integrations; see Check the results > Troubleshooting.
  1. Select Main Menu  > Maintenance > Integrations. 
  2. Kliknij Dotknij Run an Integration . 
  3. Select the Charge Master Export integration. Kliknij Dotknij Select.
  4. (Optional) Enter a unique Integration Run Name to make it easier to identify the run of the integration. Otherwise, the default name ends with a date and time stamp.

  5. Select the following:

    • Run Integration: If this is the first time this integration is being run.
    • Re-Run: If this integration has been run before, and the status is not In-Progress, you can run the integration again without entering the parameter settings again. (missing or bad snippet)Yes to run the integration with the previous parameter settings, or No to edit the parameters for this run.

    Wait for the confirmation that the integration completed  or failed . Close the panel.

    Kliknij Dotknij Refresh . 

    To see details, select the integration run. Select Run Summary.

    See Check the results.

  6. Make sure that the exported data corresponds to the source data:
    1. Open the source (input) and exported (output) files.
    2. Compare the data for accuracy.

    Example: If the Effective Date and Weight for the same Procedure Code change, the integration exports two records. Time periods cannot overlap, so a later Effective Date sets an end date for the previous record. Example: An Effective Date of 12/1/2021 on the second record ends the previous record on 11/30/2021.

    Example charge master export
    Billing Facility CodeBilling Department CodeProcedure CodeProcedure Code DescriptionWeightEffective Date
    1183140-MedSurg11183140-MedSurg10011072X-Ray MedSurge 11.0000001/1/2021
    1183140-MedSurg11183140-MedSurg10011072X-Ray MedSurge 11.50000012/1/2021
  1. Select Main Menu  > Maintenance > Integrations. 
  2. Kliknij Dotknij Run an Integration . 
  3. Select the Volume Department Copy Import integration. Kliknij Dotknij Select.
  4. (Optional) Enter a unique Integration Run Name to make it easier to identify the run of the integration. Otherwise, the default name ends with a date and time stamp.

  5. (Not recommended) You can select a different source file. Kliknij Dotknij Browse and navigate to and select the file.

    Przestroga :
    • (Required) Upewnij się, że tylko jeden Plik o tej nazwie znajduje się jednocześnie na serwerze SFTP. W przeciwnym razie dane mogą zostać uszkodzone.
    • For scheduled runs of the integration, do not select a different source file. The default file was generated from the installation kit, and a scheduled integration cannot run without it.
    • For manual runs of the integration, you must enter the complete filename of the source file. Otherwise if the Inbound folder contains multiple files, the integration cannot distinguish which source file is the correct file to process.
    • The maximum size of source file is 1 MB. However, you can compress a larger file and select the compressed *.zip file as the source file.
    • The format of the file must be .csv, .zip, .pgp, or .gpg.

  6. Select the following:

    • Run Integration: If this is the first time this integration is being run.
    • Re-Run: If this integration has been run before, and the status is not In-Progress, you can run the integration again without entering the parameter settings again. (missing or bad snippet)Yes to run the integration with the previous parameter settings, or No to edit the parameters for this run.

    Wait for the confirmation that the integration completed  or failed . Close the panel.

    Kliknij Dotknij Refresh . 

    To see details, select the integration run. Select Run Summary.

  7. When the integration run starts and when it finishes, notifications go to the Control Center and by email.
  8. If the integration run failed , check for errors in the following:
    • Billing Facility Code, Billing Department Code, Destination Billing Facility Code, and Destination Billing Department Code must be unique, because the system cannot determine which duplicate record is correct.
    • For errors that are common to all integrations; see Check the results > Troubleshooting.
  1. Select Main Menu  > Maintenance > Integrations. 
  2. Kliknij Dotknij Run an Integration . 
  3. Select the Volume Department Copy Export integration. Kliknij Dotknij Select.
  4. (Optional) Enter a unique Integration Run Name to make it easier to identify the run of the integration. Otherwise, the default name ends with a date and time stamp.

  5. Select the following:

    • Run Integration: If this is the first time this integration is being run.
    • Re-Run: If this integration has been run before, and the status is not In-Progress, you can run the integration again without entering the parameter settings again. (missing or bad snippet)Yes to run the integration with the previous parameter settings, or No to edit the parameters for this run.

    Wait for the confirmation that the integration completed  or failed . Close the panel.

    Kliknij Dotknij Refresh . 

    To see details, select the integration run. Select Run Summary.

    See Check the results.

  6. When the integration run starts and when it finishes, notifications go to the Control Center and by email.
  7. Make sure that the exported data corresponds to the source data:
    1. Open the source (input) and exported (output) files.
    2. Compare the data for accuracy.
  1. Select Main Menu  > Maintenance > Integrations. 
  2. Kliknij Dotknij Run an Integration . 
  3. Select the Volume Department Copy Override Import integration. Kliknij Dotknij Select.
  4. (Optional) Enter a unique Integration Run Name to make it easier to identify the run of the integration. Otherwise, the default name ends with a date and time stamp.

  5. (Not recommended) You can select a different source file. Kliknij Dotknij Browse and navigate to and select the file.

    Przestroga :
    • (Required) Upewnij się, że tylko jeden Plik o tej nazwie znajduje się jednocześnie na serwerze SFTP. W przeciwnym razie dane mogą zostać uszkodzone.
    • For scheduled runs of the integration, do not select a different source file. The default file was generated from the installation kit, and a scheduled integration cannot run without it.
    • For manual runs of the integration, you must enter the complete filename of the source file. Otherwise if the Inbound folder contains multiple files, the integration cannot distinguish which source file is the correct file to process.
    • The maximum size of source file is 1 MB. However, you can compress a larger file and select the compressed *.zip file as the source file.
    • The format of the file must be .csv, .zip, .pgp, or .gpg.

  6. Select the following:

    • Run Integration: If this is the first time this integration is being run.
    • Re-Run: If this integration has been run before, and the status is not In-Progress, you can run the integration again without entering the parameter settings again. (missing or bad snippet)Yes to run the integration with the previous parameter settings, or No to edit the parameters for this run.

    Wait for the confirmation that the integration completed  or failed . Close the panel.

    Kliknij Dotknij Refresh . 

    To see details, select the integration run. Select Run Summary.

  7. If the integration run failed , check for errors in the following:
    • Billing Facility Code, Billing Department Code, Destination Billing Facility Code, Destination Billing Department Code, and Procedure Code must be unique, because the system cannot determine which duplicate record is correct.
    • Make sure that the combination of the Billing Facility Code and Billing Department Code in the source file and the destination file is configured in the billing department mapping.
    • Avoid looping logic between the Volume Department Copy and Volume Department Copy Override integrations. Example: Do not import volume departments, override those departments, then import again those same departments.
    • For errors that are common to all integrations; see Check the results > Troubleshooting.
  1. Select Main Menu  > Maintenance > Integrations. 
  2. Kliknij Dotknij Run an Integration . 
  3. Select the Volume Department Copy Override Export integration. Kliknij Dotknij Select.
  4. (Optional) Enter a unique Integration Run Name to make it easier to identify the run of the integration. Otherwise, the default name ends with a date and time stamp.

  5. Select the following:

    • Run Integration: If this is the first time this integration is being run.
    • Re-Run: If this integration has been run before, and the status is not In-Progress, you can run the integration again without entering the parameter settings again. (missing or bad snippet)Yes to run the integration with the previous parameter settings, or No to edit the parameters for this run.

    Wait for the confirmation that the integration completed  or failed . Close the panel.

    Kliknij Dotknij Refresh . 

    To see details, select the integration run. Select Run Summary.

    See Check the results.

  6. When the integration run starts and when it finishes, notifications go to the Control Center and by email.
  7. Make sure that the exported data corresponds to the source data:
    1. Open the source (input) and exported (output) files.
    2. Compare the data for accuracy.
  1. Select Main Menu  > Maintenance > Integrations. 
  2. Kliknij Dotknij Run an Integration . 
  3. Select the Payroll Department Mapping Import integration. Kliknij Dotknij Select.
  4. (Optional) Enter a unique Integration Run Name to make it easier to identify the run of the integration. Otherwise, the default name ends with a date and time stamp.

  5. (Not recommended) You can select a different source file. Kliknij Dotknij Browse and navigate to and select the file.

    Przestroga :
    • (Required) Upewnij się, że tylko jeden Plik o tej nazwie znajduje się jednocześnie na serwerze SFTP. W przeciwnym razie dane mogą zostać uszkodzone.
    • For scheduled runs of the integration, do not select a different source file. The default file was generated from the installation kit, and a scheduled integration cannot run without it.
    • For manual runs of the integration, you must enter the complete filename of the source file. Otherwise if the Inbound folder contains multiple files, the integration cannot distinguish which source file is the correct file to process.
    • The maximum size of source file is 1 MB. However, you can compress a larger file and select the compressed *.zip file as the source file.
    • The format of the file must be .csv, .zip, .pgp, or .gpg.

  6. Select the following:

    • Run Integration: If this is the first time this integration is being run.
    • Re-Run: If this integration has been run before, and the status is not In-Progress, you can run the integration again without entering the parameter settings again. (missing or bad snippet)Yes to run the integration with the previous parameter settings, or No to edit the parameters for this run.

    Wait for the confirmation that the integration completed  or failed . Close the panel.

    Kliknij Dotknij Refresh . 

    To see details, select the integration run. Select Run Summary.

  7. If the integration run failed , check for errors in the following:
    • Each paycode must be unique within the input file.
    • The same Payroll Facility Code, Payroll Department Code, or Payroll Source must not map to multiple work units, unless the Delete Switch for all but one of the work units is 1. The combined payroll facility, department, and source must be unique.
    • Each Delete Switch is 0 or 1.
    • For errors that are common to all integrations; see Check the results > Troubleshooting.
  1. Select Main Menu  > Maintenance > Integrations. 
  2. Kliknij Dotknij Run an Integration . 
  3. Select the Payroll Department Mapping Export integration. Kliknij Dotknij Select.
  4. (Optional) Enter a unique Integration Run Name to make it easier to identify the run of the integration. Otherwise, the default name ends with a date and time stamp.

  5. Select the following:

    • Run Integration: If this is the first time this integration is being run.
    • Re-Run: If this integration has been run before, and the status is not In-Progress, you can run the integration again without entering the parameter settings again. (missing or bad snippet)Yes to run the integration with the previous parameter settings, or No to edit the parameters for this run.

    Wait for the confirmation that the integration completed  or failed . Close the panel.

    Kliknij Dotknij Refresh . 

    To see details, select the integration run. Select Run Summary.

    See Check the results.

  6. When the integration run starts and when it finishes, notifications go to the Control Center and by email.
  7. Make sure that the exported data corresponds to the source data:
    1. Open the source (input) and exported (output) files.
    2. Compare the data for accuracy.
  1. Select Main Menu  > Maintenance > Integrations. 
  2. Kliknij Dotknij Run an Integration . 
  3. Select the Payroll Employment Status Mapping Import integration. Kliknij Dotknij Select.
  4. (Optional) Enter a unique Integration Run Name to make it easier to identify the run of the integration. Otherwise, the default name ends with a date and time stamp.

  5. (Not recommended) You can select a different source file. Kliknij Dotknij Browse and navigate to and select the file.

    Przestroga :
    • (Required) Upewnij się, że tylko jeden Plik o tej nazwie znajduje się jednocześnie na serwerze SFTP. W przeciwnym razie dane mogą zostać uszkodzone.
    • For scheduled runs of the integration, do not select a different source file. The default file was generated from the installation kit, and a scheduled integration cannot run without it.
    • For manual runs of the integration, you must enter the complete filename of the source file. Otherwise if the Inbound folder contains multiple files, the integration cannot distinguish which source file is the correct file to process.
    • The maximum size of source file is 1 MB. However, you can compress a larger file and select the compressed *.zip file as the source file.
    • The format of the file must be .csv, .zip, .pgp, or .gpg.

  6. Select the following:

    • Run Integration: If this is the first time this integration is being run.
    • Re-Run: If this integration has been run before, and the status is not In-Progress, you can run the integration again without entering the parameter settings again. (missing or bad snippet)Yes to run the integration with the previous parameter settings, or No to edit the parameters for this run.

    Wait for the confirmation that the integration completed  or failed . Close the panel.

    Kliknij Dotknij Refresh . 

    To see details, select the integration run. Select Run Summary.

    See Check the results.

  1. Select Main Menu  > Maintenance > Integrations. 
  2. Kliknij Dotknij Run an Integration . 
  3. Select the Payroll Employment Status Mapping Export integration. Kliknij Dotknij Select.
  4. (Optional) Enter a unique Integration Run Name to make it easier to identify the run of the integration. Otherwise, the default name ends with a date and time stamp.

  5. Select the following:

    • Run Integration: If this is the first time this integration is being run.
    • Re-Run: If this integration has been run before, and the status is not In-Progress, you can run the integration again without entering the parameter settings again. (missing or bad snippet)Yes to run the integration with the previous parameter settings, or No to edit the parameters for this run.

    Wait for the confirmation that the integration completed  or failed . Close the panel.

    Kliknij Dotknij Refresh . 

    To see details, select the integration run. Select Run Summary.

    See Check the results.

  6. When the integration run starts and when it finishes, notifications go to the Control Center and by email.
  7. Make sure that the exported data corresponds to the source data:
    1. Open the source (input) and exported (output) files.
    2. Compare the data for accuracy.
  1. Select Main Menu  > Maintenance > Integrations. 
  2. Kliknij Dotknij Run an Integration . 
  3. Select the Payroll Job Mapping Import integration. Kliknij Dotknij Select.
  4. (Optional) Enter a unique Integration Run Name to make it easier to identify the run of the integration. Otherwise, the default name ends with a date and time stamp.

  5. (Not recommended) You can select a different source file. Kliknij Dotknij Browse and navigate to and select the file.

    Przestroga :
    • (Required) Upewnij się, że tylko jeden Plik o tej nazwie znajduje się jednocześnie na serwerze SFTP. W przeciwnym razie dane mogą zostać uszkodzone.
    • For scheduled runs of the integration, do not select a different source file. The default file was generated from the installation kit, and a scheduled integration cannot run without it.
    • For manual runs of the integration, you must enter the complete filename of the source file. Otherwise if the Inbound folder contains multiple files, the integration cannot distinguish which source file is the correct file to process.
    • The maximum size of source file is 1 MB. However, you can compress a larger file and select the compressed *.zip file as the source file.
    • The format of the file must be .csv, .zip, .pgp, or .gpg.

  6. Select the following:

    • Run Integration: If this is the first time this integration is being run.
    • Re-Run: If this integration has been run before, and the status is not In-Progress, you can run the integration again without entering the parameter settings again. (missing or bad snippet)Yes to run the integration with the previous parameter settings, or No to edit the parameters for this run.

    Wait for the confirmation that the integration completed  or failed . Close the panel.

    Kliknij Dotknij Refresh . 

    To see details, select the integration run. Select Run Summary.

  7. If the integration run failed , check for errors in the following:
    • The same Labor Category Entry (payroll job) and Payroll Source must not map to multiple Job Names (generic jobs), unless the Delete Switch for all but one of the jobs is 1.
    • For errors that are common to all integrations; see Check the results > Troubleshooting.
  1. Select Main Menu  > Maintenance > Integrations. 
  2. Kliknij Dotknij Run an Integration . 
  3. Select the Payroll Job Mapping Export integration. Kliknij Dotknij Select.
  4. (Optional) Enter a unique Integration Run Name to make it easier to identify the run of the integration. Otherwise, the default name ends with a date and time stamp.

  5. Select the following:

    • Run Integration: If this is the first time this integration is being run.
    • Re-Run: If this integration has been run before, and the status is not In-Progress, you can run the integration again without entering the parameter settings again. (missing or bad snippet)Yes to run the integration with the previous parameter settings, or No to edit the parameters for this run.

    Wait for the confirmation that the integration completed  or failed . Close the panel.

    Kliknij Dotknij Refresh . 

    To see details, select the integration run. Select Run Summary.

    See Check the results.

  6. When the integration run starts and when it finishes, notifications go to the Control Center and by email.
  7. Make sure that the exported data corresponds to the source data:
    1. Open the source (input) and exported (output) files.
    2. Compare the data for accuracy.
  1. Select Main Menu  > Maintenance > Integrations. 
  2. Kliknij Dotknij Run an Integration . 
  3. Select the Targets Import integration. Kliknij Dotknij Select.
  4. (Optional) Enter a unique Integration Run Name to make it easier to identify the run of the integration. Otherwise, the default name ends with a date and time stamp.

  5. (Not recommended) You can select a different source file. Kliknij Dotknij Browse and navigate to and select the file.

    Przestroga :
    • (Required) Upewnij się, że tylko jeden Plik o tej nazwie znajduje się jednocześnie na serwerze SFTP. W przeciwnym razie dane mogą zostać uszkodzone.
    • For scheduled runs of the integration, do not select a different source file. The default file was generated from the installation kit, and a scheduled integration cannot run without it.
    • For manual runs of the integration, you must enter the complete filename of the source file. Otherwise if the Inbound folder contains multiple files, the integration cannot distinguish which source file is the correct file to process.
    • The maximum size of source file is 1 MB. However, you can compress a larger file and select the compressed *.zip file as the source file.
    • The format of the file must be .csv, .zip, .pgp, or .gpg.

  6. Select the following:

    • Run Integration: If this is the first time this integration is being run.
    • Re-Run: If this integration has been run before, and the status is not In-Progress, you can run the integration again without entering the parameter settings again. (missing or bad snippet)Yes to run the integration with the previous parameter settings, or No to edit the parameters for this run.

    Wait for the confirmation that the integration completed  or failed . Close the panel.

    Kliknij Dotknij Refresh . 

    To see details, select the integration run. Select Run Summary.

  7. When the integration run starts and when it finishes, notifications go to the Control Center and by email.
  8. If the integration run failed , check for errors in the following:
    • Fixed and Variable targets are validated.
      • If a validation fails, the target definition is rejected for that combined work unit and metric.
      • Fixed or Variable targets that are empty are excluded from the target definition for a combined work unit, metric, and effective date.
    • Fixed target validations:
      • Each fixed target must have a default value.
      • Targets must be numbers; alphabetic characters are not valid.
      • Maximum length of the target is 10 digits before and 6 digits after the decimal point.
      • The Adjustment Flag applies only to the Productive Hours (daily or pay period) metric.
    • Variable target validations:
      • Each pay-period and daily-ratio target must have a default value. Alternate pay-period values are optional.
      • Targets must be numbers; alphabetic characters are not valid.
      • Maximum length of the target is 10 digits before and 6 digits after the decimal point.
      • If any fixed or variable target has an error, you must submit all of the data again.
      • Group records by Work Unit Code and metric name so that multiple records for the same combined work unit and metric are together and validated for date overlaps.
      • Work units must have pay periods defined in the system before you can import the targets for the pay period end date. Otherwise, these records fail the integration run.
    • Date-overlap validations: The same pay period (same start and end dates) cannot have more than one target definition. Otherwise, the records for that work unit and metric are rejected.
    • The Start Date of a pay period is used as the effective date. The expiration date is forever or is calculated if the same work unit has multiple pay periods. For multiple pay periods, the most recent last date of a pay period has an expiration date of forever, and all other pay period end dates are the respective expiration dates.
    • The possible values for targetType are hca_fixed_target and hca_variable_target.
    • For targetFunctions, the values contain name = PRODUCTIVE_HRS and qualifier = METRIC_SET.
    • All of the required fields are not blank.
    • Each Work Unit Code and Pay Period End Date is unique.
    • The date format is MM/DD/YYYY.
    • For errors that are common to all integrations; see Check the results > Troubleshooting.
  1. Select Main Menu  > Maintenance > Integrations. 
  2. Kliknij Dotknij Run an Integration . 
  3. Select the Targets Export integration. Kliknij Dotknij Select.
  4. (Optional) Enter a unique Integration Run Name to make it easier to identify the run of the integration. Otherwise, the default name ends with a date and time stamp.

  5. Select the following:

    • Run Integration: If this is the first time this integration is being run.
    • Re-Run: If this integration has been run before, and the status is not In-Progress, you can run the integration again without entering the parameter settings again. (missing or bad snippet)Yes to run the integration with the previous parameter settings, or No to edit the parameters for this run.

    Wait for the confirmation that the integration completed  or failed . Close the panel.

    Kliknij Dotknij Refresh . 

    To see details, select the integration run. Select Run Summary.

    See Check the results.

  6. When the integration run starts and when it finishes, notifications go to the Control Center and by email.
  7. Make sure that the exported data corresponds to the source data:
    1. Open the source (input) and exported (output) files.
    2. Compare the data for accuracy.
  1. Make sure that Fiscal Calendar Import is Allowed in your FAP; see Configure Access to Healthcare Productivity.
  2. Select Main Menu  > Maintenance > Integrations. 
  3. Kliknij Dotknij Run an Integration . 
  4. Select the Fiscal Calendar Import integration. Kliknij Dotknij Select.
  5. (Optional) Enter a unique Integration Run Name to make it easier to identify the run of the integration. Otherwise, the default name ends with a date and time stamp.

  6. (Not recommended) You can select a different source file. Kliknij Dotknij Browse and navigate to and select the file.

    Przestroga :
    • (Required) Upewnij się, że tylko jeden Plik o tej nazwie znajduje się jednocześnie na serwerze SFTP. W przeciwnym razie dane mogą zostać uszkodzone.
    • For scheduled runs of the integration, do not select a different source file. The default file was generated from the installation kit, and a scheduled integration cannot run without it.
    • For manual runs of the integration, you must enter the complete filename of the source file. Otherwise if the Inbound folder contains multiple files, the integration cannot distinguish which source file is the correct file to process.
    • The maximum size of source file is 1 MB. However, you can compress a larger file and select the compressed *.zip file as the source file.
    • The format of the file must be .csv, .zip, .pgp, or .gpg.

  7. Select the following:

    • Run Integration: If this is the first time this integration is being run.
    • Re-Run: If this integration has been run before, and the status is not In-Progress, you can run the integration again without entering the parameter settings again. (missing or bad snippet)Yes to run the integration with the previous parameter settings, or No to edit the parameters for this run.

    Wait for the confirmation that the integration completed  or failed . Close the panel.

    Kliknij Dotknij Refresh . 

    To see details, select the integration run. Select Run Summary.

  8. When the integration run starts and when it finishes, notifications go to the Control Center and by email.
  9. If the integration run failed , check for errors in the following:
    • All dates for this fiscal year are in sequence, and no date is skipped between any first and last entry.
    • FSCL_DAY_OF_YR_NBR starts at 1 and goes up in incremental order.
    • FSCL_WK_OF_YR_NBR starts at 1 and repeats in incremental order.
    • FSCL_MO_OF_YR_NBR starts at 1 and repeats in incremental order.
    • FSCL_QTR_OF_YR_NBR starts at 1 and repeats in incremental order.
    • For errors that are common to all integrations; see Check the results > Troubleshooting.
  1. Select Main Menu  > Maintenance > Integrations.
  2. Kliknij Dotknij Run an Integration . 
  3. Select the Volume Import integration. Kliknij Dotknij Select.
  4. (Optional) Enter a unique Integration Run Name to make it easier to identify the run of the integration. Otherwise, the default name ends with a date and time stamp.

  5. Set parameters:

    Select or enter the following parameters or files:

    • Billing Filename
    • Patient Flag
    • Is Billing File Rolling?
    • Manual Filename
    • Is Manual File Rolling?

  6. Select the following:

    • Run Integration: If this is the first time this integration is being run.
    • Re-Run: If this integration has been run before, and the status is not In-Progress, you can run the integration again without entering the parameter settings again. (missing or bad snippet)Yes to run the integration with the previous parameter settings, or No to edit the parameters for this run.

    Wait for the confirmation that the integration completed  or failed . Close the panel.

    Kliknij Dotknij Refresh . 

    To see details, select the integration run. Select Run Summary.

  7. When the integration run starts and when it finishes, notifications go to the Control Center and by email.
  8. When the import process starts and finishes, notifications go the Control Center and by email.
  9. If the integration run failed , check for errors that are common to all integrations; see Check the results > Troubleshooting.
    • Rename the volume exception file and consolidate the exceptions in that file.
    • Move that file to the Inbound folder.
    • Re-run the Volume Import integration to import the rows from the volume exception file.

Volume import use case – new Charge Master

The Volume Import integration creates a new charge master if one is not defined in the database.

Scenario: This integration processes a CSV input file that contains new charge-master records with or without weights.

Example volume feed
Field File 1
FCLTY_NBR Fac1
DEPT_NBR Dept
BILL_COD Procedure code1

BILL_COD_DES

 Procedure code1 description
VOL_QTY 10
POSTING_DAT 12/12/2021
SVC_DAT 12/12/2021
WEIGHT (Optional)
PAT_TYPE (Optional)
  • The volume feed has records with charges that are already in the charge master: the charges are aggregated and weight is allocated.
  • The volume feed has records with charges that are not in the charge master:
    • The integration does not check whether the charges exist for the service date, but it checks only the charges in the database.
    • The charges are added to the database with weight of null and an effective date set to the beginning of time.
      Example volume import for a new charge master
      FieldCharge master in database
      Billing Facility CodeFac1
      Billing Department CodeDept
      Procedure CodeProcedure code1

      Procedure Code Description

      		Procedure code1 description
      WEIGHTnull
      Effective Date01/01/1753 (Beginning of Time)
      Uwaga:
      • Records that have the unknown charge weight of null are written to an exception file and are not added to the database.
      • When you run the Charge Master Export integration, it exports the entire table and filters out the null weights.
      • Update the weights in the exported SCV file, and re-run the Charge Master Import integration with new weights to replace the charge master exceptions.

Volume import use case – Charge Master updates

If the charge master is in the system already, and you import a volume feed with a new weight for the charge master, the system expires the previous charge master with an effective end date of the day before the day you imported the volume feed (load date — 1). The system creates a new charge master with an effective date of the day you imported the volume feed (load date).

To see the records, run the Charge Master Export integration.

Volume import use case — Aggregation

Volume quantity is aggregated for records in the same file with facility number, department number, billing code, and service date.

Example volume import for aggregation
Fields File 1 File 1 Aggregated result
FCLTY_NBR Fac1 Fac1 Fac1
DEPT_NBR Dept Dept Dept
BILL_COD Procedure code1 Procedure code1 Procedure code1
BILL_COD_DES Procedure code1 description Procedure code1 description Procedure code1 description
VOL_QTY 10 10 20
POSTING_DAT 12/12/2021 12/12/2021 12/12/2021
SVC_DAT 12/12/2021 12/12/2021 12/12/2021
WEIGHT (Optional) — — —
PAT_TYPE (Optional) — — —

Volume import use case — Correction or override

  • If the post date and service date are the same for earlier records, new records override VOL_QTY (volume quantity). Example: File2_Record1 replaces the volume quantity from File1_Record1.
  • If the post date is different, the volume quantity of the earlier records is aggregated, and the weighted volume for the service date accounts for the aggregated value for productivity metrics.
  • For corrections, a negative volume quantity is supported.
Example volume import for correction or override
Fields File 1 File 2 Override result
FCLTY_NBR Fac1 Fac1 Fac1
DEPT_NBR Dept Dept Dept
BILL_COD Procedure code1 Procedure code1 Procedure code1
BILL_COD_DES Procedure code1 description Procedure code1 description Procedure code1 description
VOL_QTY 10 15 15
POSTING_DAT 12/12/2021 12/12/2021 12/12/2021
SVC_DAT 12/12/2021 12/12/2021 12/12/2021
WEIGHT (Optional) — — —
PAT_TYPE (Optional) — — —
  1. Select Main Menu  > Maintenance > Integrations.
  2. Kliknij Dotknij Run an Integration . 
  3. Select the Payroll Import integration. Kliknij Dotknij Select.
  4. (Optional) Enter a unique Integration Run Name to make it easier to identify the run of the integration. Otherwise, the default name ends with a date and time stamp.

  5. (Not recommended) You can select a different source file. Kliknij Dotknij Browse and navigate to and select the file.

    Przestroga :
    • (Required) Upewnij się, że tylko jeden Plik o tej nazwie znajduje się jednocześnie na serwerze SFTP. W przeciwnym razie dane mogą zostać uszkodzone.
    • For scheduled runs of the integration, do not select a different source file. The default file was generated from the installation kit, and a scheduled integration cannot run without it.
    • For manual runs of the integration, you must enter the complete filename of the source file. Otherwise if the Inbound folder contains multiple files, the integration cannot distinguish which source file is the correct file to process.
    • The maximum size of source file is 1 MB. However, you can compress a larger file and select the compressed *.zip file as the source file.
    • The format of the file must be .csv, .zip, .pgp, or .gpg.

  6. Select the following:

    • Run Integration: If this is the first time this integration is being run.
    • Re-Run: If this integration has been run before, and the status is not In-Progress, you can run the integration again without entering the parameter settings again. (missing or bad snippet)Yes to run the integration with the previous parameter settings, or No to edit the parameters for this run.

    Wait for the confirmation that the integration completed  or failed . Close the panel.

    Kliknij Dotknij Refresh . 

    To see details, select the integration run. Select Run Summary.

  7. When the integration run starts and when it finishes, notifications go to the Control Center and by email.
  8. When the import process starts and finishes, notifications go the Control Center and by email.
  9. If the integration run failed , check for errors in the following:

    Uwaga: The Payroll import integration processes employee data in batches for a pay period end date. If any records in the batch fail the validations, the integration fails all records for that employee for that pay period end date. This prevents the integration from importing invalid records. Check the error message for details.

    • The payroll data must be only for regular employees and not include data for agency employees.
    • Date formats are MM/DD/YYYY or MM-DD-YYYY.
    • The integration run fails if the following occur:

      Multiple primary job codes for an employee during one pay period

      Multiple employment status for an employee during one pay period

      Multiple standard hours values for an employee during one pay period

      Multiple home departments for an employee during one pay period

      Multiple payroll sources for the same employee during one pay period

    • Each EMP_NBR must be unique across all payroll source files.
    • The following are optional but cannot be blank:

      Przestroga :If these fields do not apply to a record, enter 0 for the value.

      STD_HRS

      PAY_RATE_AMT

      PAYROLL_PAYCD_HRS

      PAYROLL_PAYCD_AMT

    • The following must contain a distinct value for each combination of employee and pay period:

      HM_DEPT_COD

      STD_HRS

      PAYROLL_EMPLMT_STAT_COD

      PRI_JOB_COD

      SRC_COD: Must be a unique code that identifies the payroll source file and differentiates between payroll systems.

    • If the error indicates a Bad File, do the following:

      Open the source file and replace all values with zero (0).

      Run the integration again with this file that has the hours and amounts zeroed. This overrides the bad records that were imported.

      Find the correct file and run the integration again with that file.

    • Extra part time hours for an employee are calculated based on the paycode and the mapping category for the associated paycode.
    • For errors that are common to all integrations; see Check the results > Troubleshooting.

Payroll import use case — Aggregation

The hours and amounts are aggregated if there are multiple records for an employee for the same pay period that matches the following field values in the file:

  • Employee number
  • Payroll Home Facility
  • Payroll Home Department
  • Payroll Worked Facility
  • Payroll Worked Department
  • Payroll Pay Code
  • Job Code (Paid Job)
  • Payroll Employment Status Code
  • Pay Period End Date
  • Payroll Source
Example payroll import for aggregation
Fields Record 1 Record 2 Aggregated result
EMP_NBR G7704 G7704 G7704
EMP_NAM G7704FU G7704FU G7704FU
HM_FCLTY_COD BMH BMH BMH
HM_DEPT_COD 50600 50600 50600
JOB_COD C0848U C0848U C0848U
STD_HRS 40 40 80
PAYROLL_EMPLMT_STAT_COD F F F
PAY_RATE_AMT 40.580000 40.580000 40.580000
FCLTY_COD BMH BMH BMH
DEPT_COD 50600 50600 50600
PAYROLL_PAYCD A01 A01 A01
PAYROLL_PAYCD_HRS 23.250000 23.250000 46.500000
PAYROLL_PAYCD_AMT 943.490000 943.490000 1186.980000
ASSGND_SHIFT_NAM — — —
PRI_JOB_COD C0848U C0848U C0848U
HIRE_DAT 09/30/1960 09/30/1960 09/30/1960
TERM_DAT — — —
PPEND_DAT 11/29/2018 11/29/2018 11/29/2018
SRC_COD PAYROLL PAYROLL PAYROLL

Payroll import use case — Correction or override

To correct already imported records, zeroed hours and amounts must be imported with the exact same set of values for the following fields:

  • Employee number
  • Payroll Home Facility
  • Payroll Home Department
  • Payroll Worked Facility
  • Payroll Worked Department
  • Payroll Pay Code
  • Job Code (Paid Job)
  • Payroll Employment Status Code
  • Pay Period End Date
  • Payroll Source

The record date of File 2 overrides the record date of File 1.

Example payroll import for correction or override
Fields File 1 File 2 Override result
EMP_NBR G7704 G7704 G7704
EMP_NAM G7704FU G7704FU G7704FU
HM_FCLTY_COD BMH BMH BMH
HM_DEPT_COD 50600 50600 50600
JOB_COD C0848U C0848U C0848U
STD_HRS 40 30 30
PAYROLL_EMPLMT_STAT_COD F F F
PAY_RATE_AMT — — —
FCLTY_COD BMH BMH BMH
DEPT_COD 50600 50600 50600
PAYROLL_PAYCOD A01 A01 A01
PAYROLL_PAYCD_HRS 40 30 30
PAYROLL_PAYCD_AMT 943.490000 707.617500 707.617500
ASSGND_SHIFT_NAM — — —
PRI_JOB_COD C0848U C0848U C0848U
HIRE_DAT 09/30/1960 09/30/1967 09/30/1967
TERM_DAT — — —
PPEND_DAT 11/29/2018 11/29/2018 11/29/2018
SRC_COD PAYROLL PAYROLL PAYROLL

For an employee for a pay period, these fields cannot have more than one value. To correct the following values, the system must import a correction record that has zeroed hours and amounts:

  • Primary job code
  • Employment status
  • Standard hours
  • Home department
  • Payroll source
  1. Select Main Menu  > Maintenance > Integrations. 
  2. Kliknij Dotknij Run an Integration . 
  3. Select the Agency Export integration. Kliknij Dotknij Select.
  4. (Optional) Enter a unique Integration Run Name to make it easier to identify the run of the integration. Otherwise, the default name ends with a date and time stamp.
  5. Set parameters:

    Select or enter the following parameters:

    • Reference Date from which to export the transactional punches of agency employees. If you do not select a date, the integration exports the past 90 days of punches.
    • Hyperfind: Leave the default Agency Employees or All People hyperfind query selected.

    To troubleshoot exceptions in agency worker records, kliknij dotknij Browse and select the Exception_Agency_Export file. This file shows detailed information about each exception.

  6. Select the following:

    • Run Integration: If this is the first time this integration is being run.
    • Re-Run: If this integration has been run before, and the status is not In-Progress, you can run the integration again without entering the parameter settings again. (missing or bad snippet)Yes to run the integration with the previous parameter settings, or No to edit the parameters for this run.

    Wait for the confirmation that the integration completed  or failed . Close the panel.

    Kliknij Dotknij Refresh . 

    To see details, select the integration run. Select Run Summary.

    See Check the results.

    Przestroga :Do not modify the exported CSV file.

  7. When the integration run starts and when it finishes, notifications go to the Control Center and by email.
  1. Select Main Menu  > Maintenance > Integrations. 
  2. Kliknij Dotknij Run an Integration . 
  3. Select the Agency Import integration. Kliknij Dotknij Select.
  4. (Optional) Enter a unique Integration Run Name to make it easier to identify the run of the integration. Otherwise, the default name ends with a date and time stamp.

  5. (Not recommended) You can select a different source file. Kliknij Dotknij Browse and navigate to and select the file.

    Przestroga :
    • (Required) Upewnij się, że tylko jeden Plik o tej nazwie znajduje się jednocześnie na serwerze SFTP. W przeciwnym razie dane mogą zostać uszkodzone.
    • For scheduled runs of the integration, do not select a different source file. The default file was generated from the installation kit, and a scheduled integration cannot run without it.
    • For manual runs of the integration, you must enter the complete filename of the source file. Otherwise if the Inbound folder contains multiple files, the integration cannot distinguish which source file is the correct file to process.
    • The maximum size of source file is 1 MB. However, you can compress a larger file and select the compressed *.zip file as the source file.
    • The format of the file must be .csv, .zip, .pgp, or .gpg.

    To troubleshoot exceptions in agency worker records, kliknij dotknij Browse and select the Exception_Agency_Export file. This file shows detailed information about each exception.

  6. Select the following:

    • Run Integration: If this is the first time this integration is being run.
    • Re-Run: If this integration has been run before, and the status is not In-Progress, you can run the integration again without entering the parameter settings again. (missing or bad snippet)Yes to run the integration with the previous parameter settings, or No to edit the parameters for this run.

    Wait for the confirmation that the integration completed  or failed . Close the panel.

    Kliknij Dotknij Refresh . 

    To see details, select the integration run. Select Run Summary.

    See Check the results.

  7. When the integration run starts and when it finishes, notifications go to the Control Center and by email.
  8. When the import process starts and finishes, notifications go the Control Center and by email.
  9. Make sure that the imported data corresponds to the exported (source) data:
    1. Open the source (input) and imported (output) files.
    2. Compare the data for accuracy.

Check the results

On the Integrations page, each tile indicates the current status of integration runs as follows:

Wskaźniki statusu

  •  W toku: uruchomienie tej integracji nie zostało jeszcze ukończone.
  •  Ukończono: integracja przebiegła pomyślnie bez błędów.
  •  Zaplanowano: ta integracja została ujęta w harmonogramie do uruchomienia później lub wielokrotnie.
  • (Wyszarzone) Zaplanowano, ale usunięto: ta integracja została zaplanowana do uruchomienia, ale szablon integracji został usunięty. Uruchomienie spowoduje wyzwolenie błędu. Aby zapobiec wystąpieniu błędu, usuń zaplanowane uruchomienie integracji.
  •  Ukończono z błędami: integracja została przeprowadzona pomyślnie, ale co najmniej jeden rekord zawiera błędy. Uruchomienie integracji jest traktowane jako nieudane. Jeśli w zbiorze integracji skonfigurowano funkcję Przerwij w przypadku niepowodzenia, zbiór integracji zostaje zatrzymany.
  •  Niepowodzenie: uruchomienie integracji zawiera błędy lub integracji nie można uruchomić.
  • Aby rozwiązać problemy, wykonaj następujące czynności:

    sprawdź Uruchom podsumowanie, aby uzyskać szczegóły.

    • Aby rozwiązać wszystkie typy błędów lub jeśli podsumowanie uruchomienia wskazuje na liczne błędy, kliknij dotknij przejdź do Informacji dodatkowych, jeśli są dostępne, lub kliknij dotknij do Pliku źródłowego, aby otworzyć i sprawdzić plik źródłowy danych wejściowych.
    • (Wyłącznie dla integracji importu) Aby rozwiązać problemy i ponownie przesłać integracje z błędami transakcji lub danych, kliknij dotknij Idź do Asystenta transakcji.

Uwaga: Only import integrations can have a status of Partial Failed. Export integrations export all records for the run to complete or no records for the run to fail; export integrations cannot partially succeed.

The Run Summary shows an overview of the results of an integration run.

  1. Kliknij Dotknij the tile for a completed integration run.
  2. Kliknij Dotknij Run Summary to see the results of the integration run.

  3. Run Summary details

    • Integration Type: Import or Export
    • Records Processed: Number of records that were processed
    • Records Created: Number of records that were created
    • Errors: Number of records that failed
    • Source Files: For file-based import integrations, kliknij dotknij the flat file to see the input source for the integration.
    • Output File: For file-based export integrations, kliknij dotknij the CSV file to see the exported data.
    • Error Files: If the run of a file-based integration has errors, kliknij dotknij the CSV file. The filename starts with Exception_. This file lists the records that have errors, each record to a row, and is kept for 30 days. The Exception Details column in the file provides a detailed message for each error. If a record has multiple errors, each error message is separated by a semi-colon (;). You can edit this file and reload it.

To check the results in more detail and troubleshoot errors, do the following:

  1. In Error Files, open the exception file to find the erroneous records and see details.
    • The filename starts with Exception_. Example: Exception_work_units_*.csv
    • This file lists the records that have errors, each record to a row.
    • The Exception Details column in the file provides a detailed message for each error.
    • If a record has multiple errors, each error message is separated by a semi-colon (;).
    • You can edit this file and reload it.
  2. In Source Files, open the generated CSV file and check for the following errors that are common to all integrations in addition to any errors that are specific to an integration:
    • The first row of the file is a header.
    • The headers are correct.
    • All of the required fields are completed and are not blank (null). If these fields do not apply to a record, enter 0 for the value.
    • Formats are correct. Example: Dates are in MM/DD/YYYY or MM-DD-YYYY format.
    • Number fields are right-justified and have no leading zeros.
    • Negative numbers show the minus (—) sign to the left of the number (floating).
    • Field values which must be unique are unique. Example: EMP_NBR must be unique across all payroll source files.
    • If the integration depends on data from previous integrations or external processes, make sure that those integrations or processes finish before this integration starts.

      Example: Payroll Facility and Department Facility Mappings must finish before you can import the payroll records.

      Uwaga: Use integration sets to sequence integration runs; see Configure Integration Sets for Healthcare Productivity.

  3. If the source file does not open, navigate to the SFTP server and check the following:
    • The file type is .csv
    • There is only one version of the file. If an integration has multiple files, the system selects one file at random to prevent data corruption.
    • The filename is correct. Example: payroll_*.csv
  4. Log into the destination system and make sure that the data has been correctly updated.

    Examples:

    • Check the Work Unit Definitions to see if the integration imported the work units correctly; see Configure Work Units.
    • Check the Target Management to see if the integration imported the targets and thresholds correctly; see Configure Standard Targets.
Uwaga:
  • To manage the large number of Healthcare Productivity integrations, organize the related and inter-dependent integrations within integration sets. See the Configure Integration Sets for Healthcare Productivity topic.

  • Można zaplanować integracje i zbiory integracji, aby uruchomić je później jednorazowo lub cyklicznie. Zobacz temat Schedule Integrations.

  • If changes are made to volume, payroll, or agency configurations, you can process the historical data again to fit the new configuration. See the Recalculate Healthcare Productivity topic.