ActLog file from Water Supply Inventory

This file captures changes to a selection of other files. As records are altered, the deltas are captured and place into this file to form a continuous record of what has happened to the file's records.

Number of Records In File: 43437
Number of Data Fields In File: 20

Data That Is Stored Within This File
UserID  =      
ProcName  =  Procedure    
FileName  =  File being edited    
FieldName  =  Field that was changed    
OldValue  =  Original Field contents    
NewValue  =  New field contents    
Date  =  Date Changed    
Time  =      
RecordID  =  Unique Record Identifier    
RecordID2  =  Second Unique ID    
User1  =  User Defined Field 1    
User2  =  User Defined Field 2    
User3  =  User Defined Field 2    
User4  =  User Defined Field 2    
MemoPointer  =  Link to ActLogM    
DelPointer  =      
Type  =  M Memo D Deleted    
ComputerName  =      
DeletedFilename  =      
PrimaField  =  Primary Field    

Related Files and Return To Hyperlinks
 ActLogM To Relate information between files, find records where MemoPointer here = MemoPointer there

 Return To Index
 Return To Compact List of All Files/All Variables