ST_PLAN_ALLOC

(SQL Table)
 Index Back

Stock Plan Allocation

The Stock Plan Allocation record contains a history of shares that have been allocated to stock plans. The Stock Plan Allocation record is an effective dated child record of STOCK_PLAN_TBL.

  • Related Language Record: ST_PLANALC_LANG

  • Parent record: STOCK_PLAN_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Company's Stock Identification Symbol

    Default Value: STOCK_PLAN_TBL.STOCK_ID

    Prompt Table: STOCK_TBL

    2 STOCK_PLAN_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Stock Plan
    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 ST_TREASURY_ID Character(10) VARCHAR2(10) NOT NULL Treasury ID

    Prompt Table: STOCK_TREASURY

    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 APPRVL_DT Date(10) DATE Approval Date

    Default Value: %date

    9 ST_ALLOCATION_TYPE Character(1) VARCHAR2(1) NOT NULL Allocation Type
    A=Adjustment
    B=Board Approved
    H=Shareholder Approved
    I=Initial Allocation
    S=Stock Split
    10 SHARES_ALLOCATED Signed Number(20,6) DECIMAL(18,6) NOT NULL Shares Allocated
    11 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.
    12 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.
    13 COMMENTS Long Character CLOB Comment