GPTH_ALLOW_TMP

(SQL Table)
Index Back

Tax Allowance Info

Tax Allowance Info

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 GPTH_SEQ_NUM Character(6) VARCHAR2(6) NOT NULL Sequence number for tax report
4 GPTH_SPO_STATUS Character(3) VARCHAR2(3) NOT NULL Marriy Status
DIE=Died during tax year
DIV=Divorce during tax year
MAR=Married during tax year
NA=Not available
WHO=Married for the whole tax year
5 GPTH_TX_SPO_IND Number(1,0) SMALLINT NOT NULL Claim spouse allowance

Default Value: 0

6 GPTH_TX_SPP Character(1) VARCHAR2(1) NOT NULL Payee's spouse party donation
7 GPTH_TX_SPP_ID Character(3) VARCHAR2(3) NOT NULL Payee's spouse party donation - Party ID
8 GPTH_TX_PP Character(1) VARCHAR2(1) NOT NULL Payee's party donation
9 GPTH_TX_PP_ID Character(3) VARCHAR2(3) NOT NULL Payee's party donation - Party ID
10 GPTH_TX_PAFA Character(1) VARCHAR2(1) NOT NULL Declare for Payee's Father

Y/N Table Edit

Default Value: N

11 GPTH_TX_PAMOT Character(1) VARCHAR2(1) NOT NULL Declare for Payee's Mother

Y/N Table Edit

Default Value: N

12 GPTH_TX_SPO_FA Character(1) VARCHAR2(1) NOT NULL Declare for Spouse's Father

Y/N Table Edit

Default Value: N

13 GPTH_TX_SPO_MOT Character(1) VARCHAR2(1) NOT NULL Declare for Spouse's Mother

Y/N Table Edit

Default Value: N

14 GPTH_TX_HI_PAFA Character(1) VARCHAR2(1) NOT NULL Declare HI for Payee's Father
15 GPTH_TX_HI_PAMO Character(1) VARCHAR2(1) NOT NULL Declare HI for Payee's Mother
16 GPTH_TX_HI_SPOFA Character(1) VARCHAR2(1) NOT NULL Declare HI for Spouse's Father
17 GPTH_TX_HI_SPOMO Character(1) VARCHAR2(1) NOT NULL Declare HI for Spouse's Mother
18 GPTH_TX_MF_NM Character(200) VARCHAR2(200) NOT NULL Mutual Fund Name
19 GPTH_TX_LTF_NAME Character(200) VARCHAR2(200) NOT NULL LTF Name
20 GPTH_TX_CHD_ALO_NO Number(3,0) SMALLINT NOT NULL Number of child for Allowance
21 GPTH_FHOUSE_PRICE Number(12,2) DECIMAL(11,2) NOT NULL First House, house price