EQUITY_IDPrompt Table: TRX_EQTY_DEFN
EFFDTDefault Value: %date
LANGUAGE_CDPrompt Table: TRX_EQTY_DEFN
TRX_EQTY_LG(SQL Table) |
Index Back |
|---|---|
Equity DefinitionRelated language record for TRX_EQUITY_DEFN which is the parent table that holds all the equity definition information |
| # | 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.
Prompt Table: TRX_EQTY_DEFN |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 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_DEFN |
| 5 | DESCR50_MIXED | Character(50) | VARCHAR2(50) NOT NULL | Description 50 characters, mixed case |
| 6 | DESCR150_MIXED | Character(150) | VARCHAR2(150) NOT NULL | Description |