GPJP_PERNBR_TBL (SQL Table)	Index Back
JPN personal number for report Staging table used by YEA processes to be able to print decrypted JPN Personal Number. This table is shared by various reports.

GPJP_PERNBR_TBL

(SQL Table)

JPN personal number for report

Staging table used by YEA processes to be able to print decrypted JPN Personal Number. This table is shared by various reports.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

3 DEPENDENT_BENEF Character(2) VARCHAR2(2) NOT NULL Dependent Benefit
01=default

4 PERS_NUMBER_JPN Character(150) VARCHAR2(150) NOT NULL This field stores the My Number of each employee and dependent.

5 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	DEPENDENT_BENEF	Character(2)	VARCHAR2(2) NOT NULL	Dependent Benefit 01=default
4	PERS_NUMBER_JPN	Character(150)	VARCHAR2(150) NOT NULL	This field stores the My Number of each employee and dependent.
5	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID