| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 GP_PKG_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Field used for element packaging
|
| 2 |
GPIN_ITCS_TMPL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Used to store Template ID for IT Computaion Sheet Template.
|
| 3 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 4 |
GPIN_COMP_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
IT Computation calulation codes
10=Perquisites
100=Capital Gain
110=Capital Loss
120=Income from Other Sources
125=Section 80EE
130=Gross Total Income
140=Less Deduction U/c VIA
150=Taxable Income(Rounded)
160=Tax Payable on Total Income
170=Tax Payable
180=Add Surcharge
185=Less Tax Credit 87A
190=Add Cess
191=Total Tax Payable
192=Less: Tax borne by Employer
20=Previous Employer Income
200=Total Tax Payable
210=Less Tax Recovered
220=Current Month TDS
30=Gross Salary
40=Less Exemptions U/s 10
50=Net Salary
60=Tax on Employment
70=Net Taxable Salary
80=Income from House Prope
90=Loss from House Proprty
|
| 5 |
KEY_SERIAL_NBR |
Number(5,0) |
INTEGER NOT NULL |
This is an internal serial number for a Configurable Matrix key, used to indirectly associate a key combination with a data pointer.
|
| 6 |
GPIN_ITCS_LBL |
Character(60) |
VARCHAR2(60) NOT NULL |
IT Computaion Sheet Customizable Labels
|
| 7 |
GPIN_ENTRY_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Elements entry type for India used in IT Computaion Sheet.
AC=Accumulators
DD=Deductions
ER=Earnings
FM=Formulas
VR=Variables
|
| 8 |
PIN_NUM |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
|