GPTH_TAX_D_HST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON_NAME
4	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
6	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
7	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
8	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
9	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
10	GPTH_TAX_VR_LOG_PS	Character(15)	VARCHAR2(15) NOT NULL	Tax calculation phase(R/I)
11	GPTH_TAX_VR_IR_SEQ	Number(3,0)	SMALLINT NOT NULL	Control Flag for Irregular Calculation
12	GPTH_TAX_VR_CAL_MD	Character(2)	VARCHAR2(2) NOT NULL	Tax Calculation Method
13	GPTH_TAX_VR_CYCLE	Number(3,0)	SMALLINT NOT NULL	Cycle number
14	GPTH_TAX_VR_LOG_YE	Character(1)	VARCHAR2(1) NOT NULL	Year end flag
15	GPTH_INC_SECTION	Character(3)	VARCHAR2(3) NOT NULL	This field will be used to store income section category information.
16	GPTH_TAX_XMPT_402	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field will be used to tax exempt amount for employees over 65 years old for 40(2) income section
17	GPTH_SAL_R_TAL_PTD	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Total regular salary period to date
18	GPTH_SAL_R_TAL_YTD	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Total regular salary year to date
19	GPTH_TAX_VR_T_INC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Annual Total Income
20	GPTH_TAX_EXCEPT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Provident fund exception
21	GPTH_TAX_ALLOW_XT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Expense Allowance
22	GPTH_TAX_ALLOW_PE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Personal allowance
23	GPTH_TAX_ALLOW_SP	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Spouse allowance
24	GPTH_TAX_ALLOW_CH	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Child Allowance
25	GPTH_TAX_ALLOW_CE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Tax allowance of children education
26	GPTH_TAX_ALLOW_FA	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Allowance for payee's father
27	GPTH_TAX_ALLOW_MO	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Allowance for payee's mother
28	GPTH_TAX_ALLOW_SF	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Allowance for spouse's father
29	GPTH_TAX_ALLOW_SM	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Allowance for spouse's mother
30	GPTH_TAX_ALLOW_HI	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Parents health insurance allowance
31	GPTH_TAX_ALLOW_PI	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Personal life insurance allowance
32	GPTH_TAX_ALLOW_SI	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Spouse life insurance allowanc
33	GPTH_TAX_ALLOW_PF	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Provident fund allowance
34	GPTH_TAX_ALLOW_MF	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Mutual fund
35	GPTH_TAX_ALLOW_EF	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Long term equity fund
36	GPTH_TAX_ALLOW_SS	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Social security allowance
37	GPTH_TAX_ALLOW_MI	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Mortgage interest allowance
38	GPTH_TAX_ALLOW_OE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Overage exempt
39	GPTH_TAX_VR_SPORT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Base amount for sport allowance
40	GPTH_TAX_ALLOW_ED	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Education donation allowance
41	GPTH_TAX_ALLOW_PT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sports allowance
42	GPTH_TAX_ALLOW_DN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Donation allowance
43	GPTH_TAX_VR_TAXABL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Tax Taxable Amount
44	GPTH_TAX_VR_TOTAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Total Tax Amount
45	GPTH_TAX_R_TAL_PTD	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field will be used to store total period to date regular tax amount information.
46	GPTH_TAX_R_TAL_YTD	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field will be used to store total year to date regular tax amount information.
47	GPTH_TAX_VR_C_TTPY	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Tax To Period
48	GPTH_TAX_VR_C_TTPP	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Tax To Period
49	GPTH_TAX_VR_L_TTPP	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Tax To Period
50	GPTH_TAX_VR_C_TAX	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Current tax amount of irregular
51	GPTH_TAX_IR_YTD	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	year to date irregular tax
52	GPTH_TAX_IR_EE_YTD	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employee tax for irregular income, year to date
53	GPTH_TAX_IR_ER_YTD	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employer tax for irregular income, year to date
54	GPTH_TAX_IR_T_YTD	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Total of irregular tax - year to date
55	GPTH_TAX_VR_R_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Regular tax amount
56	GPTH_TAX_VR_C_IR	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Irregular Income For Current Calculation
57	GPTH_SAL_IR_SEG	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Salary irregular segment
58	GPTH_SAL_IR_YTD	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Year to date irregular salary
59	GPTH_SAL_REG_A_YTD	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	401&402 Reg for all tax method
60	GPTH_TAX_VR_CAL_CA	Character(3)	VARCHAR2(3) NOT NULL	Tax calculation method
61	GPTH_TAX_VR_ER_E	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	GPTH_TAX_VR_ER_E
62	GPTH_OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	GPTH_OFF_CYCLE
63	GPTH_TAX_VR_EE_E	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	GPTH_TAX_VR_EE_E
64	GPTH_TAX_REG_A_SEG	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	GPTH_TAX_REG_A_SEG
65	GPTH_TAX_REG_A_YTD	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	GPTH_TAX_REG_A_YTD
66	GPTH_TAX_IR_A_YTD	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	GPTH_TAX_IR_A_YTD
67	GPTH_TAX_ALLOW_DS	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Total Disabled Allowance
68	GPTH_TAX_ALLOW_HP	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	House Purchasing Allowance
69	GPTH_TAX_ALLOW_PP	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Party Donation
70	GPTH_TAX_ALLOW_PS	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Party Donation from payee's spouse
71	GPTH_TAX_ALLOW_IP	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Payee Pension Insurance Premium
72	GPTH_TAX_ALLOW_TR	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Travel Inside Thailand Amount
73	GPTH_TAX_ALLOW_OT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Tax Allowance "Others"