ST_SPLIT10B_TAO (SQL Table)	Index Back
Split ESPP DispositionTemp ST_SPLIT10_TAO is a temporary table to hold disposition data for stock splits.

ST_SPLIT10B_TAO

(SQL Table)

Split ESPP DispositionTemp

ST_SPLIT10_TAO is a temporary table to hold disposition data for stock splits.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 STOCK_PLAN_TYPE Character(1) VARCHAR2(1) NOT NULL Stock Plan Type
E=Purchase Plan
O=Option Plan

3 STOCK_PLAN Character(10) VARCHAR2(10) NOT NULL Stock Plan

4 OFFERING_ID Character(10) VARCHAR2(10) NOT NULL Offering ID

5 PERIOD_END_DT Date(10) DATE Period End Date

6 GRANT_DT Date(10) DATE Grant Date

7 DISPOSITION_NBR Number(8,0) INTEGER NOT NULL System assigned disposition number used to uniquely identify the disposition record.

8 SHARES_UNROUNDED Signed Number(23,9) DECIMAL(21,9) NOT NULL SHARES_UNROUNDED contains the full calculated vesting value based on the vesting percent and the vesting period count.

9 SHARES_REMAINDER Signed Number(23,9) DECIMAL(21,9) NOT NULL SHARES_REMAINDER field stores the number of shares that is part of the remainder for uneven share processing.

10 SHARES_ROUNDED Signed Number(20,6) DECIMAL(18,6) NOT NULL Shares Rounded

11 DISPOSITION_STATUS Character(1) VARCHAR2(1) NOT NULL Staus of disposition - active, pending for survey, void
C=Confirmed
P=Pending
V=Void

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	STOCK_PLAN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Stock Plan Type E=Purchase Plan O=Option Plan
3	STOCK_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Stock Plan
4	OFFERING_ID	Character(10)	VARCHAR2(10) NOT NULL	Offering ID
5	PERIOD_END_DT	Date(10)	DATE	Period End Date
6	GRANT_DT	Date(10)	DATE	Grant Date
7	DISPOSITION_NBR	Number(8,0)	INTEGER NOT NULL	System assigned disposition number used to uniquely identify the disposition record.
8	SHARES_UNROUNDED	Signed Number(23,9)	DECIMAL(21,9) NOT NULL	SHARES_UNROUNDED contains the full calculated vesting value based on the vesting percent and the vesting period count.
9	SHARES_REMAINDER	Signed Number(23,9)	DECIMAL(21,9) NOT NULL	SHARES_REMAINDER field stores the number of shares that is part of the remainder for uneven share processing.
10	SHARES_ROUNDED	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Shares Rounded
11	DISPOSITION_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Staus of disposition - active, pending for survey, void C=Confirmed P=Pending V=Void