station_number	A six-digit number normally referred to as the "MEDS" station number. Presently "MEDS" station numbers are only 5 digits, the six digit field will allow for future expansion.	NUMBER (6) Foreign Key
account	This field is system set with user account info for update and delete privileges.	VARCHAR2 (16)
datum_of_elevations_id	Autogenerated Unique Number.	VARCHAR2 (16)
DBE_TIME	Database Entry Time - System set.	DATE
DBU_TIME	Database Update Time - System set.	DATE
status	A field to indicate the status of this datum of elevations, either "Active" or "Historical".	VARCHAR2 (16) Mandatory check list
elevation	The magnitude in metres of the "datum of elevations". A 6-digit number with 3 decimal point precision. **On output, this value will be rounded to 2 decimal point precision.	NUMBER (7,3) Mandatory
epoch	This is a 4-digit number that will indicate the year this datum of elevations was established.	NUMBER (4) Mandatory Default value 9999
de_name	A 16-character field to indicate the name that will be associated with this datum of elevations.	VARCHAR2 (16) Mandatory
de_ref_datum	A 16-character field to indicate the datum to which this datum of elevations is referred.	VARCHAR2 (16) Mandatory
memo	A 2000 character field to inlude text comments regarding the datum of elevations. Examples of these comments would be how the datum of elevations was established.	VARCHAR2 (2000) Optional

Note: For a particular station number there can be several entries for datum of elevations although only one can be active. This will be handled by a system function.

Tables and Columns