GPTH_TAX_D_LOG

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