GPIT_770_RP_008

(SQL Table)
Index Back

Record for 770 Report

Record for 770 Report.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 GPIT_TAX_CD_1 Character(16) VARCHAR2(16) NOT NULL Tax Code
3 GPIT_FILE_NBR4 Number(4,0) SMALLINT NOT NULL File Number
4 COMP_CODE_ITA Character(30) VARCHAR2(30) NOT NULL Company Codes ITA
5 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
6 GPIT_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence Number
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 GPIT_TFR_PAID_CYR Signed Number(12,2) DECIMAL(10,2) NOT NULL TFR paid in Year
10 GPIT_TFR_PAID_PYR Signed Number(12,2) DECIMAL(10,2) NOT NULL TFR paid in Previous Years
11 GPIT_TFR_TAX_CYR Signed Number(12,2) DECIMAL(10,2) NOT NULL TFR Taxes in Year
12 GPIT_TFR_TAX_PYR Signed Number(12,2) DECIMAL(10,2) NOT NULL TFR Taxes Previous Years
13 GPIT_HEIRS_PCT Number(8,4) DECIMAL(7,4) NOT NULL Percentage for Heirs
14 HIRE_DT Date(10) DATE First Start Date
15 TERMINATION_DT Date(10) DATE Termination Date
16 MONTH2 Number(2,0) SMALLINT NOT NULL Month 2
17 GPIT_YEAR_NUM2 Number(2,0) SMALLINT NOT NULL Year
18 GPIT_YY_NUM2_01 Number(2,0) SMALLINT NOT NULL Year
19 GPIT_MM_NUM2_01 Number(2,0) SMALLINT NOT NULL Month
20 GPIT_ADDN_AMOUNT Signed Number(12,2) DECIMAL(10,2) NOT NULL Additional Amount
21 GPIT_DAYWKLEAVEOFF Number(3,0) SMALLINT NOT NULL Days of Work Leave Off
22 GPIT_TEMP_WORK Character(1) VARCHAR2(1) NOT NULL Temporary Work
23 GPIT_EQ_INDEMN Signed Number(12,2) DECIMAL(10,2) NOT NULL Equivalent Indemnities
24 GPIT_EQ_INDEMN_TTL Character(1) VARCHAR2(1) NOT NULL Equivalent Indemnities Title
25 GPIT_OT_INDEMN Signed Number(12,2) DECIMAL(10,2) NOT NULL Other Indemnities
26 GPIT_OT_INDEMN_TTL Character(1) VARCHAR2(1) NOT NULL Other Indemnities Title
27 GPIT_00TFRACCR Signed Number(12,2) DECIMAL(10,2) NOT NULL Accrued TFR before 2001
28 GPIT_00TFRPAID Signed Number(12,2) DECIMAL(10,2) NOT NULL Paid TFR before 2001
29 GPIT_00TFRPAID_TTL Character(1) VARCHAR2(1) NOT NULL Paid TFR before 2001 Title
30 GPIT_00INDPAID Signed Number(12,2) DECIMAL(10,2) NOT NULL Paid other Indemnities before 2001
31 GPIT_00INDPAID_TTL Character(1) VARCHAR2(1) NOT NULL Paid other Indemnities before 2001 Title
32 GPIT_00TFRPENSFUND Signed Number(12,2) DECIMAL(10,2) NOT NULL TFR to Pension Fund until 2000
33 GPIT_TOT_DEDUCTION Signed Number(12,2) DECIMAL(10,2) NOT NULL Total Deduction
34 GPIT_PERCENTAGE_1 Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
35 GPIT_YY_NUM2_02 Number(2,0) SMALLINT NOT NULL Year
36 GPIT_MM_NUM2_02 Number(2,0) SMALLINT NOT NULL Month
37 GPIT_01TFRACCR Signed Number(12,2) DECIMAL(10,2) NOT NULL Accrued TFR from 2001
38 GPIT_01TFRPAID Signed Number(12,2) DECIMAL(10,2) NOT NULL Paid TFR from 2001
39 GPIT_01TFRPAID_TTL Character(1) VARCHAR2(1) NOT NULL Paid TFR from 2001 Title
40 GPIT_01INDPAID Signed Number(12,2) DECIMAL(10,2) NOT NULL Paid other Indemnities after 2001
41 GPIT_01INDPAID_TTL Character(1) VARCHAR2(1) NOT NULL Paid other Indemnities after 2001 Title
42 GPIT_01TFRPENSFUND Signed Number(12,2) DECIMAL(10,2) NOT NULL TFR to Pension Fund from 2001
43 GPIT_INC_ESODO Signed Number(12,2) DECIMAL(10,2) NOT NULL Incentivo Esodo
44 GPIT_INC_ESODO_TTL Character(1) VARCHAR2(1) NOT NULL Incentivo Esodo Title
45 GPIT_YY_NUM2_03 Number(2,0) SMALLINT NOT NULL Year
46 GPIT_MM_NUM2_03 Number(2,0) SMALLINT NOT NULL Month
47 GPIT_PERCENTAGE_2 Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
48 GPIT_02TFRPAID Signed Number(12,2) DECIMAL(10,2) NOT NULL TFR Advances paid before 2002
49 GPIT_02INDPAID Signed Number(12,2) DECIMAL(10,2) NOT NULL Other Indemnities Advances paid before 2002
50 GPIT_02INDPAID_TTL Character(1) VARCHAR2(1) NOT NULL Other Indemnities Advances paid before 2002 Title
51 GPIT_AVG_INC_PR2YR Signed Number(12,2) DECIMAL(10,2) NOT NULL Previous 2 Year Average Income
52 GPIT_TAX_RATE_1 Signed Number(7,2) DECIMAL(5,2) NOT NULL Tax Rate Previous 2 Year Average Income
53 GPIT_TOT_REDUCTION Signed Number(12,2) DECIMAL(10,2) NOT NULL Total Reductions
54 GPIT_INCOME_EQUIV Signed Number(12,2) DECIMAL(10,2) NOT NULL Income for Equivalent
55 GPIT_INCOME_DEC31 Signed Number(12,2) DECIMAL(10,2) NOT NULL Income at December 31, 2000
56 GPIT_INCOME_JAN01 Signed Number(12,2) DECIMAL(10,2) NOT NULL Income at January 1, 2001
57 GPIT_TOT_INCOME Signed Number(12,2) DECIMAL(10,2) NOT NULL Total Income
58 GPIT_REF_INCOME Signed Number(12,2) DECIMAL(10,2) NOT NULL Reference Income
59 GPIT_TAX_RATE_2 Signed Number(7,2) DECIMAL(5,2) NOT NULL Tax Rate
60 GPIT_TAX_RATE_3 Signed Number(7,2) DECIMAL(5,2) NOT NULL Tax Rate
61 GPIT_TOT_TAX Signed Number(12,2) DECIMAL(10,2) NOT NULL Total Tax
62 GPIT_TAX_AFTER2001 Signed Number(12,2) DECIMAL(10,2) NOT NULL Tax after 2001
63 GPIT_TAX_DETR Signed Number(12,2) DECIMAL(10,2) NOT NULL Tax Detractions
64 GPIT_02TFRPAID_TAX Signed Number(12,2) DECIMAL(10,2) NOT NULL Taxes on Advances paid in 1974/2002
65 GPIT_COMPENSATION Signed Number(12,2) DECIMAL(10,2) NOT NULL Compensation
66 GPIT_YEAR_TAXES Signed Number(12,2) DECIMAL(10,2) NOT NULL Taxes in the Year
67 GPIT_DEDUCT_FROZEN Signed Number(12,2) DECIMAL(10,2) NOT NULL Frozen Deductions
68 GPIT_REEV_ALR_TAXD Signed Number(12,2) DECIMAL(10,2) NOT NULL Already Taxed Reevaluations
69 GPIT_TAX_CD Character(16) VARCHAR2(16) NOT NULL Tax Code
70 GPIT_TAX_CD_2 Character(16) VARCHAR2(16) NOT NULL Tax Code
71 GPIT_PERCENTAGE_3 Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
72 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
73 COMPANY Character(3) VARCHAR2(3) NOT NULL Company