ST_REFUND_DTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERS_SRCH_GBL
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	STOCK_ID	Character(10)	VARCHAR2(10) NOT NULL	Stock ID
4	STOCK_PLAN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Stock Plan Type 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	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
10	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
11	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
12	ESPP_REFUND_SRC	Character(1)	VARCHAR2(1) NOT NULL	Refund Source G=Gathered Contribution M=Manual Contribution R=Residual Contribution
13	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
14	ESPP_CONTRIB_DT	Date(10)	DATE	Gather Contributions Date
15	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
16	ESPP_CONTRIB_AMT	Signed Number(17,6)	DECIMAL(15,6) NOT NULL	Contribution Amount
17	FROM_CUR	Character(3)	VARCHAR2(3) NOT NULL	From Currency Code
18	ESPP_RESIDUAL_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Residual Amount
19	TO_CUR	Character(3)	VARCHAR2(3) NOT NULL	To Currency Code