ST_VALUE_TBL

(SQL Table)
 Index Back

Valuation Table

The 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.

  • Parent record: STOCK_TBL

    • # 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 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