EXT_ORG_IDPrompt Table: EXT_ORG_TBL
AMEX=AMEX
NASD=NASDAQ
NYSE=NYSE
Prompt Table: US_SIC_TBL
AV_EXT_ORG_DTL(SQL Table) |
Index Back |
|---|---|
Advancement External orgThis table is a one to one relationship with the external organization table to add a few fields that advancement wanted but was not desired for the other applications |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table: EXT_ORG_TBL |
| 2 | EMP_CNT | Number(9,0) | DECIMAL(9) NOT NULL | Employee Count |
| 3 | STCK_EXCHG | Character(4) | VARCHAR2(4) NOT NULL |
Stock Exchange
AMEX=AMEX NASD=NASDAQ NYSE=NYSE |
| 4 | STCK_EXCHG_SMBL | Character(10) | VARCHAR2(10) NOT NULL | Stock Exchange Symbol |
| 5 | US_SIC_CD | Character(4) | VARCHAR2(4) NOT NULL |
US Standard Industrial Classif
Prompt Table: US_SIC_TBL |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |