This view does not represent data actually stored on the database. It constitutes a conceptual table that enumerates all possible values of some other column. This conceptual table can be used to:
Translate a value into its human readable description
Cross join other tables to ensure
that all combinations are present in a result set
This particular view maps organisation types (see view idvOrganisation).
This view is only suitable for advanced users. It is an enumeration of constants for use in cross joins.
Type |
The organisation type as it appears in view idvOrganisation (and derivations thereof |
Description |
Human readable description of the value |