RU.CAT
RUCT
CATALOGUE
ALL
CATALOGUE OF ALL OF THE TABLES IN THE DATABASE, THEIR USE, SUBSYSTEM, PRIMARY AND FOREIGN KEYS
N
NO
RULINKS.CAT
RULINKCT
LINKS CATALOGUE FOR THE ROCKUNIT AND REFERENCE SYSTEMS
FROMFILE
Y
TOFILE
CN.DAT
CNDT
DATA
CONTACT
MASTER CONTACT DATA TABLE
CONTNO-ID2
CONTNO_ID2
CONTNO
CNDF
CN.POO
CNPO
HOUSEKEEPING
NUMBER POOL FOR DELETED CONTACT NUMBERS OF NEX AVAILABLE COTNTACT NUMBER, CONTNO
CNXREF.DAT
CNXREFDT
INTERSECTION TABLE LINKING BIBLIOGRAPHIC SYSTEM TO SPECIFIC CONTACT SEGMENTS
REFNO
AUTHORS.DAT
AUTHORDT
REFERENCE
AUTHOR TABLE FOR THE REFERENCE SYSTEM
REFNO-RANK
AUTHORS.DEF
AUTHORDF
FILSRC.DAT
FILSRCDT
EXTRA REFERENCE DETAILS FOR EACH DATA SOURCE OF A DIGITAL FILE FORMAT
FILSRC.DEF
FILSRCDF
MAPSRC.DAT
MAPSRCDT
EXTRA REFERENCE DETAILS FOR  EACH DATA SOURCE OF MAP FORMAT
MAPSRC.DEF
MAPSRCDF
PAPSRC.DAT
PAPSRCDT
EXTRA REFERENCE DETAILS FOR EACH DATA SOURCE OF ARTICLE FORMAT
PAPSRC.DEF
PAPSRCDF
REF.POO
REFPO
NUMBER POOL WHICH STORES THE NEXT AVAILABLE INTEGER REFNO FOR REFERENCES
REFMAIN.DAT
REFMAIDT
MASTER REFERENCE TABLE FOR THE REFERENCE SYSTEM
REFMAIN.DEF
REFMAIDF
REPSRC.DAT
REPSRCDT
EXTRA REFERENCE DETAILS FOR EACH DATA SOURCE OF REPORT STYLE
REPSRC.DEF
REPSRCDF
SVOLSRC.DAT
SVOLSRDT
EXTRA DETAILS FOR REFERENCES OF SYMPOSIUM VOLUME (OR PROCEEDINGS) FORMAT
SVOLSRC.DEF
SVOLSRDF
SYMSRC.DAT
SYMSRCDT
EXTRA REFERENCE DETAILS FOR EACH DATA SOURCE OF SYMPOSIUM ARTICLE FORMAT
SVOLNO
SYMSRC.DEF
SYMSRCDF
VOLSRC.DAT
VOLSRCDT
EXTRA REFERENCE DETAILS FOR EACH DATA SOURCE OF VOLUME FORMAT
VOLSRC.DEF
VOLSRCDF
AUREOLE.DAT
AUREOLDT
ROCKUNIT
AUREOLE DESCRIPTION FOR GIVEN INTRUSIVE ROCK UNIT COMPONENT
RUNO-ID2-COMPNO
RUNID2CNO
AUREOLE.DEF
AUREOLDF
YES
FIELD DEFINITIONS
FIELD DESCRIPTIONS FOR THE TABLE AUREOLE.DAT
FIELDNAME
AUREOLE.PMT
AUREOLPT
DOMAIN DEFINITION
VALID CHARACTER CODES FOR FIELD AUREOLE IN TABLE INTRUSIV.DAT
AUREOLE
CARBFORM.DAT
CARBFODT
GENERAL FORM OF CARBON IN CARBONACEOUS UNITS SUCH AS BLACK SHALES
RUNO-ID2
CARBFORM.DEF
CARBFODF
FIELD DEFINITIONS FOR ITEMS IN CARBFORM.DAT
CARBFORM.PMT
CARBFOPT
PERMITTED VALUES FOR THE FIELD CARBFORM IN CARBFORM.DAT
CARBFORM
CHEMGRP.PMT
CHEMGRPT
VALID MAGMA SERIES DESCRIPTORS FOR FIELD CHEMGRP IN TABLES INTRUSIV.DAT AND VOLCANIC.DAT
CHEMGRP
CHREGIME.DAT
CHREGIDT
CHEMICAL ENVIRONMENT OF DEPOSITION, EG., ANOXIC
CHREGIME.DEF
CHREGIDF
FIELD DEFINITIONS FOR ITEMS IN CHREGIME.DAT
CHREGIME.PMT
CHREGIPT
PERMITTED VALUES FOR ITEM CHREGIME IN CHREGIME.DAT
CHREGIME
CLUSTERS.PMT
CLUSTEPT
VALID CHARACTER CODES FOR FIELD CLUSTERS IN TABLE INTRUSIV.DAT
CLUSTERS
COAL.PMT
COALPT
VALID CHARACTER CODES FOR FIELD COAL IN TABLE SEDIMENT.DAT
COAL
COMMODIT.PMT
COMMODPT
PERMITTED VALUES FOR FIELD COMMODITY IN RUMIN.DAT
COMMODITY
CRYSTALL.DAT
CRYSTADT
GENERAL DESCRIPTION OF  METAMORPHIC COMPONENTS OF ROCK UNIT ENTITIES
CRYSTALL.DEF
CRYSTADF
FIELD DEFINITIONS FOR TABLE CRYSTALL.DAT
DATED.DAT
DATEDDT
RADIOMETRIC AGE DATE WITH ERRORS, METHODS, AND MATERIAL DATED FROM ONE REFERENCE
DATED.DEF
DATEDDF
FIELD DEFINTIIONS FOR THE TABLE DATED.DEF
DATED.PMT
DATEDPT
VALID CHARACTER CODES FOR ITEM DATED
DATED
DEPSET.PMT
DEPSETPT
VALID TERMS FOR FIELD DEPSET IN TABLE VOLCANIC.DAT
DEPSET
DEPTHSET.PMT
DEPTHSPT
PERMITTIED VALUES FOR FIELD DEPTHSET IN TABLE RUSET.DAT
DEPTHSET
DPREGIME.DAT
DPREGIDT
DESCRIPTORS OF SEDIMENTARY DEPOSITIONAL REGIME OR ENVIRONMENT
DPREGIME.DEF
DPREGIDF
FIELD DEFINITIONS FOR TABLE DPREGIME.DAT
DPREGIME.PMT
DPREGIPT
PERMITTED SEDIMENTARY REGIME DESCRIPTORS FOR FIELD DPREGIME
DPREGIME
EVAPOR.PMT
EVAPORPT
VALID CHARACTER CODES FOR FIELD EVAPOR IN TABLE SEDIMENT.DAT
EVAPOR
GEOGSET.PMT
GEOGSEPT
PERMITTED VALUES FOR FIELD GEOGSET IN TABLE RUSET.DAT
GEOGSET
INCLUS.DAT
INCLUSDT
DESCRIPTION OF INCLUSION SUITE IN GIVE INTRUSIVE UNIT COMPONENT
INCLUS.DEF
INCLUSDF
FIELD DEFINITIONS FOR THE TABLE INCLUS.DEF
INCLUS.PMT
INCLUSPT
VALID CHARACTER CODES FOR FIELD INCLUS IN TABLE INTRUSIV.DAT
INCLUS
INTCLASS.PMT
INTCLAPT
VALID INTRUSIVE PACKAGE CLASSIFICATIONS  IN FORM OF SUITE OR COMMON ASSOCIATION NAMES
INTCLASS
INTEQUIV.PMT
INTEQUPT
VALID CHARACTER CODES FOR FIELD INTEQUIV IN TABLE VOLCANIC.DAT
INTEQUIV
INTFORM.DAT
INTFORDT
DESCRIPTORS OF OVERALL INTRUSIVE FORM
INTFORM.DEF
INTFORDF
FIELD DEFINITIONS FOR TABLE INTFORM.DAT
INTFORM.PMT
INTFORPT
PERMITTED EXTERNAL SHAPE DESCRIPTORS FOR FIELD INTFORM IN TABLE INTFORM.PMT
INTFORM
INTMEM.DAT
INTMEMDT
INTRUSIVE ROCK NAMES FOR INTRUSIVE ROCK UNIT COMPONENT
INTMEM.DEF
INTMEMDF
FIELD DEFINITIONS FOR TABLE INTMEM.DAT
INTMEM.PMT
INTMEMPT
PERMITTED INTRUSIVE ROCK NAMES FOR FIELD INTMEM IN TABLE INTMEM.DAT
INTMEM
INTRUSIV.DAT
INTRUSDT
DESCRIPTION OF INTRUSIVE COMPONENTS OF ROCK UNIT ENTITIES
INTRUSIV.DEF
INTRUSDF
FIELD DEFINITIONS FOR TABLE INTRUSIV.DAT
INTSTRUC.DAT
INTSTRDT
DESCRIPTORS OF INTERNAL INTRUSIVE STRUCTURES
INTSTRUC.DEF
INTSTRDF
FIELD DEFINITIONS FOR TABLE INTSTRUC.DAT
INTSTRUC.PMT
INTSTRPT
PERMITTED INTERNAL STRUCTURE DESCRIPTORS FOR FIELD INTSTRUC IN TABLE INTSTRUC.DAT
INTSTRUC
MAFRANGE.PMT
MAFRANPT
VALID TERMS FOR THE FIELD MAFICRANGE, THE MAIN VOLCANIC CLASSIFIER IN THE TABLE VOLCANIC.DAT
MAFRANGE
METCLASS.PMT
METCLAPT
VALID METAMORPHIC ROCK GROUP CLASSIFIERS FOR THE FIELD METCLASS IN TABLE CRYSTALL.DAT
METCLASS
METGRADE.PMT
METGRAPT
VALID METAMORPHIC ROCK GRADE DESIGNATORS FOR THE FIELD METGRADE IN CRYSTALL.DAT
METGRADE
METMEM.DAT
METMEMDT
METAMORPHIC ROCK NAMES FOR CRYSTALLINE ROCK UNIT ENTITY COMPONENTS
METMEM.DEF
METMEMDF
FIELD DEFINITIONS FOR TABLE METMEM.DAT
METMEM.PMT
METMEMPT
PERMITTED METAMORPHIC ROCK NAMES FOR FIELD METMEM IN TABLE METMEM.DAT
METMEM
METSED.DAT
METSEDDT
CLASS AND HOST OF METALLIFEROUS SEDIMENT PRESENT IN METSED-BEARING ROCK TYPE COMPONENTS
METSED.DEF
METSEDDF
FIELD DEFINITIONS FOR THE TABLE METSED.DAT
METSED.PMT
METSEDPT
VALID CHARACTER CODES FOR ITEM METSED  IN TABLES VOLCANIC.DAT, SEDIMENT.DAT, AND CRYSTALL.DAT
METSED
MSEDCLASS.PMT
MSEDCLPT
PERMITTED ENTRIES FOR VALUES UNDER MSEDCLASS IN METSED.DAT
MSEDCLASS
MSEDHOST.PMT
MSEDHOPT
PERMITTED ENTRIES FOR VALUES UNDER MSEDHOST IN METSED.DAT
MSEDHOST
OIL.PMT
OILPT
VALID CHARACTER CODES FOR FIELD OIL IN SEDIMENT.DAT
OIL
PRIMOREP.PMT
PRIMORPT
IS DEPOSITIONAL ENVIRONMENT POST- OR SYN-DEPOSITIONAL
PRIMOREP
PRISEQ.DAT
PRISEQDT
PROVINCE
TECTONIC DOMAINS OR PROVINCES WHICH ARE EQUIVALENT
PROVNO
ISEQNO
PRISEQ.DEF
PRISEQDF
PRISIN.DAT
PRISINDT
WHAT LARGER GEOLOGICAL BELT OR PROVINCE GROUPING THE PROVINCE IS ENCOMPASSED BY
ISINNO
PRISIN.DEF
PRISINDF
PROTOLIT.DAT
PROTOLDT
TECTONIC PROTOLITHS
PROTOLIT.DEF
PROTOLDF
FIELD DEFINTIONS FOR THE TABLE PROTOLIT.DAT
PROTOLITH.PMT
PROTOLPT
VALUES FOR FIELD PROTOLITH IN TABLE PROTOLITH.DAT
PROTOLITH
REALM.PMT
REALMPT
PROVINCE-ROCKUNIT
PERMITTED VALUES FOR FIELD REALM IN TABLES PROVINCE.DAT AND RUSET.DAT
REALM
RU.DAT
RUDT
MASTER ROCK UNIT ENTITY TABLE CARRYING INPUT CODES FROM SOURCE, ONSHORE-OFFSHORE DISTINCTION, AND WHETHER THE ENTITY IS THE DISPLAY DEFAULT
RUNO_ID2
RUNO
RU.DEF
RUDF
FIELD DEFINITIONS FOR TABLE RU.DAT
RU.POO
RUPO
STORES THE POLYGON PORTION OF THE ENTITY  NUMBERS OF DELETED COVERAGE FEATURES FOR REUSE AS WELL AS THE NEXT AVAILABLE INTEGER KEY
RUAGE.DAT
RUAGEDT
TIME STRATIGRAPHIC AGE FOR EACH POLYGON DATA SET, CLASSIFIED ACCORDING TO ACCEPTED TIME SCALE
STARTAGECAT
RUAGE.DEF
RUAGEDF
FIELD DEFINITIONS FOR TABLE RUAGE.DAT
RUMIN.DAT
RUMINDT
COMMODITIES KNOWN TO EXIST IN THE ROCKUNIT ENTITY
RUMIN.DEF
RUMINDF
FIELD DEFINITIONS FOR TABLE RUMIN.DAT
RUNAME.DAT
RUNAMEDT
FORMATION, GROUP, MEMBER OR SUITE NAME TO WHICH INDIVIDUAL ROCK UNIT ENTITIES ARE ASSIGNED
UNITNAME
RUNAME.DEF
RUNAMEDF
FIELD DEFINITIONS FOR TABLE RUNAME.DAT
RUPROV.DAT
RUPROVDT
GEOLOGICAL  PROVINCE, ZONE, OR BELT TO WHICH EACH ROCK UNIT ENTITY BELONGS
PROVZONE
RUPROV.DEF
RUPROVDF
FIELD DEFINITIONS FOR TABLE RUPROV.DAT
RUSET.DAT
RUSETDT
GEOLOGOCAL SETTING PARAMETERS
RUSET.DEF
RUSETDF
FIELD DEFINITIONS FOR TABLE RUSET.DAT
RUTYPE.DAT
RUTYPEDT
HIGHEST LEVEL CLASSIFICATION OF MAJOR ROCK TYPE FOR INDIVIDUAL COMPONENTS OF EACH ROCK UNIT ENTITY
RUTYPE.DEF
RUTYPEDF
FIELD DEFINITIONS FOR TABLE RUTYPE.DAT
RUXREF.DAT
RUXREFDT
INTERSECTION TABLE LINKING ROCKUNIT ENTITIES WITH SPECIFIC REFERENCES, INDICATING WHAT TYPE OF DATA WAS DERIVED FOR EACH ENTITY FROM THE REFERENCE
RUXREF.DEF
RUXREFDF
FIELD DEFINITIONS FOR THE TABLE RUXREF.DAT
RXTP.PMT
RXTPPT
VALID ENTRIES FOR THE FIELD RXTp IN RUTYPE.DAT
RXTP
RXTPSTAT.PMT
RXTPSTPT
VALID ENTRIES FOR THE FIELD RXTYPESTAT IN RUTYPE.DAT
RXTPSTAT
SEDCLASS.PMT
SEDCLAPT
VALID EXPRESSIONS FOR BROADLY DESCRIPTIVE SEDIMENTARY PACKAGES, OR COMMON ASSOCIATIONS
SEDCLASS
SEDIDX.DAT
SEDIDXDT
INDEX LEVEL INVENTROY OF WHICH GENERAL CLASSES OF SEDIMENT TYPE OR PROPERTY ARE PRESENT OR ABSENT
SEDIDX.DEF
SEDIDXDF
FIELD DEFINITIONS FOR ITEMS IN SEDIDX.DAT
SEDIMENT.DAT
SEDIMEDT
DESCRIPTION OF THE SEDIMENTARY COMPONENTS  OF ROCK UNIT ENTITIES
SEDIMENT.DEF
SEDIMEDF
FIELD DEFINITIONS FOR TABLE SEDIMENT.DAT
SEDMEM.DAT
SEDMEMDT
SEDIMENTARY ROCK NAMES FOR SEDIMENTARY ROCK UNIT ENTITY COMPONENTS
SEDMEM.DEF
SEDMEMDF
FIELD DEFINITIONS FOR TABLE SEDMEM.DAT
SEDMEM.PMT
SEDMEMPT
PERMITTED SEDIMENTARY ROCK NAMES FOR FIELD SEDMEM IN TABLE SEDMEM.DAT
SEDMEM
SEDSTRUC.DAT
SEDSTRDT
SEDIMENTARY STRUCTURES
SEDSTRUC.DEF
SEDSTRDF
FILED DEFINITIONS FOR THE TABLE SEDSTRUC.DAT
SEDSTRUC.PMT
SEDSTRPT
PERMITTED INTERNAL STRUCTURE DESCRIPTORS FOR THE FIELD SEDSTRUC IN SEDSTRUC.DAT
SEDSTRUC
SHALE.DAT
SHALEDT
DATA NEEDED FOR GLOBAL INVENTORY OF SHALES AND BLACK SHALES
SHALE.DEF
SHALEDF
FIELD DEFINITIONS FOR ITEMS OF SHALE.DAT
TECCLASS.PMT
TECCLAPT
VALID CLASSIFICATION TERMS FOR THE FIELD TECCLASS IN TABLE TECTONIC.DAT
TECCLASS
TECMEM.DAT
TECMEMDT
TECTONIC ROCK NAMES FOR TECTONIC ROCK UNIT ENTITY COMPONENTS
TECMEM.DEF
TECMEMDF
FIELD DEFINITIONS FOR TABLE TECMEM.DAT
TECMEM.PMT
TECMEMPT
PERMITTED TECTONIC ROCK NAMES FOR FIELD TECMEM IN TABLE TECMEM.DAT
TECMEM
TECSET.PMT
TECSETPT
PERMITTED VALUES FOR FIELD TECSET IN TABLE RUSET.DAT
TECSET
TECTONIC.DAT
TECTONDT
DESCRIPTION OF THE TECTONIC COMPONENTS OF ROCK UNIT ENTITIES
TECTONIC.DEF
TECTONDF
FIELD DEFINITIONS FOR TABLE TECTONIC.DAT
THUNITS.PMT
THUNITPT
THICKNESS UNITS FOR THUNITS IN SEDTHICK.DAT
THUNITS
UNISEQ.LUT
UNISEQLT
LOOKUP
UNIT DOMAINS OR UNITNAMES WHICH ARE EQUIVALENT
ISEQ
UNISIN.LUT
UNISINLT
GROUP OR HIGHER LEVEL UNIT TO WHICH EACH UNITNAME BELONGS, IF ANY
ISIN
VOLCANIC.DAT
VOLCANDT
DESCRIPTION OF THE VOLCANIC COMPONENTS OF ROCK UNIT ENTITIES
VOLCANIC.DEF
VOLCANDF
FIELD DEFINITIONS FOR TABLE VOLCANIC.DAT
VOLEQUIV.PMT
VOLEQUPT
VALID CHARACTER CODES FOR FIELD VOLEQUIV IN TABLE INTRUSIV.DAT
VOLEQUIV
VOLFORM.DAT
VOLFORDT
DESCRIPTORS OF OVERALL VOLCANIC FORM
VOLFORM.DEF
VOLFORDF
FIELD DEFINITIONS FOR TABLE VOLFORM.DAT
VOLFORM.PMT
VOLFORPT
PERMITTED EXTERNAL SHAPE DESCRIPTORS FOR FIELD VOLFORM IN TABLE VOLFORM.DAT
VOLFORM
VOLMEM.DAT
VOLMEMDT
VOLCANIC ROCK NAMES FOR THE ROCK UNIT ENTITY - ROCK TYPE COMPONENT
VOLMEM.DEF
VOLMEMDF
FIELD DEFINITIONS FOR TABLE VOLMEM.DAT
VOLMEM.PMT
VOLMEMPT
PERMITTED VOLCANIC ROCK NAMES FOR THE FIELD VOLMEM IN TABLE VOLMEM.DAT
VOLMEM
VOLSTRUC.DAT
VOLSTRDT
DESCRIPTORS OF INTERNAL VOLCANIC STRUCTURES
VOLSTRUC.DEF
VOLSTRDF
FIELD DEFINITIONS FOR TABLE VOLSTRUC.DAT
VOLSTRUC.PMT
VOLSTRPT
PERMITTED INTERNAL STRUCTURE DESCRIPTORS FOR FIELD VOLSTRUC IN TABLE VOLSTRUC.DAT
VOLSTRUC
UPDATE.DAT
UPDATEDT
UPDATE
MAINTAINS LIST OF UPDATE INFORMATION, INCLUDING DATES AND TYPES OF DATA MODIFICATION
UPDNO
UPDATE.POO
UPDATEPO
NUMBER POOL WHICH STORES THE NEXT AVAILABLE INTEGER FOR AN UPDATE SESSION
MINCLASS.PMT
MINCLAPT
PERMITTED VALUE FOR BROAD CATEGORY OF MINERALIZATION IN RUMIN.DAT
MINCLASS
SRCTP.PMT
SRCTPPT
REFERENCE SOURCE TYPE, WITH DIFFERENT SOURCE DETAILS
SRCTP
FIELD DEFINITIONS FOR AUTHORS.DAT
FIELD DEFINITIONS FOR FILSRC.DAT
FIELD DEFINITIONS FOR TABLE FILSRC.DAT
FIELD DEFINITIONS FOR TABLE PAPSRC.DAT
FIELD DEFINITIONS FOR TABLE REFMAIN.DAT
FIELD DEFINITIONS FOR TABLE REPSRC.DAT
FIELD DEFINITIONS FOR TABLE SVOLSRC.DAT
FIELD DEFINITIONS FOR VOLSRC.DAT
PROVINCE.DAT
PROVINDT
PROVINCE (BASIN/BELT/OROGEN/PLATFORM) CLASSIFICATION AND AGE RANGE
PROVINCE.DEF
PROVINDF
PRXREF.DAT
PRXREFDT
INTERSECTION TABLE DEFINING RELATIONSHIPS BETWEEN PROVINCES AND REFERENCES
PRXREF.DEF
PRXREFDF
FIELD DEFINITIONS FOR THE TABLE PRXREF.DAT
FIELD DEFINITIONS FOR THE TABLE PROVINCE.DAT
PROVRU.DAT
PROVRUDT
ROCKUNIT-PROVINCE
INTERSECTION TABLE DEFINING RELATIONSHIPS BETWEEN ROCK UNIT ENTITIES AND PROVINCES
PROVRU.DEF
PROVRUDF
FIELD DEFINITIONS FOR THE INTERSECTION TABLE PROVRU.DAT
PROVBASE.PMT
PROVBAPT
PERMITTED VALUES FOR THE FIELD PROVBASE IN THE TABLE PROVINCE.DAT
PROVBASE
PROVTYPE.PMT
PROVTYPT
PERMITTED VALUES FOR THE FIELD PROVTYPE IN TABLE PROVINCE.DAT
PROVTYPE
PROVNAME.FQ
PROVNAFQ
UTILITY
EXISTING PROVINCE NAMES IN TABLE PROVINCE.DAT FOR FILTER PURPOSES
PROVNAME
FIELD DEFINITIONS FOR THE TABLE PRISIN.DAT
FIELD DEFINITIONS FOR THE TABLE PRISEQ.DAT
PRQUALIF.PMT
PRQUALPT
PERMITTED VALUES FOR THE FIELD PRQUALIF IN PROVINCE.DAT
PRQUALIF
GAS.PMT
GASPT
PERMITTED VALUES FOR THE FIELD GAS IN SEDIMENT.DAT
GAS
PHOSPH.PMT
PHOSPHPT
PERMITTED VALUES FOR THE FIELD PHOSPHAT IN SEDIMENT.DAT
PHOSPH
AGETSMA.LUT
AGETSMLT
AGES AND AGE QUALIFIERS IN TERMS OF THE CHRONOSTRATIC SCALE WITH ACCEPTED BOUNDARIES IN MA
AGEDES-AGEQU
AGEDESCAT