| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PI_RUN_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Payroll Interface Run Number
|
| 2 |
PI_SYSTEM_ID |
Character(4) |
VARCHAR2(4) NOT NULL |
Payroll Interface System ID
|
| 3 |
PI_CONFIG_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
PI Configuration ID
|
| 4 |
PI_PAY_GROUP1 |
Character(6) |
VARCHAR2(6) NOT NULL |
PI Paygroup 1
|
| 5 |
PI_PAY_GROUP2 |
Character(6) |
VARCHAR2(6) NOT NULL |
PI Paygroup 2
|
| 6 |
PI_EMPLID |
Character(20) |
VARCHAR2(20) NOT NULL |
Payroll Interface EMPLID
|
| 7 |
PAY_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 8 |
PI_CHECK_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
Payroll Check Number
|
| 9 |
PI_DED_TYPE |
Character(6) |
VARCHAR2(6) NOT NULL |
Payroll Deduction Type
|
| 10 |
PI_DED_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Payroll Deduction Code
|
| 11 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 12 |
PI_DED_DISTR |
Character(10) |
VARCHAR2(10) NOT NULL |
Payroll Deduction Distribution
|
| 13 |
PI_DED_CUR |
Signed Number(20,3) |
DECIMAL(18,3) NOT NULL |
Current Deduction
|
| 14 |
PI_DED_CUR_PAYBK |
Signed Number(20,3) |
DECIMAL(18,3) NOT NULL |
Current Deduction Payback
|
| 15 |
PI_DED_CUR_REFUND |
Signed Number(20,3) |
DECIMAL(18,3) NOT NULL |
Current Deduction Refund
|
| 16 |
PI_DED_NOT_TAKEN |
Signed Number(20,3) |
DECIMAL(18,3) NOT NULL |
Deduction Not Taken
|
| 17 |
PI_CALCULATED_BASE |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Coverage Base
|
| 18 |
PI_DED_YTD |
Signed Number(20,3) |
DECIMAL(18,3) NOT NULL |
Deduction Balance YTD
|
| 19 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|