{
 "currentVersion": 10.91,
 "cimVersion": "2.9.0",
 "id": 1,
 "name": "OCConstruction.DBO.JOC_Add_Proj_Info",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "Budget_BFAST_Num",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "Project_Number",
   "type": "esriFieldTypeDouble",
   "alias": "Project Number",
   "domain": null
  },
  {
   "name": "Project_Name",
   "type": "esriFieldTypeString",
   "alias": "Project Name",
   "length": 200,
   "domain": null
  },
  {
   "name": "Budget_BFAST_Num",
   "type": "esriFieldTypeString",
   "alias": "Budget/BFAST Numbers",
   "length": 12,
   "domain": null
  },
  {
   "name": "Cost_1",
   "type": "esriFieldTypeString",
   "alias": "Cost of Contract/% Completed (Prog Pay)",
   "length": 50,
   "domain": null
  },
  {
   "name": "Fiscal_Year",
   "type": "esriFieldTypeString",
   "alias": "Fiscal Year",
   "length": 10,
   "domain": null
  },
  {
   "name": "SWPP_Risk_Level",
   "type": "esriFieldTypeString",
   "alias": "SWPP Risk Level",
   "length": 50,
   "domain": null
  },
  {
   "name": "Construction_Milestones",
   "type": "esriFieldTypeString",
   "alias": "Construction Milestones",
   "length": 500,
   "domain": null
  },
  {
   "name": "Development_Milestones",
   "type": "esriFieldTypeString",
   "alias": "Development Milestones (PM Section)",
   "length": 500,
   "domain": null
  },
  {
   "name": "Planning_Initiation_Milestones",
   "type": "esriFieldTypeString",
   "alias": "Planning/Initiation Milestones (Engineering Section)",
   "length": 500,
   "domain": null
  },
  {
   "name": "Project_Status",
   "type": "esriFieldTypeString",
   "alias": "Project Status",
   "length": 500,
   "domain": null
  },
  {
   "name": "Jan1_Jan5_18",
   "type": "esriFieldTypeSingle",
   "alias": "Jan 1 - Jan 5 2018",
   "domain": null
  },
  {
   "name": "Jan8_Jan12_18",
   "type": "esriFieldTypeSingle",
   "alias": "Jan 8 - Jan 12 2018",
   "domain": null
  },
  {
   "name": "Jan15_Jan19_18",
   "type": "esriFieldTypeSingle",
   "alias": "Jan 15 - Jan 19 2018",
   "domain": null
  },
  {
   "name": "Jan22_Jan26_18",
   "type": "esriFieldTypeSingle",
   "alias": "Jan 22 - Jan 26 2018",
   "domain": null
  },
  {
   "name": "Jan29_Feb2_18",
   "type": "esriFieldTypeSingle",
   "alias": "Jan 29 - Feb 2 2018",
   "domain": null
  },
  {
   "name": "Feb5_Feb9_18",
   "type": "esriFieldTypeSingle",
   "alias": "Feb 5 - Feb 9 2018",
   "domain": null
  },
  {
   "name": "Feb12_Feb16_18",
   "type": "esriFieldTypeSingle",
   "alias": "Feb12 - Feb 16 2018",
   "domain": null
  },
  {
   "name": "Feb19_Feb23_18",
   "type": "esriFieldTypeSingle",
   "alias": "Feb 19 - Feb 23 2018",
   "domain": null
  },
  {
   "name": "Feb26_Mar2_18",
   "type": "esriFieldTypeSingle",
   "alias": "Feb 26 - Mar 2 2018",
   "domain": null
  },
  {
   "name": "Mar5_Mar9_18",
   "type": "esriFieldTypeSingle",
   "alias": "Mar 5 - Mar 9 2018",
   "domain": null
  },
  {
   "name": "Mar12_Mar16_18",
   "type": "esriFieldTypeSingle",
   "alias": "Mar 12 - Mar 16 2018",
   "domain": null
  },
  {
   "name": "Mar19_Mar23_18",
   "type": "esriFieldTypeSingle",
   "alias": "Mar 19 - Mar 23 2018",
   "domain": null
  },
  {
   "name": "Mar26_Mar30_18",
   "type": "esriFieldTypeSingle",
   "alias": "Mar 26 - Mar 30 2018",
   "domain": null
  },
  {
   "name": "Apr2_Apr6_18",
   "type": "esriFieldTypeSingle",
   "alias": "Apr 2 - Apr 6 2018",
   "domain": null
  },
  {
   "name": "Apr9_Apr13_18",
   "type": "esriFieldTypeSingle",
   "alias": "Apr 9 - Apr 13 2018",
   "domain": null
  },
  {
   "name": "Apr16_Apr20_18",
   "type": "esriFieldTypeSingle",
   "alias": "Apr 16 - Apr 20 2018",
   "domain": null
  },
  {
   "name": "Apr23_Apr27_18",
   "type": "esriFieldTypeSingle",
   "alias": "Apr 23 - Apr 27 2018",
   "domain": null
  },
  {
   "name": "Apr30_May4_18",
   "type": "esriFieldTypeSingle",
   "alias": "Apr 30 - May 4 2018",
   "domain": null
  },
  {
   "name": "May7_May11_18",
   "type": "esriFieldTypeSingle",
   "alias": "May 7 - May 11 2018",
   "domain": null
  },
  {
   "name": "May14_May18_18",
   "type": "esriFieldTypeSingle",
   "alias": "May 14 - May 18 2018",
   "domain": null
  },
  {
   "name": "May21_May25_18",
   "type": "esriFieldTypeSingle",
   "alias": "May 21 - May 25 2018",
   "domain": null
  },
  {
   "name": "May28_Jun1_18",
   "type": "esriFieldTypeSingle",
   "alias": "May 28 - Jun 1 2018",
   "domain": null
  },
  {
   "name": "Jun4_Jun8_18",
   "type": "esriFieldTypeSingle",
   "alias": "Jun 4 - Jun 8 2018",
   "domain": null
  },
  {
   "name": "Jun11_Jun15_18",
   "type": "esriFieldTypeSingle",
   "alias": "Jun 11 - Jun 15 2018",
   "domain": null
  },
  {
   "name": "Jun18_Jun22_18",
   "type": "esriFieldTypeSingle",
   "alias": "Jun 18 - Jun 22 2018",
   "domain": null
  },
  {
   "name": "Jun25_Jun29_18",
   "type": "esriFieldTypeSingle",
   "alias": "Jun 25 - Jun 29 2018",
   "domain": null
  },
  {
   "name": "Jul2_Jul6_18",
   "type": "esriFieldTypeSingle",
   "alias": "Jul 2 - Jul 6 2018",
   "domain": null
  },
  {
   "name": "Jul9_Jul13_18",
   "type": "esriFieldTypeSingle",
   "alias": "Jul 9 - Jul 13 2018",
   "domain": null
  },
  {
   "name": "Jul16_Jul20_18",
   "type": "esriFieldTypeSingle",
   "alias": "Jul 16 - Jul 20 2018",
   "domain": null
  },
  {
   "name": "Jul23_Jul27_18",
   "type": "esriFieldTypeSingle",
   "alias": "Jul 23 - Jul 27 2018",
   "domain": null
  },
  {
   "name": "Jul30_Aug3_18",
   "type": "esriFieldTypeSingle",
   "alias": "Jul 30 - Aug 3 2018",
   "domain": null
  },
  {
   "name": "Aug6_Aug10_18",
   "type": "esriFieldTypeSingle",
   "alias": "Aug 6 - Aug 10 2018",
   "domain": null
  },
  {
   "name": "Aug13_Aug17_18",
   "type": "esriFieldTypeSingle",
   "alias": "Aug 13 - Aug 17 2018",
   "domain": null
  },
  {
   "name": "Aug20_Aug24_18",
   "type": "esriFieldTypeSingle",
   "alias": "Aug 20 - Aug 24 2018",
   "domain": null
  },
  {
   "name": "Aug27_Aug31_18",
   "type": "esriFieldTypeSingle",
   "alias": "Aug 27 - Aug 31 2018",
   "domain": null
  },
  {
   "name": "Sep3_Sep7_18",
   "type": "esriFieldTypeSingle",
   "alias": "Sep 3 - Sep 7 2018",
   "domain": null
  },
  {
   "name": "Sep10_Sep14_18",
   "type": "esriFieldTypeSingle",
   "alias": "Sep 10 - Sep 14 2018",
   "domain": null
  },
  {
   "name": "Sep17_Sep21_18",
   "type": "esriFieldTypeSingle",
   "alias": "Sep 17 - Sep 21 2018",
   "domain": null
  },
  {
   "name": "Sep24_Sep28_18",
   "type": "esriFieldTypeSingle",
   "alias": "Sep 24 - Sep 28 2018",
   "domain": null
  },
  {
   "name": "Oct1_Oct5_18",
   "type": "esriFieldTypeSingle",
   "alias": "Oct 1 - Oct 5 2018",
   "domain": null
  },
  {
   "name": "Oct8_Oct12_18",
   "type": "esriFieldTypeSingle",
   "alias": "Oct 8 - Oct 12 2018",
   "domain": null
  },
  {
   "name": "Oct15_Oct19_18",
   "type": "esriFieldTypeSingle",
   "alias": "Oct 15 - Oct 19 2018",
   "domain": null
  },
  {
   "name": "Oct22_Oct26_18",
   "type": "esriFieldTypeSingle",
   "alias": "Oct 22 - Oct 26 2018",
   "domain": null
  },
  {
   "name": "Oct29_Nov2_18",
   "type": "esriFieldTypeSingle",
   "alias": "Oct 29 - Nov 2 2018",
   "domain": null
  },
  {
   "name": "Nov5_Nov9_18",
   "type": "esriFieldTypeSingle",
   "alias": "Nov 5 - Nov 9 2018",
   "domain": null
  },
  {
   "name": "Nov12_Nov16_18",
   "type": "esriFieldTypeSingle",
   "alias": "Nov 12 - Nov 16 2018",
   "domain": null
  },
  {
   "name": "Nov19_Nov23_18",
   "type": "esriFieldTypeSingle",
   "alias": "Nov 19 - Nov 23 2018",
   "domain": null
  },
  {
   "name": "Nov26_Nov30_18",
   "type": "esriFieldTypeSingle",
   "alias": "Nov 26 - Nov 30 2018",
   "domain": null
  },
  {
   "name": "Dec3_Dec7_18",
   "type": "esriFieldTypeSingle",
   "alias": "Dec 3 - Dec 7 2018",
   "domain": null
  },
  {
   "name": "Dec10_Dec14_18",
   "type": "esriFieldTypeSingle",
   "alias": "Dec 10 - Dec 14 2018",
   "domain": null
  },
  {
   "name": "Dec17_Dec21_18",
   "type": "esriFieldTypeSingle",
   "alias": "Dec 17 - Dec 21 2018",
   "domain": null
  },
  {
   "name": "Dec24_Dec28_18",
   "type": "esriFieldTypeSingle",
   "alias": "Dec 24 - Dec 28 2018",
   "domain": null
  },
  {
   "name": "Phase",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Phase",
   "domain": {
    "type": "codedValue",
    "name": "Phases",
    "description": "",
    "codedValues": [
     {
      "name": "Initial/Planning",
      "code": 1
     },
     {
      "name": "Active Construction/Development",
      "code": 2
     },
     {
      "name": "Closeout",
      "code": 3
     },
     {
      "name": "Litigation",
      "code": 4
     },
     {
      "name": "Mitigation",
      "code": 5
     },
     {
      "name": "Complete",
      "code": 6
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Contractor",
   "type": "esriFieldTypeString",
   "alias": "Contractor",
   "length": 50,
   "domain": null
  },
  {
   "name": "Job_Code",
   "type": "esriFieldTypeString",
   "alias": "Job_Code",
   "length": 10,
   "domain": null
  },
  {
   "name": "District_Project_Sponsor",
   "type": "esriFieldTypeString",
   "alias": "District/Project Sponsor",
   "length": 50,
   "domain": null
  },
  {
   "name": "PM_INSP",
   "type": "esriFieldTypeString",
   "alias": "PM/INSP",
   "length": 100,
   "domain": null
  },
  {
   "name": "Active_1",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Active",
   "domain": {
    "type": "codedValue",
    "name": "Yes/No",
    "description": "",
    "codedValues": [
     {
      "name": "No",
      "code": 0
     },
     {
      "name": "Yes",
      "code": 1
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "created_user",
   "type": "esriFieldTypeString",
   "alias": "created_user",
   "length": 255,
   "domain": null
  },
  {
   "name": "created_date",
   "type": "esriFieldTypeDate",
   "alias": "created_date",
   "length": 8,
   "domain": null
  },
  {
   "name": "last_edited_user",
   "type": "esriFieldTypeString",
   "alias": "last_edited_user",
   "length": 255,
   "domain": null
  },
  {
   "name": "last_edited_date",
   "type": "esriFieldTypeDate",
   "alias": "last_edited_date",
   "length": 8,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R30_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "GDB_836_Project_",
   "fields": "Project_Number",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 0,
   "name": "JOC_Project_Updates",
   "relatedTableId": 0,
   "role": "esriRelRoleDestination",
   "keyField": "Project_Number",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": true
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 1000,
 "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,
  "supportsSqlFormat": false,
  "supportsQueryAnalytic": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": null,
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": false,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 }
}