ST_PURCHASE_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PURCHASE_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase ID
2	STOCK_ID	Character(10)	VARCHAR2(10) NOT NULL	Company's Stock Identification Symbol Prompt Table: STOCK_TBL
3	STOCK_PLAN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Type of Stock Plan E=Purchase Plan O=Option Plan Default Value: E
4	STOCK_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Stock Plan Prompt Table: STOCK_PLAN_TBL
5	OFFERING_ID	Character(10)	VARCHAR2(10) NOT NULL	Offering ID Prompt Table: ST_OFFERING_PD
6	PERIOD_END_DT	Date(10)	DATE NOT NULL	Period End Date Prompt Table: ST_PURCHASE_PD
7	PURCHASE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Purchase Type A=Anti-Dilution Purchase S=Standard Purchase Default Value: S
8	PRORATE_FACTOR	Number(8,3)	DECIMAL(7,3) NOT NULL	Prorate Factor Default Value: 100
9	ESPP_DATE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Date Type C=Check Date P=Pay Period End Date Default Value: C
10	ESPP_PARTIC_RUN	Character(1)	VARCHAR2(1) NOT NULL	Update Participants Y/N Table Edit Default Value: N
11	ESPP_PARTIC_DTTM	DateTime(26)	TIMESTAMP	Update Participants Last Run
12	ESPP_PRICE_RUN	Character(1)	VARCHAR2(1) NOT NULL	Calculate Prices Y/N Table Edit Default Value: N
13	ESPP_PRICE_DTTM	DateTime(26)	TIMESTAMP	Calculate Prices Last Run
14	CONFIRMED	Character(1)	VARCHAR2(1) NOT NULL	Confirmed Y/N Table Edit Default Value: N
15	COMMENTS	Long Character	CLOB	Comment