TRX_EQUITY_VW

(SQL View)
 Index Back

Equity Definition

Parent table that holds all the equity definition information

SELECT EQUITY_SYMBOL , EQUITY_ID , DESCR50_MIXED , DESCR150_MIXED , EXCHG_CD , TR_SECURITY_TYPE , SECURITY_ID , IND_CLASS_CODE , EQUITY_TYPE , EQUITY_CLASS , CALC_BUYPRICE , CALC_FRACSHARES FROM PS_TRX_EQTY_DEFN A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_TRX_EQTY_DEFN B WHERE B.EQUITY_ID = A.EQUITY_ID AND B.EFF_STATUS = 'A' AND B.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS='A'

  • Related Language Record: TRX_EQUITY_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EQUITY_SYMBOL Character(15) VARCHAR2(15) NOT NULL Ticker symbol to identify an equity on the exchange that it is traded on
    2 EQUITY_ID Character(10) VARCHAR2(10) NOT NULL Equity Identification Number - used to identify an equity in the system. the number is system generated and used for technical purposes only.

    Default Value: NEXT

    Prompt Table: TRX_EQTY_DEFN

    3 DESCR50_MIXED Character(50) VARCHAR2(50) NOT NULL Description 50 characters, mixed case
    4 DESCR150_MIXED Character(150) VARCHAR2(150) NOT NULL Description
    5 EXCHG_CD Character(6) VARCHAR2(6) NOT NULL Trading exchange code

    Prompt Table: TRX_EXCHANGE_CD

    6 TR_SECURITY_TYPE Character(2) VARCHAR2(2) NOT NULL Security type - defines the agency that issued the security. CUSIP, ISIN, ISID, etc are examples of Security type.
    01=CUSIP
    02=CINS
    03=EPIC
    04=ISID
    05=ISIN
    06=QUICK
    07=RIC
    08=SEDOL
    09=SICOVAM
    10=Valoren

    Default Value: 01

    7 SECURITY_ID Character(10) VARCHAR2(10) NOT NULL A reference identifier for a given deal transaction.
    8 IND_CLASS_CODE Character(10) VARCHAR2(10) NOT NULL Class code assinged to the equity based on its industry classification.
    9 EQUITY_TYPE Character(2) VARCHAR2(2) NOT NULL Equity Type - Common or Preferred
    01=Common Shares
    02=Preferred Shares

    Default Value: 01

    10 EQUITY_CLASS Character(2) VARCHAR2(2) NOT NULL Preferred Shares have class category . Different Equity Classes - A, B, C, D, and Other
    A=Class A
    B=Class B
    C=Class C
    D=Class D
    O=Other Class
    11 CALC_BUYPRICE Character(2) VARCHAR2(2) NOT NULL Calculation method used to determine the Purchase Price for the equity. Average method and specific method are the two supported methods
    01=Average Price
    02=Specific Price

    Default Value: 01

    12 CALC_FRACSHARES Character(2) VARCHAR2(2) NOT NULL Method to determine the distribution of fractional shares as a result of a split, dividend or merger.
    01=Cash
    02=Round Up
    03=Round Down
    04=Fractional Shares
    05=Credit

    Default Value: 01