GPTH_TX_D_T_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_TAX_VR_CAL_MD	Character(2)	VARCHAR2(2) NOT NULL	Tax Calculation Method
9	GPTH_TAX_TER_ORD	Number(3,0)	SMALLINT NOT NULL	Termination Income Calculation Order
10	GPTH_TAX_VR_CYCLE	Number(3,0)	SMALLINT NOT NULL	Cycle number
11	GPTH_TAX_PR_YTD_T1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Previous period TRM1 Tax YTD
12	GPTH_TAX_PR_YTD_T2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Previous period TRM2 Tax YTD
13	GPTH_TER_TRM1_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount of TRM1
14	GPTH_TER_TRM2_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount of TRM2
15	GPTH_TAX_TR_L_TTPP	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Termination tax last tax amount
16	GPTH_TER_DD_OLD_X	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	The exemption amount of over 65 age
17	GPTH_TER_ER_E_BAS	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Base amount for term tax calc
18	GPTH_TER_VR_EXP1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount of termination expense 1
19	GPTH_TER_VR_EXP2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount of termination expense 2
20	GPTH_TER_TOTAL_EXP	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Termination total expense
21	GPTH_TAX_TR_C_TTPP	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Termination tax current tax amount
22	GPTH_TR_TX_TAL_YTD	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Termination tax YTD
23	GPTH_TAX_TR_ER_TAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employer termination tax total amount
24	GPTH_TAX_TR_EE_TAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employee termination tax total amount
25	GPTH_TAX_TR_AMT_D1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount of termination income with order 1
26	GPTH_TAX_TR_AMT_D2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount of termination income with order 2
27	GPTH_TAX_TR_AMT_D3	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount of termination income with order 1
28	GPTH_TAX_TR_AMT_D4	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount of termination income with order 4
29	GPTH_TER_INC_NAME	Character(30)	VARCHAR2(30) NOT NULL	This field will be used to store name information for termination incomes.