PERS_SEC_VW_LG

(SQL View)
 Index Back

Personal Number Japan


SELECT '1' , ROLEUSER ,LANGUAGE_CD , DESCR FROM PS_ROLEXLATOPR_LNG UNION SELECT '2' , ROLENAME , LANGUAGE_CD , DESCR FROM PS_ROLEDEFN_VW_LG

  • Related Language Record for PERS_SEC_JPN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    2 ACCESS_TYPE_JPN Character(1) VARCHAR2(1) NOT NULL User or a Role
    1=User ID
    2=Role
    3 USER_ROLE_JPN Character(30) VARCHAR2(30) NOT NULL User ID/Role Name
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description