REDUCTION_ID_ESPEFFDTDefault Value: %date
GPES_ABS_TYPEACC=Industrial Accident
CUI=Minors (Serious illness)
DIS=Temporary Disability
MAT=Maternity
RSK=Risk on Pregnancy
Y/N Table Edit
Default Value: N
Prompt Table: GPES_SS_RDTN_VW
GPES_SS_BNF_AA(SQL Table) |
Index Back |
|---|---|
SS Reduction DefinitionThis table stores the Automatic Reduction Definition. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REDUCTION_ID_ESP |
Character(3) | VARCHAR2(3) NOT NULL | Reduction ID |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | GPES_ABS_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Absence type
ACC=Industrial Accident CUI=Minors (Serious illness) DIS=Temporary Disability MAT=Maternity RSK=Risk on Pregnancy |
| 4 | GPES_BNF_AA_CHECK | Character(1) | VARCHAR2(1) NOT NULL |
Social Security benefit type
Y/N Table Edit Default Value: N |
| 5 | GPES_BNF_AA_METHOD | Character(8) | VARCHAR2(8) NOT NULL |
Social Security benefit type
Prompt Table: GPES_SS_RDTN_VW |