PSCHNLDEFN

(SQL Table)
 Index Back

Channel Definition

PSCHNLDEFN is a Tools table that holds definitions for Channel objects. Channels are used to group Application Messages. Messages in a Channel are processed according to attributes of the Channel.

  • Related Language Record: PSCHNLDEFNLANG

  • Parent Record Of PSCHNLDEFNLANG PSCHNLNODE PSSUBCHNL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CHNLNAME Character(30) VARCHAR2(30) NOT NULL Channel Name
    2 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    3 CHNLSTATUS Number(1,0) SMALLINT NOT NULL Channel Status
    4 PUBTIMEOUTMIN Number(5,0) INTEGER NOT NULL Publication Time-out minutes
    5 SUBTIMEOUTMIN Number(5,0) INTEGER NOT NULL Subscription time-out minutes
    6 PUBRETRYSEC Number(5,0) INTEGER NOT NULL Publication Retry Seconds
    7 SUBRETRYSEC Number(5,0) INTEGER NOT NULL Subscription Retry Seconds
    8 ERRORTHRESHOLD Number(5,0) INTEGER NOT NULL Error Threshold for Application Message Channels
    9 APMSGARCHIVE Number(1,0) SMALLINT NOT NULL Archive this channel?
    10 THRUPUTTYPE Number(1,0) SMALLINT NOT NULL Throughput Type
    11 QUALITYOFSERVICE Number(1,0) SMALLINT NOT NULL Application Message Quality of Service
    12 CHNLDISPLAYNAME Character(30) VARCHAR2(30) NOT NULL Channel DIsplay Name
    13 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    14 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    15 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.
    16 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.
    17 DESCRLONG Long Character CLOB Long Description