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