PSSRVVERDFN3_VW

(SQL View)
Index Back

SELECT a.ib_operationname , a.versionname , a.active_flag , a.descr , b.defaultver FROM PSOPRVERDFN a , psoperation b WHERE a.ib_operationname = b.ib_operationname

  • Related Language Record: PSSRVVERDF3_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
    2 VERSIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation Version
    3 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DEFAULTVER Character(30) VARCHAR2(30) NOT NULL Default Application Message Version