PERS_SEC_L0_JPN

(SQL Table)
 Index Back

Personal Number Japan

Level 0 record for the page HR_PERSNO_SEC_JPN. It stores user IDs/ Roles.

  • Parent Record Of PER_SEC_ADD_JPN PER_SEC_JPN

    • # 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 ACCESSTYPE_NAME Character(30) VARCHAR2(30) NOT NULL User or a Role

    Prompt Table: PERS_SEC_JPN_VW

    3 ROW_SEC_ACCESS_JPN Character(1) VARCHAR2(1) NOT NULL Default Security

    Y/N Table Edit

    Default Value: N