ST_TRSR_ALLOC (SQL Table)	Index Back
Stock Treasury Allocation The Stock Treasury Allocation record defines a stock treasury's initial allocation of shares to the treasury pool. These allocation levels can also be continually increased or decreased based on changes in allocations via board approval, shareholder approval, stock splits, or adjustments. The Stock Treasury Allocation record is a child record of STOCK_TREASURY.

ST_TRSR_ALLOC

(SQL Table)

Stock Treasury Allocation

The Stock Treasury Allocation record defines a stock treasury's initial allocation of shares to the treasury pool. These allocation levels can also be continually increased or decreased based on changes in allocations via board approval, shareholder approval, stock splits, or adjustments. The Stock Treasury Allocation record is a child record of STOCK_TREASURY.

Related Language Record: ST_TRSRALC_LANG

Parent record: STOCK_TREASURY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Company's Stock Identification Symbol
Default Value: STOCK_TREASURY.STOCK_ID

2 ST_TREASURY_ID Character(10) VARCHAR2(10) NOT NULL Treasury ID
Default Value: STOCK_TREASURY.ST_TREASURY_ID

3 ALLOCATION_DT Date(10) DATE NOT NULL Allocation Date

4 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

5 ST_ALLOCATION_TYPE Character(1) VARCHAR2(1) NOT NULL Allocation Type
A=Adjustment
B=Board Approved
H=Shareholder Approved
I=Initial Allocation
S=Stock Split

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

7 APPRVL_DT Date(10) DATE Approval Date

8 SHARES_ALLOCATED Signed Number(20,6) DECIMAL(18,6) NOT NULL Shares Allocated

9 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

10 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

11 COMMENTS Long Character CLOB Comment

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	STOCK_ID	Character(10)	VARCHAR2(10) NOT NULL	Company's Stock Identification Symbol Default Value: STOCK_TREASURY.STOCK_ID
2	ST_TREASURY_ID	Character(10)	VARCHAR2(10) NOT NULL	Treasury ID Default Value: STOCK_TREASURY.ST_TREASURY_ID
3	ALLOCATION_DT	Date(10)	DATE NOT NULL	Allocation Date
4	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
5	ST_ALLOCATION_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Allocation Type A=Adjustment B=Board Approved H=Shareholder Approved I=Initial Allocation S=Stock Split
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	APPRVL_DT	Date(10)	DATE	Approval Date
8	SHARES_ALLOCATED	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Shares Allocated
9	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
10	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
11	COMMENTS	Long Character	CLOB	Comment