RBF_SRVLC_GS_VW

(SQL View)
 Index Back

Search record of FSI SL

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

SELECT DISTINCT A.SETID , A.SITE_ID , C.BO_NAME , C.BO_NAME_AC , A.SITE_TYP_ID , B.FSI_NUMBER , B.FSI_SITE_STATUS , B.NUMBER_ATM FROM PS_RD_SITE A , PS_RDFSITE B , PS_BO_NAME C WHERE A.SETID = B.SETID AND A.SITE_ID = B.SITE_ID AND A.BO_ID = C.BO_ID AND A.MARKET = 'FIN' AND B.SERVICE_LOC_SW = 'Y'

  • 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
    Set Control Field: SETID

    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 BO_NAME_AC Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
    5 SITE_TYP_ID Character(5) VARCHAR2(5) NOT NULL Site Type identifier

    Prompt Table: RD_STYPE_GS_VW
    Set Control Field: SITE_TYP_ID

    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