Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

How to view TAEEMASTER table from SQL database in Lawson

 1 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
wintergreen
Veteran Member
Posts: 93
Veteran Member
5/21/2009 6:17 PM

    We are implementing absence management project. User will have an ODBC connection to SQL in Microsoft Access and  link to the TAEEMASTER table from SQL. However, the table is NULL, when I open the table directly from SQL server, it is NULL.  But, if I query this table using Microsoft Add-In, data was imported to Excel. I don't know how it was stored in SQL, and how to pull out the data if we use the ODBC connection to this TAEEMASTER table?

    rj
    New Member
    Posts: 1
    New Member
    5/21/2009 9:23 PM
      I found the following on the support site. In short, look in EMTAMASTR to see if the data is actually stored there.

      Prior to getting the employee's leave balance, we do a DME call to the IF system code's GLCODES table looking for an LP record to see if LP is enabled. If we find a record, LP is indeed enabled and we go after the TAEEMASTER data. If the DME does not come back with a record, we assume LP is not being used and then we go after EMTAMASTR data. The DME call is exactly the same for any employee accessing the Leave Balances task. In this case, it was a security issue. The TA format employee was not returning a GLCODES record for that call due to not having access to the GLCODES table, while the LP format employee did have access to that table and returned a record. So Employee Self Service was working as it should based on the data it was receiving and security set up. Once the employee who was seeing the TA format leave balances had access to the GLCODES table, the LP format was viewable.