ST_TRSR_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 ST_TREASURY_ID Character(10) VARCHAR2(10) NOT NULL Treasury ID
6 AS_OF_DATE Date(10) DATE As of Date
7 SHARES_ALLOC_PLAN Signed Number(20,6) DECIMAL(18,6) NOT NULL Plan Shares Allocated
8 SHARES_ALLOC_TRSR Signed Number(20,6) DECIMAL(18,6) NOT NULL Treasury Shares Allocated
9 SHARES_ALLOC_CLASS Signed Number(20,6) DECIMAL(18,6) NOT NULL Class Shares Allocated
10 SHARES_AVAIL_ISSUE Signed Number(20,6) DECIMAL(18,6) NOT NULL Shares Available to Issue
11 SHARES_CANCELLED Signed Number(20,6) DECIMAL(18,6) NOT NULL Shares Canceled
12 SHARES_EXPIRED Signed Number(20,6) DECIMAL(18,6) NOT NULL Shares Expired
13 SHARES_REPURCHASED Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of shares repurchased.
14 SHARES_SWAPPED Number(19,6) DECIMAL(18,6) NOT NULL Total number of shares swapped.
15 SHARES_EXER_SWAP Signed Number(20,6) DECIMAL(18,6) NOT NULL Exercised Shares Swapped
16 SHARES_REL_SWAP Signed Number(20,6) DECIMAL(18,6) NOT NULL Released Shares Swapped
17 SHARES_EXER_SAR Signed Number(20,6) DECIMAL(18,6) NOT NULL Exercised SAR Shares
18 SHARES_CANCEL_RPRC Signed Number(20,6) DECIMAL(18,6) NOT NULL Shares Canceled from Reprice
19 SHARES_EXPIRE_RPRC Signed Number(20,6) DECIMAL(18,6) NOT NULL Shares Expired from Reprice