####################### Meta Data Part ############################# Column Name Data Type Description Label Validation Text Unit 1 EXPEDITION Numeric expedition code Expedition expedition code (Int. 1 - 99999), required key field between 1 and 9999 # 2 SITE Numeric site code, max. number between 1 and 9999 Site site code (num 4), required key field <>0 # 3 HOLE text hole code, A-Z Hole hole code (max. 1 chars, A-Z), required key field LIKE ('[A-Z]') # 5 HALF Text section half sample is taken (A,W,WR) Half half is: A=archieve, W=working, WR=whole round IN ( 'A','W', 'WR') # 6 SERIES_TYPE Text type of sample series # # # # 7 TYPE Text sample code, default is --- if a request is specified Sample Type required field, a valid sample type <>'' # 8 TOP_DEPTH Double relative top depth of sample in cm Top Depth top depth required field >=0 >=0 cm 9 BOTTOM_DEPTH Double bottom depth of sample Bottom Depth bottom depth required field <>0 <>0 cm 10 VOLUME Integer volume of sample in cc Sample Volume (cc) sample volume,required field a valid volume (0 - 200000) Between 0 And 200000 # 11 LOCATION Text location identifier, shortcut of core repository Repository repository: DRI or SBR IN ( 'DRI','SBR') # 12 REQUEST Text identifier of sample request Request ID required field, a valid request identifier sample belongs to # # 13 REQUEST_PART Text identifier of request part sample was taken for Request Part request part, a character between A and Z LIKE ('[A-Z]') # 14 ANALYST Text initials of observer Curator # # # 15 SAMPLE_DATE Date date and time sample was taken Sample Date required field, a valid sample date <>0 # 16 REMARKS Text optional additional remarks Remarks # # # 17 IGSN Text IGSN # # # # ####################### Data Part ############################# EXPEDITION SITE HOLE LABEL HALF SERIES_TYPE TYPE TOP_DEPTH BOTTOM_DEPTH VOLUME LOCATION REQUEST REQUEST_PART ANALYST SAMPLE_DATE REMARKS IGSN 5029 4 B 3_1 W Undefined --- 5 7 2 DRI IDDP0002 A RZ 18-Nov-2016 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EX01701 5029 4 B 3_1 W Undefined --- 9 11 2 DRI IDDP0003 A RZ 18-Nov-2016 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EX11701 5029 4 B 3_1 W Undefined --- 15 17 2 DRI IDDP0004 A RZ 18-Nov-2016 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EX21701 5029 4 B 3_1 W Undefined --- 22 24 2 DRI IDDP0005 A RZ 18-Nov-2016 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EX31701 5029 4 B 3_1 W Undefined --- 28 30 2 DRI IDDP0006 A RZ 18-Nov-2016 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EX41701 5029 4 B 3_1 W Undefined --- 5 7 2 DRI IDDP0002 A RZ 18-Nov-2016 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EX01701 5029 4 B 3_1 W Undefined --- 12 31 19 DRI IDDP0008 A RZ 30-Dec-2016 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXA1701 5029 4 B 3_1 W Undefined --- 31 52 21 DRI IDDP0009 A RZ 30-Dec-2016 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXB1701 5029 4 B 5_1 W Undefined --- 0 4 4 DRI IDDP0010 A RZ 30-Dec-2016 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXC1701 5029 4 B 5_3 W Undefined --- 59 65 4 DRI IDDP0011 A RZ 30-Dec-2016 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXD1701 5029 4 B 6_1 W Undefined --- 5 15 10 DRI IDDP0012 B RZ 30-Dec-2016 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXE1701 5029 4 B 7_1 W Undefined --- 5 8 3 DRI IDDP0013 B RZ 30-Dec-2016 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXH1701 5029 4 B 8_1 W Undefined CA 19 28 9 DRI IDDP0014 B RZ 03-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXJ1701 5029 4 B 10_1 W Undefined CA 14 22 8 DRI IDDP0015 B RZ 03-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXK1701 5029 4 B 3_1 W Undefined PP 3 6 3 DRI IDDP0016 A RZ 03-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXL1701 5029 4 B 3_1 W Undefined PP 45 48 3 DRI IDDP0017 A RZ 03-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXM1701 5029 4 B 5_1 W Undefined PP 8 11 3 DRI IDDP0018 A RZ 03-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXN1701 5029 4 B 5_1 W Undefined PP 22 25 3 DRI IDDP0019 A RZ 03-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXO1701 5029 4 B 5_3 W Undefined PP 61 64 3 DRI IDDP0020 A RZ 03-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXP1701 5029 4 B 5_3 W Undefined PP 68 71 3 DRI IDDP0021 A RZ 03-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXQ1701 5029 4 B 6_1 W Undefined PP 11 14 3 DRI IDDP0022 A RZ 03-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXR1701 5029 4 B 7_1 W Undefined PP 3 8 5 DRI IDDP0023 A RZ 03-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXS1701 5029 4 B 8_1 W Undefined PP 8 11 3 DRI IDDP0024 A RZ 03-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXT1701 5029 4 B 10_1 W Undefined PP 16 19 3 DRI IDDP0025 A RZ 03-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXU1701 5029 4 B 3_1 W Undefined TS 31 33 2 DRI IDDP0026 A RZ 03-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXV1701 5029 4 B 3_1 W Undefined TS 47 52 5 DRI IDDP0027 A RZ 03-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXW1701 5029 4 B 3_1 W Undefined TS 48 52 4 DRI IDDP0028 A RZ 03-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXX1701 5029 4 B 5_1 W Undefined TS 0 2 2 DRI IDDP0029 A RZ 03-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXY1701 5029 4 B 5_1 W Undefined TS 105 107 2 DRI IDDP0030 A RZ 03-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXZ1701 5029 4 B 5_2 W Undefined TS 102 107 5 DRI IDDP0031 A RZ 03-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EX02701 5029 4 B 5_3 W Undefined TS 60 65 5 DRI IDDP0032 A RZ 05-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EX32701 5029 4 B 5_3 W Undefined TS 141 143 2 DRI IDDP0033 A RZ 05-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EX42701 5029 4 B 6_1 W Undefined TS 5 10 5 DRI IDDP0034 A RZ 05-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EX52701 5029 4 B 7_1 W Undefined TS 0 2 2 DRI IDDP0035 A RZ 05-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EX62701 5029 4 B 7_1 W Undefined TS 7 8 1 DRI IDDP0036 A RZ 05-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EX72701 5029 4 B 8_1 W Undefined TS 0 5 5 DRI IDDP0037 A RZ 05-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EX92701 5029 4 B 8_1 W Undefined TS 23 28 5 DRI IDDP0038 A RZ 05-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXB2701 5029 4 B 10_1 W Undefined TS 7 12 5 DRI IDDP0039 A RZ 05-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXC2701 5029 4 B 10_1 W Undefined TS 16 21 5 DRI IDDP0040 A RZ 05-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXD2701 5029 4 B 11_3 W Undefined CA 58 63 5 DRI IDDP0041 A GOF 27-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXE2701 5029 4 B 11_1 W Undefined CA 28 32 4 DRI IDDP0042 A GOF 27-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXG2701 5029 4 B 11_1 W Undefined CA 91 95 4 DRI IDDP0043 A GOF 27-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXH2701 5029 4 B 11_2 W Undefined CA 95 102 7 DRI IDDP0044 A GOF 27-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXJ2701 5029 4 B 11_2 W Undefined CA 50 56 6 DRI IDDP0045 A GOF 27-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXL2701 5029 4 B 11_3 W Undefined CA 56 58 2 DRI IDDP0046 A GOF 27-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXM2701 5029 4 B 11_5 W Undefined CA 120 123 3 DRI IDDP0047 A GOF 27-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXN2701 5029 4 B 11_5 W Undefined CA 0 3 3 DRI IDDP0048 A GOF 27-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXO2701 5029 4 B 12_5 W Undefined CA 89 99 10 DRI IDDP0049 A GOF 27-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXP2701 5029 4 B 12_6 W Undefined CA 17 18 1 DRI IDDP0050 A GOF 27-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXR2701 5029 4 B 12_6 W Undefined CA 18 27 9 DRI IDDP0051 A GOF 27-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXS2701 5029 4 B 13_3 W Undefined CA 0 5 5 DRI IDDP0052 A GOF 27-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXT2701 5029 4 B 13_2 W Undefined CA 27 30 3 DRI IDDP0053 A GOF 27-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXU2701 5029 4 B 11_5 W Undefined PP 110 120 10 DRI IDDP0054 A GOF 27-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXV2701 5029 4 B 12_5 W Undefined PP 41 51 10 DRI IDDP0055 A GOF 27-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXW2701 5029 4 B 13_2 W Undefined PP 122 132 10 DRI IDDP0056 A GOF 27-Jan-2017 00:00 5029_4_B-RN-15 -deepening RN-15 down to 5000m: sidetrack from hole 4A ICDP5029EXX2701