The table structure is as below.

The insert has values only for the Not Null coulmns. None of the other fields are populated.

CREATE TABLE DIS_EVENT (
DIS_EVENT_ID BIGINT NOT NULL,
DIS_ID BIGINT NOT NULL,
EVENT_SEQ SMALLINT,
FIELD_NAME VARCHAR(40),
OLD_VALUE VARCHAR(100),
NEW_VALUE VARCHAR(100),
CREATED_SOURCE_TYPE SMALLINT NOT NULL,
CREATED_SOURCE VARCHAR(25),
CREATED_DTTM TIMESTAMP NOT NULL,
DIS_DETAIL_ID BIGINT,
PRIMARY KEY(DIS_EVENT_ID)
)
GO
ALTER TABLE DIS_EVENT
ADD CONSTRAINT DIS_EVENT_DIS_FK
FOREIGN KEY(DIS_ID)
REFERENCES DISP(DIS_ID)
GO

Hi nidm,

First thing we did was to check for any Triggers, but none on this table and there are no check constraints as well. There was a stored procedure depending on this table, but as mentioned, there are no triggers to initiate this stored procudure.