GPJP_PERNBR_AET

(SQL Table)
Index Back

JPN Pers Num AET

AET record for JPN Personal Number decrypt process

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 DEPENDENT_BENEF Character(2) VARCHAR2(2) NOT NULL Dependent Benefit
01=default
6 PERS_NUMBER_JPN Character(150) VARCHAR2(150) NOT NULL This field stores the My Number of each employee and dependent.
7 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
8 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance