EnterpriseOne UserIDs Of Terminated Empoyees
My current employer is a publicly traded entity. As such, we are subject to SOX regulations. Because of this we run many reports periodically to satisfy the auditing department.
One of those reports determines if there are any terminated employees that still have active UserIDs.
Here is the SQL that is used for the report:
SELECT uluser, -- userid from f0092 sceuser, -- userid from f98owsec yapast, -- employee pay status from f060116 date(char(yadt+1900000)), -- adjustment date (last edit of record) from f060116 yaalph -- full name from f060116 FROM sy811/f0092 a, sy811/f98owsec b, proddta/f060116 c WHERE a.uluser = b.scuser = userid and a.ulan8 = c.yaan8 -- address book # and c.yapast <> '0' -- employee pay status not active and b.sceuser = '01' -- userid is enabled
Tags: enterpriseone, EnterpriseOne - Security, EnterpriseOne - SQLs, sql
