STOCK_IDST_AGENCY_IDEFFDTST_AGENT_TRN_VW(SQL View) |
Index Back |
|---|
| SELECT A.STOCK_ID , A.ST_AGENCY_ID , A.EFFDT , B.DESCR FROM PS_STOCK_AGENT_DTL A , PS_ST_AGENT_DTL B WHERE A.ST_AGENCY_ID = B.ST_AGENCY_ID AND A.EFFDT <= ( SELECT MAX(C.EFFDT) FROM PS_STOCK_AGENT_DTL C WHERE C.STOCK_ID = A.STOCK_ID AND C.ST_AGENCY_ID =A.ST_AGENCY_ID) AND B.EFFDT= ( SELECT MAX(D.EFFDT) FROM PS_ST_AGENT_DTL D WHERE D.ST_AGENCY_ID = B.ST_AGENCY_ID AND D.EFFDT <= A.EFFDT) AND A.AGENCY_TYPE <> 'E' |
| # | 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_AGENCY_ID |
Character(10) | VARCHAR2(10) NOT NULL | This field is used for Transfer Agents as well as Escrow Agents |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |