ST_SPLIT_TBL (SQL Table)	Index Back
Stock Split The Stock Split record defines business rules and tracks the processing status for a corresponding stock split. A stock split automatically adjusts the number of shares and the option price for each option in the system as of the split date; all ESPP activity is also adjusted during a stock split. The Stock Split record is a child record of STOCK_TBL.

ST_SPLIT_TBL

(SQL Table)

Stock Split

The Stock Split record defines business rules and tracks the processing status for a corresponding stock split. A stock split automatically adjusts the number of shares and the option price for each option in the system as of the split date; all ESPP activity is also adjusted during a stock split. The Stock Split record is a child record of STOCK_TBL.

Related Language Record: ST_SPLIT_LANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Company's Stock Identification Symbol
Prompt Table: STOCK_TBL

2 ST_SPLIT_ID Character(10) VARCHAR2(10) NOT NULL Split ID

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
Default Value: ST_SPLIT_TBL.DESCR

5 RECORD_DT Date(10) DATE NOT NULL Record Date
Default Value: %date

6 PAYABLE_DT Date(10) DATE Payable Date
Default Value: %date

7 ST_SPLIT_SHARE_NEW Number(3,0) SMALLINT NOT NULL Stock Split New Shares
Default Value: 2

8 ST_SPLIT_SHARE_OLD Number(3,0) SMALLINT NOT NULL Stock Split Old Shares
Default Value: 1

9 ST_ROUNDING_RULE Character(1) VARCHAR2(1) NOT NULL Used to determine how the shares will be rounded to the maximum decimal point.
D=Round Down
S=Standard Rounding
U=Round Up

10 ST_ROUNDING_RULE2 Character(1) VARCHAR2(1) NOT NULL Used to determine how thestock prices will be rounded to the maximum decimal point.
D=Round Down
S=Standard Rounding
U=Round Up

11 DEC_PLACES Number(3,0) SMALLINT NOT NULL Number of Decimal Places

12 DEC_PLACES2 Number(3,0) SMALLINT NOT NULL Number of Decimal Places

13 ST_SPLIT_STATUS Character(1) VARCHAR2(1) NOT NULL Stock Split Status
P=Processed
U=Unprocessed
Default Value: U

14 STATUS_DT Date(10) DATE Status Date
Default Value: %Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	STOCK_ID	Character(10)	VARCHAR2(10) NOT NULL	Company's Stock Identification Symbol Prompt Table: STOCK_TBL
2	ST_SPLIT_ID	Character(10)	VARCHAR2(10) NOT NULL	Split ID
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description Default Value: ST_SPLIT_TBL.DESCR
5	RECORD_DT	Date(10)	DATE NOT NULL	Record Date Default Value: %date
6	PAYABLE_DT	Date(10)	DATE	Payable Date Default Value: %date
7	ST_SPLIT_SHARE_NEW	Number(3,0)	SMALLINT NOT NULL	Stock Split New Shares Default Value: 2
8	ST_SPLIT_SHARE_OLD	Number(3,0)	SMALLINT NOT NULL	Stock Split Old Shares Default Value: 1
9	ST_ROUNDING_RULE	Character(1)	VARCHAR2(1) NOT NULL	Used to determine how the shares will be rounded to the maximum decimal point. D=Round Down S=Standard Rounding U=Round Up
10	ST_ROUNDING_RULE2	Character(1)	VARCHAR2(1) NOT NULL	Used to determine how thestock prices will be rounded to the maximum decimal point. D=Round Down S=Standard Rounding U=Round Up
11	DEC_PLACES	Number(3,0)	SMALLINT NOT NULL	Number of Decimal Places
12	DEC_PLACES2	Number(3,0)	SMALLINT NOT NULL	Number of Decimal Places
13	ST_SPLIT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Stock Split Status P=Processed U=Unprocessed Default Value: U
14	STATUS_DT	Date(10)	DATE	Status Date Default Value: %Date