ST_CLASS_AET

(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 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Company's Stock Identification Symbol

Prompt Table: STOCK_TBL

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