GPTH_TAX_G_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 Record
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_INC_SECTION	Character(3)	VARCHAR2(3) NOT NULL	This field will be used to store income section category information.
9	GPTH_TAX_CAL_C_CAT	Character(3)	VARCHAR2(3) NOT NULL	Current calculate method (CAM or ACM)
10	GPTH_TAX_R_SEG_WH	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Regular tax amount -- WH
11	GPTH_TAX_R_SEG_GA	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Regular tax amount -- GA
12	GPTH_TAX_R_SEG_GO	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Regular tax amount -- GO
13	GPTH_TAX_IR_SEG_WH	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Irregular tax segment WH
14	GPTH_TAX_IR_SEG_GA	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Irregular tax segment GA
15	GPTH_TAX_IR_SEG_GO	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Irregular tax segment GO
16	GPTH_TAX_RIR_SG_WH	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	SEG Regular Irregular Tax -- WH
17	GPTH_TAX_RIR_SG_GA	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	SEG Regular Irregular Tax -- GA
18	GPTH_TAX_RIR_SG_GO	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	SEG Regular Irregular Tax -- GO
19	GPTH_TAX_WH_DED	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Overall tax deduction for WH
20	GPTH_TAX_GA_DED	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Overall tax deduction for GA
21	GPTH_TAX_GO_DED	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Overall tax deduction for GO
22	GPTH_TAX_OV_YTD_WH	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Over paid tax -- year to date -- WH
23	GPTH_TAX_OV_YTD_GA	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Over paid tax -- year to date -- GA
24	GPTH_TAX_OV_YTD_GO	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Over paid tax -- year to date -- GO
25	GPTH_SAL_R_PRO_SEG	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Total regular salary, segment to date
26	GPTH_SAL_R_TAL_PTD	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Total regular salary period to date
27	GPTH_REMAIN_PRD	Number(3,0)	SMALLINT NOT NULL	Remaining Periods
28	GPTH_TAX_R_402_WH	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field will be used to store withhoding tax amount for 40(2) regular incomes.
29	GPTH_TAX_R_402_GA	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field will be used to store gross up all tax amount for 40(2) regular incomes.
30	GPTH_TAX_R_402_GO	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field will be used to store gross up one tax amount for 40(2) regular incomes.
31	GPTH_TAX_IR_402_WH	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field will be used to store withhoding tax amount for 40(2) irregular incomes as earning.
32	GPTH_TAX_IR_402_GA	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field will be used to store gross up all tax amount for 40(2) irregular incomes as earning.
33	GPTH_TAX_IR_402_GO	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field will be used to store gross up one tax amount for 40(2) irregular incomes as earning.
34	GPTH_TAX_DD_402WH	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field will be used to store withhoding tax amount for 40(2) irregular incomes as deduction.
35	GPTH_TAX_DD_402GA	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field will be used to store gross up all tax amount for 40(2) irregular incomes as deduction.
36	GPTH_TAX_DD_402GO	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field will be used to store gross up one tax amount for 40(2) irregualr incomes as deduction.
37	GPTH_TAX_OVT_402WH	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field will be used to store withhoding overtime tax amount for 40(2) irregular incomes.
38	GPTH_TAX_OVT_402GA	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field will be used to store gross up all overtime tax amount for 40(2) irregular incomes.
39	GPTH_TAX_OVT_402GO	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field will be used to store gross up one overtime tax amount for 40(2) irregular incomes.
40	GPTH_OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	GPTH_OFF_CYCLE