RDFSITE_SL_SRCH

(SQL View)
 Index Back

Search record of FSI SL

a view of serive location only, with SERVICE_LOC_SW = 'Y'

SELECT s.SETID , s.SITE_ID , n.BO_NAME , n.PRIMARY_IND , s.SITE_TYP_ID , s.FSI_NUMBER , s.FSI_SITE_STATUS , s.NUMBER_ATM , sv.SERVICE_ID , sn.SERVICE_NAME , s.PARENT_SITE_ID , s.PRIMARY_LANG_CD FROM PS_RDFSITE_VW s , PS_BO_NAME n , PS_RDFSITE_SERV_VW sv , PS_RBF_SERVICE sn WHERE s.BO_ID = n.BO_ID AND s.SETID = sv.SETID (+) AND s.SITE_ID = sv.SITE_ID (+) AND sv.SERVICE_ID = sn.SERVICE_ID (+) AND s.MARKET = 'FIN' AND s.SERVICE_LOC_SW = 'Y'

  • Related Language Record: RDFSITE_SL_SH_L

  • Parent record: BO

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Prompt Table: SP_SETID_NONVW

    2 SITE_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
    3 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
    4 PRIMARY_IND Character(1) VARCHAR2(1) NOT NULL Flag that indicates whether or not it is Primary
    N=No
    Y=Yes
    5 SITE_TYP_ID Character(5) VARCHAR2(5) NOT NULL Site Type identifier

    Prompt Table: RD_SITETYPE_TBL

    6 FSI_NUMBER Character(30) VARCHAR2(30) NOT NULL FSI bank ABA number
    7 FSI_SITE_STATUS Character(1) VARCHAR2(1) NOT NULL FSI loation status
    1=Open
    2=Closed
    3=Targeted for Closure
    4=Pending Open
    8 NUMBER_ATM Number(2,0) SMALLINT NOT NULL Number of ATM machines
    9 SERVICE_ID_SRCH Character(20) VARCHAR2(20) NOT NULL service_id, used for searive search

    Prompt Table: RBF_SERVICE

    10 SERVICE_NAME Character(30) VARCHAR2(30) NOT NULL Service Name
    11 PARENT_SITE_ID Character(15) VARCHAR2(15) NOT NULL Parent site Id of the service location

    Prompt Table: RDFSITE_SL_P_VW

    12 PRIMARY_LANG_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    CFR=Canadian French
    DAN=Danish
    DUT=Dutch
    ENG=English
    ESP=Spanish
    FRA=French
    GER=German
    GRK=Greek
    ITA=Italian
    JPN=Japanese
    KOR=Korean
    POR=Portuguese
    SVE=Swedish
    THA=Thai
    ZHS=Simplified Chinese
    ZHT=Traditional Chinese