ST_AE_CLASS_BAL

(SQL Table)
Index Back

Stock Balance - AE Process Rcd

The AE process record for Stock Balances.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Stock ID

Prompt Table: STOCK_TBL

2 STOCK_CLASS_TYPE Character(1) VARCHAR2(1) NOT NULL Stock Class Type
C=Common Shares
P=Preferred Shares
W=Warrants
3 STOCK_CLASS Character(10) VARCHAR2(10) NOT NULL Stock Class ID
4 AS_OF_DATE Date(10) DATE As of Date
5 SHARES_OUTSTANDING Signed Number(20,6) DECIMAL(18,6) NOT NULL Shares Outstanding
6 SHARES_ALLOC_CLASS Signed Number(20,6) DECIMAL(18,6) NOT NULL Class Shares Allocated
7 SHARES_EXERCISED Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of shares exercised.
8 SHARES_PURCHASED Signed Number(20,6) DECIMAL(18,6) NOT NULL Shares Purchased
9 SHARES_REPURCHASED Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of shares repurchased.
10 SHARES_SWAPPED Number(19,6) DECIMAL(18,6) NOT NULL Total number of shares swapped.
11 SHARES_EXER_SWAP Signed Number(20,6) DECIMAL(18,6) NOT NULL Exercised Shares Swapped
12 SHARES_REL_SWAP Signed Number(20,6) DECIMAL(18,6) NOT NULL Released Shares Swapped
13 SHARES_EXER_SAR Signed Number(20,6) DECIMAL(18,6) NOT NULL Exercised SAR Shares