Prev
Next
Forums Human Capital Management Infor Global HR (GHR)

What table contains CHANGEDFIELDS

 1 Replies
 0 Subscribed to this topic
 45 Subscribed to this forum
Sort:
Author
Messages
TimC
Veteran Member
Posts: 84
Veteran Member
6/19/2017 5:55 PM
    I need to query the export tables and need the CHANGEDFIELDS field as it doesn't exists on the ...EXPORT tables (WorkassignmentExport, EmployeeExport. What tables correlate that I can join to fetch this field?

    Landmark V10.
    TimC
    Veteran Member
    Posts: 84
    Veteran Member
    6/20/2017 1:03 PM
      I figured it out. This is the SQL Server version

      SELECT t.name,c.name
      FROM sys.columns c
      JOIN sys.tables t ON c.object_id = t.object_id
      WHERE c.name LIKE '%CHANGEDFIELDS%'