| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 GP_PKG_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Field used for element packaging
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 3 |
CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
|
| 4 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 5 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
|
| 6 |
CAL_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
calendar id
|
| 7 |
RSLT_SEG_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Result Segment Number
|
| 8 |
INSTANCE |
Number(3,0) |
SMALLINT NOT NULL |
Instance Number
|
| 9 |
PIN_NUM |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
|
| 10 |
SLICE_BGN_DT |
Date(10) |
DATE |
Element Slice Begin Date
|
| 11 |
SLICE_END_DT |
Date(10) |
DATE |
Element Slice End Date
|
| 12 |
ENTRY_TYPE_ELEM |
Character(3) |
VARCHAR2(3) NOT NULL |
entry type element
|
| 13 |
CALC_RSLT_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Calculation Numeric Result
|
| 14 |
CALC_ADJ_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Calculation Adjustment Value
|
| 15 |
BASE_RSLT_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Calculated Base Value
|
| 16 |
BASE_ADJ_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Base Adjustment
|
| 17 |
RATE_RSLT_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Rate Result Value
|
| 18 |
UNIT_RSLT_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Number of units used in result calculation
|
| 19 |
UNIT_ADJ_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Unit Adjustment
|
| 20 |
PCT_RSLT_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Percent Result Value
|
| 21 |
RSLT_NOT_TKN |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Amount Not Taken
|
| 22 |
RSLT_ADD_ARR |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Amount Added To Arrears
|
| 23 |
RSLT_PAYBK |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Payback Amount Result
|
| 24 |
RSLT_XFER_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Bank Transfer Value of Deduct
|
| 25 |
FORCED_RECALC_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicator field on Result table. A "Y" indicates that the value was recalculated during (a retro period) pay calc even though the definition says not to recalc. This may occur if the segments of the pay period differs between the original and the re-calced run.
|