ST_GRANT_VALUE

(SQL Table)
Index Back

Grant Valuation Table

Stores the Grant Valuation information that is calculated by the ST_VALUE AE process.

  • Parent record: ST_GRANT
  • # 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 NOT NULL Value effective date.
    5 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    6 ST_VALUE_REASON Character(1) VARCHAR2(1) NOT NULL Valuation Reason
    I=Initial Valuation
    M=ReValuation
    R=Reprice
    7 ST_VALUATION_ID Character(10) VARCHAR2(10) NOT NULL Valuation ID
    8 ST_VALUE_PER_SHARE Number(16,6) DECIMAL(15,6) NOT NULL Value Per Share
    9 GRANT_FMV Number(19,6) DECIMAL(18,6) NOT NULL Grant Fair Market Value
    10 GRANT_PRICE Number(19,6) DECIMAL(18,6) NOT NULL Price an employee pays to exercise the option.
    11 SHARES_VALUED Number(19,6) DECIMAL(18,6) NOT NULL Shares Valued
    12 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.
    13 ST_VOLATILITY Number(8,6) DECIMAL(7,6) NOT NULL Volatility
    14 ST_INTEREST_RATE Number(9,6) DECIMAL(8,6) NOT NULL Risk-Free Interest Rate
    15 ST_DIVIDEND_RATE Number(9,6) DECIMAL(8,6) NOT NULL Expected Dividend Rate
    16 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    17 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    18 COMMENTS Long Character CLOB