EMPLIDYEARMONTHPP_FUND_PRVDR_ESPPP_FPVDR_ESP_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 P.EMPLID ,%NumToChar(CAL.CALYEAR) ,GPES_MONTH ,%Substring(XLAT.XML_XLAT_VALUE, 1, 5) ,XLAT.DESCR50 FROM PS_XML_XLATITEM XLAT , PS_PERSON P , PS_GPES_SYS_CALEND CAL WHERE XLAT.SETID='ESP' AND XLAT.XML_XLAT_CODE = 'T-100' |
| # | 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 |