ST_REFUND_ESPP

#	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 Prompt Table: STOCK_TBL
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 Prompt Table: STOCK_PLAN_TBL
6	OFFERING_ID	Character(10)	VARCHAR2(10) NOT NULL	Offering ID Prompt Table: ST_OFFERING_PD
7	PERIOD_END_DT	Date(10)	DATE	Period End Date Prompt Table: ST_PURCHASE_PD
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	ST_PR_DT	Date(10)	DATE	This field is the date that a transaction was sent to payroll.
13	REVERSAL_DT	Date(10)	DATE	Reversal Date
14	ESPP_REFUND_STS	Character(1)	VARCHAR2(1) NOT NULL	Refund Status P=Processed R=Refunded U=UnProcessed V=Reversed
15	ESPP_RESIDUAL_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Residual Amount
16	TO_CUR	Character(3)	VARCHAR2(3) NOT NULL	To Currency Code
17	ST_SEND_SRC	Character(1)	VARCHAR2(1) NOT NULL	This field is for audit purposes and will determine how the tax information was delivered to Payroll: either via the interface with Paysheets or via a manual report. N=North American Payroll R=Stock Payroll Report
18	ST_REFUND_SRC	Character(1)	VARCHAR2(1) NOT NULL	Refund Source C=Contribution Refund P=Stock Purchase