GPTH_TAX_D_HST

(SQL Table)
 Index Back

GPTH Tax Detail Log

GPTH Tax Detail Log

# 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 Record
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 for Thailand
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 for log