Database Table Reference → PES_AgileWIAuditCurrent

PES_AgileWIAuditCurrent

PES_AgileWIAuditCurrent stores Agile work item information outside of the blob in plain text and can be retrieved without defining the oledb provider.

Columns

Name Type Length Description
obj_UID int 4 Primary key to PES_AgileWI.
att_UID int 4 Primary key to PES_Attribute.
dim_UID tinyint 1 Foreign key to PES_Dimension.
usr_UID int 4 ID of the user who last changed the item.
aud_Timestamp datetime 8 Date and time that the item was last updated.
aud_Text nvarchar -1 Attribute values. See below.
aud_Float float 8
aud_Integer int 4
aud_Date datetime 8
aud_Bool bit 1
aud_Text2 nvarchar -1
obj_TransactionId uniqueidentifier 16 Transaction ID.

Using aud_* Attribute Columns

Consult the following table for details of determining attribute type and using the columns.
Attribute type How to determine type Which column need to use
listintegerresource

PES_Attribute.lst_UID IS NOT NULL
PES_Attribute.atyp_UID == 2
PES_Attribute.atyp_UID == 28

 auh_Integer 
flag PES_Attribute.atyp_UID == 3 auh_Bool
date PES_Attribute.atyp_UID == 1 auh_Date
Text PES_Attribute.atyp_UID == 4 auh_Text

RANGED_CALCULATION
FLOAT
MONEY
PERCENT
SCORECARD

PES_Attribute.atyp_UID == 12
PES_Attribute.atyp_UID == 5
PES_Attribute.atyp_UID == 6
PES_Attribute.atyp_UID == 13
PES_Attribute.atyp_UID == 24

 auh_Float
Milestone PES_Attribute.atyp_UID == 10, 11 auh_Date, auh_Bool, auh_Integer
UrlLink PES_Attribute.atyp_UID == 27 auh_Bool, auh_Text, auh_Text2

SQL Example

SELECT*
FROM [dbo].[PES_AgileWIAuditCurrent]
obj_UID     att_UID          dim_UID usr_UID       aud_Timestamp           aud_Text      aud_Float       aud_Integer                aud_Date   aud_Bool aud_Text2      obj_TransactionId
----------- ---------------- ------- ------------  ----------------------- ------------- --------------- -------------------------- ---------- -------- -------------- --------------------
124         110              NULL    1             2008-10-17 04:00:01.000 NULL          NULL            0                          NULL       NULL     NULL           NULL
124         132              NULL    1             2008-10-17 04:00:01.000 NULL          NULL            43                         NULL       NULL     NULL           NULL
239         140              NULL    1             2009-01-24 01:25:22.373 NULL          NULL            8                          NULL       NULL     NULL           NULL
166         108              NULL    1             2009-03-25 11:42:38.090 Alpha         NULL            NULL                       NULL       NULL     NULL           NULL
103         103              NULL    18            2010-03-12 13:14:02.750 NULL          NULL            396                        NULL       NULL     NULL           E954C0A4-23DA-46BC-9F82-12C97E7D797C
239         134              NULL    1             2009-01-24 01:25:22.373 NULL          NULL            10                         NULL       NULL     NULL           NULL
409         12               NULL    18            2010-03-12 13:12:50.173 NULL          NULL            -6                         NULL       NULL     NULL           1815AF51-76FF-4848-ACBE-CBB961355B47