Difference between revisions of "Act Log Table"

From SDU
Jump to: navigation, search
m
m
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
The '''Act_Log''' table stores the [[Activity]] information for Requests, Incidents, and Problems. The '''alg''' [[Object|object]] is used to reference the content of the table.
+
__NOTOC__
 
+
[[Category:Tables]]
 +
{{Global Header}}
 +
{{Global Announcement}}
  
 +
== Overview ==
 +
The '''Act_Log''' table stores the [[Activities|Activity]] information for Requests, Incidents, and Problems. The '''alg''' [[Object|object]] is used to reference the content of the table.
  
 +
== Details ==
 
{| style="width:50%;"
 
{| style="width:50%;"
 
|-
 
|-
Line 15: Line 20:
 
|}
 
|}
  
 
+
The '''[[Object]]''' is what is used in scripting [[spel code]], [[Stored Queries]], [[Events and Macros|Action Macros]], web pages, etc.  
The '''[[Object]]''' is what is used in scripting [[spel code]], [[Stored Queries]], [[Action Macro|Action Macros]], web pages, etc.  
+
  
 
The '''Table''' is what you will reference when doing data extracts or loads. (eg pdm_extract Act_Log > alg.txt)
 
The '''Table''' is what you will reference when doing data extracts or loads. (eg pdm_extract Act_Log > alg.txt)
  
 
The '''SQL Name''' is what you will physically see if accessing the database directly.
 
The '''SQL Name''' is what you will physically see if accessing the database directly.
 
 
----
 
<div align='center'><font color="red">To make corrections or additions to this article, select the ''edit'' tab above.<br>
 
To discuss or ask questions about this article, select the ''discussion'' tab above.</font></div>
 
 
[[Category:Tables]]
 

Latest revision as of 03:59, 27 July 2008

To make corrections or additions to this article, select the edit tab above.
To discuss or ask questions about this article, select the discussion tab above.

Overview

The Act_Log table stores the Activity information for Requests, Incidents, and Problems. The alg object is used to reference the content of the table.

Details

Object Table SQL Name
alg Act_Log act_log

The Object is what is used in scripting spel code, Stored Queries, Action Macros, web pages, etc.

The Table is what you will reference when doing data extracts or loads. (eg pdm_extract Act_Log > alg.txt)

The SQL Name is what you will physically see if accessing the database directly.