|
File |
Field |
Length |
Alias |
Mandatory |
Max. Entries |
Example |
Checks & Range |
|
|
|
|
|
|
|
|
|
E01 |
MINFILNO |
9 |
MINFILE_NUMBER |
Y |
1 |
104B 021 |
082-114/A-P/NESW/001-999 |
|
E01 |
LAT_DEG |
2 |
LATITUDE_DEGREES |
note 2 |
1 |
56 |
48 - 60 |
|
E01 |
LAT_MIN |
2 |
LATITUDE_MINUTES |
N |
1 |
12 |
0 - 60 |
|
E01 |
LAT_SEC |
2 |
LATITUDE_SECONDS |
N |
1 |
41 |
0 - 60 |
| E01 |
LAT_HEMI |
1 |
LATITUDE_HEMISPHERE |
Y |
1 |
N |
N or S |
|
E01 |
LONG_DEG |
3 |
LONGITUDE_DEGREES |
note 2 |
1 |
130 |
114 - 140 |
|
E01 |
LONG_MIN |
2 |
LONGITUDE_MINUTES |
N |
1 |
20 |
0 - 60 |
|
E01 |
LONG_SEC |
2 |
LONGITUDE_SECONDS |
N |
1 |
35 |
0 - 60 |
| E01 |
LONG_HEMI |
1 |
LONGITUDE_HEMISPHERE |
Y |
1 |
W |
W or E |
| E01 |
N83_LATDEG |
2 |
NAD83_LATITUDE_DEGREES |
note 2 |
1 |
56 |
48 - 60 |
| E01 |
N83_LATMIN |
2 |
NAD83_LATITUDE_MINUTES |
N |
1 |
12 |
0 - 60 |
| E01 |
N83_LATSEC |
2 |
NAD83_LATITUDE_SECONDS |
N |
1 |
40 |
0 - 60 |
| E01 |
N83_LATHEMI |
1 |
LATITUDE_HEMISPHERE |
Y |
1 |
N |
N or S |
| E01 |
N83_LONDEG |
3 |
NAD83_LONGITUDE_DEGREES |
note 2 |
1 |
130 |
48 - 60 |
| E01 |
N83_LONMIN |
2 |
NAD83_LONGITUDE_MINUTES |
N |
1 |
20 |
0 - 60 |
| E01 |
N83_LONSEC |
2 |
NAD83_LONGITUDE_SECONDS |
N |
1 |
42 |
0 - 60 |
| E01 |
N83_LONHEMI |
1 |
LONGITUDE_HEMISPHERE |
Y |
1 |
W |
W or E |
|
E01 |
UTM_ZONE |
2 |
UTM_ZONE |
note 2 |
1 |
09 |
07 - 11 |
|
E01 |
UTM_EAST |
6 |
UTM_EASTING |
note 2 |
1 |
416700 |
290000 - 725000 |
|
E01 |
UTM_NORT |
8 |
UTM_NORTHING |
note 2 |
1 |
6230200 |
5300000 - 6653000 |
| E01 |
N83_ZONE |
2 |
NAD83_ZONE |
note 2 |
1 |
09 |
07 - 11 |
| E01 |
N83_EAST |
6 |
NAD83_EASTING |
note 2 |
1 |
416694 |
290000 - 725000 |
| E01 |
N83_NORT |
8 |
NAD83_NORTHING |
note 2 |
1 |
6230205 |
5300000 - 6653000 |
|
E01 |
ELEV |
4 |
ELEVATION |
Y |
1 |
0975 |
0 - 6000 |
|
E01 |
LOC_ACC |
1 |
DEPOSIT_LOCATION_ACCURACY |
Y |
1 |
1 |
1,2,3 |
|
E01 |
DEPSIZEL |
4 |
DEP_SIZE_L |
N |
1 |
1200 |
nnnn |
|
E01 |
DEPSIZEB |
4 |
DEP_SIZE_B |
N |
1 |
0760 |
nnnn |
|
E01 |
DEPSIZEW |
4 |
DEP_SIZE_W |
N |
1 |
0240 |
nnnn |
|
E01 |
DIP |
3 |
DEPOSIT_DIP |
N |
1 |
40W |
nnN,E,S,W |
|
E01 |
STRIKE |
3 |
DEPOSIT_STRIKE |
N |
1 |
020 |
001 - 360 |
|
E01 |
PLUNGE |
6 |
DEPOSIT_TREND_PLUNGE |
N |
1 |
02040 |
001 - 360/01 - 90 |
|
E01 |
NATMINNO |
18 |
NAT_MIN_INV_NO |
N |
1 |
104B1 Cu1 |
082-114/A-P/1-16/aaa/nnn |
|
E01 |
CANMINNO |
6 |
CANMINDEX_NUMBER |
N |
1 |
|
000001 - 999999 |
|
E01 |
CODED |
8 |
DATE_CODED |
Y |
1 |
240785 |
D/M/Y |
|
E01 |
REVISED |
8 |
DATE_REVISED |
Y |
1 |
250788 |
D/M/Y |
|
E01 |
GREVISED |
4 |
GEOLOGIST_REVISE |
Y |
1 |
LDJ |
aaaa |
|
E01 |
FREVISED |
1 |
FIELD_REVISED |
Y |
1 |
N |
Y or N |
|
E01 |
FCHECKED |
1 |
FIELD_CHECKED |
Y |
1 |
N |
Y or N |
|
E01 |
GNAME |
4 |
GEOLOGIST_NAME |
Y |
1 |
GSB |
aaaa |
|
E01 |
OPENPIT |
1 |
OPEN_PIT |
note 3 |
1 |
X |
X |
|
E01 |
UGROUND |
1 |
UNDER_GROUND |
note 3 |
1 |
X |
Y |
|
E31 |
PROJ_NO |
7 |
PROJECT_NUMBER |
if exists |
1 |
|
nnnnnnn |
|
E31 |
PROPERTY |
30 |
PROPERTY_NAME |
Y |
1 |
|
open |
|
E31 |
PROPERTY_2 |
30 |
PROPERTY_NAME2 |
N |
1 |
|
|
|
E31 |
OWNER |
30 |
OWNER_NAME |
Y |
1 |
|
Company name or First name, Last name |
|
E31 |
OWNER_2 |
30 |
OWNER_NAME2 |
N |
1 |
|
|
E31 |
OPERATOR |
30 |
OPERATOR |
Y |
1 |
|
|
E31 |
DIST_SEQNO |
3 |
DISTRICT_SEQUENCE_NUMBER |
N |
1 |
|
|
|
E31 |
DIST_MAPNO |
3 |
DISTRICT_MAP_NUMBER |
N |
1 |
|
|
|
E31 |
LAT_DEG |
2 |
LATITUDE_DEGREE |
Y |
1 |
|
48 - 60 |
|
E31 |
LAT_MIN |
2 |
LATITUDE_MINUTE |
Y |
1 |
|
0 - 60 |
|
E31 |
LAT_SEC |
2 |
LATITUDE_SECOND |
Y |
1 |
|
0 - 60 |
| E01 |
LAT_HEMI |
1 |
LATITUDE_HEMISPHERE |
Y |
1 |
|
N or S |
|
E31 |
LON_DEG |
3 |
LONGITUDE_DEGREE |
Y |
1 |
|
114 - 140 |
|
E31 |
LON_MIN |
2 |
LONGITUDE_MINUTE |
Y |
1 |
|
0 - 60 |
|
E31 |
LON_SEC |
2 |
LONGITUDE_SECOND |
Y |
1 |
|
0 - 60 |
| E31 |
LON_HEMI |
1 |
LONGITUDE_HEMISPHERE |
Y |
1 |
|
W or E |
| E31 |
N83_LATDEG |
2 |
NAD83_LATITUDE_DEGREES |
note 2 |
1 |
|
48 - 60 |
| E31 |
N83_LATMIN |
2 |
NAD83_LATITUDE_MINUTES |
N |
1 |
|
0 - 60 |
| E31 |
N83_LATSEC |
2 |
NAD83_LATITUDE_SECONDS |
N |
1 |
|
0 - 60 |
| E31 |
N83_LATHEMI |
1 |
LATITUDE_HEMISPHERE |
Y |
1 |
|
N or S |
| E31 |
N83_LONDEG |
3 |
NAD83_LONGITUDE_DEGREES |
note 2 |
1 |
|
48 - 60 |
| E31 |
N83_LONMIN |
2 |
NAD83_LONGITUDE_MINUTES |
N |
1 |
|
0 - 60 |
| E31 |
N83_LONSEC |
2 |
NAD83_LONGITUDE_SECONDS |
N |
1 |
|
0 - 60 |
| E31 |
N83_LONHEMI |
1 |
LONGITUDE_HEMISPHERE |
Y |
1 |
|
W or E |
|
E31 |
LOC_ACC |
1 |
LOCATION_ACCURACY_CODE |
Y |
1 |
|
1,2,3 |
|
E31 |
CR_DATE |
8 |
CREATED_DATE |
Y |
1 |
|
D/M/Y |
|
E31 |
RV_DATE |
8 |
REVISED_DATE |
Y |
1 |
|
D/M/Y |
|
E31 |
CHECKED_BY |
5 |
CHECKED_BY |
Y |
1 |
|
aaaa |
| |
ELECTORAL DISTRICT |
|
ELECTORAL DISTRICT |
|
1 |
|
table E42 |
| |
FOREST DISTRICT |
|
FOREST DISTRICT |
|
1 |
|
table E43 |
|
|
|
|
|
|
|
|
|
R02 |
STATUS_C |
4 |
STATUS_TYPE_CODE |
Y |
1 |
PAPR |
SHOW/PROS/DEPR/PROD/PAPR |
|
R03 |
DOMHRK_C |
1 |
DOMINANT_HOST_ROCK_CODE |
Y |
1 |
1 |
table E03 |
|
R04 |
DEPMOD_C |
1 |
DEPOSIT_MODIFIER_CODE |
N |
2 |
1,4 |
table E04 |
|
R05 |
DEPCHR_C |
2 |
DEPOSIT_CHARACTER_CODE |
Y |
4 |
12,09,01 |
table E05; ranked |
|
R06 |
DEPSHA_C |
2 |
DEPOSIT_SHAPE_TYPE_CODE |
N |
1 |
1 |
table E06 |
|
R07 |
DEPCLA_C |
2 |
DEPOSIT_CLASSIFICATION_CODE |
Y |
4 |
03,05 |
table E07, ranked |
|
R08 |
NAME |
30 |
NAME |
Y |
16 |
GRANDUC |
ranked |
|
R09 |
MINDIV_C |
4 |
MINING_DIVISION_CODE |
Y |
2 |
SKEE |
table E09 |
|
R10 |
NTSMAP_C |
7 |
NTS_MAPSHEET (1:50000) |
Y |
4 |
104B01W |
082-114/A-P/01-16/E,W; table E10 |
|
R11 |
BCMAP_C |
7 |
BC_MAPSHEET (1:20000) |
N |
4 |
104B029 |
082-114/A-P/001-100: table E11 |
|
R12 |
TECBLT_C |
2 |
TECTONIC_BELT_CODE |
Y |
1 |
IN |
table E12 |
|
R13 |
TERRAN_C |
3 |
TERRANE_CODE |
Y |
2 |
ST |
table E13 |
|
R14 |
PHYSIO_C |
4 |
PHYSIOGRAPHIC_AREA_CODE |
N |
1 |
BNRG |
table E14 |
|
R15 |
META_T_C |
1 |
METAMORPHIC_TYPE_CODE |
note 4 |
2 |
2 |
table E15 |
|
R16 |
META_G_C |
2 |
METAMORPHIC_GRADE_CODE |
N |
2 |
AM |
table E16 |
|
R17 |
META_R_C |
1 |
METAMORPHIC_RELATIONSHIP_CODE |
N |
3 |
3 |
table E17 |
|
R18a |
YEAR |
4 |
YEAR |
if exists |
1 |
1984 |
table E18 |
|
R18a |
MINED |
12 |
ORE_MINED |
Y |
1 |
352630 |
tonnes |
|
R18a |
MILLED |
12 |
ORE_MILLED |
Y |
1 |
352630 |
tonnes |
|
R18b |
COMMOD_C |
2 |
COMMODITY_CODE |
Y |
6 |
AG |
table E19 |
|
R18b |
QUANTITY |
12 |
QUANTITY |
Y |
6 |
3944057 |
grams or kilograms |
|
R19 |
COMMOD_C |
2 |
COMMODITY_CODE |
Y |
15 |
CU,AG... |
table E19; ranked |
|
R20 |
MINCLA_C |
1 |
MINERALOGY_CLASS_CODE |
Y |
1 |
|
1,2,3; table E20a |
|
R20 |
MINERL_C |
4 |
MINERAL_CODE |
note 5 |
16/8/8 |
PYRT etc |
table E20b; ranked |
|
R21 |
ALTER_C |
4 |
ALTERATION_CODE |
N |
6 |
EPID etc |
table E21; ranked |
|
R22 |
DATMET_C |
2 |
DATING_METHOD_CODE |
N |
1 |
01 |
table E22 |
|
R22 |
ISOAGE |
20 |
ISOTOPIC_AGE_MINERALIZATION |
N |
1 |
220 +/- 2 Ma |
text |
|
R22 |
MATERIAL |
30 |
MATERIAL_DATED_MINERALIZATION |
N |
1 |
Galena |
text |
|
R23 |
ST_AGE_C |
3 |
STRATIGRAPHIC_AGE_CODE |
Y |
1 |
227 |
table E24 |
|
R23 |
STNAME_C |
6 |
STRATIGRAPHIC_NAME_CODE |
note 6 |
2/2 |
289,514 |
table E23 |
|
R23 |
DATMET_C |
2 |
DATING_METHOD_CODE |
N |
1 |
11 |
table E22 |
|
R23 |
ISOAGE |
20 |
ISOTOPIC_AGE_HOST |
N |
1 |
210+/-10Ma |
text |
|
R23 |
MATERIAL |
30 |
MATERIAL_DATED_HOST |
N |
1 |
Zircon |
text |
|
R24 |
ST_AGE_C |
3 |
MINERALIZATION_AGE_CODE |
N |
1 |
*** |
table E24 |
|
R25 |
ROCK_T_C |
4 |
ROCK_TYPE_CODE |
Y |
10 |
SCST etc |
table E25; ranked |
|
R25 |
ROCK_M_C |
4 |
ROCK_MODIFIER_CODE |
N |
3x10 |
QRTZ etc |
table E26 |
|
R26-R28 |
OREZON_C |
5 |
ORE_ZONE_CODE |
if exists |
unlimited |
99814 |
table E27 |
|
R26,R28 |
RESCAT_C |
2 |
RESERVE_CATEGORY_CODE |
Y |
1 |
IN |
table E29 |
|
R26-R28 |
A_OR_B |
1 |
A_OR_B |
Y |
1 |
A |
use A first |
|
R26,R27 |
YEAR |
4 |
YEAR |
Y |
1 |
1969 |
table E18 |
|
R26 |
QUANTITY |
12 |
QUANTITY |
Y |
1 |
39316435 |
tonnes |
|
R26 |
REPORT_ON |
1 |
REPORT_ON |
N |
1 |
Y |
Y or N |
|
R27 |
SAMPLE_C |
4 |
SAMPLE_TYPE_CODE |
N |
1 |
|
table E28 |
|
R28 |
COMMOD_C |
2 |
COMMODITY_CODE |
Y |
6 |
CU |
table E19 |
|
R28 |
GRADE |
9 |
GRADE |
Y |
6 |
1.73 |
grams per tonne or per cent |
|
R30 |
DEPTYP_C |
5 |
DEPOSIT_TYPE_CODE |
N |
4 |
GO4 |
table E30 |
|
R31 |
PROJ_NO |
7 |
PROJECT_NUMBER |
if exists |
1 |
|
nnnnnnn |
|
R31 |
MINFILNO |
9 |
MINFILE_NUMBER |
if exists |
16 |
|
if associated with Project |
|
R32a |
NOW_NO |
9 |
NOTICE_NUMBER |
if exists |
unlimited |
|
YYYY-nnnn |
|
R32a |
NOTIC_TYP |
1 |
NOTICE_TYPE_CODE |
Y |
1 |
|
table E32 |
|
R32a |
RECVD_DATE |
8 |
RECEIVED_DATE |
N |
1 |
|
D/M/Y |
|
R32a |
APRV_DATE |
8 |
APPROVED_DATE |
N |
1 |
|
D/M/Y |
|
R32a |
OPERATOR |
30 |
OPERATOR |
N |
1 |
|
|
|
R32a |
MANAGER |
30 |
MANAGER |
N |
1 |
|
|
|
R32a |
MGR_TEL |
14 |
MANAGER_TELEPHONE |
N |
1 |
|
|
|
R32a |
WK_START |
8 |
WORK_STARTED |
N |
1 |
|
D/M/Y |
|
R32a |
WK_END |
8 |
WORK_ENDED |
N |
1 |
|
D/M/Y |
|
R32a |
EXP_BUD |
13 |
EXPLORATION_BUDGET |
N |
1 |
|
$ |
|
R32a |
PROD_BUD |
13 |
PRODUCTION_BUDGET |
N |
1 |
|
$ |
|
R32a |
COMPLETED |
1 |
COMPLETED |
N |
1 |
|
Y or N |
|
R32a |
DISCUSSED |
1 |
DISCUSSED |
N |
1 |
|
T or F |
|
R32a |
MDSCREV |
1 |
MDSC_REVIEW |
N |
1 |
|
T or F |
|
R32a |
DEP_TARGET |
60 |
DEPOSIT_TARGET |
N |
1 |
|
|
|
R32b |
WK_TODO |
70 |
WORK_TO_DO |
N |
1 |
|
|
|
R32b |
WK_DONE |
70 |
WORK_DONE |
N |
1 |
|
|
|
R33 |
PRJTYP_C |
1 |
PROJECT_TYPE_CODE |
Y |
1 |
|
table E33 |
|
R34 |
STAGE_C |
1 |
MDAP_STAGE_CODE |
N |
1 |
|
table E34 |
|
R35 |
MINDIV_C |
4 |
MINING_DIVISION |
Y |
2 |
|
table E09, for Project |
|
R36 |
NTSMAP_C |
7 |
NTS_MAP |
Y |
4 |
|
table E10, for Project |
| R39 |
REGION_C |
4 |
REGION_CODE_PROJECT |
Y |
10 |
|
table E40, for Project |
| R40 |
REGION_C |
4 |
REGION_CODE_MINFILE |
Y |
10 |
|
table E40, for MINFILE |
|
|
|
|
|
|
|
|
|
C01 |
IDENT_T |
70 |
IDENTIFICATION_COMMENTS |
N |
unlimited |
The mine is ... |
upper & lower case text |
|
C02 |
SIGMIN_T |
70 |
SIGNIFICANT_MINERALS_COMMENTS |
N |
4 |
|
upper & lower case text |
|
C03 |
ASSMIN_T |
70 |
ASSOCIATED_MINERALS_COMMENTS |
N |
3 |
|
upper & lower case text |
|
C04 |
ALTMIN_T |
70 |
ALTERATION_MINERALS_COMMENTS |
N |
4 |
|
upper & lower case text |
|
C05 |
STRUCT_T |
70 |
STRUCTURAL_COMMENTS |
N |
3 |
Granduc dep... |
upper & lower case text |
|
C06 |
HSTRCK_T |
70 |
HOST_ROCK_COMMENTS |
N |
2 |
Age date ... |
upper & lower case text |
|
C07 |
META_T |
70 |
METAMORPHISM_COMMENT |
N |
1 |
|
upper & lower case text |
|
C08 |
CAPSUL_T |
70 |
CAPSULE_GEOLOGY_COMMENTS |
Y |
unlimited |
The Granduc ... |
upper & lower case text |
|
C09 |
BIBLIO_T |
70 |
BIBLIOGRAPHY_COMMENTS |
Y |
unlimited |
EMPR BULL ... |
upper & lower case text |
|
C10 |
PROD_T |
66 |
PRODUCTION_COMMENTS |
N |
1 |
|
upper & lower case text |
|
C11 |
RESERV_T |
70 |
RESERVES_COMMENTS |
N |
unlimited |
|
for each A or B calculation |
|
C12 |
RESREF_T |
70 |
RESERVES_REFERENCE |
Y |
1 |
Open File ... |
for each A or B calculation |
|
C13 |
CONF_NOTE |
70 |
CONFIDENTIAL_NOTES |
N |
unlimited |
|
upper & lower case text |
|
C14 |
EXPL_T |
70 |
EXPLORATION_COMMENTS |
N |
unlimited |
|
upper & lower case text |
|
|
|
|
|
|
|
|
|
NOTES: |
1. All fields are character. 2. Either Longitude/Latitude or UTM coordinates must be entered in NAD 27 or NAD 83. 3. Either underground or open pit if Producer or Past Producer. 4. Mandatory if relationship and/or grade fields are used. 5. One significant (16 max) mineral is mandatory; up to 8 associated and alteration allowed. 6. At least one FORMAL or INFORMAL host required; maximum of 2 each. |