| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 RETROPAY_SEQ_NO |
Character(15) |
VARCHAR2(15) NOT NULL |
Retro Pay Sequence Number
|
| 2 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 3 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table:
PAYGROUP_TBL
|
| 4 |
PAY_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 5 |
OFF_CYCLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Off Cycle ?
Y/N Table Edit
Default Value: N
|
| 6 |
PAGE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Page Nbr
|
| 7 |
LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Line Nbr
|
| 8 |
ADDL_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Additional Pay Line Nbr
Prompt Table:
PAY_EARNINGS
|
| 9 |
EARNS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Earning
1=Regular Hourly
2=Regular Salary
3=Overtime
4=Other Earns
5=Other Hours
|
| 10 |
ERNCD |
Character(3) |
VARCHAR2(3) NOT NULL |
Earnings Code
Prompt Table:
EARNINGS_TBL
|
| 11 |
SEQ_NO |
Number(2,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 12 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON
|
| 13 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 14 |
RETROPAY_EFFDT |
Date(10) |
DATE NOT NULL |
Retro Pay Effective Date
|
| 15 |
SEPCHK |
Number(2,0) |
SMALLINT NOT NULL |
Separate check number.
|
| 16 |
ADDL_SEQ |
Number(2,0) |
SMALLINT NOT NULL |
Additional Pay Sequence Number
|
| 17 |
EARNS_BEGIN_DT |
Date(10) |
DATE |
Earnings Begin Date
|
| 18 |
EARNS_END_DT |
Date(10) |
DATE |
Earnings End Date
|
| 19 |
EARNS_HRS |
Signed Number(8,2) |
DECIMAL(6,2) NOT NULL |
Earnings Hours
|
| 20 |
HOURLY_RT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Hourly Rate
|
| 21 |
NEW_HOURLY_RT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
New Hourly Rate
|
| 22 |
EARNS_AMT |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Earnings Amount
|
| 23 |
EARNS_AMT_ENTERED |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Earns Amount Entered
|
| 24 |
NEW_EARNS_AMT |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
New Earnings Amount
|
| 25 |
EARNS_AMT_OVRD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Earnings Amount Override
|
| 26 |
AMOUNT_DIFF |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Amount Difference
|
| 27 |
PRIOR_RETRO_PAID |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Prior Retro Paid
|
| 28 |
SHIFT |
Character(1) |
VARCHAR2(1) NOT NULL |
Regular Shift
1=Day
2=Evening
3=Night
A=Any
C=Compressed
N=Not Applicable
R=Rotating
|
| 29 |
SHIFT_RT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Shift Differential Rate
|
| 30 |
RETROPAY_ERNCD |
Character(3) |
VARCHAR2(3) NOT NULL |
Retro Pay Earnings Type
Prompt Table:
EARNINGS_TBL
|
| 31 |
RETROPAY_PRCS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
If translate values are added/modified for RETROPAY_PRCS_FLAG field, same changes must be done for RETROPAY_PRCS_FLG1 field.
A=Action Required
C=Calculated
F=Confirmed Payment
M=Manually Loaded to Paysheet
N=Not Processed
P=Loaded to Paysheets
R=Recalculate Request
S=Suspended
V=Paycheck Reversed
W=Cancelled / Withdrawn
X=Extracted
|
| 32 |
EXCEPTION_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Exception - Chg in Pay Period
Y/N Table Edit
Default Value: N
|
| 33 |
OK_TO_PAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Okay to pay indicator.
Y/N Table Edit
Default Value: N
|
| 34 |
JOB_PAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Job Pay
Y/N Table Edit
Default Value: N
|
| 35 |
RETRO_ADDL_NO |
Number(3,0) |
SMALLINT NOT NULL |
Retro Pay Additional Number
|
| 36 |
RETRO_SEPCHK |
Number(2,0) |
SMALLINT NOT NULL |
Retro Pay Separate Check No.
|
| 37 |
TERM_EMPL_PRCS |
Character(1) |
VARCHAR2(1) NOT NULL |
Terminated Employees Processed
Y/N Table Edit
Default Value: N
|
| 38 |
FLSA_REQUIRED |
Character(1) |
VARCHAR2(1) NOT NULL |
FLSA required
N=NO FLSA REQUIRED
Y=FLSA REQUIRED
Default Value: N
|
| 39 |
RATE_USED |
Character(1) |
VARCHAR2(1) NOT NULL |
Rate Used
A=Alternative Rate
F=FLSA Rate
H=Hourly Rate
Default Value: H
|
| 40 |
FLSA_RT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
FLSA Rate
|
| 41 |
RECORD_CHANGED |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Changed
Y/N Table Edit
Default Value: N
|
| 42 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 43 |
LOCALITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Locality
|
| 44 |
DIST_PCT |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Percent of Distribution
|
| 45 |
COMP_RATECD |
Character(6) |
VARCHAR2(6) NOT NULL |
Comp Rate Code
|
| 46 |
COMPRATE_USED |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Comp Rate Used
|
| 47 |
NEW_COMPRATE_USED |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
New Comp Rate Used
|
| 48 |
RETROPAY_LOAD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Retro Pay Load Switch
Y/N Table Edit
Default Value: Y
|
| 49 |
FLSA_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
FLSA Status
A=Administrative
C=Computer Employee
E=Executive
H=Highly Compensated Employees
M=Management
N=Nonexempt
O=Outside Salesperson
P=Professional
V=Nonexempt Alt Overtime
X=No FLSA Required
Default Value: X
|
| 50 |
OVERRIDE_HOURLY_RT |
Character(1) |
VARCHAR2(1) NOT NULL |
OverRide Hourly Rate Indicator
|
| 51 |
OVERRIDE_OTH_RATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate that Other Earnings has a specific hourly rate entered
|
| 52 |
OVERRIDE_RT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Override rate
|
| 53 |
PY_JUR_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
This field is used for storing Jurisdiction Code for the state
|