STOCK_DTL

(SQL Table)
 Index Back

Stock Detail

STOCK_DTL is a record that defines the attributes of a stock id that can change over time. It is an effective dated child record of the STOCK_TBL.

  • Parent record: STOCK_TBL

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

    Prompt Table: STOCK_TBL

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 PUBLIC_PRIVATE Character(1) VARCHAR2(1) NOT NULL Public/Private
    P=Public
    V=Private

    Default Value: P

    5 ST_REGISTERED Character(1) VARCHAR2(1) NOT NULL SEC Registered

    Y/N Table Edit

    Default Value: Y

    6 ESCROW_AGENCY_ID Character(10) VARCHAR2(10) NOT NULL Escrow Agent ID

    Prompt Table: ST_AGENT_ESC_VW

    7 TRANSFER_AGENCY_ID Character(10) VARCHAR2(10) NOT NULL Transfer Agent ID

    Prompt Table: ST_AGENT_TRN_VW

    8 FMV_METHOD Character(10) VARCHAR2(10) NOT NULL FMV Method

    Prompt Table: ST_FMV_MTHD_TBL

    9 FMV_HOLIDAY_RULE Character(1) VARCHAR2(1) NOT NULL This field indicates what day is used to determine the Fair Market Value of transactions that occur on a holiday.
    N=Next Trading Day
    P=Previous Trading Day

    Default Value: P

    10 FMV_WEEKEND_RULE Character(1) VARCHAR2(1) NOT NULL This field indicates what day is used to determine the Fair Market Value of transactions that occur over a weekend.
    1=Both Previous Trading Day
    2=Both Next Trading Day
    3=Saturday Next-Sunday Previous
    4=Saturday Previous-Sunday Next

    Default Value: 1

    11 DEC_PLACES Number(3,0) SMALLINT NOT NULL Number of Decimal Places
    12 ST_ROUNDING_RULE Character(1) VARCHAR2(1) NOT NULL Used to determine how the shares will be rounded to the maximum decimal point.
    D=Round Down
    S=Standard Rounding
    U=Round Up

    Default Value: D

    13 DEC_PLACES2 Number(3,0) SMALLINT NOT NULL Number of Decimal Places
    14 ST_ROUNDING_RULE2 Character(1) VARCHAR2(1) NOT NULL Used to determine how thestock prices will be rounded to the maximum decimal point.
    D=Round Down
    S=Standard Rounding
    U=Round Up

    Default Value: D

    15 CAPTIVE_OPTIONS Character(1) VARCHAR2(1) NOT NULL Options Captive

    Y/N Table Edit

    Default Value: N

    16 CAPTIVE_ESPP Character(1) VARCHAR2(1) NOT NULL Stock Purchases Captive

    Y/N Table Edit

    Default Value: N

    17 GRANT_YEAR_RULE Character(1) VARCHAR2(1) NOT NULL Grant Year Rule
    C=Calendar Year
    F=Fiscal Year

    Default Value: C

    18 GRANT_LIMIT_RULE Character(1) VARCHAR2(1) NOT NULL Grant Limit Rule
    P=Plan Limit
    S=Stock Limit

    Default Value: S

    19 GRANT_SHARES_LIM Number(7,0) INTEGER NOT NULL This field indicates the maximum number of shares which may be granted to an individual during a defined period.
    20 AGREEMENT_ACCEPT Character(1) VARCHAR2(1) NOT NULL Prompt Option Agreement

    Y/N Table Edit

    Default Value: N

    21 ISO_LIM_VEST_RULE Character(1) VARCHAR2(1) NOT NULL ISO Limit Vesting Rule
    E=Even Distribution of ISO
    M=Maximum ISO limit each year

    Default Value: M

    22 ISO_LIM_REPRC_RULE Character(1) VARCHAR2(1) NOT NULL ISO Limit Repricing Rule
    A=First Exercisable All Years
    F=First Exercisable asof Reprice

    Default Value: F

    23 ERNCD_NQ_CALC_TAX Character(3) VARCHAR2(3) NOT NULL NQ/RSA Calculate Taxes Erncd

    Prompt Table: EARNINGS_TBL

    24 ERNCD_NQ_EXER_INC Character(3) VARCHAR2(3) NOT NULL NQ Exercise Ordinary Inc Erncd

    Prompt Table: EARNINGS_TBL

    25 ERNCD_NQ_REL_INC Character(3) VARCHAR2(3) NOT NULL NQ Release Ordinary Inc Erncd

    Prompt Table: EARNINGS_TBL

    26 ERNCD_ISO_DD_INC Character(3) VARCHAR2(3) NOT NULL ISO Disq Disp Ord Inc Erncd

    Prompt Table: EARNINGS_TBL

    27 ERNCD_RSA_EXER_INC Character(3) VARCHAR2(3) NOT NULL RSA Exercise Ord Inc Erncd

    Prompt Table: EARNINGS_TBL

    28 ERNCD_RSA_REL_INC Character(3) VARCHAR2(3) NOT NULL RSA Release Ordinary Inc Erncd

    Prompt Table: EARNINGS_TBL

    29 ERNCD_NET_TAX Character(3) VARCHAR2(3) NOT NULL Net Earnings Code

    Prompt Table: EARNINGS_TBL

    30 ERNCD_ESPP_DD_INC Character(3) VARCHAR2(3) NOT NULL ESPP Disq Disp Send Tax Erncd

    Prompt Table: EARNINGS_TBL

    31 ERNCD_ESPP_QD_INC Character(3) VARCHAR2(3) NOT NULL ESPP Qual Disp Tax Erncd

    Prompt Table: EARNINGS_TBL

    32 PURCHASE_VALUE_LIM Number(16,6) DECIMAL(15,6) NOT NULL Allows specification of an amount for Sec. 423(b) of the Internal Revenue code that no employee may be granted an option which permits his rights to purchase stock under all such plans of his employer corporation and its parent and subsidiary corporations to accrue at a rate which exceeds $25,000 of fair market value of such stock for each calendar year in which such option is outstanding.
    33 PURCHASE_LIM_RULE Character(1) VARCHAR2(1) NOT NULL FMV interpretation
    C=Calendar Year
    Y=Years Offering Outstanding

    Default Value: Y

    34 NAME_UPDATE_ALLOW Character(1) VARCHAR2(1) NOT NULL Name Update Allowed
    35 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL Contact Name
    36 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code
    37 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    38 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
    39 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
    40 ST_GOVERN_CD Character(4) VARCHAR2(4) NOT NULL Contains the code used to identify the organization / entity responsible for setting the rules which govern the stock plans.

    Prompt Table: ST_GOVERN_BODY