ST_TRSRALC_LANG (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_TRSRALC_LANG

(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 for ST_TRSR_ALLOC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Stock ID
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
Default Value: %date

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

5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

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

7 COMMENTS Long Character CLOB Comment

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	STOCK_ID	Character(10)	VARCHAR2(10) NOT NULL	Stock ID 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 Default Value: %date
4	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
5	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	COMMENTS	Long Character	CLOB	Comment