{
 "currentVersion": 11.3,
 "cimVersion": "3.3.0",
 "id": 1,
 "name": "Projects",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "Name",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "Number",
   "type": "esriFieldTypeString",
   "alias": "Number",
   "length": 20,
   "domain": null
  },
  {
   "name": "Name",
   "type": "esriFieldTypeString",
   "alias": "Name",
   "length": 100,
   "domain": null
  },
  {
   "name": "Description",
   "type": "esriFieldTypeString",
   "alias": "Description",
   "length": 400,
   "domain": null
  },
  {
   "name": "Confidential",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Confidential",
   "domain": null
  },
  {
   "name": "Principal",
   "type": "esriFieldTypeString",
   "alias": "Principal",
   "length": 50,
   "domain": null
  },
  {
   "name": "ProjectManager",
   "type": "esriFieldTypeString",
   "alias": "ProjectManager",
   "length": 50,
   "domain": null
  },
  {
   "name": "ClientName",
   "type": "esriFieldTypeString",
   "alias": "ClientName",
   "length": 200,
   "domain": null
  },
  {
   "name": "StartDate",
   "type": "esriFieldTypeDate",
   "alias": "StartDate",
   "length": 8,
   "domain": null
  },
  {
   "name": "EndDate",
   "type": "esriFieldTypeDate",
   "alias": "EndDate",
   "length": 8,
   "domain": null
  },
  {
   "name": "PrimaryProjectPurposeTags",
   "type": "esriFieldTypeString",
   "alias": "PrimaryProjectPurposeTags",
   "length": 1000,
   "domain": null
  },
  {
   "name": "SiteId",
   "type": "esriFieldTypeInteger",
   "alias": "SiteId",
   "domain": null
  },
  {
   "name": "Comments",
   "type": "esriFieldTypeString",
   "alias": "Comments",
   "length": 2000,
   "domain": null
  },
  {
   "name": "ReadOnly",
   "type": "esriFieldTypeSmallInteger",
   "alias": "ReadOnly",
   "domain": null
  },
  {
   "name": "RecordOwner",
   "type": "esriFieldTypeString",
   "alias": "RecordOwner",
   "length": 50,
   "domain": null
  },
  {
   "name": "RecordOwnerCP",
   "type": "esriFieldTypeInteger",
   "alias": "RecordOwnerCP",
   "domain": null
  },
  {
   "name": "RecordOwnerBU",
   "type": "esriFieldTypeString",
   "alias": "RecordOwnerBU",
   "length": 60,
   "domain": null
  },
  {
   "name": "CreatedBy",
   "type": "esriFieldTypeString",
   "alias": "CreatedBy",
   "length": 50,
   "domain": null
  },
  {
   "name": "DateCreated",
   "type": "esriFieldTypeDate",
   "alias": "DateCreated",
   "length": 8,
   "domain": null
  },
  {
   "name": "ModifiedBy",
   "type": "esriFieldTypeString",
   "alias": "ModifiedBy",
   "length": 50,
   "domain": null
  },
  {
   "name": "DateModified",
   "type": "esriFieldTypeDate",
   "alias": "DateModified",
   "length": 8,
   "domain": null
  },
  {
   "name": "CP",
   "type": "esriFieldTypeSmallInteger",
   "alias": "CP",
   "domain": {
    "type": "codedValue",
    "name": "CPs_ID",
    "description": "Consulting Practices",
    "codedValues": [
     {
      "name": "Argentina",
      "code": 1
     },
     {
      "name": "Australia",
      "code": 2
     },
     {
      "name": "Brazil",
      "code": 3
     },
     {
      "name": "Chile",
      "code": 4
     },
     {
      "name": "China",
      "code": 5
     },
     {
      "name": "Congo",
      "code": 6
     },
     {
      "name": "Finland",
      "code": 7
     },
     {
      "name": "Ghana",
      "code": 8
     },
     {
      "name": "Hong Kong",
      "code": 9
     },
     {
      "name": "India",
      "code": 10
     },
     {
      "name": "Kazakhstan",
      "code": 11
     },
     {
      "name": "Mongolia",
      "code": 12
     },
     {
      "name": "North America",
      "code": 13
     },
     {
      "name": "Peru",
      "code": 14
     },
     {
      "name": "Russia",
      "code": 15
     },
     {
      "name": "South Africa",
      "code": 16
     },
     {
      "name": "Sweden",
      "code": 17
     },
     {
      "name": "Turkey",
      "code": 18
     },
     {
      "name": "United Kingdom",
      "code": 19
     },
     {
      "name": "Affiliate Companies",
      "code": 20
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "StudyStage",
   "type": "esriFieldTypeSmallInteger",
   "alias": "StudyStage",
   "domain": {
    "type": "codedValue",
    "name": "StudyStage_ID",
    "description": "Study Stage",
    "codedValues": [
     {
      "name": "Scoping-PEA",
      "code": 1
     },
     {
      "name": "Pre-Feasibility",
      "code": 2
     },
     {
      "name": "Feasibility",
      "code": 3
     },
     {
      "name": "Detail Design",
      "code": 4
     },
     {
      "name": "Not Relevant",
      "code": 5
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "PropertyStage",
   "type": "esriFieldTypeSmallInteger",
   "alias": "PropertyStage",
   "domain": {
    "type": "codedValue",
    "name": "PropertyStage_ID",
    "description": "Property Stage",
    "codedValues": [
     {
      "name": "Exploration",
      "code": 1
     },
     {
      "name": "Advanced Exploration",
      "code": 2
     },
     {
      "name": "Development",
      "code": 3
     },
     {
      "name": "Operating Mine",
      "code": 4
     },
     {
      "name": "Care and Maintenance",
      "code": 5
     },
     {
      "name": "Closure",
      "code": 6
     },
     {
      "name": "Not Relevant",
      "code": 7
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ClientClassification",
   "type": "esriFieldTypeSmallInteger",
   "alias": "ClientClassification",
   "domain": {
    "type": "codedValue",
    "name": "ClientClassification_ID",
    "description": "Client Classification",
    "codedValues": [
     {
      "name": "Major Mining Company",
      "code": 1
     },
     {
      "name": "Intermediate Mining Company",
      "code": 2
     },
     {
      "name": "Junior Mining Company",
      "code": 3
     },
     {
      "name": "Government",
      "code": 4
     },
     {
      "name": "Intermediary",
      "code": 5
     },
     {
      "name": "Industrial Mineral Production",
      "code": 6
     },
     {
      "name": "Industrial Corporation",
      "code": 7
     },
     {
      "name": "Other",
      "code": 8
     },
     {
      "name": "SRK Affiliates",
      "code": 9
     },
     {
      "name": "Unknown",
      "code": 10
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "PPP_Code",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Primarty Project Purpose Code",
   "domain": {
    "type": "codedValue",
    "name": "PrimaryProjectPurpose_ID",
    "description": "Primary Project Purpose",
    "codedValues": [
     {
      "name": "Mining Viability Studies",
      "code": 1
     },
     {
      "name": "Operational Improvement",
      "code": 2
     },
     {
      "name": "Mine Waste Management",
      "code": 3
     },
     {
      "name": "Mine Reclamation and Closure",
      "code": 4
     },
     {
      "name": "Mining Infrastructure",
      "code": 5
     },
     {
      "name": "Independent Project Review",
      "code": 6
     },
     {
      "name": "Legal Support",
      "code": 7
     },
     {
      "name": "Corporate Advisory",
      "code": 8
     },
     {
      "name": "Geology / Resources",
      "code": 9
     },
     {
      "name": "Mining / Reserves",
      "code": 10
     },
     {
      "name": "Process / Metallurgy",
      "code": 11
     },
     {
      "name": "Ventilation",
      "code": 12
     },
     {
      "name": "Rock Mechanics",
      "code": 13
     },
     {
      "name": "Soil Mechanics",
      "code": 14
     },
     {
      "name": "Mine Water Management",
      "code": 15
     },
     {
      "name": "Geochemistry",
      "code": 16
     },
     {
      "name": "Environmental / Social",
      "code": 17
     },
     {
      "name": "Contaminated Land",
      "code": 18
     },
     {
      "name": "Storm Water Management",
      "code": 19
     },
     {
      "name": "Infrastructure",
      "code": 20
     },
     {
      "name": "Groundwater Supply",
      "code": 21
     },
     {
      "name": "Nuclear Waste",
      "code": 22
     },
     {
      "name": "Civil Tunneling",
      "code": 23
     },
     {
      "name": "Civil Infrastructure",
      "code": 24
     },
     {
      "name": "Full Technical Report (Compliance)",
      "code": 25
     },
     {
      "name": "Construction Oversight",
      "code": 26
     },
     {
      "name": "Contributor Technical Report (Compliance)",
      "code": 27
     },
     {
      "name": "Full Study Report",
      "code": 28
     },
     {
      "name": "Contributor Study Report",
      "code": 29
     },
     {
      "name": "Independent Review Report",
      "code": 30
     },
     {
      "name": "Closure Plan",
      "code": 31
     },
     {
      "name": "Audit",
      "code": 32
     },
     {
      "name": "Legal Report",
      "code": 33
     },
     {
      "name": "Financial Report",
      "code": 34
     },
     {
      "name": "Trade-off Studies (Stand alone)",
      "code": 35
     },
     {
      "name": "Training",
      "code": 36
     },
     {
      "name": "Engineering Report",
      "code": 37
     },
     {
      "name": "Geoscience Report",
      "code": 38
     },
     {
      "name": "Engineering Drawings",
      "code": 39
     },
     {
      "name": "Engineering Specifications",
      "code": 40
     },
     {
      "name": "Permit Applications",
      "code": 41
     },
     {
      "name": "Exploration / Resource",
      "code": 42
     },
     {
      "name": "Scoping / Preliminary Economics Assessment (PEA)",
      "code": 43
     },
     {
      "name": "Prefeasibility",
      "code": 44
     },
     {
      "name": "Feasibility (FS / BFS / DFS)",
      "code": 45
     },
     {
      "name": "FEED (Front End Engineering & Design)",
      "code": 46
     },
     {
      "name": "Detailed Design",
      "code": 47
     },
     {
      "name": "Operations and Optimization",
      "code": 48
     },
     {
      "name": "Closure and Maintenance",
      "code": 49
     },
     {
      "name": "Not Relevant (Stand Alone)",
      "code": 50
     },
     {
      "name": "NI 43-101",
      "code": 51
     },
     {
      "name": "JORC",
      "code": 52
     },
     {
      "name": "Other Public Instrument",
      "code": 53
     },
     {
      "name": "Internal Client Use",
      "code": 54
     },
     {
      "name": "Auditing",
      "code": 55
     },
     {
      "name": "Characterization Data Analysis",
      "code": 56
     },
     {
      "name": "Cost Estimation",
      "code": 57
     },
     {
      "name": "Design",
      "code": 58
     },
     {
      "name": "Evaluation",
      "code": 59
     },
     {
      "name": "Field / Lab Characterization Program",
      "code": 60
     },
     {
      "name": "Foundation Assessment",
      "code": 61
     },
     {
      "name": "GIS",
      "code": 62
     },
     {
      "name": "Inspections",
      "code": 63
     },
     {
      "name": "Investigations",
      "code": 64
     },
     {
      "name": "Management Plans",
      "code": 65
     },
     {
      "name": "Market Studies",
      "code": 66
     },
     {
      "name": "Monitoring",
      "code": 67
     },
     {
      "name": "Numerical Modeling",
      "code": 68
     },
     {
      "name": "Operational Support",
      "code": 69
     },
     {
      "name": "Performance Monitoring",
      "code": 70
     },
     {
      "name": "Permitting",
      "code": 71
     },
     {
      "name": "Planning",
      "code": 72
     },
     {
      "name": "Project Execution Reviews",
      "code": 73
     },
     {
      "name": "Remote Sensing",
      "code": 74
     },
     {
      "name": "Risk Assessment",
      "code": 75
     },
     {
      "name": "Technical Review",
      "code": 76
     },
     {
      "name": "Terrain Risk Assessments",
      "code": 77
     },
     {
      "name": "Trade-off Studies",
      "code": 78
     },
     {
      "name": "3D Modeling  ",
      "code": 79
     },
     {
      "name": "Alteration Mapping",
      "code": 80
     },
     {
      "name": "Exploration",
      "code": 81
     },
     {
      "name": "Exploration Geochemistry",
      "code": 82
     },
     {
      "name": "Geophysics",
      "code": 83
     },
     {
      "name": "Geostatistics",
      "code": 84
     },
     {
      "name": "Resource Estimation",
      "code": 85
     },
     {
      "name": "Sampling QA / QC",
      "code": 86
     },
     {
      "name": "Structural Geology",
      "code": 87
     },
     {
      "name": "Targeting",
      "code": 88
     },
     {
      "name": "Geomineralogy and Geometallurgy  ",
      "code": 89
     },
     {
      "name": "Metallurgical Studies",
      "code": 90
     },
     {
      "name": "Plant Performance Audit / Optimization",
      "code": 91
     },
     {
      "name": "Process Design Services",
      "code": 92
     },
     {
      "name": "Process Recovery",
      "code": 93
     },
     {
      "name": "Agitated Leaching",
      "code": 94
     },
     {
      "name": "Ferrometallurgical",
      "code": 95
     },
     {
      "name": "Flotation",
      "code": 96
     },
     {
      "name": "Heap Leach",
      "code": 97
     },
     {
      "name": "Hydrometallurgical",
      "code": 98
     },
     {
      "name": "Remediation",
      "code": 99
     },
     {
      "name": "Backfill Design",
      "code": 100
     },
     {
      "name": "Blasting / Fragmentation",
      "code": 101
     },
     {
      "name": "Mine CapEx / OpEx / Equipment Estimation",
      "code": 102
     },
     {
      "name": "Mine Design",
      "code": 103
     },
     {
      "name": "Mine Operation Support",
      "code": 104
     },
     {
      "name": "Mine Planning",
      "code": 105
     },
     {
      "name": "Mine Scheduling",
      "code": 106
     },
     {
      "name": "Mine Simulation",
      "code": 107
     },
     {
      "name": "Pit Optimization",
      "code": 108
     },
     {
      "name": "Reserves",
      "code": 109
     },
     {
      "name": "Shaft Design",
      "code": 110
     },
     {
      "name": "Surface/Open Pit ",
      "code": 111
     },
     {
      "name": "Tailings Relocation / Rehandling",
      "code": 112
     },
     {
      "name": "In-Situ Leaching",
      "code": 113
     },
     {
      "name": "Brine Extraction",
      "code": 114
     },
     {
      "name": "Block/Panel Caving",
      "code": 115
     },
     {
      "name": "Sublevel Caving",
      "code": 116
     },
     {
      "name": "Cut and Fill",
      "code": 117
     },
     {
      "name": "Long Wall",
      "code": 118
     },
     {
      "name": "Room and Pillar",
      "code": 119
     },
     {
      "name": "Shrinkage",
      "code": 120
     },
     {
      "name": "Sublevel Open Stoping",
      "code": 121
     },
     {
      "name": "Sublevel Stoping with Backfill",
      "code": 122
     },
     {
      "name": "Underhand Cut and Fill",
      "code": 123
     },
     {
      "name": "Climatic Modeling",
      "code": 124
     },
     {
      "name": "Cooling Systems",
      "code": 125
     },
     {
      "name": "Fire Modeling",
      "code": 126
     },
     {
      "name": "Heating Systems",
      "code": 127
     },
     {
      "name": "Particulate Analysis",
      "code": 128
     },
     {
      "name": "Ventilation Design",
      "code": 129
     },
     {
      "name": "Energy",
      "code": 130
     },
     {
      "name": "Facilities and Storage",
      "code": 131
     },
     {
      "name": "Fuel / Air Supply",
      "code": 132
     },
     {
      "name": "Logistics",
      "code": 133
     },
     {
      "name": "Material Sizing",
      "code": 134
     },
     {
      "name": "Materials Handling",
      "code": 135
     },
     {
      "name": "Transportation",
      "code": 136
     },
     {
      "name": "Water Handling",
      "code": 137
     },
     {
      "name": "Attenuation Modeling",
      "code": 138
     },
     {
      "name": "Baseline Water Chemistry",
      "code": 139
     },
     {
      "name": "Geochemical Modeling",
      "code": 140
     },
     {
      "name": "Pit Lake Analysis",
      "code": 141
     },
     {
      "name": "Waste Characterization",
      "code": 142
     },
     {
      "name": "Waste Management Plans",
      "code": 143
     },
     {
      "name": "Water Quality Prediction",
      "code": 144
     },
     {
      "name": "Water Quality /ARD / ML",
      "code": 145
     },
     {
      "name": "Dewatering Assessment / Evaluation",
      "code": 146
     },
     {
      "name": "Flood Management / Hydraulic Design",
      "code": 147
     },
     {
      "name": "Ground Water Characterization",
      "code": 148
     },
     {
      "name": "Ground Water Monitoring",
      "code": 149
     },
     {
      "name": "Ground Water Supply Study",
      "code": 150
     },
     {
      "name": "Load Balance/Water Quality Prediction",
      "code": 151
     },
     {
      "name": "Seepage Control",
      "code": 152
     },
     {
      "name": "Surface Water Hydrology",
      "code": 153
     },
     {
      "name": "Water Balance",
      "code": 154
     },
     {
      "name": "Water Management",
      "code": 155
     },
     {
      "name": "Water Treatment",
      "code": 156
     },
     {
      "name": "Geotechnical Mine Design Parameter",
      "code": 157
     },
     {
      "name": "Ground Control Specifications",
      "code": 158
     },
     {
      "name": "Stability Analysis",
      "code": 159
     },
     {
      "name": "Open Pit / UG Interactions",
      "code": 160
     },
     {
      "name": "Pit Slope Rock",
      "code": 161
     },
     {
      "name": "Foundations Assessment",
      "code": 162
     },
     {
      "name": "Geotechnical Inspections",
      "code": 163
     },
     {
      "name": "Pit Slope Soils",
      "code": 164
     },
     {
      "name": "Roads and Cuts",
      "code": 165
     },
     {
      "name": "Seismic Hazards",
      "code": 166
     },
     {
      "name": "Best Practices Evaluations (OMS, EPRP)",
      "code": 167
     },
     {
      "name": "Cover Design",
      "code": 168
     },
     {
      "name": "Dam / Pond Design",
      "code": 169
     },
     {
      "name": "Dam Break Analysis",
      "code": 170
     },
     {
      "name": "Dam Safety Inspections",
      "code": 171
     },
     {
      "name": "Drainage",
      "code": 172
     },
     {
      "name": "Heap Leach Design",
      "code": 173
     },
     {
      "name": "Waste Characterization",
      "code": 174
     },
     {
      "name": "Waste Dump Design",
      "code": 175
     },
     {
      "name": "Dams & Hydropower",
      "code": 176
     },
     {
      "name": "Landfills",
      "code": 177
     },
     {
      "name": "Nuclear Waste",
      "code": 178
     },
     {
      "name": "Ports",
      "code": 179
     },
     {
      "name": "Rails",
      "code": 180
     },
     {
      "name": "Roads",
      "code": 181
     },
     {
      "name": "Structural Design",
      "code": 182
     },
     {
      "name": "Tunneling / Subways",
      "code": 183
     },
     {
      "name": "Air Quality",
      "code": 184
     },
     {
      "name": "Baseline Studies",
      "code": 185
     },
     {
      "name": "Environmental Impact Assessment",
      "code": 186
     },
     {
      "name": "ESIA / ESIS",
      "code": 187
     },
     {
      "name": "Flora and Fauna (Fish)",
      "code": 188
     },
     {
      "name": "Social",
      "code": 189
     },
     {
      "name": "Water Quality",
      "code": 190
     },
     {
      "name": "Financial Modeling",
      "code": 191
     },
     {
      "name": "TEM (Technical Economic Modeling)",
      "code": 192
     },
     {
      "name": "Business Strategy",
      "code": 193
     },
     {
      "name": "Expert Witness",
      "code": 194
     },
     {
      "name": "Competent Person (Report)",
      "code": 195
     },
     {
      "name": "Due Diligence",
      "code": 196
     },
     {
      "name": "Fatal Flaw",
      "code": 197
     },
     {
      "name": "IE (Independent Engineers Report)",
      "code": 198
     },
     {
      "name": "Wrkshop",
      "code": 199
     },
     {
      "name": "SRK Internal Overhead",
      "code": 201
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "PM_Email",
   "type": "esriFieldTypeString",
   "alias": "Project Manager Email",
   "length": 255,
   "domain": null
  },
  {
   "name": "Principal_Email",
   "type": "esriFieldTypeString",
   "alias": "Principal Email",
   "length": 255,
   "domain": null
  },
  {
   "name": "LegacyNumber",
   "type": "esriFieldTypeString",
   "alias": "Legacy Number",
   "length": 20,
   "domain": null
  },
  {
   "name": "LegalCompanyName",
   "type": "esriFieldTypeString",
   "alias": "Legal Company Name",
   "length": 255,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R24_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "GDB_1631_SiteId",
   "fields": "SiteId",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 0,
   "name": "Sites",
   "relatedTableId": 0,
   "role": "esriRelRoleDestination",
   "keyField": "SiteId",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{461F2FFC-FA5A-4834-864F-31470F347197}"
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 15000,
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, PBF",
 "isDataVersioned": false,
 "useStandardizedQueries": true,
 "advancedQueryCapabilities": {
  "useStandardizedQueries": true,
  "supportsStatistics": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsPagination": true,
  "supportsTrueCurve": false,
  "supportsReturningQueryExtent": true,
  "supportsQueryWithDistance": true,
  "supportsSqlExpression": true,
  "supportsTimeRelation": true,
  "supportsAdvancedQueryRelated": true,
  "supportsQueryRelatedPagination": true,
  "supportsSqlFormat": false,
  "supportsQueryAnalytic": true,
  "supportsCurrentUserQueries": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": null,
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "serviceItemId": "7740cf2f50fe4cd688dbcac829f71538"
}