GPIT_INAILX2TMP

(SQL Table)
Index Back

INAIL Report Temporary Record

INAIL Year-End Report Temporary Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 GPIT_YEAR_NUM4 Number(4,0) SMALLINT NOT NULL Year
3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
4 INAIL_CODE Character(11) VARCHAR2(11) NOT NULL INAIL Code
5 RISK_CD_ITA Character(4) VARCHAR2(4) NOT NULL Risk Code ITA (or INAIL Tariff Code)
6 FROMDATE Date(10) DATE NOT NULL From Date
7 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
8 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
9 SEQUENCENO Number(10,0) DECIMAL(10) NOT NULL Sequence Number
10 THRU_DATE Date(10) DATE Thru Date
11 GPIT_TYPE_CHAR1 Character(1) VARCHAR2(1) NOT NULL Type
12 GPIT_CHK_BOX_YN Character(1) VARCHAR2(1) NOT NULL This field is used in different tables as CheckBox. Depending on the context, a different lable can be chosen. For example it is used in the Scaglioni and Tax detraction table.
13 RISK_PERC_ITA Number(8,4) DECIMAL(7,4) NOT NULL Risk Percentage ITA
14 RISK_SIL_ASB_ITA Number(8,4) DECIMAL(7,4) NOT NULL Silicosis Asbestosi Percentage ITA
15 GPIT_INAIL_ASS_INC Number(15,2) DECIMAL(14,2) NOT NULL INAIL Assessable Income
16 GPIT_INAIL_RED_INC Number(15,2) DECIMAL(14,2) NOT NULL INAIL Reducted Income
17 GPIT_SILICOSIS_INC Number(15,2) DECIMAL(14,2) NOT NULL INAIL Silicosis Income