TRX_EQTY_DEFN (SQL Table)	Index Back
Equity Definition Parent table that holds all the equity definition information

TRX_EQTY_DEFN

(SQL Table)

Equity Definition

Parent table that holds all the equity definition information

Related Language Record: TRX_EQTY_LG

Parent Record Of TRX_EQTY_DVDND TRX_EQTY_RIGHT TRX_EQTY_SPLIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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

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 EQUITY_SYMBOL Character(15) VARCHAR2(15) NOT NULL Ticker symbol to identify an equity on the exchange that it is traded on

5 DESCR50_MIXED Character(50) VARCHAR2(50) NOT NULL Description 50 characters, mixed case

6 DESCR150_MIXED Character(150) VARCHAR2(150) NOT NULL Description

7 EXCHG_CD Character(6) VARCHAR2(6) NOT NULL Trading exchange code
Prompt Table: TRX_EXCHANGE_CD

8 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

9 SECURITY_ID Character(10) VARCHAR2(10) NOT NULL A reference identifier for a given deal transaction.

10 IND_CLASS_CODE Character(10) VARCHAR2(10) NOT NULL Class code assinged to the equity based on its industry classification.

11 EQUITY_TYPE Character(2) VARCHAR2(2) NOT NULL Equity Type - Common or Preferred
01=Common Shares
02=Preferred Shares
Default Value: 01

12 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

13 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

14 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

15 EVENT_TRACKING_ID Number(10,0) DECIMAL(10) NOT NULL The event tracking ID is used in order to correlate objects with an event. Each object (i.e. Payment) will store the tracking ID with a given payment. That way the system can obtain all the events for a given payment via the tracking ID.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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
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	EQUITY_SYMBOL	Character(15)	VARCHAR2(15) NOT NULL	Ticker symbol to identify an equity on the exchange that it is traded on
5	DESCR50_MIXED	Character(50)	VARCHAR2(50) NOT NULL	Description 50 characters, mixed case
6	DESCR150_MIXED	Character(150)	VARCHAR2(150) NOT NULL	Description
7	EXCHG_CD	Character(6)	VARCHAR2(6) NOT NULL	Trading exchange code Prompt Table: TRX_EXCHANGE_CD
8	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
9	SECURITY_ID	Character(10)	VARCHAR2(10) NOT NULL	A reference identifier for a given deal transaction.
10	IND_CLASS_CODE	Character(10)	VARCHAR2(10) NOT NULL	Class code assinged to the equity based on its industry classification.
11	EQUITY_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Equity Type - Common or Preferred 01=Common Shares 02=Preferred Shares Default Value: 01
12	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
13	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
14	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
15	EVENT_TRACKING_ID	Number(10,0)	DECIMAL(10) NOT NULL	The event tracking ID is used in order to correlate objects with an event. Each object (i.e. Payment) will store the tracking ID with a given payment. That way the system can obtain all the events for a given payment via the tracking ID.