GPTH_TAX_G_HST

(SQL Table)
 Index Back

GPTH Tax Head Log

GPTH Tax Head 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 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_INC_SECTION Character(3) VARCHAR2(3) NOT NULL This field will be used to store income section category information.
11 GPTH_TAX_CAL_C_CAT Character(3) VARCHAR2(3) NOT NULL Current calculate method (CAM or ACM)
12 GPTH_TAX_R_SEG_WH Signed Number(20,6) DECIMAL(18,6) NOT NULL Regular tax amount -- WH
13 GPTH_TAX_R_SEG_GA Signed Number(20,6) DECIMAL(18,6) NOT NULL Regular tax amount -- GA
14 GPTH_TAX_R_SEG_GO Signed Number(20,6) DECIMAL(18,6) NOT NULL Regular tax amount -- GO
15 GPTH_TAX_IR_SEG_WH Signed Number(20,6) DECIMAL(18,6) NOT NULL Irregular tax segment WH
16 GPTH_TAX_IR_SEG_GA Signed Number(20,6) DECIMAL(18,6) NOT NULL Irregular tax segment GA
17 GPTH_TAX_IR_SEG_GO Signed Number(20,6) DECIMAL(18,6) NOT NULL Irregular tax segment GO
18 GPTH_TAX_RIR_SG_WH Signed Number(20,6) DECIMAL(18,6) NOT NULL SEG Regular Irregular Tax -- WH
19 GPTH_TAX_RIR_SG_GA Signed Number(20,6) DECIMAL(18,6) NOT NULL SEG Regular Irregular Tax -- GA
20 GPTH_TAX_RIR_SG_GO Signed Number(20,6) DECIMAL(18,6) NOT NULL SEG Regular Irregular Tax -- GO
21 GPTH_TAX_WH_DED Signed Number(20,6) DECIMAL(18,6) NOT NULL Overall tax deduction for WH
22 GPTH_TAX_GA_DED Signed Number(20,6) DECIMAL(18,6) NOT NULL Overall tax deduction for GA
23 GPTH_TAX_GO_DED Signed Number(20,6) DECIMAL(18,6) NOT NULL Overall tax deduction for GO
24 GPTH_TAX_OV_YTD_WH Signed Number(20,6) DECIMAL(18,6) NOT NULL Over paid tax -- year to date -- WH
25 GPTH_TAX_OV_YTD_GA Signed Number(20,6) DECIMAL(18,6) NOT NULL Over paid tax -- year to date -- GA
26 GPTH_TAX_OV_YTD_GO Signed Number(20,6) DECIMAL(18,6) NOT NULL Over paid tax -- year to date -- GO
27 GPTH_SAL_R_PRO_SEG Signed Number(20,6) DECIMAL(18,6) NOT NULL Total regular salary, segment to date
28 GPTH_SAL_R_TAL_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Total regular salary period to date
29 GPTH_REMAIN_PRD Number(3,0) SMALLINT NOT NULL Remaining Periods
30 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.
31 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.
32 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.
33 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.
34 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.
35 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.
36 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.
37 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.
38 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.
39 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.
40 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.
41 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.
42 GPTH_OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL GPTH_OFF_CYCLE