GPIT_SCAGL_REC2 (SQL Table)	Index Back
Scaglioni-Key: ID and DATE This table contains ID, date (as keys) and eff.status of the scaglioni table. It is supposed that the Scaglioni table will be used not only for IRPEF values (ID-table: IRPF) but also for other rules.

GPIT_SCAGL_REC2

(SQL Table)

Scaglioni-Key: ID and DATE

This table contains ID, date (as keys) and eff.status of the scaglioni table. It is supposed that the Scaglioni table will be used not only for IRPEF values (ID-table: IRPF) but also for other rules.

Parent record: GPIT_SCAGL_REC1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPIT_TAB_SCAGL_ID Character(4) VARCHAR2(4) NOT NULL Id of the Scaglioni table. The table should be useful bothb for IRTEF taxation and contribution. The ID exist in order to distinguish between tables.

2 EFFDT Date(10) DATE Effective Date
Default Value: %date

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPIT_TAB_SCAGL_ID	Character(4)	VARCHAR2(4) NOT NULL	Id of the Scaglioni table. The table should be useful bothb for IRTEF taxation and contribution. The ID exist in order to distinguish between tables.
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A