KK_TRAN_IDKK_TRAN_DTKK_I_EXCPDEL_VW(SQL View) |
Index Back |
|---|---|
Comm Cntrl Deleted ExceptionsDeleted Commitment Control Exceptions for Insights Dashboard |
| SELECT KK_TRAN_ID, KK_TRAN_DT, KK_TRAN_LN, LEDGER_GROUP, EXCPTN_TYPE, MESSAGE_NBR, MESSAGE_PARM1, MESSAGE_PARM2, MESSAGE_PARM3, MESSAGE_PARM4, MAX(DTTM_STAMP_SEC) FROM PS_KK_I_EXCPTN_DEL GROUP BY KK_TRAN_ID, KK_TRAN_DT, KK_TRAN_LN, LEDGER_GROUP, EXCPTN_TYPE, MESSAGE_NBR, MESSAGE_PARM1, MESSAGE_PARM2, MESSAGE_PARM3, MESSAGE_PARM4 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | KK_TRAN_ID |
Character(10) | VARCHAR2(10) NOT NULL | Commitment Control Foreign Key for Transaction Identification. |
| 2 | KK_TRAN_DT |
Date(10) | DATE NOT NULL | Commitment Control Transaction Original processing date. Primary key with KK_TRAN_ID. |
| 3 | KK_TRAN_LN | Number(9,0) | DECIMAL(9) NOT NULL | Commitment Control Transaction Line number. |
| 4 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 5 | EXCPTN_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Exception Type |
| 6 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 7 | MESSAGE_PARM1 | Character(30) | VARCHAR2(30) NOT NULL | Message Parameter 1 |
| 8 | MESSAGE_PARM2 | Character(30) | VARCHAR2(30) NOT NULL | Message Parameter 2 |
| 9 | MESSAGE_PARM3 | Character(30) | VARCHAR2(30) NOT NULL | Message Parameter 3 |
| 10 | MESSAGE_PARM4 | Character(30) | VARCHAR2(30) NOT NULL | Message Parameter 4 |
| 11 | KK_DATETIME_STAMP | DateTime(26) | TIMESTAMP | DateTime Stamp |