|
Name |
|
|
Comment |
REGION sets out valid region IDs. |
|
REGION data is public, so is available to all participants. Source REGION updates if a change is ever made to a region. This table is static data and is likely to change very infrequently. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Public |
|
Name |
|
REGIONID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
REGIONID |
VARCHAR2(10) |
X |
Differentiates this region from all other regions |
|
DESCRIPTION |
VARCHAR2(64) |
|
Full description of region |
|
REGIONSTATUS |
VARCHAR2(8) |
|
Status of the region e.g. working, inactive, archive. |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
|
|