PSOPERATION

(SQL Table)
Index Back

IB Services

  • Related Language Record: PSOPERATIONLANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation
    2 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference

    Default Value: 1

    3 DEFAULTVER Character(30) VARCHAR2(30) NOT NULL Default Application Message Version
    4 RTNGTYPE Character(1) VARCHAR2(1) NOT NULL Routing Type
    A=Asynchronous - One Way
    N=Synchronous Non-Blocking
    R=Asynch Request/Response
    S=Synchronous
    X=Asynch to Synch
    5 IB_USERPWDREQ Character(1) VARCHAR2(1) NOT NULL User/Password Required

    Y/N Table Edit

    Default Value: N

    6 IB_REQUESTSTATUS Character(1) VARCHAR2(1) NOT NULL Req Verification
    A=Digital Sign or SSL
    B=Encrypt and Digitally Sign
    C=Encrypt/Digital Sign or SSL
    D=Digitally Signed
    E=Encrypt
    H=SSL
    K=Encrypt or SSL
    N=None

    Default Value: N

    7 IB_ACTIVEDATAGUARD Number(1,0) SMALLINT NOT NULL Active Data Guard
    8 IB_THINKTIME Number(1,0) SMALLINT NOT NULL Used with Think Time Methods
    9 IB_CONNAV Number(1,0) SMALLINT NOT NULL Conditional Navigation
    10 IB_READONLY_PERM Number(1,0) SMALLINT NOT NULL Read Only Permission List
    11 IB_RESTMETHOD Character(10) VARCHAR2(10) NOT NULL REST Method
    12 IB_REST_SERVICE Number(1,0) SMALLINT NOT NULL REST Service Type
    13 IB_RESTBASE_URL Character(254) VARCHAR2(254) NOT NULL REST Base URL
    14 IB_REST_OVERRIDE Number(1,0) SMALLINT NOT NULL REST Override
    15 IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service (see PSSERVICE).

    Prompt Table: PSSERVICE

    16 PTIBAPPLNAME Character(30) VARCHAR2(30) NOT NULL Application Service ID. (see PSIBAPPLDEFN).
    17 IB_ALIASNAME Character(128) VARCHAR2(128) NOT NULL Service Alias
    18 MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).

    Prompt Table: PSMSGDEFN

    19 IB_MSGVERSION Character(30) VARCHAR2(30) NOT NULL Message Version

    Prompt Table: PSSRVMSGVER_VW

    20 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    21 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    22 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    23 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    24 DESCRLONG Long Character CLOB Long Description