| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
GPIT_INQ_TFR_3112 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Fund 31/12 Y-1
|
| 3 |
GPIT_INQ_TFR_REV |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Reevaluation 31/12 Y-1
|
| 4 |
GPIT_INQ_TFR_ACC00 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
TFR accrued 31/12/2000
|
| 5 |
GPIT_INQ_TFR_DTR00 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Deductions 31/12/2000
|
| 6 |
GPIT_INQ_TFR_PAID |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
TFR paid employment
|
| 7 |
GPIT_INQ_TFR_ANT_Y |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Anticipations YTD
|
| 8 |
GPIT_INQ_TFR_IMP |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Gross income Pre-2000 empl
|
| 9 |
GPIT_INQ_TFR_IMP_N |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Net income pre-2000 empl
|
| 10 |
GPIT_INQ_TFR_TXP00 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Tax pre 2000 employment
|
| 11 |
GPIT_INQ_TFR_IND00 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Net income post-2000 employment
|
| 12 |
GPIT_INQ_TFR_TXD00 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Tax post 2000 employment
|
| 13 |
GPIT_INQ_TFR_RATE |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
TFR Tax rate
|
| 14 |
GPIT_INQ_TFR_MM_RR |
Number(3,0) |
SMALLINT NOT NULL |
Months useful ref. Income
|
| 15 |
GPIT_INQ_TFR_MMDTR |
Number(3,0) |
SMALLINT NOT NULL |
Months for detractions
|
| 16 |
GPIT_INQ_TFR_MDTR1 |
Number(3,0) |
SMALLINT NOT NULL |
Months for detr. Temp employee
|
| 17 |
GPIT_INQ_TFR_FPC_E |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
TFR pension fund empl
|