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 |