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 NameField TypeColumn TypeDescription
    ROUTINGDEFNNAMECharacter(30)VARCHAR2(30) NOT NULLRouting Name
    EFFDTDate(10)DATEEffective Date

    Default: %date

    IB_OPERATIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation (see PSOPERATION).
    VERSIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation Version
    IB_SERVICENAMECharacter(30)VARCHAR2(30) NOT NULLService (see PSSERVICE).
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19