| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 3 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 4 |
GPES_PP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Pension Plan Identifier
|
| 5 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 6 |
GPES_PP_CNTRIBUTOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Pension Plan Contributor
C=Company
E=Employee
Default Value: C
|
| 7 |
AMOUNT |
Signed Number(20,3) |
DECIMAL(18,3) NOT NULL |
Commuting Allowance Paid Per Cycle.
|
| 8 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: EUR
Prompt Table:
CURRENCY_CD_TBL
|
| 9 |
GPES_FISCAL_KEY |
Character(2) |
VARCHAR2(2) NOT NULL |
Fiscal key. Used to identify the earnings.
Prompt Table:
GPES_PERCEP_KEY
|
| 10 |
GPES_FISCAL_SUBKEY |
Character(2) |
VARCHAR2(2) NOT NULL |
Fiscal sub-key. Used to identify the earnings.
Prompt Table:
GPES_PERCP_SKEY
|
| 11 |
GPES_JANUARY |
Character(1) |
VARCHAR2(1) NOT NULL |
Use in GPES_PP_CONTRIB record
Y/N Table Edit
Default Value: N
|
| 12 |
GPES_FEBRUARY |
Character(1) |
VARCHAR2(1) NOT NULL |
Use in GPES_PP_CONTRIB record
Y/N Table Edit
Default Value: N
|
| 13 |
GPES_MARCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Use in GPES_PP_CONTRIB record
Y/N Table Edit
Default Value: N
|
| 14 |
GPES_APRIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Use in GPES_PP_CONTRIB record
Y/N Table Edit
Default Value: N
|
| 15 |
GPES_MAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Use in GPES_PP_CONTRIB record
Y/N Table Edit
Default Value: N
|
| 16 |
GPES_JUNE |
Character(1) |
VARCHAR2(1) NOT NULL |
Use in GPES_PP_CONTRIB record
Y/N Table Edit
Default Value: N
|
| 17 |
GPES_JULY |
Character(1) |
VARCHAR2(1) NOT NULL |
Use in GPES_PP_CONTRIB record
Y/N Table Edit
Default Value: N
|
| 18 |
GPES_AUGUST |
Character(1) |
VARCHAR2(1) NOT NULL |
Use in GPES_PP_CONTRIB record
Y/N Table Edit
Default Value: N
|
| 19 |
GPES_SEPTEMBER |
Character(1) |
VARCHAR2(1) NOT NULL |
Use in GPES_PP_CONTRIB record
Y/N Table Edit
Default Value: N
|
| 20 |
GPES_OCTOBER |
Character(1) |
VARCHAR2(1) NOT NULL |
Use in GPES_PP_CONTRIB record
Y/N Table Edit
Default Value: N
|
| 21 |
GPES_NOVEMBER |
Character(1) |
VARCHAR2(1) NOT NULL |
Use in GPES_PP_CONTRIB record
Y/N Table Edit
Default Value: N
|
| 22 |
GPES_DECEMBER |
Character(1) |
VARCHAR2(1) NOT NULL |
Use in GPES_PP_CONTRIB record
Y/N Table Edit
Default Value: N
|
| 23 |
GPES_PP_RETRIB_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of retribution
D=Deduction
E=Earnings
K=Earnings in kind
|
| 24 |
GPES_PP_REDCTN_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
RDL 12/22 pension plan reducion flag
Y/N Table Edit
|