ST_BRKR_BRAN_VW

(SQL View)
 Index Back

Brokerage Branch Prompt View

Prompt for Brokerage Branch

SELECT DISTINCT A.STOCK_ID , A.ST_BROKERAGE_ID , A.ST_BRANCH_ID , C.EFFDT , C.DESCR FROM PS_STOCK_BRNCH_DTL A , PS_ST_BROKER_DTL C WHERE A.ST_BROKERAGE_ID = C.ST_BROKERAGE_ID AND C.EFFDT = ( SELECT MAX(EFFDT) FROM PS_ST_BROKER_DTL WHERE ST_BROKERAGE_ID = A.ST_BROKERAGE_ID AND EFFDT <= A.EFFDT)

  • Parent record: ST_BROKER_TBL

    • # 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_TO Character(10) VARCHAR2(10) NOT NULL Brokerage ID

    Prompt Table: ST_BROKER_TBL

    3 ST_BRANCH_ID Character(10) VARCHAR2(10) NOT NULL Branch Identification
    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description