File Information

Database Validation File

This file is created manually with a text editor and is used by the dbdchk program.

*
* SPECIFICATION FILE FOR Validatiion of Geological/Analytical DATA
*
* NPC/NEWLANDS TOTAL Geological Validation
*
* global specs
BEGIN$DEF GLOBAL
        SYSTEM_SYNONYM_NAME = 'GEO'
        NO_RELOAD_SAME_HOLE
        UNIQUE_LOCATION
        TOTAL_DEPTH_MATCH
END$DEF GLOBAL
* head1 record
BEGIN$DEF HEAD1_HOLEID
        MANDATORY
        FATAL
END$DEF HEAD1_HOLEID
BEGIN$DEF HEAD1_HOLTYP
        MANDATORY
        TRANSLATE
END$DEF HEAD1_HOLTYP
BEGIN$DEF HEAD1_PROJ
        MANDATORY
        TRANSLATE
        FATAL
END$DEF HEAD1_PROJ
* HEADER record
BEGIN$DEF HEADER_ORGN
        MANDATORY
        TRANSLATE
END$DEF HEADER_ORGN
BEGIN$DEF HEADER_HOLEID
        MANDATORY
END$DEF HEADER_HOLEID
BEGIN$DEF HEADER_HOLTYP
        MANDATORY
        TRANSLATE
END$DEF HEADER_HOLTYP
BEGIN$DEF HEADER_GRID
        TRANSLATE
END$DEF HEADER_GRID
BEGIN$DEF HEADER_EAST
        MINIMUM=592000.0
        MAXIMUM=597000.0
        FATAL
END$DEF HEADER_EAST
BEGIN$DEF HEADER_NORTH
        MINIMUM=7648000.0
        MAXIMUM=7657000.0
        FATAL
END$DEF HEADER_NORTH
BEGIN$DEF HEADER_ACC
        MANADATORY
        TRANSLATE
END$DEF HEADER_ACC
BEGIN$DEF HEADER_DATUM
        TRANSLATE
END$DEF HEADER_DATUM
BEGIN$DEF HEADER_COLLAR
        MINIMUM=2100.00
        MAXIMUM=2500.00
        FATAL
END$DEF HEADER_COLLAR
BEGIN$DEF HEADER_TOTDEP
        MANDATORY
END$DEF HEADER_TOTDEP
BEGIN$DEF HEADER_START
        MANDATORY
        DATE = DDMMYY
END$DEF HEADER_START
BEGIN$DEF HEADER_FINISH
        MANDATORY
        DATE = DDMMYY
END$DEF HEADER_FINISH
* logger record
BEGIN$DEF LOGGER_LOGORG
        MANDATORY
        TRANSLATE
END$DEF LOGGER_LOGORG
BEGIN$DEF LOGGER_LOGGED
        MANDATORY
END$DEF LOGGER_LOGGED
BEGIN$DEF LOGGER_DRLCNT
        MANDATORY
        TRANSLATE
END$DEF LOGGER_DRLCNT
BEGIN$DEF LOGGER_GEOPH
        TRANSLATE
END$DEF LOGGER_GEOPH
BEGIN$DEF LOGGER_CORE
        MANDATORY
END$DEF LOGGER_CORE
BEGIN$DEF LOGGER_FLUID
        TRANSLATE
END$DEF LOGGER_FLUID
BEGIN$DEF LOGGER_PROJ
        TRANSLATE
END$DEF LOGGER_PROJ
* litho record
BEGIN$DEF LITHO_RCKTYP
        MANDATORY
        TRANSLATE
END$DEF LITHO_RCKTYP
BEGIN$DEF LITHO_SHADE
        TRANSLATE
END$DEF LITHO_SHADE
BEGIN$DEF LITHO_COL1
        TRANSLATE
END$DEF LITHO_COL1
BEGIN$DEF LITHO_COL2
        TRANSLATE
END$DEF LITHO_COL2
BEGIN$DEF LITH0_GSZ
        TRANSLATE
END$DEF LITHO_GSZ
BEGIN$DEF LITHO_LITAD1
        TRANSLATE
END$DEF LITHO_LITAD1
BEGIN$DEF LITHO_LITAD2
        TRANSLATE
END$DEF LITHO_LITAD2
BEGIN$DEF LITHO_THICK
        MINIMUM=0.0
END$DEF LITHO_THICK
BEGIN$DEF LITHO_BOTINT
        INCREASING
END$DEF LITHO_BOTINT
BEGIN$DEF LITHO_STFLAG
        TRANSLATE
END$DEF LITHO_STFLAG
BEGIN$DEF LITHO_STRAT
        TRANSLATE
        BEGIN$TAB ORDER
          'QUA'
          'TEB'
          'TES'
          'REW'
          'PEO'
          'UNS'
          'INT'
          'LNS'
          'LNF'
          'FCM'
         END$TAB ORDER
END$DEF LITHO_STRAT