GPTH_TX_ALOW_VW(SQL View) |
Index Back |
|---|---|
Tax Allowance InfoTax Allowance Info |
| SELECT A.EMPLID , A.GPTH_SEQ_NUM , A.GPTH_SPO_STATUS , A.GPTH_TX_SPO_IND , A.GPTH_TX_SPP , A.GPTH_TX_SPP_ID , A.GPTH_TX_PP , A.GPTH_TX_PP_ID , A.GPTH_TX_PAFA , A.GPTH_TX_PAMOT , A.GPTH_TX_SPO_FA , A.GPTH_TX_SPO_MOT , A.GPTH_TX_HI_PAFA , A.GPTH_TX_HI_PAMO , A.GPTH_TX_HI_SPOFA , A.GPTH_TX_HI_SPOMO , A.GPTH_TX_MF_NM , A.GPTH_TX_LTF_NAME , A.GPTH_TX_CHD_ALO_NO , A.GPTH_FHOUSE_PRICE , G.PROCESS_INSTANCE FROM PS_GPTH_TAX_ALLOW A , PS_GPTH_RPT_G_VW G WHERE A.EMPLID=G.EMPLID AND A.EFFDT=( SELECT MAX(A_ED.EFFDT) FROM PS_GPTH_TAX_ALLOW A_ED WHERE A.EMPLID=A_ED.EMPLID AND A_ED.EFF_STATUS='A' AND A_ED.EFFDT <= G.PRD_END_DT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | GPTH_SEQ_NUM | Character(6) | VARCHAR2(6) NOT NULL | Sequence number for tax report |
| 3 | 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 |
| 4 | GPTH_TX_SPO_IND | Number(1,0) | SMALLINT NOT NULL |
Claim spouse allowance
Default Value: 0 |
| 5 | GPTH_TX_SPP | Character(1) | VARCHAR2(1) NOT NULL | Payee's spouse party donation |
| 6 | GPTH_TX_SPP_ID | Character(3) | VARCHAR2(3) NOT NULL | Payee's spouse party donation - Party ID |
| 7 | GPTH_TX_PP | Character(1) | VARCHAR2(1) NOT NULL | Payee's party donation |
| 8 | GPTH_TX_PP_ID | Character(3) | VARCHAR2(3) NOT NULL | Payee's party donation - Party ID |
| 9 | GPTH_TX_PAFA | Character(1) | VARCHAR2(1) NOT NULL |
Declare for Payee's Father
Y/N Table Edit Default Value: N |
| 10 | GPTH_TX_PAMOT | Character(1) | VARCHAR2(1) NOT NULL |
Declare for Payee's Mother
Y/N Table Edit Default Value: N |
| 11 | GPTH_TX_SPO_FA | Character(1) | VARCHAR2(1) NOT NULL |
Declare for Spouse's Father
Y/N Table Edit Default Value: N |
| 12 | GPTH_TX_SPO_MOT | Character(1) | VARCHAR2(1) NOT NULL |
Declare for Spouse's Mother
Y/N Table Edit Default Value: N |
| 13 | GPTH_TX_HI_PAFA | Character(1) | VARCHAR2(1) NOT NULL | Declare HI for Payee's Father |
| 14 | GPTH_TX_HI_PAMO | Character(1) | VARCHAR2(1) NOT NULL | Declare HI for Payee's Mother |
| 15 | GPTH_TX_HI_SPOFA | Character(1) | VARCHAR2(1) NOT NULL | Declare HI for Spouse's Father |
| 16 | GPTH_TX_HI_SPOMO | Character(1) | VARCHAR2(1) NOT NULL | Declare HI for Spouse's Mother |
| 17 | GPTH_TX_MF_NM | Character(200) | VARCHAR2(200) NOT NULL | Mutual Fund Name |
| 18 | GPTH_TX_LTF_NAME | Character(200) | VARCHAR2(200) NOT NULL | LTF Name |
| 19 | GPTH_TX_CHD_ALO_NO | Number(3,0) | SMALLINT NOT NULL | Number of child for Allowance |
| 20 | GPTH_FHOUSE_PRICE | Number(12,2) | DECIMAL(11,2) NOT NULL | First House, house price |
| 21 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |