EMPLIDPrompt Table: PERSON
CONTRACT_NUMREDCTN_ID_ESPPrompt Table: GPES_SS_BNF
EFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
GPES_SS_D_REDVW(SQL View) |
Index Back |
|---|---|
SS Reduction DefinitionHouses the employee reduction definition. |
| SELECT DISTINCT A.EMPLID , A.CONTRACT_NUM , A.REDCTN_ID_ESP , C.EFFDT , A.EFF_STATUS , A.EFFDT , A.END_DT , C.GPES_SS_BONIF_FROM , C.GPES_SS_BONIF_TO FROM PS_CNTRCT_DATA_ESP A , PS_GPES_SS_BNF B , PS_GPES_SS_BNF_DTA C WHERE A.REDCTN_ID_ESP = B.REDUCTION_ID_ESP AND B.REDUCTION_ID_ESP = C.REDUCTION_ID_ESP AND B.EFFDT = C.EFFDT AND A.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract Number |
| 3 | REDCTN_ID_ESP |
Character(3) | VARCHAR2(3) NOT NULL |
Reduction ID
Prompt Table: GPES_SS_BNF |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 6 | GPES_REDCTN_DT | Date(10) | DATE | Social Security / Inem reduction date |
| 7 | END_DT | Date(10) | DATE | end date |
| 8 | GPES_SS_BONIF_FROM | Number(3,0) | SMALLINT NOT NULL | This field houses the month number to where the reduction takes place. |
| 9 | GPES_SS_BONIF_TO | Number(3,0) | SMALLINT NOT NULL | This field houses the month number from where the reduction takes place. |