GPES_SS_BSE_VW(SQL View) |
Index Back |
|---|---|
SS Contribution VWGPES_SS_BSE_VW houses the employee contribution definition. This information is used in Social Security formulas. |
| SELECT A.SCHEME_ID_ESP , A.CURRENCY_CD , A.EFFDT , C.CONTRIB_ID_ESP , B.SOC_SEC_WRK_GRP_CD , A.EFF_STATUS , B.WRK_GRP_FREQ_ESP , C.CONTRIB_TYPE_ESP , C.SSN_EMPL_TYPE , A.MIN_CEIL_ESP , A.MAX_CEIL_ESP , B.MIN_WRK_GRP_AMNT , B.MAX_WRK_GRP_AMNT , A.MIN_HRLY_RT_ESP , B.HRLY_WRK_GRP_AMNT FROM PS_SOC_SEC_RGM_TBL A , PS_RGM_BSE_ESP_TBL B , PS_RGM_CTZ_ESP_TBL C WHERE A.SCHEME_ID_ESP = B.SCHEME_ID_ESP AND A.CURRENCY_CD = B.CURRENCY_CD AND A.EFFDT = B.EFFDT AND B.SCHEME_ID_ESP = C.SCHEME_ID_ESP AND B.CURRENCY_CD = C.CURRENCY_CD AND B.EFFDT = C.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SCHEME_ID_ESP |
Character(4) | VARCHAR2(4) NOT NULL | Scheme ID - ESP |
| 2 | CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 3 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 4 | CONTRIB_ID_ESP |
Character(5) | VARCHAR2(5) NOT NULL | Soc.Sec. Contribution ID - ESP |
| 5 | SOC_SEC_WRK_GRP_CD | Character(2) | VARCHAR2(2) NOT NULL |
Social Security Work Group
01=01-Engineers 02=02-Technicals 03=03-Administrative 04=04-Assistants 05=05-White Collar 06=06-Subordinates 07=07-Administrative assistants 08=08-1st and 2nd degree 09=09-3rd degree 10=10-Over 18 years 11=11-Under 18 years |
| 6 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 7 | WRK_GRP_FREQ_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Frequency - ESP
D=Daily M=Monthly |
| 8 | CONTRIB_TYPE_ESP | Character(2) | VARCHAR2(2) NOT NULL |
Soc.Sec. Contribution Type - ESP
10=Percentage 20=Rate |
| 9 | SSN_EMPL_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Social Security Number Type
1=Regular 2=Apprenticeship 3=Training |
| 10 | MIN_CEIL_ESP | Number(9,2) | DECIMAL(8,2) NOT NULL | Lower Ceiling |
| 11 | MAX_CEIL_ESP | Number(9,2) | DECIMAL(8,2) NOT NULL | Upper Ceiling |
| 12 | MIN_WRK_GRP_AMNT | Number(9,2) | DECIMAL(8,2) NOT NULL | Minimum Amount |
| 13 | MAX_WRK_GRP_AMNT | Number(9,2) | DECIMAL(8,2) NOT NULL | Maximum Amount |
| 14 | MIN_HRLY_RT_ESP | Number(9,2) | DECIMAL(8,2) NOT NULL | Minimum Hourly Rate |
| 15 | HRLY_WRK_GRP_AMNT | Number(9,2) | DECIMAL(8,2) NOT NULL | Minimum Hourly Amount - ESP |