| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
COUNT_EE |
Number(12,3) |
DECIMAL(11,3) NOT NULL |
Employee Count
|
| 2 |
FIELDLABEL |
Character(30) |
VARCHAR2(30) NOT NULL |
Field Label
|
| 3 |
GPCN_MONTHLY_INC |
Signed Number(22,6) |
DECIMAL(20,6) NOT NULL |
Monthly Income used in Summary RPT
|
| 4 |
GPCN_REM_INC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Remuneration Income
|
| 5 |
GPCN_TOT_TAXABLE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Total Taxable Income
|
| 6 |
GPCN_EXEMPT_AMT |
Signed Number(22,6) |
DECIMAL(20,6) NOT NULL |
Exempt Amt used in summary rpt.
|
| 7 |
GPCN_EMP_PENSION |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Employee Pension
|
| 8 |
GPCN_EMP_MEDICAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Employee Medical
|
| 9 |
GPCN_EMP_UNEMPL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Employee Unemployment
|
| 10 |
GPCN_EMP_PHF |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Employee Public Housing Fund
|
| 11 |
GPCN_ACUM_INC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Accumulative Income
|
| 12 |
GPCN_ACUM_TX_EXPT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Accumulative Income
|
| 13 |
GPCN_ACUM_PHF_SI |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Accumulative PHF/SI Amount
|
| 14 |
GPCN_EDU_FEE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Children's Education Fee
|
| 15 |
GPCN_ELD_SUPP |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Expenses for Elderly Support
|
| 16 |
GPCN_HSLN_INT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Housing Loan Interest
|
| 17 |
GPCN_HS_RENTAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Housing Rentals
|
| 18 |
GPCN_CONT_EDU |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Continuing Education Fee
|
| 19 |
GPCN_CHILD_CARE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Child Care Below 3 Years
|
| 20 |
GPCN_TAX_RDRATE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Tax Reduction Rate
|
| 21 |
GPCN_DON_EXEMPT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Donation Tax Exempt Amount
|
| 22 |
GPCN_TAXABLE_INC |
Signed Number(22,6) |
DECIMAL(20,6) NOT NULL |
Taxable Income used in summary rpt
|
| 23 |
GPCN_TAX_RATE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Tax Rate
|
| 24 |
GPCN_QUICK_CALD |
Signed Number(22,6) |
DECIMAL(20,6) NOT NULL |
Quick Calculation used in summary rpt
|
| 25 |
GPCN_INC_TAX |
Signed Number(22,6) |
DECIMAL(20,6) NOT NULL |
Income Tax used in summary rpt
|
| 26 |
GPCN_TAX_WITHHELD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Withheld Tax Amount
|
| 27 |
GPCN_TAX_RDAMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Tax Reduction Amount
|
| 28 |
GPCN_ACUM_TAX |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Accumulative Tax Amount
|
| 29 |
GPCN_TAX_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Tax Amount
|