PSIBRTNGSRCH_VW

index back

Search view for IB Routings


SELECT DISTINCT R.ROUTINGDEFNNAME , R.EFFDT , R.IB_OPERATIONNAME , R.VERSIONNAME , S.IB_SERVICENAME , R.DESCR FROM PSIBRTNGDEFN R , PSOPERATION S WHERE R.IB_OPERATIONNAME = S.IB_OPERATIONNAME

  • Related language record: PSIBRTNGSRC_LVW
  • PeopleSoft Field Name Field Type Column Type Description
    ROUTINGDEFNNAME Character(30) VARCHAR2(30) NOT NULL Routing Name
    EFFDT Date(10) DATE Effective Date

    Default: %date

    IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
    VERSIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation Version
    IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service (see PSSERVICE).
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19