GPES_TX_RSPD_VW

(SQL View)
 Index Back

Tax Results VW Personal Data

Personal Data Tax Results VW

SELECT A.EMPLID , A.CAL_RUN_ID , A.EMPL_RCD , A.GP_PAYGROUP , A.CAL_ID , A.ORIG_CAL_RUN_ID , A.RSLT_SEG_NUM , A.EFFDT , A.RSLT_VER_NUM , A.RSLT_REV_NUM , B.NATIONAL_ID , C.BIRTHDATE , A.GPES_CEUTA_MELILLA , A.GPES_DISABLTY_TYPE , A.GPES_FAMLR_SITUATN , A.GPES_NID_SPOUSE , A.GPES_RELSHIP_TYPE , A.GPES_RED_GEO , A.GPES_RED_WORK_EXT , A.GPES_RED_MORTGAGE FROM PS_GPES_TAX_RSLT A , PS_GPES_NID_VW B , PS_PERSON C WHERE A.EMPLID = B.EMPLID AND A.EMPLID = C.EMPLID

# 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 EFFDT Date(10) DATE Effective Date

Default Value: %date

9 RSLT_VER_NUM Number(4,0) SMALLINT NOT NULL Result Version Number
10 RSLT_REV_NUM Number(4,0) SMALLINT NOT NULL Result Revision Number
11 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
12 BIRTHDATE Date(10) DATE Date of Birth
13 GPES_CEUTA_MELILLA Character(1) VARCHAR2(1) NOT NULL Payee is working in Spanish cities Ceuta or Melilla. This cities has a special tax status.

Y/N Table Edit

14 GPES_DISABLTY_TYPE Character(1) VARCHAR2(1) NOT NULL Type of disability.
0=No Disabled
1=Disability 33%- 65%
2=Disability 33-65% Need Help
3=Disability > 65%
15 GPES_FAMLR_SITUATN Character(1) VARCHAR2(1) NOT NULL Family situation.
1=1.- With fiscal dependent
2=2.- With spouse to support
3=3.- Other situations
16 GPES_NID_SPOUSE Character(10) VARCHAR2(10) NOT NULL NID Spouse
17 GPES_RELSHIP_TYPE Character(1) VARCHAR2(1) NOT NULL Labor Relationship Type.
1=1.- General Relationship
2=2.- Less 1 Year Relationship
3=3.- Special Relationship
18 GPES_RED_GEO Character(1) VARCHAR2(1) NOT NULL Geographic Mobility reduction.

Y/N Table Edit

19 GPES_RED_WORK_EXT Character(1) VARCHAR2(1) NOT NULL Work life Extension reduction.

Y/N Table Edit

20 GPES_RED_MORTGAGE Character(1) VARCHAR2(1) NOT NULL Eligibility Flag for Home Mortgage Reduction
1=Reduction From 2011
1=Reduction From 2011
N=No Reduction
Y=Reduction
Y=Reduction Before 2011

Y/N Table Edit