GPGB_PEN_PAYEE(SQL Table) |
Index Back |
|---|---|
Employee Pension DetailsCaptures payee details for qualifying pension scheme. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 4 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 5 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 6 | GPGB_OPTIN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Pension Opt In Flag for GBR
0=NO 1=YES |
| 7 | GPGB_OPTIN_RE | Character(1) | VARCHAR2(1) NOT NULL |
Pension Opt In Flag for Re-Enrolment GBR
0=NO 1=YES |
| 8 | GPGB_OPTOUT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Pension Opt Out Flag for GBR
0=None 1=Opt-Out 2=Cease |
| 9 | GPGB_POSTPONE_DT | Date(10) | DATE | GBR postpone till date field |
| 10 | GPGB_POSTPONE_RSN | Character(4) | VARCHAR2(4) NOT NULL |
Pension Postponement reason for GBR
JDDF=Job Holder Deferment SDDF=Staging Date Deferment WRDF=Worker Deferement |
| 11 | GPGB_AGGER_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Aggregate Earning Flag for GBR
0=NO 1=YES |
| 12 | GPGB_NOTPRC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Do not Process Flag for GBR
0=NO 1=YES |
| 13 | GPGB_OVRPEN_SCHEME | Character(10) | VARCHAR2(10) NOT NULL |
Pension Scheme for GBR
Prompt Table: GPGB_PEN_SCM_VW |
| 14 | GPGB_PEN_FACTOR | Number(2,0) | SMALLINT NOT NULL |
Multiplication Factor GBR
Default Value: 1 |
| 15 | GPGB_REASON | Character(20) | VARCHAR2(20) NOT NULL | GBR Pension Do not Process Reason |