KK_I_EXCPTN_DEL

(SQL Table)
Index Back

Comm Cntrl Deleted Exceptions

Deleted Commitment Control Exceptions for Insights Dashboard

# 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 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
7 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
8 MESSAGE_PARM1 Character(30) VARCHAR2(30) NOT NULL Message Parameter 1
9 MESSAGE_PARM2 Character(30) VARCHAR2(30) NOT NULL Message Parameter 2
10 MESSAGE_PARM3 Character(30) VARCHAR2(30) NOT NULL Message Parameter 3
11 MESSAGE_PARM4 Character(30) VARCHAR2(30) NOT NULL Message Parameter 4
12 DTTM_STAMP_SEC 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.