PSBATCHRPT_TBL

(SQL Table)
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 PeopleSoft Field Type Database Column Type Description
    1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
    3 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    4 TOTAL_ROW_COUNT Number(8,0) INTEGER NOT NULL Total Row Count
    5 GROUP_MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    6 GROUP_BY_COLUMNS Number(3,0) SMALLINT NOT NULL Group By Columns
    7 MESSAGE_NBR01 Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    8 MESSAGE_NBR02 Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    9 MESSAGE_NBR03 Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    10 MESSAGE_NBR04 Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    11 MESSAGE_NBR05 Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    12 MESSAGE_NBR06 Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    13 MESSAGE_NBR07 Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    14 MESSAGE_NBR08 Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    15 MESSAGE_NBR09 Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    16 MESSAGE_NBR10 Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    17 COLHEADING01 Character(30) VARCHAR2(30) NOT NULL Column Heading
    18 COLHEADING02 Character(30) VARCHAR2(30) NOT NULL Column Heading
    19 COLHEADING03 Character(30) VARCHAR2(30) NOT NULL Column Heading
    20 COLHEADING04 Character(30) VARCHAR2(30) NOT NULL Column Heading
    21 COLHEADING05 Character(30) VARCHAR2(30) NOT NULL Column Heading
    22 COLHEADING06 Character(30) VARCHAR2(30) NOT NULL Column Heading
    23 COLHEADING07 Character(30) VARCHAR2(30) NOT NULL Column Heading
    24 COLHEADING08 Character(30) VARCHAR2(30) NOT NULL Column Heading
    25 COLHEADING09 Character(30) VARCHAR2(30) NOT NULL Column Heading
    26 COLHEADING10 Character(30) VARCHAR2(30) NOT NULL Column Heading