 |
|
|
|
        |
|
||
MagIC Help Library |
|
|
|
 |
|
||
|
|
|
|
|
|
||
MagIC Help Library |
|
|
|
|
|
||
3.1.3 MagIC Table Layout
Each table is divided into several pre-titled columns. The first Five rows of each column characterize the data to be entered below the headings. The first row gives the Label of the column and describes the data to be entered (explanation in plain English). The second row displays the Oracle Variable Name associated to these data in the relational database and used by the MagIC Console Software. The third row indicates the Data Type and maximum length of text strings. The fourth row shows the expected Unit of the data. The fifth row indicate the Status of the data to show whether the data is required, recommended or optional. All five heading rows are fixed in the MagIC Data and Metadata definition, which is strictly maintained and versioned.
Upon opening a SmartBook in the MagIC Console Software they will be used to check the validity of the tables and columns residing in the Microsoft Excel© File.
See also ...
Contents MagIC Chapter 3 MagIC Console Software Topic 3.1.1 What is a SmartBook? Topic 3.1.2 Structure of the MagIC SmartBooks Topic 3.1.4 Standard MagIC Text File Format Topic 3.1.5 Software Installation
|
|
|