PSBATCHRPT_TBL

index back

Batch Report Table

Contains one row for each type of message that a batch program can generate

  • Parent record: PSBATCHRPT_HDR
  • PeopleSoft Field Name Field Type Column Type Description
    PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
    MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    TOTAL_ROW_COUNT Number(8,0) INTEGER NOT NULL Total Row Count
    GROUP_MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    GROUP_BY_COLUMNS Number(3,0) SMALLINT NOT NULL Group By Columns
    MESSAGE_NBR01 Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    MESSAGE_NBR02 Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    MESSAGE_NBR03 Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    MESSAGE_NBR04 Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    MESSAGE_NBR05 Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    MESSAGE_NBR06 Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    MESSAGE_NBR07 Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    MESSAGE_NBR08 Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    MESSAGE_NBR09 Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    MESSAGE_NBR10 Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    COLHEADING01 Character(30) VARCHAR2(30) NOT NULL Column Heading
    COLHEADING02 Character(30) VARCHAR2(30) NOT NULL Column Heading
    COLHEADING03 Character(30) VARCHAR2(30) NOT NULL Column Heading
    COLHEADING04 Character(30) VARCHAR2(30) NOT NULL Column Heading
    COLHEADING05 Character(30) VARCHAR2(30) NOT NULL Column Heading
    COLHEADING06 Character(30) VARCHAR2(30) NOT NULL Column Heading
    COLHEADING07 Character(30) VARCHAR2(30) NOT NULL Column Heading
    COLHEADING08 Character(30) VARCHAR2(30) NOT NULL Column Heading
    COLHEADING09 Character(30) VARCHAR2(30) NOT NULL Column Heading
    COLHEADING10 Character(30) VARCHAR2(30) NOT NULL Column Heading
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19