ST_CONTRIB_MANL

(SQL Table)
Index Back

Manual Contributions

This table stores Stock Purchase Plan Manual Contributions either by import or online data entry.

  • Parent record: ST_PURCH_PARTIC
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Company's Stock Identification Symbol

    Prompt Table: STOCK_TBL

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

    Default Value: E

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

    Prompt Table: STOCK_PLAN_TBL

    6 OFFERING_ID Character(10) VARCHAR2(10) NOT NULL Offering ID

    Prompt Table: ST_OFFERING_PD

    7 PERIOD_END_DT Date(10) DATE NOT NULL Period End Date

    Prompt Table: ST_PURCHASE_PD

    8 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    9 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

    Prompt Table: PAYGROUP_TBL

    10 ESPP_CONTRIB_DT Date(10) DATE NOT NULL Gather Contributions Date

    Default Value: %Date

    11 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    12 ESPP_CONTRIB_AMT Signed Number(17,6) DECIMAL(15,6) NOT NULL Contribution Amount
    13 FROM_CUR Character(3) VARCHAR2(3) NOT NULL From Currency Code

    Prompt Table: CURRENCY_CD_TBL

    14 ESPP_CONTRIB_STS Character(1) VARCHAR2(1) NOT NULL Contribution Status
    N=New Contribution
    P=Processed Contribution
    R=Refunded
    V=Reversed

    Default Value: N

    15 ESPP_REFUND_STS Character(1) VARCHAR2(1) NOT NULL Refund Status
    P=Processed
    R=Refunded
    U=UnProcessed
    V=Reversed

    Default Value: N

    16 ESPP_MANUAL_SOURCE Character(1) VARCHAR2(1) NOT NULL Manual Source
    C=ESPP - Carry Forward
    D=Data Entry
    I=Import
    R=ESPP - Refund
    17 STATUS_DT Date(10) DATE Status Date

    Default Value: %Date

    18 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    19 LAST_UPDT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Updated User Name
    20 LAST_UPDT_DTTM DateTime(26) TIMESTAMP Last Updated Date-Time Stamp
    21 ST_IMPORT_NBR Number(3,0) SMALLINT NOT NULL Import Number
    22 ST_IMPORT_DT Date(10) DATE Import Date