# |
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
|