ST_BRNC_CT_LANG

(SQL Table)
 Index Back

Language Rcrd for Broker Brnch

Language Record for Broker Branch

  • Related Language Record for ST_BRANCH_CNTCT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Stock ID

    Prompt Table: STOCK_TBL

    2 ST_BROKERAGE_ID 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

    Prompt Table: ST_BRKR_BRANCH

    4 EFFDT Date(10) DATE NOT NULL Effective Date
    5 ST_CONTACT_TYPE Character(1) VARCHAR2(1) NOT NULL Contact Type
    A=Administrative
    B=Broker
    E=Escrow
    T=Transfer
    Y=Escrow/Transfer
    Z=Administrative/Broker

    Default Value: B

    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 COMMENTS Long Character CLOB Comment