Data Dictionary
Data Dictionary
Data Dictionary
Module: System Administration
Overview
Use the Data Dictionary (program #1819) when you are developing reports or queries, or simply to better understand SBN. In Data Dictionary you can view
-
Tables
-
Table descriptions
-
Table fields
-
Field descriptions
-
Field types
-
Field lengths
-
Whether nulls are allowed
The Data Dictionary Window
The following graphic shows Data Dictionary as the program opens. The upper pane displays all tables used in SBN (except work tables and copytask tables).

Field/Column Descriptions
The following table describes the fields and columns used in Data Dictionary.
|
Field/Column |
Description |
|
Table |
Name of the table. |
|
Database |
Name of the database where SBN stores this table. |
|
Description |
Text description of the table. |
|
Chart Location |
References the name of the data map chart that includes this table. |
Using Common Functions
See the reference document Common Functions in SBN for more information.
Zooming into Data Dictionary
Data Dictionary contains a sublevel tab in which you manage the fields included in a selected table.
The Fields Tab
The Fields tab displays a list of all the fields included in the selected table and their descriptions.

Field/Column Descriptions
The following table describes the fields and columns used in the Data Dictionary Fields tab.
|
Field/Column |
Description |
|
Field Name |
Name of the field |
|
Description |
Text description of the field |
|
Type |
Sybase or company-defined type |
|
Length |
Length of field, in bytes. |
|
Allow Null |
Enter a check mark in this field to allow null values. |
Button Functions
The following table displays the buttons, describes the shortcut keys, actions, and functionality.
|
Button |
Name |
Shortcut Key |
Action |
Description |
|
|
Get |
ALT+F1 |
1819/ 1 |
Get record. |
|
|
Change |
F2 |
1819/ 2 |
Change selected record. |
|
|
New |
F3 |
1819/ 3 |
Create new record. |
|
|
Delete |
SHIFT+F10 |
1819/ 4 |
Delete selected record. |
|
|
Undelete |
ALT+F10 |
1819/ 5 |
Restore deleted record. |
|
|
|
CTRL+F8 |
1819/ 6 |
Print selected records. |
|
Details |
1819/ 10 |
|||
|
|
Get |
ALT+F1 |
1819/ 11 |
Get record. |
|
|
Change |
F2 |
1819/ 12 |
Change selected record. |
|
|
New |
F3 |
1819/ 13 |
Create new record. |
|
|
Delete |
SHIFT+F10 |
1819/ 14 |
Delete selected record. |
|
|
Undelete |
ALT+F10 |
1819/ 15 |
Restore deleted record. |
|
|
|
CTRL+F8 |
1819/ 16 |
Print selected records. |
|
|
Previous |
F4 |
1819/ 999 |
Select last record. |
|
|
Next |
F5 |
1819/ 999 |
Select next record. |
|
|
Zoom |
F10 |
1819/ 999 |
Zoom in/out of sublevel. |
|
|
Tear |
[ ] |
1819/ 999 |
Open the Details tab in a full-sized separate window. |
Modifications and Updates to Data Dictionary
The following table lists modifications and updates to the Data Dictionary document.
|
Mod Number |
Date |
Description |
|
n/a |
8/18/14 |
Images updated. |









