GPES_SSTC_PRV_V(SQL View) |
Index Back |
|---|---|
SS previous valuesSocial Security previous values |
| SELECT DISTINCT D.EMPLID , D.CAL_RUN_ID , D.EMPL_RCD , D.GP_PAYGROUP , D.CAL_ID , D.ORIG_CAL_RUN_ID , D.RSLT_SEG_NUM , D.SLICE_BGN_DT , D.GPES_SSTC_PAYMNT , D.GPES_SSTC_ELEMENT , D.SSN_EMPLOYER , D.GPES_YEAR , D.GPES_MONTH , D.GPES_YEAR_RECALC , D.GPES_MONTH_RECALC , D.GPES_SSTC_STRIKE , D.GPES_SSTC_MULTIJOB , D.GPES_SSTC_LGL_CUST , D.GPES_SSTC_MONTHLY , D.GPES_SSTC_NOSALARY , D.GPES_SSTC_OTHERS , D.GPES_SSTC_CONTR_7D , D.GPES_SSTC_RED_PART , D.SOC_SEC_WRK_GRP_CD , D.GPES_SSTC_CNT_FLG , D.CONTRACT_TYPE , D.SOC_SEC_RISK_CODE , D.GPES_SSTC_DISABLTY , D.GPES_SSTC_RELSHIP , D.GPES_SS_BNF_SUBTYP , D.GPES_SSTC_HRS_FLAG , D.GPES_SSTC_DAYS_HRS , D.GPES_SSTC_DEC_PART , D.GPES_SSTC_ELEM_NUM , D.RSLT_VER_NUM FROM PS_GPES_SSTC_RSLT D WHERE D.GPES_SSTC_PAYMNT IN ( 'L00' , 'L03', 'L09') AND D.GPES_SSTC_ELEMENT LIKE 'CD%' AND %Sql(GPES_SS_MAX_VER_REV_NUM, PS_GP_PYE_PRC_STAT, D) |
| # | 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 Rcd Nbr |
| 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 | RSLT_SEG_NUM | Number(4,0) | SMALLINT NOT NULL | Result Segment Number |
| 8 | SLICE_BGN_DT | Date(10) | DATE | Element Slice Begin Date |
| 9 | 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 |
| 10 | GPES_SSTC_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL | This code indicates if the element represents a base or a deduction. This field is used to populate the GP Write Array, which is used to generate the FAN File. |
| 11 | SSN_EMPLOYER | Character(13) | VARCHAR2(13) NOT NULL | Employer Social Security number |
| 12 | GPES_YEAR | Number(4,0) | SMALLINT NOT NULL | Year |
| 13 | GPES_MONTH | Number(2,0) | SMALLINT NOT NULL | Month |
| 14 | GPES_YEAR_RECALC | Number(4,0) | SMALLINT NOT NULL | Retro year |
| 15 | GPES_MONTH_RECALC | Number(2,0) | SMALLINT NOT NULL | Retro month |
| 16 | GPES_SSTC_STRIKE | Character(1) | VARCHAR2(1) NOT NULL | Strike indicator. This field is used to populate the GP Write Array, which is used to generate the FAN File. |
| 17 | GPES_SSTC_MULTIJOB | Character(1) | VARCHAR2(1) NOT NULL | Multijob indicator. This field is used to populate the GP Write Array, which is used to generate the FAN File. |
| 18 | GPES_SSTC_LGL_CUST | Character(1) | VARCHAR2(1) NOT NULL | Legal custody indicator. This field is used to populate the GP Write Array, which is used to generate the FAN File. |
| 19 | GPES_SSTC_MONTHLY | Character(1) | VARCHAR2(1) NOT NULL | Monthly indicator. This field is used to populate the GP Write Array, which is used to generate the FAN File. |
| 20 | GPES_SSTC_NOSALARY | Character(1) | VARCHAR2(1) NOT NULL | No salary. This field is used to populate the GP Write Array, which is used to generate the FAN File. |
| 21 | GPES_SSTC_OTHERS | Character(1) | VARCHAR2(1) NOT NULL | Others flag. This field is used to populate the GP Write Array, which is used to generate the FAN File. |
| 22 | GPES_SSTC_CONTR_7D | Character(1) | VARCHAR2(1) NOT NULL | Contracts with duration of less than seven days |
| 23 | GPES_SSTC_RED_PART | Character(1) | VARCHAR2(1) NOT NULL |
Part Time Reduction Type
0=Total Amount 1=Minimum Reduction 2=Medium Reduction 3=Maximum Reduction |
| 24 | SOC_SEC_WRK_GRP_CD | Character(2) | VARCHAR2(2) NOT NULL | Social Security Work Group |
| 25 | GPES_SSTC_CNT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Original contract flag for contract type 540 corresponding to pre-retired people
D=Contract of Limited duration I=Unlimited Contract |
| 26 | CONTRACT_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Contract Type |
| 27 | SOC_SEC_RISK_CODE | Character(3) | VARCHAR2(3) NOT NULL | Occupation Code |
| 28 | GPES_SSTC_DISABLTY | Character(1) | VARCHAR2(1) NOT NULL | Disability Type |
| 29 | GPES_SSTC_RELSHIP | Character(4) | VARCHAR2(4) NOT NULL |
Labor Relationship
0100=Senior Management 0409=Professional Sportsman 0900=Lawyer in Lawyer Bureau 9909=Research Staff |
| 30 | GPES_SS_BNF_SUBTYP | Character(4) | VARCHAR2(4) NOT NULL | Bonification/Reduction Subtype |
| 31 | GPES_SSTC_HRS_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Hour indicator. In case of hours, this field should be populated with 'H'. This field is used to populate the GP Write Array, which is used to generate the FAN File. |
| 32 | GPES_SSTC_DAYS_HRS | Signed Number(4,0) | DECIMAL(3) NOT NULL | Amount of Days or Hours (depending on Hours Flag). This field is used to populate the GP Write Array, which is used to generate the FAN File. |
| 33 | GPES_SSTC_DEC_PART | Signed Number(3,0) | DECIMAL(2) NOT NULL | Amount of the element (Decimal part). This field is used to populate the GP Write Array, which is used to generate the FAN File. |
| 34 | GPES_SSTC_ELEM_NUM | Number(3,0) | SMALLINT NOT NULL | This field indicates the number of the CD22 elements in FAN file. |
| 35 | RSLT_VER_NUM | Number(4,0) | SMALLINT NOT NULL | Result Version Number |