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 |
|
|
|