PSOPRHDLR

(SQL Table)
Index Back

IB Server Handlers

  • Related Language Record: PSOPRHDLRLANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
    2 HANDLERNAME Character(30) VARCHAR2(30) NOT NULL Handler Name
    3 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    4 IB_HANDLERALIAS Character(30) VARCHAR2(30) NOT NULL Handler Alias Name
    5 HANDLERID Character(4) VARCHAR2(4) NOT NULL Handler Type
    NOTF=On Notify
    PRNF=On Pre Notify
    PTNF=On Post Notify
    RECV=On Receive
    RESP=On Response
    ROUT=On Route
    RQST=On Request
    SEND=On Send
    6 HANDLEROWNER Character(30) VARCHAR2(30) NOT NULL Handler Owner
    7 HANDLERTYPE Character(30) VARCHAR2(30) NOT NULL Implementation
    8 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
    A=Active
    I=Inactive

    Default Value: A

    9 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
    10 IB_ROLLBACK Character(1) VARCHAR2(1) NOT NULL Rollback Enabled

    Y/N Table Edit

    Default Value: N

    11 IB_ATTRIBUTENAME Character(30) VARCHAR2(30) NOT NULL Attribute Name
    12 IB_ATTRIBUTEVALUE Character(30) VARCHAR2(30) NOT NULL Attribute Value
    13 IB_DMS_ROLLBACK Number(7,0) INTEGER NOT NULL Rollback Size (In Kilobytes)

    Default Value: 32

    14 IB_BULKLOAD_MODE Number(1,0) SMALLINT NOT NULL Bulk Load Mode
    15 SUBPROC_FLAG Character(1) VARCHAR2(1) NOT NULL Generate Process Instance

    Y/N Table Edit

    Default Value: N

    16 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.
    17 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.
    18 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    19 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    20 DESCRLONG Long Character CLOB Long Description