ERE_DTA_BNF_ESP(SQL Table) |
Index Back |
---|---|
ERE Complementary benefitsERE Complementary benefits |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | ERE_ID_ESP | Character(10) | VARCHAR2(10) NOT NULL |
ERE ID
Prompt Table: ERE_DATA_ESP |
2 | ERE_BNF_TO_ESP | Number(3,0) | SMALLINT NOT NULL | ERE Complementary Benefits TO. |
3 | ERE_BNF_PCT_ESP | 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). |