Table: REGION

REGION

Name

REGION

Comment

REGION sets out valid region IDs.


Description

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.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

REGIONID


Index Columns

Name

LASTCHANGED


Content

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