GPCN_SUM_DTL_FL

(SQL Table)
Index Back

Tax Summary Report File Layout

Tax Summary Report File Layout. Used to print Detail section of the summary report.

# 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