| # |
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 |
SEG_END_DT |
Date(10) |
DATE |
Payee Process Segment's End Date
|
| 11 |
SEG_BGN_DT |
Date(10) |
DATE |
Payee Process Segment's Begin Date
|
| 12 |
GPIT_INQ_TAX_DETR |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Expence Reduction
|
| 13 |
GPIT_INQ_GG_DETR |
Number(3,0) |
SMALLINT NOT NULL |
Dependant Work Days
|
| 14 |
GPIT_INQ_SPO_DETR |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Spouse detraction
|
| 15 |
GPIT_INQ_FAM_DETR |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Dependant detractions
|
| 16 |
GPIT_INQ_ONE_DETR |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Detractable oneri
|
| 17 |
GPIT_INQ_DETR_ONE |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Oneri detractions
|
| 18 |
GPIT_INQ_TOT_DETR |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Total applied detractions
|
| 19 |
GPIT_INQ_IRP_INC |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Irpef income
|
| 20 |
GPIT_INQ_IRP_GROSS |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Gross 1001 tax
|
| 21 |
GPIT_INQ_IRP_NET |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Net 1001 tax
|
| 22 |
GPIT_INQ_SEP_TAX |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Separate tax income
|
| 23 |
GPIT_INQ_IRP_SEP |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Gross 1002 tax
|
| 24 |
GPIT_INQ_DETR_TSEP |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Detraction 1002
|
| 25 |
GPIT_INQ_NET_TSEP |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Net 1002 tax
|
| 26 |
GPIT_INQ_INC_Y_1 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Income Y-1
|
| 27 |
GPIT_INQ_INC_Y_2 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Income Y-2
|
| 28 |
GPIT_INQ_CITY_AC |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
City Tax Current Year
|
| 29 |
GPIT_INQ_CITY_AP |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
City Tax Y-1 Theoretical
|
| 30 |
GPIT_INQ_CITY_P |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
City Tax Y-1 Paid
|
| 31 |
GPIT_INQ_CNTY_AC |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
County tax current year
|
| 32 |
GPIT_INQ_CNTY_AP |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
County tax Y-1 Theoretical
|
| 33 |
GPIT_INQ_CNTY_P |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
County tax Y-1 (paid)
|
| 34 |
GPIT_INQ_IVS_INC |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
IVS income
|
| 35 |
GPIT_INQ_OTH_INC |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Other contributions income
|
| 36 |
GPIT_INQ_IVS_AGG |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Add. IVS contribution
|
| 37 |
GPIT_INQ_FPC_ER_Y |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Employer ctr YTD
|
| 38 |
GPIT_INQ_FPC_EE_Y |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Employee ctr YTD
|
| 39 |
GPIT_INQ_FPC_EE_E |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Employee ctr employment
|
| 40 |
GPIT_INQ_FPC_TFR_Y |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
TFR ctr YTD
|
| 41 |
GPIT_INQ_FPC_TFR_E |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
TFR ctr employment
|
| 42 |
GPIT_INQ_FPC_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Assessed YTD amt.
|
| 43 |
GPIT_INQ_FPC_ER_E |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Employer ctr employment
|
| 44 |
GPIT_INQ_TFR_3112 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Fund 31/12 Y-1
|
| 45 |
GPIT_INQ_TFR_REV |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Reevaluation 31/12 Y-1
|
| 46 |
GPIT_INQ_TFR_INC |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
TFR useful income curr year
|
| 47 |
GPIT_INQ_TFR_FPC |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
TFR to pension fund
|
| 48 |
GPIT_INQ_TFR_CTR |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Ctr 0.5% current year
|
| 49 |
GPIT_INQ_TFR_ANT_Y |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Anticipations YTD
|
| 50 |
GPIT_INQ_TFR_AN_Y1 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Anticipations on Y-1
|
| 51 |
GPIT_INQ_TFR_AN_AC |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Anticipations on curr year
|
| 52 |
GPIT_INQ_TFR_AN_RV |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Reevaluation on anticipations
|
| 53 |
GPIT_INQ_TFR_RIVAN |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Reevaluation on anticipations
|
| 54 |
GPIT_INQ_TFR_ANTRV |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Anticipation granted as reev.
|
| 55 |
GPIT_INQ_TFR_RIVAL |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Accrued reevaluation
|
| 56 |
GPIT_INQ_TFR_TXRIV |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Tax on reevalution YTD
|
| 57 |
GPIT_INQ_TFR_FUND |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
TFR Fund
|
| 58 |
GPIT_INQ_TFR_MM_RR |
Number(3,0) |
SMALLINT NOT NULL |
Months useful ref. Income
|
| 59 |
GPIT_INQ_TFR_PAID |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
TFR paid employment
|
| 60 |
GPIT_INQ_TFR_FPC_E |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
TFR pension fund empl
|
| 61 |
GPIT_INQ_TFR_RATE |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
TFR Tax rate
|
| 62 |
GPIT_INQ_TFR_ACC |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Balance TFR accrued
|
| 63 |
GPIT_INQ_TFR_FPCAC |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Balance TFR pension fund
|
| 64 |
GPIT_INQ_TFR_MMRRA |
Number(3,0) |
SMALLINT NOT NULL |
Balance months ref. Income
|
| 65 |
GPIT_INQ_TFR_MMDTR |
Number(3,0) |
SMALLINT NOT NULL |
Months for detractions
|
| 66 |
GPIT_INQ_TFR_MDTR1 |
Number(3,0) |
SMALLINT NOT NULL |
Months for detr. Temp employee
|
| 67 |
GPIT_INQ_TFR_DTR |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Detractions employment
|
| 68 |
GPIT_INQ_TFR_DTRY |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Detractions YTD
|
| 69 |
GPIT_INQ_TFR_DTR00 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Deductions 31/12/2000
|
| 70 |
GPIT_INQ_TFR_ACC00 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
TFR accrued 31/12/2000
|
| 71 |
GPIT_INQ_TFR_IMP |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Gross income Pre-2000 empl
|
| 72 |
GPIT_INQ_TFR_IMP_N |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Net income pre-2000 empl
|
| 73 |
GPIT_INQ_TFR_TXP00 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Tax pre 2000 employment
|
| 74 |
GPIT_INQ_TFR_ILP00 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Gross income Pre-2000 YTD
|
| 75 |
GPIT_INQ_TFR_INP00 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Net income pre-2000 YTD
|
| 76 |
GPIT_INQ_TFR_TP00Y |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Tax Pre 2000 YTD
|
| 77 |
GPIT_INQ_TFR_IND00 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Net income post-2000 employment
|
| 78 |
GPIT_INQ_TFR_TXD00 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Tax post 2000 employment
|
| 79 |
GPIT_INQ_TFR_IMPD0 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Net income post-2000 YTD
|
| 80 |
GPIT_INQ_TFR_TD00Y |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Tax post 2000 YTD
|
| 81 |
GPIT_INQ_TFR_INCAI |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Other indemnities income empl.
|
| 82 |
GPIT_INQ_TFR_TXAI |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Other indemnities tax empl
|
| 83 |
GPIT_INQ_TFR_INCIY |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Other indemnities inc. YTD
|
| 84 |
GPIT_INQ_TFR_TAXIY |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Other indemnities tax YTD
|
| 85 |
GPIT_INQ_TFR_ESIMP |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Incent. esodo inc. empl
|
| 86 |
GPIT_INQ_TFR_ESTX |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Incent. esodo tax empl
|
| 87 |
GPIT_INQ_TFR_ESINY |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Incent. esodo income YTD
|
| 88 |
GPIT_INQ_TFR_ESTXY |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Incent. esodo tax YTD
|
| 89 |
GPIT_INQ_TFR_PRE |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Notification income YTD
|
| 90 |
GPIT_INQ_TFR_CTPRE |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Ctr on notification YTD
|
| 91 |
GPIT_INQ_TFR_RVPAG |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Paid reevaluation year
|
| 92 |
GPIT_INQ_TFR_RIV_E |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Tax on reevalution employment
|