EMPLIDYEARMONTHPP_FUND_PRVDR_ESPGPES_PP_FPVD_VW(SQL View) |
Index Back |
|---|---|
Pension fund providersPension plan fund providers. If GP Spain is installed, the providers are retrieved from the payroll results. If GP Spain is not installed, the providers are retrieved from code table T-100. |
| SELECT DISTINCT A.EMPLID ,%NumToChar(A.GPES_YEAR) ,A.GPES_MONTH ,A.GPES_PP_FUND_PRVDR ,X.DESCR50 FROM PS_GPES_PP_RSLT A , PS_XML_XLATITEM X WHERE X.SETID='ESP' AND X.XML_XLAT_CODE = 'T-100' AND X.XML_XLAT_VALUE = A.GPES_PP_FUND_PRVDR AND %Sql(GPES_TX_MAX_VER_REV_NUM, PS_GPES_PP_RSLT, A) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | YEAR |
Character(4) | VARCHAR2(4) NOT NULL | Character field to represent a year |
| 3 | MONTH |
Number(2,0) | SMALLINT NOT NULL | Month |
| 4 | PP_FUND_PRVDR_ESP |
Character(5) | VARCHAR2(5) NOT NULL | Pension plan provider |
| 5 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |