PAY_EIM_ISS_PUB

#	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 Rcd Nbr
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
17	AUDIT_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted. A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values
18	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance