Description of the Contents of NCIS Tables

TABLE_NAME COLUMN_NAME COMMENTS
ACCESS_TYPE_CODES ACCESS_ID Unique identifier
ACCESS_DESC Description associated with access id
ACCURACY_CODES ACCURACY_ID Unique identifier
DESCRIPTION Description associated with accuracy id
ADR_MASTER ADR_ID Unique identifier
TEAM_MEMBER_ID Unique identifier
QUERY_ID Unique identifier
SERVER_ADDRESS Address of the server
REQUEST_TYPE Type of request
SUMMARY Summary
STATUS Status
SUBMITTED_DT Date Submitted
COMPLETED_DT Date Completed
INTENT Intent
LATITUDE_MIN Minimum latitude
LATITUDE_MAX Maximum Latitude
LONGITUDE_MIN Minimum Longitude
LONGITUDE_MAX Maximum Longitude
DATE_MIN Minimum Date
DATE_MAX Maximum Date
ADR_STATE Adr state
NEW_FLG New Flag?
REMOTE_ADR_ID Remote address id
ANALYSIS_METHODS ANALYSIS_METHOD_ID System generated unique identifier for analysis method.
NAME_E Instance within a class e.g. Gas Chromatography (English)
CLASS_E General descriptor e.g. Chromatography (English)
NAME_F Instance within a class e.g. Chromatographie (French)
CLASS_F General descriptor e.g. Chromatographie (French)
ARCHIVE_FILES ARCHIVE_FILE_ID Unique identifier
FILENAME Name of file
ARCHIVE_SIZE Size of archive
CONTENTS Contents
ARCHIVE_SOURCES ARCHIVE_SOURCE_ID System generated unique identifier for an archive.
ORGANIZATION_ID Unique system generated identifier.
SHORT_NAME Short name of the archive e.g. CTD.
FULL_NAME The complete name of the archive.
ADDRESS Network address of the archive e.g. nod:[dir]filename
NETWORK_PROTOCOL e.g. DECnet or TCP/IP.
BIOLOGICAL_RESPONSE_CLASSES BIO_RESP_CLASS_ID Unique system generated identifier.
CLASS_E A protocol of the specific response e.g. respiration, feeding (English)
CLASS_TYPE_E The general type of the response e.g. physiological, behavioural (English)
CLASS_F A protocol of the specific response e.g. respiration, feeding (French)
CLASS_TYPE_F The general type of the response e.g. physiological, behavioural (French)
CLASS_DESCRIPTION_E The full description of the class (English)
CLASS_DESCRIPTION_F The full description of the class (French)
CLASS_TYPE_DESCRIPTION_E The description of the type of the class (English)
CLASS_TYPE_DESCRIPTION_F The description of the type of the class (French)
BULLETIN_BOARD BULLETIN_ID Unique identifier
SUBJECT Topic
BULLETIN_DT Date of bulletin
CONTRIBUTOR Contributor
INVENTORY Inventory
CONTENTS Contents
CONSTITUENTS CONSTITUENT_ID System generated identifier uniquely identifying a constituent.
GROUP_ID Unique system generated identifier.
NAME_E The name of the constituent (English)
FULLNAME_E The complete name of the constituent (English)
CAS_NUMBER The Chemical Abstracts Service System Registry constituent number
NAME_F The name of the constituent (French)
FULLNAME_F The complete name of the constituent (French)
CONTRACTS CONTRACT_ID System generated unique identifier for a contract.
PROJ_RES_ID Unique system generated identifier.
AMOUNT The amount of the external contract (in thousands of dollars).
BUDGET_YEAR The fiscal year in which the contract is let e.g. 1993/94.
CONTRACT_TYPE The type of contract e.g. Green Plan.
CONTRACTOR The name of the company e.g. Software Kinetics, Dartmouth
SCIENTIFIC_AUTHORITY The responsible person e.g. Peter Strain.
CONTRACT_TITLE Short title of the contract.
DESCRIPTION Description of the work on the contract.
COORD_RATING_CODES RATING_ID Rating Id
DESCRIPTION Description
DATA_SOURCE_CODES SOURCE_ID Source Id
SOURCE_DESC Source Description
DOCUMENTS DOCUMENT_ID A system generated unique identifier of a document.
PROJECT_ID Unique system generated identifier.
TEAM_MEMBER_ID System generated unique identifier of an individual.
PUBLISH_DATE The date the document was published.
AUTHOR The author of the document.
TITLE The title of the document.
DOCUMENT_TYPE A list of values e.g. ASCII, MSWord.
ABSTRACT_E Flag = 1 indicates there is an abstract in table LONGFIELDS in English
ABSTRACT_F Flag = 1 indicates there is an abstract in table LONGFIELDS in French
DOCUMENT The full text of the document (ASCII or common word processor).
ERROR_LOG ERROR_ID Unique identifier
ERROR_NO Error Number
USER_ID User Id
QUERY_ID Unique identifier of a query
ERROR_TXT Error Text
ERROR_DT Date of error
EVENT_ASSIGNMENTS EVENT_ASSIGNMENT_ID Unique identifier
TEAM_MEMBER_ID Unique identifier of a team member
SURVEY_EVENT_ID Unique identifier for a survey event
EXP_EVENT_ID Unique identifier for an experiment event
RESPONSE_ID Unique identifier of a response
MEMBER_TYPE Type of member
EVENT_LOCATIONS EVENT_LOC_ID Event location identifier
LOCATION_ID Unique identifier of a location
SURVEY_EVENT_ID Unique identifier of a survey event
EXP_EVENT_ID Unique identifier of an experiment event
START_DATE Start Date
END_DATE End Date
START_TIME Start Time
END_TIME End Time
MINIMUM_SAMPLE_DEPTH Minimum sample depth
MAXIMUM_SAMPLE_DEPTH Maximum sample depth
STATION_NAME Name of the station
SI_DESCRIPTION Si description
EXPERIMENT_CONSTITUENTS CONSTITUENT_ID System generated identifier uniquely identifying a constituent.
EXP_EVENT_ID A unique ID to identify an experiment event
EXPERIMENT_ENVIRONMENTS EXP_ENV_ID System generated unique identifer for the experiment environment
NAME_E The name of the habitat e.g. lake, river, ocean (English)
NAME_F The name of the habitat e.g. lac, riviere, ocean (French)
DESCRIPTION_E The full description of the habitat (English)
DESCRIPTION_F The full description of the habitat (French)
EXPERIMENT_EVENTS EXP_EVENT_ID A unique ID to identify an experiment event
PROJECT_ID Unique system generated identifier.
EXP_ENV_ID System generated unique id for the experiment environment.
EXP_TYPE_ID System generated unique identifier for the experiment type
ARCHIVE_SOURCE_ID System generated unique identifier for an archive.
ARCHIVE_STATUS_FLAG Flag indicating if the data have been archived (1=yes, 0=no).
ARCHIVE_EVENT_ID Identifier attached to an event in a regional archive.
EXPERIMENT_RATING Flag (1) indicates there is a rating in the LONGFIELDS table
BANKED_SPECIMEN Specimen is available for future analysis (1= yes, 0 = no).
RELATED_EVENTS_FLAG Flag (1) indicates there are other events associated with this event
RATING_DATE The date the data were rated
DATA_SOURCE_TYPE Type of data source (eg. cruise).
ACCESS_TYPE_FLAG The type of access permitted to the data
DATA_SOURCE_ID Identifier provided by the PI to locate his own data.
RATING_DESCRIPTION The rationale behind the assignment of the data rating
EXPERIMENT_TYPES EXP_TYPE_ID Unique system generated identifier.
EXP_TYPE_E Either toxicological or fate.
SUBTYPE_E The subtype of the experiment e.g. lethal, sublethal.
EXP_TYPE_F Column definition derived from attribute experiment type f.
SUBTYPE_F Column definition derived from attribute subtype f.
GEOREFERENCES GEOREFERENCE_ID Unique system generated identifier.
REGION_ID Unique system generated identifier for region.
DIRECTION_INDEX Value = sequence number; +/- = clockwise/counterclockwise.
LATITUDE Decimal latitude of the location ( + = north of the equator).
LONGITUDE Decimal longitude of the location ( +/- = west/east of Greenwich).
GEOREFERENCE_CODES GEOREF_ID Unique identifier
GEOREF_DESC Georeference Description
GROUPS GROUP_ID Unique system generated identifier.
PARAMETER_ID System generated unique identifier.
NAME_E The name of the constituent group. For example, metals, gases.
NAME_F The name of the constituent group e.g. metals, gases (French)
HISTORIES HISTORY_ID System generated unique identifier for History.
TABLENAME Name of table.
ACTION Action done on table.
UPDATE_USER Person who updated table.
UPDATE_TIMESTAMP Time of update(s) done on table.
OLDRECORD old record.
HLT_EVENT_ASSIGNMENTS BATCH_NO Unique system generated identifier
EVENT_ASSIGNMENT_ID Unique system generated identifier
RESPONSE_ID Unique system generated identifier
SURVEY_EVENT_ID Unique identifier
EXP_EVENT_ID Experiment event identifier
MEMBER_TYPE Code for role of a member, eg. PI Scientific, etc.
TEAM_MEMBER_ID Unique system generated identifier
HLT_EVENT_LOCATIONS BATCH_NO Unique system generated identifier
EVENT_LOC_ID Unique system-generated identifier for a location.
SURVEY_EVENT_ID Unique identifier
EXP_EVENT_ID Unique identifier
LOCATION_ID Unique identifier
END_DATE The date (GMT) that an event ended.
END_TIME The time (GMT) that an event ended e.g. 0940
MAXIMUM_SAMPLE_DEPTH The depth (m) of the deepest sample collected
MINIMUM_SAMPLE_DEPTH The depth (m) of the shallowest sample collected
SI_DESCRIPTION Description of the sample collection interval e.g. 10 minutes.
START_DATE The date (GMT) that an event started.
START_TIME The time (GMT) that an event started e.g. 0922.
STATION_NAME The name given to the station e.g. Station PAPA
HLT_EXPERIMENT_CONSTITUENTS BATCH_NO System-generated identifier uniquely identifying a constituent.
EXP_EVENT_ID An unique ID to identify an event in a project.
CONSTITUENT_ID System-generated identifier uniquely identifying a constituent.
HLT_EXPERIMENT_EVENTS BATCH_NO Unique system generated identifier
EXP_EVENT_ID A unique ID to identify an experiment event
EXP_TYPE_ID System generated unique identifier for the experiment type
EXP_ENV_ID System generated unique identifier for the experiment environment
ARCHIVE_SOURCE_ID System generated unique identifier for an archive
PROJECT_ID Unique system generated identifier
ACCESS_TYPE_FLAG The type of access permitted to the data
ARCHIVE_STATUS_FLAG Flag indicating if the data have been archived (1=yes, 0=no).
BANKED_SPECIMEN Specimen is available for future analysis (1= yes, 0 = no).
DATA_SOURCE_ID Identifier provided by the PI to locate his own data.
DATA_SOURCE_TYPE Type of data source (eg. cruise).
GEOREFERENCE_FLAG Georeference flag
RATING_DATE Date the data was rated.
EXPERIMENTAL_RATING Flag (1) indicates that there is a rating in the LONGFIELDS table
NUMBER_OF_TREATMENTS Number of treatments
RATING_DESCRIPTION The rationale behind the assignment of the data rating
ARCHIVE_EVENT_ID Identifier attached to an event in a regional archive.
RELATED_EVENTS_FLAG Flag (1) indicates there are other events associated with this event
HLT_LOCATIONS BATCH_NO Unique system generated identifier
LOCATION_ID Unique system-generated identifier for a location.
COORDINATE_RATING The quality rating (as a code) of the lat-long coordinates
COORDINATE_RATING_DESCRIPTION Explanation of the coordinate rating.
GEOREFERENCE_TYPE Type of georeference construct e.g. measured or estimated.
GRID_ID Unique identifier of a one degree square.
LOCATION_DESCRIPTION Detailed description of the location.
PROVINCE Unique name of a province.
WATER_DEPTH Water depth to the bottom (metres).
LATITUDE Decimal latitude of the location (+ = north of the equator).
LONGITUDE Decimal longitude of the location (+/- = west/east of Greenwich).
HLT_RESPONSES BATCH_NO Unique system generated identifier
RESPONSE_ID Unique system generated identifier
ORGANISM_ID Unique system generated identifier.
SAMPLING_METHOD_ID Unique system generated identifier.
EXP_EVENT_ID A unique ID to identify an experiment event
STORAGE_METHOD_ID Unique system generated identifier.
SAMPLING_DESIGN_ID System generated unique identifier for the sampling design.
CONSTITUENT_ID System generated identifier uniquely ientifying a constituent
BIO_RESP_CLASS_ID Unique system generated identifier.
ANALYSIS_METHOD_ID System generated unique identifier for analysis method.
ACCURACY Deviation of a measurement from the true value
ACCURACY_DESCRIPTION Rationale for the accuracy assignment.
ANALYSIS_DESCRIPTION Full description of the analysis method.
PRECISION Measure of the degree of variability
PRECISION_DESCRIPTION Rationale for the precision assignment.
PRESERVE_FLAG Was the sample preserved before analysis? (1=yes, 0=no).
SAMPLING_DESCRIPTION Full description of the sample method.
STORAGE_DESCRIPTION Full description of the storage method.
STORAGE_DURATION The length of time the sample was stored (in decimal days)
STORAGE_TEMPERATURE The temperature the sample was stored at (in degrees C)
MEDIUM_ID Unique system generated identifier.
CHEM_RESP_FLAG AUTOCREATED - Manual intervention required.
BIO_RESP_FLAG AUTOCREATED - Manual intervention required
HLT_SURVEY_EVENTS BATCH_NO Unique system generated identifier
SURVEY_EVENT_ID A unique ID to identify a survey event
PROJECT_ID Unique system generated identifier
ARCHIVE_SOURCE_ID System generated unique identifier for an archive
MEDIUM_ID Unique system generated identifier
SAMPLING_DESIGN_ID System generated unique identifier for the sampling design
STORAGE_METHOD_ID Unique system generated identifier.
SAMPLING_METHOD_ID Unique system generated identifier.
ORGANISM_ID Unique system generated identifier.
CONSTITUENT_ID System generated identifier uniquely identifying a constituent
ANALYSIS_METHOD_ID System generated unique id for analysis method.
ARCHIVE_EVENT_ID Identifier attached to an event in a regional archive.
ACCESS_TYPE_FLAG The type of access permitted to the data e.g. restricted
ARCHIVE_STATUS_FLAG Flag indicating if the data has been archived (1=yes, 0=no).
PRESERVE_FLAG Was the sample preserved before analysis (1=yes, 0=no).
OVERALL_DATA_RATING Flag (1) indicated the rating is in the LONGFIELDS table
RATING_DATE The date the data were rated
DATA_SOURCE_TYPE Type of data source (eg. cruise).
BANKED_SPECIMEN Specimen is available for future analysis (1= yes, 0 = no).
DATA_SOURCE_ID Identifier provided by the PI to locate his own data.
DATA_PRECISION Precision of the data
ACCURACY Percent deviation of a measurement from the true value.
STORAGE_TEMPERATURE The temperature the sample was stored at (in degrees C).
STORAGE_DURATION Length of time the sample was stored (in decimal days).
PRECISION_DESCRIPTION Rationale for the precision assignment
ACCURACY_DESCRIPTION Rationale for the accuracy assignment
RATING_DESCRIPTION The rationale behind the assignment of the data rating
ANALYSIS_DESCRIPTION Full description of the analysis method.
STORAGE_DESCRIPTION Full description of the storage method.
SAMPLING_DESCRIPTION Full description of the sampling method.
RELATED_EVENTS_FLAG Flag indicating a related data source id exists ('1' = yes, '0' = no)
PRECISION Measure of the degree of variability
LOCATIONS LOCATION_ID Unique system generated identifier for a location
GRID_ID Unique identifier of a one degree square
COORDINATE_RATING The quality rating (as a code) of the lat-long coordinates
WATER_DEPTH Water depth to the bottom (metres)
LONGITUDE Decimal longitude of the location (+/- = west/east of Greenwich)
PROVINCE Unique name of a province
LOCATION_DESCRIPTION Detailed description of the location
LOCATION_REGIONS REGION_ID Unique system generated identifier for a region
LONGFIELDS TABLE_ID Unique system generated identifier
TABLE_UNIQUE_ID Unique identifier of the row of the table for which the long record applies
TABLENAME Name of the table for which the long record applies
TABLE_ATTRIBUTE Name of the attribute for which the long record applies
LONG_FIELD The long field contents
MEDIA MEDIUM_ID Unique system generated identifier.
NAME_E Name of the medium e.g. muscle, liver, rain.
CLASS_E Classes of media e.g., animal tissue, plant tissue, sediment.
NAME_F Column definition derived from attribute name f.
CLASS_F Column definition derived from attribute class f.
DESCRIPTION_E Full description of the medium e.g. whole or portion of kidney.
DESCRIPTION_F Column definition derived from attribute description f.
MEMBER_TYPE_CODES MEMBER_ID Unique identifier
MEMBER_DESC Description of member
MILESTONES MILESTONE_ID Unique system generated identifier.
PROJECT_ID Unique system generated identifier.
MILESTONE_DATE The date of the milestone.
MILESTONE_TYPE Type of milestone e.g. meeting, contract report.
DESCRIPTION The description of the milestone.
NODC_CLASSES CLASS_ID NODC reference code for the taxonomic class of the organism.
CLASS_NAME Name of the NODC taxonomic class of the organism.
NODC_FAMILIES FAMILY_ID Unique identifier
FAMILY_NAME Name of family
NODC_GENERA GENUS_ID NODC reference code for the taxonomic genus of the organism.
GENUS_NAME Name of the NODC taxonomic genus of the organism.
NODC_ORDERS ORDER_ID NODC reference code for the taxonomic order of the organism.
ORDER_NAME Name of the NODC taxonomic order of the organism
NODC_PHYLA PHYLUM_ID NODC reference code for the taxonomic phylum of the organism.
PHYLUM_NAME Name of the NODC taxonomic phylum of the organism
ORGANISMS ORGANISM_ID Unique system generated identifier
CLASS_ID NODC reference code for the taxonomic class of the organism
ORDER_ID NODC reference code for the taxonomic order of the organism
PHYLUM_ID NODC reference code for the taxonomic phylum of the organism
SPECIES The latin name of the species of the organism
NAME_F The common French name of the organism
ORGANIZATIONS ORGANIZATION_ID Unique system generated identifier.
REGION The region the organization is in e.g. Maritimes
NAME The name of the organization e.g. Bedford Institute.
ADDRESS The mailing address of the organization.
POSTAL_CODE The postal code of the organization.
TELEPHONE The general telephone number of the organization unit.
FAX The general fax number of the organization unit
TELEX The general telex number of the organization unit.
UNIT The title of the unit within organization e.g. Marine Chemistry.
EMAIL The email address of the organization unit.
OVERALL_DATA_CODES RATING_ID Unique identifier
RATING_DESC Description of the rating
PARAMETERS PARAMETER_ID System generated unique identifier.
NAME_E The short parameter name (English)
NAME_F The short parameter name (French)
PLAN_TABLE STATEMENT_ID Unique identifier
TIMESTAMP Timestamp
REMARKS Remarks
OPERATION Operation
OPTIONS Options
OBJECT_NODE Object Node
OBJECT_OWNER Object Owner
OBJECT_NAME Name of the object
OBJECT_INSTANCE Instance of the object
OBJECT_TYPE Type of the object
SEARCH_COLUMNS Search Columns
ID Id
PARENT_ID Parent Id
POSITION Position
OTHER Other
PRECISION_CODES PRECISION_ID Precision Id
DESCRIPTION Description
PROGRAMME_CATEGORIES PROG_CAT_ID Unique identifier of programme category.
CATEGORY The name of the category e.g. Assessments.
PROGRAMME_RESOURCES PROG_RES_ID Unique system generated identifier.
PROG_CAT_ID Unique identifier of programme category.
PERSON_YEARS The number of person years budgetted for the programme year.
CAPITAL_AMOUNT The capital amount for the programme year (in 1000s of dollars).
O_M_AMOUNT The Operational and Maintenance amounts (in thousands of dollars).
SALARY_AMOUNT The salary amount for the programme year (in 1000s of dollars).
BUDGET_YEAR The budget year of the programme e.g. 1993/94.
RESOURCE_TYPE The category of the programme e.g. Green Plan.
DESCRIPTION Notes concerning resource allocations for the programme year.
PROJECTS PROJECT_ID Unique system generated identifier.
PROG_CAT_ID Unique identifier of programme category.
STATUS_DATE The date the current status was set.
SUBMISSION_DATE The date the project was submitted.
PROJECT_NO The number assigned by DFO to the project e.g. 95-103.
FUNDING_REGION DFO funding regions e.g. Pacific
STATUS The status of the project e.g. approved.
TITLE The title of the project.
DELIVERABLES Description of planned milestones and results
COMMUNICATIONS A description of how the results will be presented
RELATED_PROJECTS The identifiers of related projects
PY_JUSTIFICATION An explanation of the person year resources needed by the project
DATA_MANAGEMENT_IMPLICATIONS Description of the data management implications of the project
DESCRIPTION Description of the project
PROJECT_ASSIGNMENTS PROJECT_ID Unique system generated identifier.
TEAM_MEMBER_ID System generated unique identifier of an individual.
MEMBER_TYPE The type of participation of the member in a project
DATE_ASSIGNED The date that the team member was assigned to the project
PROJECT_ORGANIZATIONS ORGANIZATION_ID Unique system generated identifier.
PROJECT_ID Unique system generated identifier.
PROJECT_RESOURCES PROJ_RES_ID Unique system generated identifier.
PROJECT_ID Unique system generated identifier.
PERSON_YEARS The number of person years allocated for the budget year
CAPITAL_AMOUNT The capital amount for the budget year (in 1000s of dollars)
O_M_AMOUNT O and M amount for the budget year (in thousands of dollars)
SALARY_AMOUNT The salary amount for the budget year (in 1000s of dollars)
PROJ_RES_TYPE A-Base versus Green Plan.
BUDGET_YEAR The budget year e.g. 1993/94.
DESCRIPTION The description of the project resources
PROVINCE_CODES PROVINCE_ID Unique identifier
QUERY_DETAILS QUERY_ID Unique identifier
QUERY_NAME Name of query
USER_ID Id of user
QUERY_TYPE Type of query
DATE_CREATED Date created
DATE_LAST_RUN Date last run
DELETED_FLAG Deleted flag
SQL_STATEMENT Sql statement
QUERY_SERVER SERVER_ID Id of server
SERVER_NAME Name of server
SERVER_ADDRESS Address of server
ACTIVE_FLG Active flag
TEAM_MEMBER_ID Team member Id
QUERY_STATISTICS QUERY_STATS_ID Unique identifier
QUERY_ID Unique identifier
ROWS_RETURNED Rows returned
APPROXIMATE_TM Approximate time
RUN_DT Run date
REGIONS REGION_ID Unique system generated identifier for region
NAME The name for the region
REGION_TYPE The type of region e.g. lake, watershed
REGION_TYPE_CODES TYPE_DESC Description of type
RESPONSES RESPONSE_ID Unique system generated identifier of a response.
ANALYSIS_METHOD_ID System generated unique identifier for analysis method.
QUERY_SQL QUERY_ID Unique identifier
SEQ_NO Sequence Number
FORM_NAME Name of form
ITEM_NAME Name of item
TABLE_NAME Name of table
KEY_NAME Name of key
COLUMN_NAME Name of column
DATA_TYPE Data type
VALUE Value
SQL Sql
RESPONSES EXP_EVENT_ID A unique ID to identify an experiment event
MEDIUM_ID Unique system generated identifier.
ORGANISM_ID Unique system generated identifier.
SAMPLING_DESIGN_ID System generated unique identifier for the sampling design.
SAMPLING_METHOD_ID Unique system generated identifier.
STORAGE_METHOD_ID Unique system generated identifier.
CONSTITUENT_ID System generated identifier uniquely identifying a constituent.
BIO_RESP_CLASS_ID Unique system generated identifier
PRESERVE_FLAG Was the sample preserved before analysis? (1=yes, 0=no).
CHEM_RESP_FLAG AUTOCREATED - Manual intervention required.
BIO_RESP_FLAG Biological response flag
STORAGE_DURATION The length of time the sample was stored (in decimal days)
STORAGE_TEMPERATURE The temperature the sample was stored at (in degrees C)
PRECISION Measure of the degree of variability
ACCURACY Deviation of a measurement from the true value
ACCURACY_DESCRIPTION Rationale for the accuracy assignment.
PRECISION_DESCRIPTION Rationale for the precision assignment.
SAMPLE_DESCRIPTION Full description of the sample method.
STORAGE_DESCRIPTION Full description of the storage method.
ANALYSIS_DESCRIPTION Full description of the analysis method.
RETRIEVAL_GROUPS GROUP_ID Unique identifier
OWNER_CONTACT_ID Owner contact id
ARCHIVE_FILE_ID Archive file id
ADR_ID Unique identifier
ARCHIVE_SOURCE_ID Unique identifier
SERVER_ADDRESS Address of server
STATUS Status
GROUP_STATE Group state
DBA_CONTACT_ID Unique identifier
REMOTE_ADR_ID Unique identifier
ACCESS_TYPE_FLAG Access type flag
REMOTE_GROUP_ID Unique identifier
RETRIEVAL_ITEMS ITEM_ID Unique identifier
GROUP_ID Unique identifier
EVENT_ID Unique identifier
DATA_SOURCE_ID Unique identifier
SAMPLING_DESIGNS SAMPLING_DESIGN_ID System generated unique identifier for the sampling design.
SAMPLING_DESIGN_TYPE Description of the sampling design type.
SAMPLING_METHODS SAMPLING_METHOD_ID Unique system generated identifier.
CLASS_E The broad class of the sampling method e.g. sediment, water.
NAME_E The specific method used e.g. bedload trap, bottle (English)
CLASS_F The broad class of the sampling method used e.g. sediment (French)
NAME_F The specific method used e.g. bedload trap, bottle (French)
STATS_SERVER_XREF SERVER_ID Unique identifier
QUERY_STATS_ID Unique identifier
STORAGE_METHODS STORAGE_METHOD_ID Unique system generated identifier.
NAME_E Storage method e.g. glass container, metal container.
NAME_F Storage method e.g. glass container, metal container (French)
SURVEY_EVENTS SURVEY_EVENT_ID A unique ID to identify a survey event
PROJECT_ID Unique system generated identifier.
ARCHIVE_SOURCE_ID System generated unique identifier for an archive.
MEDIUM_ID Unique system generated identifier.
SAMPLING_DESIGN_ID System generated unique identifier for the sampling design.
STORAGE_METHOD_ID Unique system generated identifier.
SAMPLING_METHOD_ID Unique system generated identifier.
ORGANISM_ID Unique system generated identifier.
CONSTITUENT_ID System generated identifier uniquely identifying a constituent
ANALYSIS_METHOD_ID System generated unique id for analysis method.
ARCHIVE_EVENT_ID Identifier attached to an event in a regional archive.
RELATED_EVENTS_FLAG Flag indicating a related data source id exists (1=yes, 0=no).
DATA_SOURCE_ID Identifier provided by the PI to locate his own data.
ARCHIVE_STATUS_FLAG Flag indicating if the data has been archived (1=yes, 0=no).
PRESERVE_FLAG Was the sample preserved before analysis? ('1'=yes, '0'=no)
OVERALL_DATA_RATING Flag (1) indicates teh rating is in the LONGFIELDS table
BANKED_SPECIMEN Specimen is available for future analysis (1= yes, 0 = no).
RATING_DATE The date the data were rated
ACCESS_TYPE_FLAG The type of access permitted to the data e.g. restricted
STORAGE_TEMPERATURE The temperature the sample was stored at (in degrees C).
STORAGE_DURATION Length of time the sample was stored (in decimal days).
PRECISION Measure of the degree of variability
ACCURACY Percent deviation of a measurement from the true value
DATA_SOURCE_TYPE Type of data source (eg. cruise).
RATING_DESCRIPTION The rationale behind the assignment of the data rating
PRECISION_DESCRIPTION Rationale for the precision assignment
ACCURACY_DESCRIPTION Rationale for the accuracy assignment
ANALYSIS_DESCRIPTION Full description of the analysis method.
STORAGE_DESCRIPTION Full description of the storage method.
SAMPLING_DESCRIPTION Full description of the sampling method.
TEAM_MEMBERS TEAM_MEMBER_ID System generated unique identifier of an individual
ORGANIZATION_ID Unique system generated identifier
TELEPHONE_NUMBER The telephone number of the individual
EXPERTISE The area of expertise of the individual
LAST_NAME The last name of an individual
TITLE The title of an individual e.g. Dr., Mr.
FAX_NUMBER The fax number of the individual
FIRST_NAME The given names of an individual
EMAIL Email addresses for the individual
USER_ID Id of user
PASSWORD Password
NETWORK_ADDRESS Network address
USER_ROLE Role of user
LOCATIONS GEOREFERENCE_TYPE Type of georeference construct e.g. measured or estimated
LATITUDE Decimal latitude of the location (+ = north of the equator)
COORDINATE_RATING_DESCRIPTION Explanation of the coordinate rating
LOCATION_REGIONS LOCATION_ID Unique system generated identifier for a location
ORGANISMS FAMILY_ID NODC reference code for the taxonomic family of the organism
GENUS_ID NODC reference code for the taxonomic genus of the organism
NAME_E The common English name of the organism
MAP_LIST MAP_ID Unique identifier
PARENT_ID Unique identifier of parent
FILENAME Name of file
TITLE_E The name of the map (English)
TITLE_F The name of the map (French)
DESCRIPTION_E Full description of the medium e.g. portion of kidney (English)
DESCRIPTION_F Full description of the medium e.g. portion of kidney (French)
PROJ_ID Unique identifier
PROJ_PARAMS Projection parameters
Date modified: