LM_SEC_VW_LNG1

(SQL View)
 Index Back

LangRec for Sec Group PrmptRec

Language Record for Security Group Prompt Record

SELECT B.FIELDVALUE , A.ROLENAME , A.LANGUAGE_CD , A.DESCR FROM PSROLEDEFNLANG A , PSXLATITEMLANG B WHERE A.LANGUAGE_CD = B.LANGUAGE_CD AND B.FIELDNAME = 'LM_SEC_TYPE' AND B.FIELDVALUE = 'ROLE' AND %EffdtCheck(PSXLATITEMLANG, B, %currentdatein) UNION ALL SELECT B.FIELDVALUE , A.CLASSID , A.LANGUAGE_CD , A.CLASSDEFNDESC FROM PSCLASSDEFN_LNG A , PSXLATITEMLANG B WHERE A.LANGUAGE_CD = B.LANGUAGE_CD AND B.FIELDNAME = 'LM_SEC_TYPE' AND B.FIELDVALUE = 'PERM' AND %EffdtCheck(PSXLATITEMLANG, B, %currentdatein)

  • Related Language Record for LM_SEC_VW1

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 LM_DESCR Character(50) VARCHAR2(50) NOT NULL Description