List of bursting rights, elements and users

Author
Messages
Donna
Veteran Member
Posts: 110
Veteran Member
    What tables have the bursting information fields?

    Thank you.
    Donna
    Donna
    Veteran Member
    Posts: 110
    Veteran Member
      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.
      Kelly H
      Veteran Member
      Posts: 167
      Veteran Member
        Are these tables listed with your other Lawson tables? Or did you have to go to a different location?
        Greg Moeller
        Veteran Member
        Posts: 1498
        Veteran Member
          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.
          Joan Herzfeldt
          Veteran Member
          Posts: 74
          Veteran Member
            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
            Donna
            Veteran Member
            Posts: 110
            Veteran Member
              Nice
              Lance Kelley
              Advanced Member
              Posts: 24
              Advanced Member
                Thank you Joan.
                ---