List of bursting rights, elements and users

Well, I answered my own question with a little help from the guru archives.

The tables are ERS_RULEMASTER, ERS_RULE DETAIL, ERS_ELEMENTS, ERS_STRUCTURE. There are additional tables in ERS but the ones listed solved my requirements.

Are these tables listed with your other Lawson tables? Or did you have to go to a different location?

They are actually under the LBI schema (if you are running Oracle) They default to LawsonFS, LawsonRS, LawsonSN.. but your DBA could have named them anything.
MSSQL treats them a little bit differently... and they could really be anywhere.

This might help. I prefer to create views and use crystal to format the data. Here is the view I created to pull our rights.
select
M.RULEID
, U.CONSUMERID AS USERORROLE
, M.RULENAME
, M.RULEOWNER
, M.STARTDATE --datetime field for CR
, M.ENDDATE --datetime field for CR
, D.STRUCTUREID, S.STRUCTURENAME
, D.ELEMENTID, E.ELEMENTNAME
, D.ELEMENTORDER
, V.SEQUENCEID
, D.OPERAND
, V.ELEMENTVALUE1
, D.ELEMENTVALUE2
, V.RULEGROUPING

FROM ERS_RULEMASTER M
JOIN ERS_RULEMAPPINGS U ON M.RULEID = U.RULEID
JOIN ERS_RULEDETAIL D ON M.RULEID = D.RULEID
JOIN ERS_RULEVALUES V ON D.RULEID = V.RULEID and D.STRUCTUREID = V.STRUCTUREID and D.ELEMENTID = V.ELEMENTID
JOIN ERS_STRUCTURE S ON D.STRUCTUREID = S.STRUCTUREID AND S.STATUS = 'A'
JOIN ERS_ELEMENTS E ON D.ELEMENTID = E.ELEMENTID
where M.STATUS = 'A' --active records

Joan

Nice

Thank you Joan.