EMPLIDPrompt Table: PERSON
EMPL_RCDGPGB_STK_SCHEMEAMT=Fixed Amount Scheme
PCT=Percentage Scheme
BGN_DTGPGB_EE_STKHLD(SQL Table) |
Index Back |
|---|---|
Employee Stakeholder DetailsCaptures employee stakeholder pension details. |
| # | 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 Rcd Nbr |
| 3 | GPGB_STK_SCHEME |
Character(3) | VARCHAR2(3) NOT NULL |
Stakeholders Pension Scheme
AMT=Fixed Amount Scheme PCT=Percentage Scheme |
| 4 | BGN_DT |
Date(10) | DATE NOT NULL | Begin Date |
| 5 | GPGB_EE_PCTG_CONT | Number(6,2) | DECIMAL(5,2) NOT NULL | Employee's Percentage Contribution |
| 6 | GPGB_ER_PCTG_CONT | Number(6,2) | DECIMAL(5,2) NOT NULL | Employer's Percentage Contribution |
| 7 | GPGB_EE_PEN_AMT | Number(10,2) | DECIMAL(9,2) NOT NULL | Employers Flat Amount Contribution |
| 8 | GPGB_ER_PEN_AMT | Number(10,2) | DECIMAL(9,2) NOT NULL | Employers Pension Fixed Amount |
| 9 | END_DT | Date(10) | DATE | end date |