ST_OPTN_TAO1(SQL Table) |
Index Back |
|---|---|
Stock Balance Temp - PlansThis record is a temporary record to store Stock Option Plan details used during Stock Balance processing. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 2 | CANCEL_SHARES_MTHD | Character(1) | VARCHAR2(1) NOT NULL |
Cancelled Shares Method
P=Return Shares to Plan T=Retire Shares to Treasury |
| 3 | EXPIRED_SHARE_MTHD | Character(1) | VARCHAR2(1) NOT NULL |
Expired Shares Method
P=Return Shares to Plan T=Retire Shares to Treasury |
| 4 | SAR_EXERCISE_MTHD | Character(1) | VARCHAR2(1) NOT NULL |
SAR Exercises Method
P=Return Shares to Plan T=Retire Shares to Treasury |
| 5 | SWAP_SHARES_MTHD | Character(1) | VARCHAR2(1) NOT NULL |
Swap/Trade Shares Method
P=Return Shares to Plan T=Retire Shares to Treasury |
| 6 | REPURCH_SHARE_MTHD | Character(1) | VARCHAR2(1) NOT NULL |
Repurchased Shares
P=Return Shares to Plan T=Retire Shares to Treasury |
| 7 | ST_TREASURY_ID | Character(10) | VARCHAR2(10) NOT NULL | Treasury ID |