####################### 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 # 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, valid sample type # 8 TOP_DEPTH Double relative top depth of sample in cm Top Depth top depth required field >=0 cm 9 BOTTOM_DEPTH Double bottom depth of sample Bottom Depth bottom depth required field cm 10 VOLUME Integer volume of sample in cc Sample Volume (cc) sample volume, required field, 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, 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, valid sample date # 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 5052 2 A 59.10_FO - Undefined WO 0 110 10 DRI DFDP5003 A MK 21-Jan-2015 00:00 DFDP-2A ICDP5052EXVQ601