EOEC_DS_RULE_VW

(SQL View)
 Index Back

Dataset Rule View

SELECT DISTINCT B.ROLEUSER , C.EOEC_DATASETNAME , C.EOEC_RULENAME , E.DESCR , E.SEARCHRECNAME , 'Y' FROM PSROLEDEFN A , PSROLEUSER B , PS_EOEC_MP_ROLRULE C , PS_EOEC_MP_RULE E WHERE A.ROLENAME = B.ROLENAME AND A.ROLENAME = C.ROLENAME AND C.EOEC_RULENAME = E.EOEC_RULENAME AND A.ROLESTATUS = 'A' AND E.STATUS = 'A' AND E.EOEC_MP_VALIDRULE = 'Y'

SELECT DISTINCT B.ROLEUSER , C.EOEC_DATASETNAME , C.EOEC_RULENAME , E.DESCR , E.SEARCHRECNAME , 'Y' FROM PSROLEDEFN A , PSROLEUSER B , PS_EOEC_MP_ROLRULE C , PS_EOEC_MP_RULE E WHERE A.ROLENAME = B.ROLENAME AND A.ROLENAME = C.ROLENAME AND C.EOEC_DATASETNAME = E.EOEC_DATASETNAME AND C.EOEC_RULENAME = E.EOEC_RULENAME AND A.ROLESTATUS = 'A' AND E.STATUS = 'A' AND E.EOEC_MP_VALIDRULE = 'Y'

  • Related Language Record: EOEC_DS_RLNG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User
    2 EOEC_DATASETNAME Character(30) VARCHAR2(30) NOT NULL The name of one or more rules that will be used to filter a rowset.
    3 EOEC_RULENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 SEARCHRECNAME Character(15) VARCHAR2(15) NOT NULL Search Record Name
    6 EOEC_SELECT_RULE Character(1) VARCHAR2(1) NOT NULL came with the crm import.

    Y/N Table Edit