EQUITY_IDDefault Value: NEXT
Prompt Table: TRX_EQTY_DEFN
EFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
Prompt Table: TRX_EQTY_SYM_VW
TRX_EQTY_VW(SQL View) |
Index Back |
|---|---|
Equity DefinitionParent table that holds all the equity definition information |
| SELECT A.EQUITY_ID ,A.EFFDT ,A.EFF_STATUS ,B.EQUITY_SYMBOL ,A.DESCR50_MIXED ,A.DESCR150_MIXED ,A.EXCHG_CD FROM PS_TRX_EQTY_DEFN A , PS_TRX_EQTY_SYM_VW B WHERE A.EQUITY_SYMBOL=B.EQUITY_SYMBOL AND A.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_TRX_EQTY_DEFN D WHERE A.EQUITY_ID=D.EQUITY_ID AND D.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS='A' |
| # | 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
Prompt Table: TRX_EQTY_SYM_VW |
| 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 |