RQ_ROLEDEFN_VW

(SQL View)
 Index Back

Quality Role Definition View


SELECT %Substring(C1.OPRALIASVALUE,1,15) , A.ROLENAME , A.DESCR , A.DESCRLONG , A.ROLESTATUS FROM PSROLEDEFN A , PS_ROLEXLATOPR A1 , PSROLEUSER B1 , PSOPRALIAS C1 WHERE A1.ROLEUSER = B1.ROLEUSER AND A1.OPRID = C1.OPRID AND C1.OPRALIASTYPE = 'PER' AND A.ROLENAME = B1.ROLENAME

  • Related Language Record: RQ_ROLEDFNLNGVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
    2 R_INT_PERSON_TYPE Character(30) VARCHAR2(30) NOT NULL Interested Person
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRLONG Long Character CLOB Long Description
    5 ROLESTATUS Character(1) VARCHAR2(1) NOT NULL Role Status
    A=Active
    I=Inactive