| # |
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_EARN_TYPE |
Character(6) |
VARCHAR2(6) NOT NULL |
Payroll Earning Type
|
| 10 |
PI_EARN_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Payroll Earnings Code
|
| 11 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 12 |
PI_EARN_DISTR |
Character(10) |
VARCHAR2(10) NOT NULL |
Payroll Earnings Distribution
|
| 13 |
EARNS_HRS |
Signed Number(8,2) |
DECIMAL(6,2) NOT NULL |
Earnings Hours
|
| 14 |
HOURLY_RT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Hourly Rate
|
| 15 |
PI_EARNS_AMT |
Signed Number(20,3) |
DECIMAL(18,3) NOT NULL |
Earnings Amount
|
| 16 |
EARNS_BEGIN_DT |
Date(10) |
DATE |
Earnings Begin Date
|
| 17 |
EARNS_END_DT |
Date(10) |
DATE |
Earnings End Date
|
| 18 |
HRS_YTD |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Hours year-to-date.
|
| 19 |
PI_GRS_YTD |
Signed Number(20,3) |
DECIMAL(18,3) NOT NULL |
Gross Earnings YTD
|
| 20 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|