| # |
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 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 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
Default Value: NA
|
| 5 |
GPTH_TX_SPO_IND |
Number(1,0) |
SMALLINT NOT NULL |
Claim spouse allowance
Default Value: 4
Prompt Table:
GPTH_SPO_IND
|
| 6 |
GPTH_TX_SPO_AMT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Premiun Amount
|
| 7 |
GPTH_TX_HALF_SPO |
Character(1) |
VARCHAR2(1) NOT NULL |
This field represents that if an employee declare the tax allowance of Half Declare with spous
Y/N Table Edit
Default Value: N
|
| 8 |
GPTH_TX_CHD_ALO_NO |
Number(3,0) |
SMALLINT NOT NULL |
Number of child for Allowance
|
| 9 |
GPTH_TX_CHD_EDU_NO |
Number(3,0) |
SMALLINT NOT NULL |
Number of child for education
|
| 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
Default Value: N
|
| 15 |
GPTH_TX_HI_PAMO |
Character(1) |
VARCHAR2(1) NOT NULL |
Declare HI for Payee's Mother
Default Value: N
|
| 16 |
GPTH_TX_HI_SPOFA |
Character(1) |
VARCHAR2(1) NOT NULL |
Declare HI for Spouse's Father
Default Value: N
|
| 17 |
GPTH_TX_HI_SPOMO |
Character(1) |
VARCHAR2(1) NOT NULL |
Declare HI for Spouse's Mother
Default Value: N
|
| 18 |
GPTH_TX_OE_401_AMT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Overage Exempt 40(1)
|
| 19 |
GPTH_TX_OE_402_AMT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Overage Exempt 40(2)
|
| 20 |
GPTH_TX_OE_TER_AMT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Overage Exempt Termination
|
| 21 |
GPTH_TX_OE_TOT_AMT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Overage Exempt Total Amount
|
| 22 |
GPTH_TX_HI_AMT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Parents HI Allowance Amount
|
| 23 |
GPTH_TX_OVRAGE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field will be used to store overage tax exempt flag information.
D=Default
N=No
Y=Yes
Default Value: D
|
| 24 |
GPTH_TX_MF_NM |
Character(200) |
VARCHAR2(200) NOT NULL |
Mutual Fund Name
|
| 25 |
GPTH_TX_MF_AMT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Mutual Fund Amount
|
| 26 |
GPTH_TX_LTF_NAME |
Character(200) |
VARCHAR2(200) NOT NULL |
LTF Name
|
| 27 |
GPTH_TX_LTF_AMT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
This field will be used to store total long term equiry amount information.
|
| 28 |
GPTH_TX_INS_PRE |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Payee Life Insurance Premium
|
| 29 |
GPTH_TX_CD_AMT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Charitable Donation
|
| 30 |
GPTH_TX_MOR_INT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Home Mortgage Interest
|
| 31 |
GPTH_TX_ED_AMT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Education Donation
|
| 32 |
GPTH_TX_SP_AMT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Sport Donation
|
| 33 |
GPTH_SEQ_NUM |
Character(6) |
VARCHAR2(6) NOT NULL |
Sequence number for tax report
|
| 34 |
LAST_UPDT_DTTM |
DateTime(26) |
TIMESTAMP |
Last Updated Date-Time Stamp
|
| 35 |
LAST_UPDT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Updated User Name
|
| 36 |
GPTH_TX_SPP |
Character(1) |
VARCHAR2(1) NOT NULL |
Payee's spouse party donation
Default Value: 0
|
| 37 |
GPTH_TX_SPP_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Payee's spouse party donation - Party ID
|
| 38 |
GPTH_TX_SPP_AMT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Payee's spouse party donation - Amount
Default Value: 100
|
| 39 |
GPTH_TX_PP |
Character(1) |
VARCHAR2(1) NOT NULL |
Payee's party donation
Default Value: 0
|
| 40 |
GPTH_TX_PP_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Payee's party donation - Party ID
|
| 41 |
GPTH_TX_PP_AMT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Payee's party donation - Amount
Default Value: 100
|
| 42 |
GPTH_TX_HP_AMT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
House Purchasing Amount
|
| 43 |
GPTH_TX_DIS_SP |
Character(1) |
VARCHAR2(1) NOT NULL |
Disable for payee's spouse
Default Value: N
|
| 44 |
GPTH_TX_DIS_FAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Disable for payee's father
Default Value: N
|
| 45 |
GPTH_TX_DIS_MOT |
Character(1) |
VARCHAR2(1) NOT NULL |
Disable for payee's mother
Default Value: N
|
| 46 |
GPTH_TX_DIS_SFAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Disable for father of payee's spouse
Default Value: N
|
| 47 |
GPTH_TX_DIS_SMOT |
Character(1) |
VARCHAR2(1) NOT NULL |
Disable for mother of payee's spouse
Default Value: N
|
| 48 |
GPTH_TX_DIS_CHD |
Character(1) |
VARCHAR2(1) NOT NULL |
Disable for payee's child
Default Value: N
|
| 49 |
GPTH_TX_DIS_CHD_NO |
Number(2,0) |
SMALLINT NOT NULL |
Number of disabled children
|
| 50 |
GPTH_TX_DIS_SCHD |
Character(1) |
VARCHAR2(1) NOT NULL |
Disable for child of payee's spouse
Default Value: N
|
| 51 |
GPTH_TX_DIS_SCH_NO |
Number(2,0) |
SMALLINT NOT NULL |
The number of disabled persons
|
| 52 |
GPTH_TX_DIS_ADT |
Character(1) |
VARCHAR2(1) NOT NULL |
Disable for adopted child of payee's spouse
Default Value: N
|
| 53 |
GPTH_TX_DIS_ADT_NO |
Number(2,0) |
SMALLINT NOT NULL |
Number of disabled person
|
| 54 |
GPTH_TX_DIS_OTHER |
Character(1) |
VARCHAR2(1) NOT NULL |
Patron of other person
Default Value: N
|
| 55 |
GPTH_TX_PEN_INS |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Payee Pension Insurance Premium
|
| 56 |
GPTH_TX_TRV_IN |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Travel Inside Thailand Amount
|
| 57 |
GPTH_TX_OTHERS |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Others allownce
|
| 58 |
GPTH_FHOUSE_PRICE |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
First House, house price
|
| 59 |
GPTH_FHOUSE_YEAR |
Character(3) |
VARCHAR2(3) NOT NULL |
First House, first tax exempt year
554=BE. 2554 (2011)
555=BE. 2555 (2012)
556=BE. 2556 (2013)
557=BE. 2557 (2014)
558=BE. 2558 (2015)
559=BE. 2559 (2016)
|
| 60 |
GPTH_FHOUSE_SPOUSE |
Character(1) |
VARCHAR2(1) NOT NULL |
First House, flag for spouse
I=Not available
N=Spouse is not co-owner
S=Co-owner, but submit separate
T=Co-owner, and submit jointly
|
| 61 |
GPTH_FHOUSE_COOWN |
Number(2,0) |
SMALLINT NOT NULL |
First House, Co-owner
|
| 62 |
GPTH_FHOUSE_EXEMPT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
First House, Maximum Tax Exempt
|
| 63 |
GPTH_TX_GS |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Purchase of goods or services in the country.
|
| 64 |
GPTH_PUR_DT |
Date(10) |
DATE |
Date of transfer of ownership
|
| 65 |
GPTH_TX_FT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Travel and Expenses during Songkran Festival
|
| 66 |
GPTH_TX_TR_DEC |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Travel in December
|
| 67 |
GPTH_TX_OTOP |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Purchase of OTOP
|