| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PSARCH_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Archive ID (see PSARCHTEMPLATE).
|
| 2 |
PSARCH_BATCHNUM |
Number(30,0) |
DECIMAL(30) NOT NULL |
Archive Batch Number
|
| 3 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 4 |
CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
|
| 5 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 6 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
|
| 7 |
CAL_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
calendar id
|
| 8 |
ORIG_CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Original Calendar Group ID
|
| 9 |
RSLT_SEG_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Result Segment Number
|
| 10 |
INSTANCE |
Number(3,0) |
SMALLINT NOT NULL |
Instance Number
|
| 11 |
PIN_NUM |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
|
| 12 |
SLICE_BGN_DT |
Date(10) |
DATE |
Element Slice Begin Date
|
| 13 |
SLICE_END_DT |
Date(10) |
DATE |
Element Slice End Date
|
| 14 |
CALC_RSLT_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Calculation Numeric Result
|
| 15 |
CALC_ADJ_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Calculation Adjustment Value
|
| 16 |
BASE_RSLT_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Calculated Base Value
|
| 17 |
BASE_ADJ_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Base Adjustment
|
| 18 |
RATE_RSLT_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Rate Result Value
|
| 19 |
UNIT_RSLT_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Number of units used in result calculation
|
| 20 |
UNIT_ADJ_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Unit Adjustment
|
| 21 |
PCT_RSLT_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Percent Result Value
|
| 22 |
RECIPIENT_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Payment recipient ID
|
| 23 |
RECIPIENT_TAG |
Number(3,0) |
SMALLINT NOT NULL |
Used to identify recipients for E/D, PI
|
| 24 |
RSLT_NOT_TKN |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Amount Not Taken
|
| 25 |
RSLT_ADD_ARR |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Amount Added To Arrears
|
| 26 |
RSLT_PAYBK |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Payback Amount Result
|
| 27 |
RSLT_XFER_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Bank Transfer Value of Deduct
|
| 28 |
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.
Y/N Table Edit
|
| 29 |
USER_FLD1 |
Character(25) |
VARCHAR2(25) NOT NULL |
User Field 1
|
| 30 |
USER_FLD2 |
Character(25) |
VARCHAR2(25) NOT NULL |
User Field 2
|
| 31 |
USER_FLD3 |
Character(25) |
VARCHAR2(25) NOT NULL |
User Field 3
|
| 32 |
USER_FLD4 |
Character(25) |
VARCHAR2(25) NOT NULL |
User Field 4
|
| 33 |
USER_FLD5 |
Character(25) |
VARCHAR2(25) NOT NULL |
User FIeld 5
|
| 34 |
USER_FLD6 |
Character(25) |
VARCHAR2(25) NOT NULL |
User Field 6
|
| 35 |
ED_ASSIGN_INSTANCE |
Number(3,0) |
SMALLINT NOT NULL |
Earn/Ded Assignment Instance
|
| 36 |
PI_INSTANCE |
Number(3,0) |
SMALLINT NOT NULL |
Positive Input Instance
|
| 37 |
DRIVER_EXISTS_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Driver Accumulator Row Exists during resolution indicator
Y/N Table Edit
Default Value: N
|
| 38 |
CALC_RSLT_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Source of Amount or Calculated Result
A=Assigned via Element
E=Earn Ded Assignment
F=Post Formula
N=Not Applicable
P=Positive Input
R=Rule Definition
|
| 39 |
BASE_RSLT_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Source of Base on Result
A=Assigned via Element
E=Earn Ded Assignment
F=Post Formula
N=Not Applicable
P=Positive Input
R=Rule Definition
|
| 40 |
PCT_RSLT_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Source of Percent on Result
A=Assigned via Element
E=Earn Ded Assignment
F=Post Formula
N=Not Applicable
P=Positive Input
R=Rule Definition
|
| 41 |
RATE_RSLT_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Source of Rate on Result
A=Assigned via Element
E=Earn Ded Assignment
F=Post Formula
N=Not Applicable
P=Positive Input
R=Rule Definition
|
| 42 |
UNIT_RSLT_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Source of Unit on Result
A=Assigned via Element
E=Earn Ded Assignment
F=Post Formula
N=Not Applicable
P=Positive Input
R=Rule Definition
|