RBF_SRVLG_CLSVW

(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 , A.BO_NAME , A.BO_NAME_AC , A.SITE_TYP_ID , A.FSI_NUMBER , A.FSI_SITE_STATUS , A.NUMBER_ATM , B.OPRID FROM PS_RBF_SRVL_GS_VW A , PSOPRCLS B , PS_SEC_SETID_CLS C WHERE A.SETID = C.SETID AND B.OPRCLASS = C.OPRCLASS

  • 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
    9 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).