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