ST_VALUE_TAO

(SQL Table)
Index Back

Grant Valuation Temp Table 1

This temporary table is used in the Grant Valuation AE process.

  • Parent record: ST_RUNCTL_VALUE
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: ST_GROUP_VW4

    2 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Stock ID

    Default Value: ST_RUNCTL_VALUE.STOCK_ID

    3 GRANT_NBR Character(10) VARCHAR2(10) NOT NULL System assigned grant number used to uniquely identify the grant record.

    Prompt Table: ST_GROUP_VW5

    4 ST_OPTION_TYPE Character(4) VARCHAR2(4) NOT NULL Option Type
    ISAR=ISO-Stock Appreciation Right
    ISO=Incentive Stock Option
    NQ=Non-Qualified
    NSAR=NQ-Stock Appreciation Right
    RSA=Restricted Stock Award