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 NameField TypeColumn TypeDescription
    PROCESS_INSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
    MESSAGE_SET_NBRNumber(5,0)INTEGER NOT NULLMessage Set Number. This field refers to the Message Set Number in the Message Catalog.
    MESSAGE_NBRNumber(5,0)INTEGER NOT NULLMessage Number. This field refers to the Message Number in the Message Catalog.
    TOTAL_ROW_COUNTNumber(8,0)INTEGER NOT NULLTotal Row Count
    GROUP_MESSAGE_NBRNumber(5,0)INTEGER NOT NULLMessage Number. This field refers to the Message Number in the Message Catalog.
    GROUP_BY_COLUMNSNumber(3,0)SMALLINT NOT NULLGroup By Columns
    MESSAGE_NBR01Number(5,0)INTEGER NOT NULLMessage Number. This field refers to the Message Number in the Message Catalog.
    MESSAGE_NBR02Number(5,0)INTEGER NOT NULLMessage Number. This field refers to the Message Number in the Message Catalog.
    MESSAGE_NBR03Number(5,0)INTEGER NOT NULLMessage Number. This field refers to the Message Number in the Message Catalog.
    MESSAGE_NBR04Number(5,0)INTEGER NOT NULLMessage Number. This field refers to the Message Number in the Message Catalog.
    MESSAGE_NBR05Number(5,0)INTEGER NOT NULLMessage Number. This field refers to the Message Number in the Message Catalog.
    MESSAGE_NBR06Number(5,0)INTEGER NOT NULLMessage Number. This field refers to the Message Number in the Message Catalog.
    MESSAGE_NBR07Number(5,0)INTEGER NOT NULLMessage Number. This field refers to the Message Number in the Message Catalog.
    MESSAGE_NBR08Number(5,0)INTEGER NOT NULLMessage Number. This field refers to the Message Number in the Message Catalog.
    MESSAGE_NBR09Number(5,0)INTEGER NOT NULLMessage Number. This field refers to the Message Number in the Message Catalog.
    MESSAGE_NBR10Number(5,0)INTEGER NOT NULLMessage Number. This field refers to the Message Number in the Message Catalog.
    COLHEADING01Character(30)VARCHAR2(30) NOT NULLColumn Heading
    COLHEADING02Character(30)VARCHAR2(30) NOT NULLColumn Heading
    COLHEADING03Character(30)VARCHAR2(30) NOT NULLColumn Heading
    COLHEADING04Character(30)VARCHAR2(30) NOT NULLColumn Heading
    COLHEADING05Character(30)VARCHAR2(30) NOT NULLColumn Heading
    COLHEADING06Character(30)VARCHAR2(30) NOT NULLColumn Heading
    COLHEADING07Character(30)VARCHAR2(30) NOT NULLColumn Heading
    COLHEADING08Character(30)VARCHAR2(30) NOT NULLColumn Heading
    COLHEADING09Character(30)VARCHAR2(30) NOT NULLColumn Heading
    COLHEADING10Character(30)VARCHAR2(30) NOT NULLColumn Heading
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19