GPIT_INAILX1TMP

(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 SEQUENCENO Number(10,0) DECIMAL(10) NOT NULL Sequence Number
3 GPIT_YEAR_NUM4 Number(4,0) SMALLINT NOT NULL Year
4 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
6 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
7 GPIT_INAIL_CO_CD Character(11) VARCHAR2(11) NOT NULL INAIL Company Code
8 GPIT_TMP_CHAR09_01 Character(9) VARCHAR2(9) NOT NULL Field for Application Engines.
9 GPIT_TMP_CHAR02_01 Character(2) VARCHAR2(2) NOT NULL Field for Application Engines.
10 GPIT_COMP_CODFIS Character(16) VARCHAR2(16) NOT NULL Company tax code
11 DESCR Character(30) VARCHAR2(30) NOT NULL Description
12 GPIT_INAIL_SITE Character(5) VARCHAR2(5) NOT NULL INAIL Site