SAIF.Application.LogView database tables

This page catalogs database tables accessed by this library.

Table catalog

Table	Database	Schema/Link	CRUD	Purpose	Primary business object
App_Error	SQL Server	NetFramework.dbo (insert), [unqualified] (read/update)	C/R/U	Application error log storage	clsAppError
App_Info	SQL Server	NetFramework.dbo (insert), [unqualified] (read)	C/R	Application info/audit log storage	clsAppInfo

---

App_Error

Field	Value
Database	SQL Server
Schema/Link	NetFramework.dbo for inserts; [unqualified] for collection reads and update SQL
Purpose	Stores application error log entries, search text, user context, and deleted-flag state.
Access pattern	Direct SQL via IBusinessCriteria
CRUD operations	Create, Read, Update
Key columns used	App_Error_Seq_Num, App_Name, Deleted_Flag, Environment, Error_Date, Error_Info, Error_Source, Machine_Name, Page_Name, State_Info, User_Name
Sequence	Identity value retrieved through Select @@IDENTITY
Related tables	None
Business objects	clsAppError, clsAppErrorCollection

Operations referencing this table

• Create a new application error log entry from struct
• Create a new application error log entry from discrete parameters
• Retrieve a single error log entry
• Update an error deleted flag
• Search application error logs
• Normalize free-text search terms

Business rules referencing this table

• BR-001: Search results are capped at 300 rows
• BR-002: All sentinel suppresses selected filters
• BR-003: Semicolon-delimited filters expand to SQL IN lists
• BR-004: Search text is normalized for full-text queries
• BR-005: Single-object retrieval requires exactly one row
• BR-006: Inserts must affect exactly one row

SQL referencing this table

• SQL-001: clsAppError identity retrieval
• SQL-003: clsAppError.InsertSQL
• SQL-005: clsAppErrorCollection.RetrieveSQL
• SQL-006: clsAppErrorCollection.RetrieveSQLCount
• SQL-009: clsAppError.UpdateSQL

---

App_Info

Field	Value
Database	SQL Server
Schema/Link	NetFramework.dbo for inserts; [unqualified] for collection reads
Purpose	Stores application info/audit messages, supplemental data text, and purge-date retention metadata.
Access pattern	Direct SQL via IBusinessCriteria
CRUD operations	Create, Read
Key columns used	App_Info_Seq_Num, App_Name, Create_Date, Data_Text, Environment, Machine_Name, Message_Text, Page_Name, Purge_Date, User_Name
Sequence	Identity value retrieved through Select @@IDENTITY
Related tables	None
Business objects	clsAppInfo, clsAppInfoCollection

Operations referencing this table

• Create a new application info log entry from struct
• Create a new application info log entry from discrete parameters
• Retrieve or create a single application info object
• Search application info logs
• Normalize free-text search terms

Business rules referencing this table

• BR-001: Search results are capped at 300 rows
• BR-002: All sentinel suppresses selected filters
• BR-003: Semicolon-delimited filters expand to SQL IN lists
• BR-004: Search text is normalized for full-text queries
• BR-005: Single-object retrieval requires exactly one row
• BR-006: Inserts must affect exactly one row
• BR-007: Audit rows receive a 30-day purge date
• BR-008: Audit searches exclude EPAY and DirectDeposit

SQL referencing this table

• SQL-002: clsAppInfo identity retrieval
• SQL-004: clsAppInfo.InsertSQL
• SQL-007: clsAppInfoCollection.RetrieveSQL
• SQL-008: clsAppInfoCollection.RetrieveSQLCount

---

Table relationship diagram

No cross-table relationships were identified in this library's SQL.

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• SQL catalog
• API reference

Sources

• Application\SAIF.Application.LogView\clsAppError.vb
• Application\SAIF.Application.LogView\clsAppErrorCollection.vb
• Application\SAIF.Application.LogView\clsAppInfo.vb
• Application\SAIF.Application.LogView\clsAppInfoCollection.vb