# |
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_INC_CAT_DESC |
Character(20) |
VARCHAR2(20) NOT NULL |
Income Categoey Description used in Tax Report.
|
4 |
MONTH_OF_YEAR |
Character(9) |
VARCHAR2(9) NOT NULL |
Month of the year
|
5 |
GPCN_MONTHLY_INC |
Signed Number(22,6) |
DECIMAL(20,6) NOT NULL |
Monthly Income used in Summary RPT
|
6 |
GPCN_EXEMPT_AMT |
Signed Number(22,6) |
DECIMAL(20,6) NOT NULL |
Exempt Amt used in summary rpt.
|
7 |
GPCN_TAXABLE_INC |
Signed Number(22,6) |
DECIMAL(20,6) NOT NULL |
Taxable Income used in summary rpt
|
8 |
GPCN_TAX_RATE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Tax Rate
|
9 |
GPCN_QUICK_CALD |
Signed Number(22,6) |
DECIMAL(20,6) NOT NULL |
Quick Calculation used in summary rpt
|
10 |
GPCN_INC_TAX |
Signed Number(22,6) |
DECIMAL(20,6) NOT NULL |
Income Tax used in summary rpt
|
11 |
GPCN_PAYMNT_DT |
Date(10) |
DATE |
Payment date
|