BATCH_IDTEST_REC_NBRDTTM_STAMPRB_CIMROW_ERRVW(SQL View) |
Index Back |
|---|---|
Batch Row Error ViewThis view returns all of the errors from the latest import or purge process run against the batch row. |
| SELECT A.BATCH_ID , A.TEST_REC_NBR , A.DTTM_STAMP , A.RUN_CNTL_ID , A.PROCESS_INSTANCE , A.MESSAGE_SET_NBR , A.MESSAGE_NBR , A.MESSAGE_PARM , A.DESCR254 FROM PS_RB_CIM_RUN_LOG A , PS_RB_CIM_BAT_HDR B WHERE B.BATCH_ID = A.BATCH_ID AND A.PROCESS_INSTANCE > 0 AND A.CIM_LOG_LEVEL = 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BATCH_ID |
Number(15,0) | DECIMAL(15) NOT NULL | CDH INTERFACE TABLE FIELD - BATCH_ID |
| 2 | TEST_REC_NBR |
Number(9,0) | DECIMAL(9) NOT NULL | Unique record number within a batch. This field was created by CRM and should be replaced with the OFFICIAL version of the field from Campus. |
| 3 | DTTM_STAMP |
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. |
| 4 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 5 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 6 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 7 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 8 | MESSAGE_PARM | Character(254) | VARCHAR2(254) NOT NULL | Message Parameter Text |
| 9 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |