Schema of Views¶
The Schema tab contains information about the fields of the view.
For each field, it provides:
PK. The icon is showed if the field is a primary key.
Its name.
Its logical name. This column is only visible when the configuration option Allow logical names for view fields is enabled. If you have the proper permissions, you can edit the logical name clicking its icon.
Its type.
Its assigned tags. To navigate to the details of a tag, just click its name. This column is only visible when there are VDP tags imported.
A description in plain text. At first, it is obtained from Virtual DataPort. However, if you have the proper permissions, you will see a icon next to the description. Click it and define a new description, which will be specific to the Data Catalog.
Nullable. The icon is showed if the field can be null.
Optionally, three additional columns related to the native datasource field type can be displayed if “Additional columns” is checked.
Source Type. The type of the field in the source. E.g.
VARCHAR
,NCHAR
,INTEGER
,BIGINT
, etc.Type Size. Its meaning depends on the type of the field.
For fields of type
text
, it indicates the maximum length of the field.For numeric types, the maximum precision.
For values without decimals (
int
andlong
), this number is0
.
Type Decimals. The number of decimals for fields of type
decimal
,0
otherwise.
Note
This tab shows the current schema in Virtual DataPort, but if a description was modified for a field in Data Catalog this description will be shown. Only synchronized fields can be edited.
If changes are made in Virtual DataPort after you have logged in, you may need to reload the browser or start a new session in order to the changes to take effect as this information is cached in the web application.