ADP Tax Integration / Technical system-level issues

Objective

• To provide instructions on using ADP Tax Integration Data Export files

User

• Finance & Business Services IT/Payroll

Scope

• ADP Tax Integration is a Laravel job that will export employee's demographic, wages, deduction & end of the year tax document data from the Banner into the ADP system.  This extract of data will be uploaded to ADP via the SFTP site
• The data that transferred to ADP server will be loaded to the ADP system. Finance & Business Services will utilize the services of ADP Smart Compliance to pay Miami's withholding taxes throughout the year on Miami's behalf

Environment

• 1157613: ADP Tax Integration
• PHP Server: mualphpp25.mcs.miamioh.edu
• ADP Server: tfsuxp02.adp.com

Instructions 

Logs in ELK

• Check ELK
• ELK TEST Lookup: 
  • Periodic File
    • (agent.hostname: mualphpt* OR kubernetes.namespace: "oh-tst") AND tags: adp_tax_integration
  • Quarterly File
    • (agent.hostname: mualphpt* OR kubernetes.namespace: "oh-tst") AND tags: adp_tax_integration
• ELK PROD Lookup: 
  • Periodic File
    • (agent.hostname: mualphpp* OR  kubernetes.namespace: "oh-prd") AND tags: adp_tax_integration 
  • Quarterly File
    • (agent.hostname: mualphpp* OR  kubernetes.namespace: "oh-prd") AND tags: adp_tax_integration 

AWS S3

• Log in to AWS
• Go to UIT -> Management Console ->S3
• TEST Bucket Name: oh-tst-admin-soldel-laravel-s3-f8d3c195c7
• PROD Bucket Name: oh-prd-admin-soldel-laravel-s3-ecae143d60
• Name of the object directory: adp_tax_integration
• ADP Tax Integration Periodic File, Quarterly File & error files are stored in AWS S3
• ADP Tax Integration  Periodic PRODUCTION Environment File name: 

  'p.mud1.tax.[date].prl'
  

• ADP Tax Integration Periodic TEST Environment File name: 

  'c.mud1.tax.test.[date].prl'
  

• ADP Tax Integration Quarterly PRODUCTION Environment File name: 

  'p.mud1.tax.[date].qtrly'
  

• ADP Tax Integration Quarterly TEST Environment File name: 

  'c.mud1.tax.test.[date].qtrly'

• [date] is in the format of "Ymdhis". So, January 17th, 2023 11:54:53 would be 20230117115453 

AppWorx Jobs

• Periodic Job: ADP-TAX-PERIODIC-FILE
• Quarterly Job: ADP-TAX-QUARTERLY-FILE

ADP SFTP details

• Server Name: tfsuxp02.adp.com 
• Private key: 
  • TEST Private Key: This private key is placed in Test server, PHPT25 directory in /var/www/apps/adp-tax-integration/storage/app/.ssh/id_rsa
  • PROD Private Key: This  private key is placed in Test server, PHPP25 directory in /var/www/apps/adp-tax-integration/storage/app/.ssh/id_rsa
• Public Key: 
  • TEST Public Key: This public key is placed in Test server, PHPT25 directory in /var/www/apps/adp-tax-integration/storage/app/.ssh/id_rsa.pub
  • PROD Public Key: This public key is placed in Test server, PHPP25 directory in /var/www/apps/adp-tax-integration/storage/app/.ssh/id_rsa.pub
• File Location Path:
  • ADP Tax integration Export File is located in /INBOUND/ directory