GPTH_ALLOW_TMP(SQL Table) |
Index Back |
---|---|
Tax Allowance InfoTax 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 |