System Maint. Log Inquiry

• Overview
• Key Fields
• Log Date
• Log Time
• Session ID
• Data Fields
• Comments
• Key #1
• Key #2
• Log Action
• Table Name
• User ID
• Browse Selection/Sort Fields
• Log Date
• User ID
• Table Name
• Special Notes

• Help Topics
• Help Index
• Inquiry Window
• Browse Window

The purpose of this procedure is to view and browse records in the database table "x_log" (Log of Maint Activities).

Key Fields

These entry field(s) are used to retrieve a specific record from this table.

Log Date.
Date of log entry (mm/dd/yyyy).

• DB fieldname/type/format: LogDate [date] 99/99/9999
• Screen component type: Textfield

Log Time.
Time of log entry (seconds since midnight).

• DB fieldname/type/format: LogTime [integer] >>>>9
• Screen component type: Textfield

Session ID.
Session ID which generated log entry.

• DB fieldname/type/format: SessionID [integer] >>>>>>9
• Screen component type: Textfield

Data Fields

These are the data fields in each record from this table.

Comments.
Optional comments regarding action being logged.

• DB fieldname/type/format: Comments [character] x(60)
• Screen component type: Textfield

Key #1.
First key value for record being added/changed/deleted.

• DB fieldname/type/format: x_key1 [character] x(32)
• Screen component type: Textfield

Key #2.
Second key value for record.

• DB fieldname/type/format: x_key2 [character] x(32)
• Screen component type: Textfield

Log Action.
Type of action being logged: Add/Chg/Del

• DB fieldname/type/format: LogAction [character] x(20)
• Screen component type: Textfield

Table Name.
Name of DB table being changed.

• DB fieldname/type/format: x_table [character] x(32)
• Screen component type: Textfield

User ID.
User ID who generated log entry.

• DB fieldname/type/format: xUserID [character] x(12)
• Screen component type: Textfield

Browse Selection/Sort Fields

In the browse for this procedure, you can select and sort records by the following fields.

Log Date.
Date of log entry (mm/dd/yyyy).

• DB fieldname/type/format: LogDate [date] 99/99/9999

User ID.
User ID who generated log entry.

• DB fieldname/type/format: xUserID [character] x(12)

Table Name.
Name of DB table being changed.

• DB fieldname/type/format: x_table [character] x(32)

Special Notes

None.