Difference between revisions of "Change Act Log Table"

From SDU
Jump to: navigation, search
m
m
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
 +
__NOTOC__
 +
[[Category:Tables]]
 +
{{Global Header}}
 +
{{Global Announcement}}
 +
 +
== Overview ==
 
The '''Change_Act_Log''' table stores the [[Activities|Activity]] information for Change Orders. The '''chgalg''' [[Object|object]] is used to reference the content of the table.
 
The '''Change_Act_Log''' table stores the [[Activities|Activity]] information for Change Orders. The '''chgalg''' [[Object|object]] is used to reference the content of the table.
  
 
+
== Details ==
 
+
 
{| style="width:50%;"
 
{| style="width:50%;"
 
|-
 
|-
Line 14: Line 19:
 
|-
 
|-
 
|}
 
|}
 
  
 
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]], [[Events and Macros|Action Macros]], web pages, etc.  
Line 21: Line 25:
  
 
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="green">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 Change_Act_Log table stores the Activity information for Change Orders. The chgalg object is used to reference the content of the table.

Details

Object Table SQL Name
chgalg Change_Act_Log chgalg

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 Change_Act_Log > chgalg.txt)

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