ST_CONTRIB_MANL

#	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 Prompt Table: STOCK_TBL
4	STOCK_PLAN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Type of Stock Plan E=Purchase Plan O=Option Plan Default Value: E
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 NOT NULL	Period End Date Prompt Table: ST_PURCHASE_PD
8	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
9	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group Prompt Table: PAYGROUP_TBL
10	ESPP_CONTRIB_DT	Date(10)	DATE NOT NULL	Gather Contributions Date Default Value: %Date
11	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
12	ESPP_CONTRIB_AMT	Signed Number(17,6)	DECIMAL(15,6) NOT NULL	Contribution Amount
13	FROM_CUR	Character(3)	VARCHAR2(3) NOT NULL	From Currency Code Prompt Table: CURRENCY_CD_TBL
14	ESPP_CONTRIB_STS	Character(1)	VARCHAR2(1) NOT NULL	Contribution Status N=New Contribution P=Processed Contribution R=Refunded V=Reversed Default Value: N
15	ESPP_REFUND_STS	Character(1)	VARCHAR2(1) NOT NULL	Refund Status P=Processed R=Refunded U=UnProcessed V=Reversed Default Value: N
16	ESPP_MANUAL_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Manual Source C=ESPP - Carry Forward D=Data Entry I=Import R=ESPP - Refund
17	STATUS_DT	Date(10)	DATE	Status Date Default Value: %Date
18	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
19	LAST_UPDT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Updated User Name
20	LAST_UPDT_DTTM	DateTime(26)	TIMESTAMP	Last Updated Date-Time Stamp
21	ST_IMPORT_NBR	Number(3,0)	SMALLINT NOT NULL	Import Number
22	ST_IMPORT_DT	Date(10)	DATE	Import Date