ST_GRNT_VAL_DTL

(SQL Table)
Index Back

Grant Valuation Detail

Stores the Grant Valuation Detail that is calculated by the ST_VALUE AE process for 'Multiple' Valuation Methods.

  • Parent record: ST_GRANT_VALUE
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Company's Stock Identification Symbol
    3 GRANT_NBR Character(10) VARCHAR2(10) NOT NULL System assigned grant number used to uniquely identify the grant record.
    4 ST_VALUE_EFFDT Date(10) DATE Value effective date.
    5 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    6 ST_VALUATION_DT Date(10) DATE Valuation Date
    7 ST_VALUE_PER_SHARE Number(16,6) DECIMAL(15,6) NOT NULL Value Per Share
    8 SHARES_VALUED Number(19,6) DECIMAL(18,6) NOT NULL Shares Valued
    9 ST_EXPECTED_LIFE Number(10,6) DECIMAL(9,6) NOT NULL Expected Life Years a Stock Option or Offering Period has from grant to exercise/purchase date.
    10 ST_VOLATILITY Number(8,6) DECIMAL(7,6) NOT NULL Volatility
    11 ST_INTEREST_RATE Number(9,6) DECIMAL(8,6) NOT NULL Risk-Free Interest Rate
    12 ST_DIVIDEND_RATE Number(9,6) DECIMAL(8,6) NOT NULL Expected Dividend Rate