| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 2 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
|
| 3 |
PAY_END_DT |
Date(10) |
DATE NOT NULL |
Pay Period End Date
|
| 4 |
OFF_CYCLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Off Cycle ?
Y/N Table Edit
Default Value: Y
|
| 5 |
PAGE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Page Nbr
|
| 6 |
LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Line Nbr
|
| 7 |
ADDL_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Additional Pay Line Nbr
|
| 8 |
ERNCD |
Character(3) |
VARCHAR2(3) NOT NULL |
Earnings Code
Prompt Table:
ERN_PROG_DESCR
|
| 9 |
RATE_USED |
Character(1) |
VARCHAR2(1) NOT NULL |
Rate Used
A=Alternative Rate
F=FLSA Rate
H=Hourly Rate
Default Value: H
|
| 10 |
SEPCHK |
Number(2,0) |
SMALLINT NOT NULL |
Separate check number.
|
| 11 |
JOB_PAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Job Pay
Y/N Table Edit
Default Value: N
|
| 12 |
OTH_HRS |
Signed Number(8,2) |
DECIMAL(6,2) NOT NULL |
Other hours.
|
| 13 |
OTH_PAY |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Other Pay
|
| 14 |
OTH_EARNS |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Other Earnings
|
| 15 |
ADD_GROSS |
Character(1) |
VARCHAR2(1) NOT NULL |
Add to Gross Pay
N=No
Y=Yes
Y/N Table Edit
|
| 16 |
TAX_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax method.
A=Annualized
B=Bonus
C=Cumulative
G=Aggregate
L=Lump Sum
M=Commission
P=Specified on Paysheet
S=Supplemental
X=Special Supplemental
|
| 17 |
ADDL_SEQ |
Number(2,0) |
SMALLINT NOT NULL |
Additional Pay Sequence Number
Prompt Table:
ADDL_PAY_DATA
|
| 18 |
TL_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Time && Labor Source Flag
T=Time and Labor Record
U=User Updated/Created Record
|
| 19 |
BAS_CREDIT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Benefits Admin Credit
Y/N Table Edit
|
| 20 |
COMP_RATECD |
Character(6) |
VARCHAR2(6) NOT NULL |
Comp Rate Code
Prompt Table:
COMP_RT_REG_VW
|
| 21 |
COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Compensation Rate
|
| 22 |
COMPRATE_USED |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Comp Rate Used
|
| 23 |
HRS_DIST_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Hours Distribution
|
| 24 |
XREF_NUM |
Number(15,0) |
DECIMAL(15) NOT NULL |
T&L Xref Num
|
| 25 |
EX_DOC_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Expense Doc ID
|
| 26 |
EX_DOC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Expense Doc Type
|
| 27 |
EX_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Expense Line #
|
| 28 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 29 |
VC_PLAN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
VC Plan ID
|
| 30 |
VC_PAYOUT_PRD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Payout Period ID
|
| 31 |
GB_GROUP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Group Build ID.
|
| 32 |
APPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Job Applicant ID
|
| 33 |
AWARD_DATE |
Date(10) |
DATE |
Award Date
|
| 34 |
NOTIFY_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
eRecruit Status
N=Not Sent
R=Reversed
S=Sent to eRecruit
Default Value: N
|
| 35 |
EIM_KEY |
Character(20) |
VARCHAR2(20) NOT NULL |
SIM Sequence Number
|
| 36 |
PU_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Paysheet update source.
AM=Absence Management
ER=Recruiting Interface
EX=Expense Interface
IM=SIM Interface
OT=Other Sources
PL=Lifetime Balance Payout USF
RP=Rapid Paysheets
SP=Stock Admin - ESPP Refunds
ST=Stock Admin - Options & ESPP
VC=Variable Compensation
VF=Bonus from Fusion
WI=What-If
|
| 37 |
RETROPAY_SEQ_NO |
Character(15) |
VARCHAR2(15) NOT NULL |
Retro Pay Sequence Number
|