Data Dictionary

·         A Central Repository containing data item definitions and attributes, just like a dictionary contains word definitions.

·         Only ONE Data Dictionary is recommended for a JDE EnterpriseOne software installation.

·         Therefore, Data Dictionary is shared across all environments, i.e. Production, Prototype, and Development.

·         The data item definition defines how the item is used and includes information such as the type of item and its length.

·         The Data Dictionary is active, i.e. a change is effective immediately.

 

Creation of Data Dictionary Items

1.     After entering into OMW window click on "ADD" button then a window will be opened from that window select "Data Item" and click on OK button.

2.     Then a message window will be opened asking whether we want to add a glossary data item or a normal data item, click YES if you want to add a glossary item or click NO if you want to add a normal data item.

3.     Click on No for creating regular data item.

4.     Now a window having the fields like Data item,Alias,Glossary group,Description,Product code,Data type,Size.

5.     Fill all the fields and click OK button.

6.     If we want we can add Default value,Visual assists,Next number. 

7.     DD item is added to the project.  

8.     If we want to add a glossary data item in the message window click on YES button.

9.     Now a window having the fields like Item specification,Alias,Glossary group,Product code,Product code reporting,Description and Error level. Fill all these fields and click OK button

10.  Then the glossary item is added to the project.

 

Data Dictionary Items are stored in

·        The Master Data  Dictionary is stored in relational tables on the enterprise server:

ü  F9200 - Data Item Master

ü  F9202 - Data Field Display Text

ü  F9203 - Data Item Alpha Description/Glossary Overrides Information

ü  F9207 - Error/Workflow Message Information

ü  F9210 - Data Field Specifications

ü  F9211 - Smart Fields

ü  F9212 - Smart Fields Criteria-Setup Rules

ü  F00165  - Data Item Glossary Text

·         Local specifications tables exist on every PeopleSoft EnterpriseOne software Client and the Logic Server

ü  By path code under the b7/pathcode/spec directory

ü  The local specifications are a replicated local copy of the data dictionary stored in the dddict and ddtext (.ddb and .xdb) files. Data Dictionary information  does a Just in Time install (JITI) from the  Master Data Dictionary tables to the Data Dictionary specification files the first time a data item  is accessed by an interactive or batch application.  This is true except for glossary group C data items that never JITI.

·         Global Tables - glbltbl (.ddb and .xdb)

ü  Part of the local specifications stored under the b7/pathcode/spec directory

ü  Stores data item definitions for every PeopleSoft EnterpriseOne software table.

ü  Data item definition is dependent on Data Dictionary specs.

ü  JITI happens only the first time a table is accessed by PeopleSoft EnterpriseOne software.

ü  Used at Runtime by PeopleSoft EnterpriseOne software interactive and batch applications.

 

Types of Data Item Glossary Groups

·         D - Primary Data Elements

·         S - Secondary Data Elements

ü  No different from a D glossary group data item.

ü  Assigned by the Data Dictionary application when creating a group of Data Items.

·         C - Data Item Class

ü  A way to create a class that is then used to group several data items that share the same attribute such as display decimals, i.e. QTYINV, CURRENCY

Note: Data Items with this glossary group do not JITI

·         K - Smart Field

ü  Special Data Items used for specific application report templates in Report Design Aid.

·         E - Error Messages

ü  Used for error messages within PeopleSoft EnterpriseOne software applications.

·         Y - Workflow Messages

·         H - Processing Option Glossary

 

NOTE: Only Glossary Groups D and S data items can be used as attributes of a table.

 

 

 Data Item Attributes

·         Determines how a data item APPEARS on forms and reports (i.e. number of decimals and default value).

·         VALIDATES data entry within an application.

·         ASSIGNS column and row descriptions on forms and reports.

·         Provides glossary text for field-level HELP (i.e. on a form control, press the F1 key or use the Help “What's This" menu item)

·         Defines how data is STORED in a table.

 

Difference between File Decimals and Display Decimals

·         The DIFFERENCE between file decimals and display decimals:

ü  Has to do with the way the data is stored in the data base.

ü  You have to use one or the other and cannot use both.

·         File Decimals:

ü  Defines the number of decimals that are stored to the right of the decimal of the data item within the table.

ü  Must NEVER be changed for existing PeopleSoft EnterpriseOne data items.

Example: 

File Decimals = 2   

Displayed by PeopleSoft EnterpriseOne software as 1.23       

Stored in Database as 1.23      

·         Display Decimals:

ü  Designates the number of decimals to display for a data item

ü  Display decimals are for display purposes and are not stored in the database tables.

ü  Changes to the display decimals on a data item do NOT convert any existing data already in the tables.

ü  PeopleSoft EnterpriseOne supports the change for data items belonging to QTYINV class and data item QNTY.  

ü  As a general rule, display decimals should NOT be changed on other standard PeopleSoft EnterpriseOne data items.

Example: 

Display Decimals = 2

Displayed by PeopleSoft EnterpriseOne software as 1.23   

Stored in Database as 123 (multiply by a factor of 10 for each display decimal i.e. 100)

 

Should Not be changed for Existing JDE EnterpriseOne Data Items

·         Glossary Group

ü  For example, changing from D to C will not JITI the data item.

·         Data Type and Size

ü  This will affect table definitions and business functions.

ü  Doing so will create data integrity issues and affect upgrades to future releases.

·         Class

ü  JDE EnterpriseOne has identified groups of like data items and assigned them to a class to ensure they share a particular attribute (i.e. display decimals for QTYINV class)

·         File Decimals

·         Next Numbers

·         Display Decimals (other than the supported change of data items in the QTYINV class and data item QNTY)