GPTH_SS_DISA_VW

(SQL View)
Index Back

TAX ALLOWANCE

Self tax allowance

SELECT A.EMPLID ,B.EFFDT ,A.NATIONAL_ID ,A.NAME ,A.SEX ,A.RELATIONSHIP ,B.GPTH_TX_CLAIM ,B.GPTH_TX_INCAP ,A.LAST_NAME ,A.FIRST_NAME ,A.MIDDLE_NAME FROM PS_GPTH_TX_DISA_VW A LEFT JOIN PS_GPTH_TX_DISABLE B ON A.EMPLID=B.EMPLID AND A.NATIONAl_ID=B.NATIONAL_ID AND A.RELATIONSHIP =B.RELATIONSHIP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

3 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
4 NAME Character(50) VARCHAR2(50) NOT NULL Name
5 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec

Default Value: M

6 RELATIONSHIP Character(2) VARCHAR2(2) NOT NULL Relationship to Employee
7 GPTH_TX_CLAIM Character(1) VARCHAR2(1) NOT NULL Tax claim

Y/N Table Edit

8 GPTH_TX_INCAP Character(1) VARCHAR2(1) NOT NULL Incapacitated

Y/N Table Edit

9 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
10 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
11 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME