Report on Employee Email address in SmarList

  • Report on Employee Email address in SmarList

    Posted by DSC Communities on October 26, 2022 at 1:47 pm
    • Dianna Clem

      Member

      October 26, 2022 at 1:47 PM

      We would like to be able to pull Employee’s e-mail addresses into custom SmartList reports. What table would the Employee Internet Information window/e-mail address information be in (Payroll modules)? Is it possible to add this data to a SmartList report? If anyone has any table information or tips on doing this, we’d appreciate it. Thanks!

      #HRandPayroll
      #SmartList

      -Dianna

      ???

      ——————————
      Dianna Clem
      Payroll Specialist
      Houghton College
      Houghton NY
      ——————————

    • Dexterity Developer

      Member

      October 27, 2022 at 2:12 AM

      Same table is used to hold Employee‘s e-mail addresses, that isĀ  SY01200. You can create new smartlist by using either view or smartlist builder.

      SELECT * FROM SY01200 WHERE Master_type=’EMP’

      ——————————
      dexteritydeveloper
      dexteritydeveloper@gmail.com
      https://keptonworking.blogspot.com/
      ——————————
      ——————————————-

    DSC Communities replied 3 years, 5 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Report on Employee Email address in SmarList’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!