STOCK_IDPrompt Table: STOCK_TBL
ST_BROKERAGE_IDST_BRANCH_IDST_BRNC_ADMN_VW(SQL View) |
Index Back |
|---|---|
Non-Captive Broker%RECNAME_EDIT2 prompt view. |
| SELECT DISTINCT A.STOCK_ID ,A.ST_BROKERAGE_ID ,A.ST_BRANCH_ID ,B.DESCR FROM PS_STOCK_BRNCH_DTL A , PS_ST_BRKR_BRANCH B WHERE A.ST_BROKERAGE_ID = B.ST_BROKERAGE_ID AND A.ST_BRANCH_ID = B.ST_BRANCH_ID AND A.EFFDT = ( SELECT MAX(AA.EFFDT) FROM PS_STOCK_BRNCH_DTL AA WHERE AA.STOCK_ID = A.STOCK_ID AND AA.ST_BROKERAGE_ID = A.ST_BROKERAGE_ID AND AA.ST_BRANCH_ID = A.ST_BRANCH_ID AND AA.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(BB.EFFDT) FROM PS_ST_BRKR_BRANCH BB WHERE BB.ST_BROKERAGE_ID = B.ST_BROKERAGE_ID AND BB.ST_BRANCH_ID = B.ST_BRANCH_ID AND BB.EFFDT <= %CurrentDateIn ) AND B.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STOCK_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Company's Stock Identification Symbol
Prompt Table: STOCK_TBL |
| 2 | ST_BROKERAGE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Brokerage ID |
| 3 | ST_BRANCH_ID |
Character(10) | VARCHAR2(10) NOT NULL | Branch Identification |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |