PER_SEC_ADD_JPN(SQL Table) |
Index Back |
|---|---|
Personal Number JapanThis record stores the user IDs/roles that will have access to the Personal Number of individual Employees. |
| # | 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 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PER_SEC_JPN_DVW |
| 3 | ACCESSTYPE_NAME |
Character(30) | VARCHAR2(30) NOT NULL |
User or a Role
Default Value: PERS_SEC_L0_JPN.ACCESSTYPE_NAME Prompt Table: %EDITTABLE |
| 4 | VIEW_ACCESS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Japan Personal Number. This checkbox validates whether an admin has been given view access to the Personal Number of an Employee.
Y/N Table Edit Default Value: N |
| 5 | FULL_ACCESS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Japan Personal Number. This checkbox validates whether an admin has been given full access to the Personal Number of an Employee.
Y/N Table Edit Default Value: N |
| 6 | NO_ACCESS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Japan Personal Number. This checkbox validates whether an admin hasnt been given access to the Personal Number of an Employee.
Y/N Table Edit Default Value: N |