GPES_PAYEE_VW

(SQL View)
 Index Back

Payee Data

Payee Data

SELECT A.EMPLID , A.EFFDT , A.GPES_HELP_NEEDED , A.GPES_FAMLR_SITUATN , A.GPES_NID_SPOUSE , A.GPES_TAX_LOCATION , A.GPES_CEUTA_MELILLA , A.GPES_RELSHIP_TYPE , A.HANDICAP_PCNT_ESP , A.GPES_DISABLTY_TYPE , B.CURRENCY_CD , B.GPES_MILEAGE_RT , B.GPES_MAINT_DOM , B.GPES_MAINT_INTL , B.GPES_MAINT_FLG_INT , B.GPES_MAINT_FLG_DOM , B.GPES_NIGHT_DOM , B.GPES_NIGHT_INTL , B.GPES_PIN_BR1_NUM , B.GPES_PIN_BR2_NUM , B.GPES_PIN_BR3_NUM , B.GPES_MAX_DEPNT_AGE , A.GPES_RED_GEO , A.GPES_RED_WORK_EXT FROM PS_GPES_PAYEE_DATA A , PS_GPES_TAX_LOCATN B WHERE B.GPES_TAX_LOCATION = A.GPES_TAX_LOCATION AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_GPES_TAX_LOCATN B_ED WHERE B.GPES_TAX_LOCATION = B_ED.GPES_TAX_LOCATION AND B_ED.EFFDT <= A.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EFFDT Date(10) DATE Effective Date

Default Value: %date

3 GPES_HELP_NEEDED Character(1) VARCHAR2(1) NOT NULL Payee requires assistance to go to work.
N=No
Y=Yes
4 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

Default Value: 3

5 GPES_NID_SPOUSE Character(10) VARCHAR2(10) NOT NULL NID Spouse
6 GPES_TAX_LOCATION Character(5) VARCHAR2(5) NOT NULL Fiscal Territory. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.

Prompt Table: GPES_TAX_LOCATN

7 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

Default Value: N

8 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

Default Value: 1

9 HANDICAP_PCNT_ESP Number(3,0) SMALLINT NOT NULL Handicap Percent
10 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%
11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: EUR

Prompt Table: CURRENCY_CD_TBL

12 GPES_MILEAGE_RT Number(6,2) DECIMAL(5,2) NOT NULL Statutory rate for mileage
13 GPES_MAINT_DOM Number(9,2) DECIMAL(8,2) NOT NULL Statutory rate for domestic maintenance
14 GPES_MAINT_INTL Number(9,2) DECIMAL(8,2) NOT NULL Statutory rate for non-domestic maintenance
15 GPES_MAINT_FLG_DOM Number(9,2) DECIMAL(8,2) NOT NULL Domestic flight maintenance
16 GPES_MAINT_FLG_INT Number(9,2) DECIMAL(8,2) NOT NULL International flight maintenance
17 GPES_NIGHT_DOM Number(9,2) DECIMAL(8,2) NOT NULL Statutory rate for domestic night stay
18 GPES_NIGHT_INTL Number(9,2) DECIMAL(8,2) NOT NULL Statutory rate for non-domestic night stay
19 GPES_PIN_BR1_NUM Number(8,0) INTEGER NOT NULL Bracket Pin Num.

Prompt Table: GPES_TX_BRK1_VW

20 GPES_PIN_BR2_NUM Number(8,0) INTEGER NOT NULL Bracket Pin Num.

Prompt Table: GPES_TX_BRK2_VW

21 GPES_PIN_BR3_NUM Number(8,0) INTEGER NOT NULL Bracket Pin Num.

Prompt Table: GPES_TX_BRK3_VW

22 GPES_MAX_DEPNT_AGE Number(3,0) SMALLINT NOT NULL Maximum dependent age
23 GPES_RED_GEO Character(1) VARCHAR2(1) NOT NULL Geographic Mobility reduction.

Y/N Table Edit

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

Y/N Table Edit