GPES_SSTC_CCCVW(SQL View) |
Index Back |
|---|---|
TCs Generation CCC ViewTCs Generation CCC View |
| SELECT DISTINCT S.OPRID , S.RUN_CNTL_ID , A.SSN_EMPLOYER , A.GPES_SSTC_PAYMNT , A.GPES_SSTC_CNTRL_DT , A.GPES_OOD_PYMT_SUR , A.GPES_MONTH , A.GPES_YEAR , A.GPES_YEAR_RECALC , S.GPES_SSTC_OUTOF_DT , A.GPES_SSTC_ELEM_GRP FROM PS_GPES_SSTC_RS_VW A , PS_GPES_RC_SS_SURC S WHERE A.SSN_EMPLOYER = S.SSN_EMPLOYER AND A.GPES_SSTC_PAYMNT = S.GPES_SSTC_PAYMNT AND %Coalesce(A.GPES_SSTC_CNTRL_DT, %CurrentDateIn) = %Coalesce(S.GPES_SSTC_CNTRL_DT , %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | SSN_EMPLOYER |
Character(13) | VARCHAR2(13) NOT NULL | Employer Social Security number |
| 4 | 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/Surcharge Bases Increa L91=Retro w/Surchage new Slices Default Value: L00 |
| 5 | GPES_SSTC_CNTRL_DT |
Date(10) | DATE | Social Security TC�s control date |
| 6 | GPES_OOD_PYMT_SUR |
Number(2,0) | SMALLINT NOT NULL | FAN surcharge because of an out of date payment |
| 7 | GPES_MONTH |
Number(2,0) | SMALLINT NOT NULL | Month |
| 8 | GPES_YEAR |
Number(4,0) | SMALLINT NOT NULL | Year |
| 9 | GPES_YEAR_RECALC | Number(4,0) | SMALLINT NOT NULL | Retro year |
| 10 | GPES_SSTC_OUTOF_DT | Character(1) | VARCHAR2(1) NOT NULL |
Out of date indicator. This field is used to populate the GP Write Array, which is used to generate the FAN File.
0=Payment in Period 3=Payment Out of Period Default Value: 0 |
| 11 | 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 |