| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 2 |
GPES_TAX_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Fiscal Territory. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
|
| 3 |
PAY_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 4 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 5 |
GPES_FISCAL_KEY |
Character(2) |
VARCHAR2(2) NOT NULL |
Fiscal key. Used to identify the earnings.
|
| 6 |
GPES_FISCAL_SUBKEY |
Character(2) |
VARCHAR2(2) NOT NULL |
Fiscal sub-key. Used to identify the earnings.
|
| 7 |
YEARCD |
Character(4) |
VARCHAR2(4) NOT NULL |
Calendar Year
|
| 8 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 9 |
GPES_SALARY_INCOME |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Salary Income.
|
| 10 |
GPES_SALARY_WITHLD |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Salary Withholding.
|
| 11 |
GPES_INKIND_INCOME |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Total amount earned as in kind income.
|
| 12 |
GPES_INKIND_WITHLD |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Contribution (payee + employer) as in-kind withholding.
|
| 13 |
GPES_INK_WITHLD_EE |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Contribution (payee) as in-kind withholding.
|
| 14 |
GPES_SUBSD_INCOME |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Social Security subsidy income
|
| 15 |
GPES_SUBSD_WITHLD |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Social Security subsidy withholding
|
| 16 |
GPES_SUBSD_INK_INC |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Social Security subsidy in kind income
|
| 17 |
GPES_SUBSD_INK_WTH |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Social Security subsidy in kind withholding
|
| 18 |
GPES_SUBSD_INK_WEE |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Contribution (payee) as subsidy in-kind withholding.
|
| 19 |
GPES_REDUCTIONS |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Taxes reductions
|
| 20 |
GPES_GARN_SPOUSE |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Amount paid by the payee in concept of garnishment for spouse alimony.
|
| 21 |
GPES_GARN_CHILDREN |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Amount paid by the payee in concept of garnishment for children alimony.
|
| 22 |
GPES_SS_CT_EE |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Employee Social Security contribution
|