ST_CONTRIB_PART

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	STOCK_ID	Character(10)	VARCHAR2(10) NOT NULL	Company's Stock Identification Symbol
4	STOCK_PLAN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Type of Stock Plan E=Purchase Plan O=Option Plan
5	STOCK_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Stock Plan
6	OFFERING_ID	Character(10)	VARCHAR2(10) NOT NULL	Offering ID
7	PERIOD_END_DT	Date(10)	DATE	Period End Date
8	PROCESS_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Process Group
9	ESPP_CONTRIB_SRC	Character(4)	VARCHAR2(4) NOT NULL	Contribution Source CF=Carry-Forward Contribution D=Data Entered GP=Global Payroll I=Import MA=Manual Contributions NAP=North American Payroll OFF=Offset Contribution Balance PI=Payroll Interface Contribution REF=Stock Purchase Refund
10	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
11	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
12	ESPP_CONTRIB_DT	Date(10)	DATE	Gather Contributions Date
13	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
14	ESPP_CONTRIB_AMT	Signed Number(17,6)	DECIMAL(15,6) NOT NULL	Contribution Amount
15	FROM_CUR	Character(3)	VARCHAR2(3) NOT NULL	From Currency Code
16	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
17	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
18	EXCHANGE_DT	Date(10)	DATE	Exchange Date
19	ESPP_STOCK_CONTRIB	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	ESPP Stock Contribution Amount
20	TO_CUR	Character(3)	VARCHAR2(3) NOT NULL	To Currency Code
21	ESPP_CONTRIB_STS	Character(1)	VARCHAR2(1) NOT NULL	Contribution Status N=New Contribution P=Processed Contribution R=Refunded V=Reversed Default Value: N
22	STATUS_DT	Date(10)	DATE	Status Date