Difference between revisions of "Change Request 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 Request''' table stores the Change Orders. The '''chg''' [[Object|object]] is used to reference the content of the table.
 
The '''Change Request''' table stores the Change Orders. The '''chg''' [[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:58, 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 Request table stores the Change Orders. The chg object is used to reference the content of the table.

Details

Object Table SQL Name
chg Change_Request chg

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_Request > chg.txt)

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