OPRIDRUN_CNTL_IDPERS_TYPE_JPND=Dependent
E=Employee
EMPLIDDEPENDENT_BENEF01=default
Y/N Table Edit
E=Error
S=Success
PER_G_MUPL_JPN(SQL Table) |
Index Back |
|---|---|
Personal Number JapanUnderlying record of the grid on Personal Number Mass Upload page for Employees. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | PERS_TYPE_JPN |
Character(1) | VARCHAR2(1) NOT NULL |
Person Type for Japan, Decides wether employee or dependent
D=Dependent E=Employee |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | DEPENDENT_BENEF |
Character(2) | VARCHAR2(2) NOT NULL |
Dependent Benefit
01=default |
| 6 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 7 | NATIONAL_ID_TYPE | Character(6) | VARCHAR2(6) NOT NULL | National ID Type |
| 8 | PRIMARY_NID | Character(1) | VARCHAR2(1) NOT NULL |
Primary ID
Y/N Table Edit |
| 9 | RUNDATE | Date(10) | DATE | Process Scheduler Run Date |
| 10 | HR_PERS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Stores the run status during Mass Upload of Personal Number
E=Error S=Success |
| 11 | PERS_NUMBER_JPN | Character(150) | VARCHAR2(150) NOT NULL | This field stores the My Number of each employee and dependent. |