Open Forum

 View Only
  • 1.  Report on Employee Email address in SmarList

    Posted Oct 26, 2022 01: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
    ------------------------------


  • 2.  RE: Report on Employee Email address in SmarList

    Posted Oct 27, 2022 02: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/
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role