Message-ID: <2057680212.7746.1711638010569.JavaMail.confluence@ip-172-30-4-17.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_7745_1257542515.1711638010568" ------=_Part_7745_1257542515.1711638010568 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Audit Tables

Audit Tables

Each table in the project management database has limited auditi= ng of its own management through the change management columns. These colum= ns record the following:

=20 =20



The = columns are filled in when changes are made by the web services. There is n= o guarantee that the columns are filled in during direct database access. <= br class=3D"atl-forced-newline">

=20
=20 =20 = =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20

Transaction Columns

 

 

 

 

 

 

ENTRY_DATE

datetime

 

CHANGE_DATE

datetime

 

CHANGEBY_CHAR

varchar(50)

 

STATUS_CD

varchar(50)

=20



The = codes in the STATUS_CD column are:

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20

Code

Description

D

Delete

U

Update

C

Create

=20



= =20 =20



------=_Part_7745_1257542515.1711638010568--