EMPLIDEMPL_RCDERE_BGNDT_ESPPrompt Table: %GP_EDIT_FLD5
GPES_LBR_ERE_VW(SQL View) |
Index Back |
|---|---|
ERE Complementary benefitsERE Complementary benefits for employees included in an ERE procedure. |
| SELECT EE.EMPLID , EE.EMPL_RCD , EE.ERE_BGNDT_ESP , EE.ERE_ENDDT_ESP , BN.ERE_BNF_TO_ESP , BN.ERE_BNF_PCT_ESP , ED.ERE_PIN_BN1_NUM FROM PS_ERE_ALL_EE_VW EE , PS_ERE_DTA_BNF_ESP BN , PS_ERE_DATA_ESP ED WHERE ERE_U_ACTN_TYP_ESP <> 'P' AND EE.ERE_ID_ESP = BN.ERE_ID_ESP AND EE.ERE_ID_ESP = ED.ERE_ID_ESP |
| # | 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 | ERE_BGNDT_ESP |
Date(10) | DATE | ERE Begin date |
| 4 | ERE_ENDDT_ESP | Date(10) | DATE | ERE End date |
| 5 | GPES_BNF_ERE_TO | Number(3,0) | SMALLINT NOT NULL | ERE Complementary Benefits TO. This field houses the day until the ERE Complementary Benefits percentage applies. It is defined in days. |
| 6 | GPES_BNF_ERE_PCT | Signed Number(11,6) | DECIMAL(9,6) NOT NULL | ERE Complementary Benefits. This field houses the percentage to be applied over the employee benefits base during ERE. This percentage is equal to SPEE statutory benefits + Company Complementary Benefits (no mandatory and defined by LA). |
| 7 | GPES_PIN_SS1_NUM | Number(8,0) | INTEGER NOT NULL |
This field houses the Employer SS Accumulator Pin Number.
Prompt Table: %GP_EDIT_FLD5 |