STOCK_IDPrompt Table: STOCK_TBL
ST_VALUATION_IDDefault Value: ST_VALUE_TBL.ST_VALUE_DESCR
M=Multiple Method
S=Single Method
Default Value: S
Prompt Table: ST_ESTIMATE_TBL
H=High
L=Low
M=Mean
Default Value: H
ST_VALUE_TBL(SQL Table) |
Index Back |
|---|---|
Valuation TableThe Valuation Table is a static record that defines a valuation for use in the FAS 123 valuation process. The FAS 123 valuation process calculates valuations for both stock option grant and stock purchase offerings. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STOCK_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Company's Stock Identification Symbol
Prompt Table: STOCK_TBL |
| 2 | ST_VALUATION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Valuation ID |
| 3 | ST_VALUE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | ST_VALUE_DESCR10 | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: ST_VALUE_TBL.ST_VALUE_DESCR |
| 5 | ST_VALUE_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Valuation Method
M=Multiple Method S=Single Method Default Value: S |
| 6 | ST_ESTIMATE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Estimate ID
Prompt Table: ST_ESTIMATE_TBL |
| 7 | ST_VOLATILITY_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Volatility Type
H=High L=Low M=Mean Default Value: H |
| 8 | COMMENTS | Long Character | CLOB | Comment |