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 Stock ID
    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 ST_VALUE_REASON Character(1) VARCHAR2(1) NOT NULL Valuation Reason
    I=Initial Valuation
    R=Reprice
    6 ST_VALUATION_ID Character(10) VARCHAR2(10) NOT NULL Valuation ID
    7 ST_VALUE_PER_SHARE Number(16,6) DECIMAL(15,6) NOT NULL Value Per Share
    8 GRANT_FMV Number(19,6) DECIMAL(18,6) NOT NULL Grant Fair Market Value
    9 GRANT_PRICE Number(19,6) DECIMAL(18,6) NOT NULL Price an employee pays to exercise the option.
    10 SHARES_VALUED Number(19,6) DECIMAL(18,6) NOT NULL Shares Valued
    11 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.
    12 ST_VOLATILITY Number(8,6) DECIMAL(7,6) NOT NULL Volatility
    13 ST_INTEREST_RATE Number(9,6) DECIMAL(8,6) NOT NULL Risk-Free Interest Rate
    14 ST_DIVIDEND_RATE Number(9,6) DECIMAL(8,6) NOT NULL Expected Dividend Rate
    15 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.
    16 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.
    17 COMMENTS Long Character CLOB Comment