PERS_SEC_JPN_VW

(SQL View)
Index Back

Personal Number Japan


SELECT '1' ,ROLEUSER , DESCR FROM PS_ROLEXLATOPR UNION SELECT '2' , ROLENAME , DESCR FROM PS_ROLEDEFN_VW1

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