PSBATCHRPT_TBL(SQL Table) |
Index Back |
---|---|
Batch Report TableContains one row for each type of message that a batch program can generate |
# | 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 |