What is the best way to capture time approvals? I see in the LaborDtl table there is the approved date but I do not see an Approved By field. Need to have a change log that includes “who” approved or rejected time. Maybe a little more challenging is deciphering who the who actually was taking into consideration the Authorized Users list.
LaborDtl.ChangedBy: Userid of the user who made the last change to this record.
Use LaborDtl.TimeStatus = ‘A’ for approved.
Thanks Nate! That did the trick! Now if I can just find a way to “purge” change logs selectively… but that’s another topic!