Each table in the project management database has limited auditing of its own management through the change management columns. These columns record the following:



The columns are filled in when changes are made by the web services. There is no guarantee that the columns are filled in during direct database access.

Transaction Columns

 

 

 

 

 

 

ENTRY_DATE

datetime

 

CHANGE_DATE

datetime

 

CHANGEBY_CHAR

varchar(50)

 

STATUS_CD

varchar(50)



The codes in the STATUS_CD column are:

Code

Description

D

Delete

U

Update

C

Create