| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
GPIT_730_CONSEGNA |
Date(10) |
DATE |
Date of delivery of 730
|
| 6 |
GPIT_730_TIPO_ASS |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of assistance
A=Employer
C=CAF
|
| 7 |
GPIT_730_TIPO_FORM |
Character(1) |
VARCHAR2(1) NOT NULL |
Form type
O=Original
R=Corrective
|
| 8 |
GPIT_730_CD_CAF |
Character(4) |
VARCHAR2(4) NOT NULL |
CAF Code
Prompt Table:
GPIT_CAF_DATA
|
| 9 |
GPIT_730_NUM_RATE |
Number(1,0) |
SMALLINT NOT NULL |
Number of installments
|
| 10 |
GPIT_730_IRP_RIMB |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
IRPEF to reimburse
|
| 11 |
GPIT_730_IRP_PAG |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
IRPEF to repay
|
| 12 |
GPIT_730_1_ACCONTO |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
First advance
|
| 13 |
GPIT_730_2_ACCONTO |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
Second advance
|
| 14 |
GPIT_730_RIMBREGDI |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
Reimbursement county tax payee
|
| 15 |
GPIT_730_RIMBREGCO |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
Reimbursement county tax spo
|
| 16 |
GPIT_730_PAG_REGDI |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
Repayment county tax payee
|
| 17 |
GPIT_730_PAG_REGCO |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
Repayment county tax spouse
|
| 18 |
GPIT_730_CDREG_DIC |
Character(4) |
VARCHAR2(4) NOT NULL |
County code payee
|
| 19 |
GPIT_730_CDREG_CON |
Character(4) |
VARCHAR2(4) NOT NULL |
County code spouse
|
| 20 |
GPIT_730_RIMBCOMDI |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
Reimbursement city tax payee
|
| 21 |
GPIT_730_RIMBCOMCO |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
Reimbursement city tax spouse
|
| 22 |
GPIT_730_PAG_COMDI |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
Repayment city tax payee
|
| 23 |
GPIT_730_PAG_COMCO |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
Repayment city tax spouse
|
| 24 |
GPIT_730_CDCOM_DIC |
Character(4) |
VARCHAR2(4) NOT NULL |
City code payee
|
| 25 |
GPIT_730_CDCOM_CON |
Character(4) |
VARCHAR2(4) NOT NULL |
City code spouse
|
| 26 |
GPIT_730_ACTSEP_DI |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
Advance separate taxation payee
|
| 27 |
GPIT_730_ACTSEP_CO |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
Advance separate taxation spouse
|
| 28 |
GPIT_770_CORR_730 |
Character(2) |
VARCHAR2(2) NOT NULL |
Reason of corrective 730
Year 2002, field fills in box 28
A=A Adjustment due 730-3/730-4
B=B Late adjustment due to 730-3
C=C Late adjustment due to 730-4
D=D Corr of previous late adjust
E=E Corr of previous on time adj
F=F Correction only county code
G=G Correction only of city code
|
| 29 |
GPIT_770_CONG_NO |
Character(2) |
VARCHAR2(2) NOT NULL |
Adjustments not completed
Year 2002 field fills in box 46
A=A Temination
B=B Unpaid leave
C=C Deceased payee
D=D Low compensation
E=E Reimbursment not done
|
| 30 |
GPIT_770_RIS_2ACC |
Character(2) |
VARCHAR2(2) NOT NULL |
Result second advance
Year 2002 field fills in box 35
A=A Request of lower 2 advance
B=B Amounts are lower than 1 EUR
|
| 31 |
GPIT_770_NO_PAG |
Character(2) |
VARCHAR2(2) NOT NULL |
Not payable 770
Yera 2002 field fills in box 30
Y/N Table Edit
|
| 32 |
GPIT_770_TIPO_CONG |
Character(2) |
VARCHAR2(2) NOT NULL |
Type of adjustment
A=A Adjustment due to form 730-3
B=B Late adjustment form 730-4
|
| 33 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: EUR
Prompt Table:
CURRENCY_CD_TBL
|