PAY_EIM_ISSUE

(SQL Table)
Index Back

Payment Issue Message

Message definition which contains payment issues published to Sales Incentive Management.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EIM_KEY Character(20) VARCHAR2(20) NOT NULL SIM Sequence Number
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
4 PAYOUT_SYSTEM_CD Character(10) VARCHAR2(10) NOT NULL Payment Code
5 EIM_MONETARY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL SIM Monetary Amount
6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
7 EARNS_BEGIN_DT Date(10) DATE Earnings Begin Date
8 EARNS_END_DT Date(10) DATE Earnings End Date
9 PAYOUT_DT Date(10) DATE Payout Date
10 PAYMENT_SYSTEM Character(8) VARCHAR2(8) NOT NULL Payment System
11 SEPCHK_FLAG Character(1) VARCHAR2(1) NOT NULL Separate check flag.
12 GROSSUP Character(1) VARCHAR2(1) NOT NULL Gross-Up
13 CHECK_DT Date(10) DATE Check date.
14 PAYCHECK_NBR Number(15,0) DECIMAL(15) NOT NULL Paycheck number.
15 PAYCHECK_STATUS Character(1) VARCHAR2(1) NOT NULL Paycheck status.
A=Adjusted
C=Calculated
F=Confirmed
R=Reversed
V=Reversing Check
16 PAYCHECK_REPRINT Character(1) VARCHAR2(1) NOT NULL Paycheck Reprint