GPIT_770TWA_HST

(SQL Table)
 Index Back

Record for 770 Report

This is the Archive (shadow) table used in Data Archiving for the record: GPIT_770_TFR_WA.

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