ST_BROKER_VW(SQL View) |
Index Back |
---|---|
Stock Branch Prompt View |
SELECT DISTINCT STOCK_ID , ST_BROKERAGE_ID FROM PS_STOCK_BRANCH |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | STOCK_ID | Character(10) | VARCHAR2(10) NOT NULL | Company's Stock Identification Symbol |
2 | ST_BROKERAGE_ID | Character(10) | VARCHAR2(10) NOT NULL | Brokerage ID |