GPCN_TAXRPT_WA

(SQL Table)
Index Back

Tax report Writable array

Tax report Writable array

# 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 GPCN_TAX_AREA Character(30) VARCHAR2(30) NOT NULL Tax Area
9 GPCN_INC_CATEGORY Character(2) VARCHAR2(2) NOT NULL Income category
10 GPCN_EMP_TYPE Character(3) VARCHAR2(3) NOT NULL Employee Type
1=Local Employee Only
2=Expatriate Only
3=Remuneration Serv Only
4=All
11 GPCN_TAX_RATE Signed Number(20,6) DECIMAL(18,6) NOT NULL Tax Rate
12 GPCN_TAX_TOT_GROSS Signed Number(20,6) DECIMAL(18,6) NOT NULL Tax Total Gross
13 GPCN_TAX_EXEMPTION Signed Number(20,6) DECIMAL(18,6) NOT NULL Tax exempt amount
14 GPCN_TOT_TAXABLE Signed Number(20,6) DECIMAL(18,6) NOT NULL Total Taxable Income
15 GPCN_TAX_QUICK_CAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Quick Calculation Deduction
16 GPCN_TAX_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Tax Amount
17 GPCN_EMP_PENSION Signed Number(20,6) DECIMAL(18,6) NOT NULL Employee Pension
18 GPCN_EMP_MEDICAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Employee Medical
19 GPCN_EMP_PHF Signed Number(20,6) DECIMAL(18,6) NOT NULL Employee Public Housing Fund
20 GPCN_EMP_UNEMPL Signed Number(20,6) DECIMAL(18,6) NOT NULL Employee Unemployment
21 GPCN_ACUM_INC Signed Number(20,6) DECIMAL(18,6) NOT NULL Accumulative Income
22 GPCN_ACUM_TX_EXPT Signed Number(20,6) DECIMAL(18,6) NOT NULL Accumulative Income
23 GPCN_ACUM_SI Signed Number(20,6) DECIMAL(18,6) NOT NULL Accumulative SI amount
24 GPCN_ACUM_PHF_SI Signed Number(20,6) DECIMAL(18,6) NOT NULL Accumulative PHF/SI Amount
25 GPCN_EDU_FEE Signed Number(20,6) DECIMAL(18,6) NOT NULL Children's Education Fee
26 GPCN_ELD_SUPP Signed Number(20,6) DECIMAL(18,6) NOT NULL Expenses for Elderly Support
27 GPCN_HSLN_INT Signed Number(20,6) DECIMAL(18,6) NOT NULL Housing Loan Interest
28 GPCN_HS_RENTAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Housing Rentals
29 GPCN_CONT_EDU Signed Number(20,6) DECIMAL(18,6) NOT NULL Continuing Education Fee
30 GPCN_CHILD_CARE Signed Number(20,6) DECIMAL(18,6) NOT NULL Child Care Below 3 Years
31 GPCN_TAX_RDRATE Signed Number(20,6) DECIMAL(18,6) NOT NULL Tax Reduction Rate
32 GPCN_ACUM_TAX Signed Number(20,6) DECIMAL(18,6) NOT NULL Accumulative Tax Amount
33 GPCN_TAX_RDAMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Tax Reduction Amount
34 GPCN_TAX_WITHHELD Signed Number(20,6) DECIMAL(18,6) NOT NULL Withheld Tax Amount
35 GPCN_DON_EXEMPT Signed Number(20,6) DECIMAL(18,6) NOT NULL Donation Tax Exempt Amount
36 GPCN_UNUSED_RD_TX Signed Number(20,6) DECIMAL(18,6) NOT NULL Unused Tax Reduction Amount