ST_VC_ALLOC

(SQL Table)
 Index Back

Stock/Var Comp Allocation

ST_VC_ALLOC is a table that captures funding/allocation of stock units between Stock Administration and Variable Compensation

  • Parent record: STOCK_PLAN_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Stock ID

    Default Value: STOCK_PLAN_TBL.STOCK_ID

    Prompt Table: STOCK_TBL

    2 STOCK_PLAN_TYPE Character(1) VARCHAR2(1) NOT NULL Stock Plan Type
    E=Purchase Plan
    O=Option Plan

    Default Value: STOCK_PLAN_TBL.STOCK_PLAN_TYPE

    3 STOCK_PLAN Character(10) VARCHAR2(10) NOT NULL Stock Plan

    Default Value: STOCK_PLAN_TBL.STOCK_PLAN

    4 ALLOCATION_DT Date(10) DATE NOT NULL Allocation Date

    Default Value: %date

    5 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    6 SHARES_ALLOCATED Signed Number(20,6) DECIMAL(18,6) NOT NULL Shares Allocated
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 APPRVL_DT Date(10) DATE Approval Date

    Default Value: %date

    9 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.
    10 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.
    11 COMMENTS Long Character CLOB Comment