LM_SEC_VW1

(SQL View)
 Index Back

PromptRec for Security Group

Prompt Record for Security Group

SELECT B.FIELDVALUE , A.ROLENAME , A.DESCR FROM PSROLEDEFN A , PSXLATITEM B WHERE A.ROLESTATUS = 'A' AND B.FIELDNAME = 'LM_SEC_TYPE' AND B.FIELDVALUE = 'ROLE' AND %EffdtCheck(PSXLATITEM, B, %currentdatein) UNION ALL SELECT B.FIELDVALUE , A.CLASSID , A.CLASSDEFNDESC FROM PSCLASSDEFN A , PSXLATITEM B WHERE B.FIELDNAME = 'LM_SEC_TYPE' AND B.FIELDVALUE = 'PERM' AND %EffdtCheck(PSXLATITEM, B, %currentdatein)

  • Related Language Record: LM_SEC_VW_LNG1

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_SEC_TYPE Character(4) VARCHAR2(4) NOT NULL XLAT for Roles/Permission List
    PERM=Permission List
    ROLE=Role
    2 LM_SEC_ITEM Character(30) VARCHAR2(30) NOT NULL Group Similar Roles/Permission List
    3 LM_DESCR Character(50) VARCHAR2(50) NOT NULL Description