GPES_SSTC_EE_VW(SQL View) |
Index Back |
|---|---|
TCs Generation CCC and EE ViewTCs Generation CCC and EE View |
| SELECT DISTINCT A.EMPLID , A.CAL_RUN_ID , A.EMPL_RCD , A.GP_PAYGROUP , A.CAL_ID , A.ORIG_CAL_RUN_ID , A.GPES_SSTC_PAYMNT , A.SSN_EMPLOYER , A.GPES_SSTC_ELEM_GRP , A.GPES_YEAR , A.GPES_MONTH , A.GPES_YEAR_RECALC , A.GPES_MONTH_RECALC , A.RSLT_VER_NUM , A.RSLT_REV_NUM , A.GPES_SSTC_CNTRL_DT , A.GPES_OOD_PYMT_SUR , %Coalesce(C.NATIONAL_ID, ' ') FROM PS_GPES_SSTC_RS_VW A LEFT OUTER JOIN PS_PERS_NID C ON A.EMPLID = C.EMPLID AND C.COUNTRY = 'ESP' AND C.NATIONAL_ID_TYPE = 'SSN' WHERE A.GPES_SSTC_EXCL_FAN = '00' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 5 | CAL_ID | Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 6 | ORIG_CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Original Calendar Group ID |
| 7 | GPES_SSTC_PAYMNT | Character(3) | VARCHAR2(3) NOT NULL |
Payment Type. This field is used to populate the GP Write Array, which is used to generate the FAN File.
L00=Regular L02=Litigation Salary L03=Retroactivity wo/Surcharge L04=Reductions Payback L09=Retroactivity w/Surcharge L13=Vacations L90=Retro w/Surch. Base Incr. L91=Retro w/Surch. New Slices V03=Retro wo/ Surcharge Vacations V90=Retro w/ Surcharge Vacations Default Value: L00 |
| 8 | SSN_EMPLOYER | Character(13) | VARCHAR2(13) NOT NULL | Employer Social Security number |
| 9 | GPES_SSTC_ELEM_GRP | Character(4) | VARCHAR2(4) NOT NULL |
Element Grouping used to separate data into different TC2 payment messages.
CDPG=Company Paid Benefit CDXX=Reductions XXXX=Other |
| 10 | GPES_YEAR | Number(4,0) | SMALLINT NOT NULL | Year |
| 11 | GPES_MONTH | Number(2,0) | SMALLINT NOT NULL | Month |
| 12 | GPES_YEAR_RECALC | Number(4,0) | SMALLINT NOT NULL | Retro year |
| 13 | GPES_MONTH_RECALC | Number(2,0) | SMALLINT NOT NULL | Retro month |
| 14 | RSLT_VER_NUM | Number(4,0) | SMALLINT NOT NULL | Result Version Number |
| 15 | RSLT_REV_NUM | Number(4,0) | SMALLINT NOT NULL | Result Revision Number |
| 16 | GPES_SSTC_CNTRL_DT | Date(10) | DATE | Social Security TCs control date |
| 17 | GPES_OOD_PYMT_SUR | Number(2,0) | SMALLINT NOT NULL | FAN surcharge because of an out of date payment |
| 18 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |