{
 "currentVersion": 11.2,
 "cimVersion": "3.2.0",
 "id": 37,
 "name": "PASS Contracts",
 "type": "Table",
 "description": "Contract data that comes from the District of Columbia\u2019s Procurement Automated Support System (PASS). The Office of Contracting and Procurement (OCP) is required to post contract awards valued at $100,000 or more for agencies served by OCP. The awarded contracts database includes a caption describing the type of goods or services provided, the contract number, the ordering agency, the contract amount, the period of time covered by the contract award, the contractor receiving the award, and the market type. To obtain a copy of any contract, you may submit a FOIA request onlinevia the DC government Public FOIA Portal. Questions regarding details within the data, contact the Office of Contract and Procurement at https://contracts.ocp.dc.gov/contact.",
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "AGENCY_NAME",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "TITLE",
   "type": "esriFieldTypeString",
   "alias": "TITLE",
   "length": 1017,
   "domain": null
  },
  {
   "name": "AGENCY",
   "type": "esriFieldTypeString",
   "alias": "BUDGET CODE",
   "length": 384,
   "domain": null
  },
  {
   "name": "MARKETTYPE",
   "type": "esriFieldTypeString",
   "alias": "MARKETTYPE",
   "length": 300,
   "domain": null
  },
  {
   "name": "LASTMODIFIED",
   "type": "esriFieldTypeDate",
   "alias": "LASTMODIFIED",
   "length": 8,
   "domain": null
  },
  {
   "name": "CONTRACTSTATUS",
   "type": "esriFieldTypeString",
   "alias": "CONTRACTSTATUS",
   "length": 90,
   "domain": null
  },
  {
   "name": "AWARDDATE",
   "type": "esriFieldTypeDate",
   "alias": "AWARDDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "CONTRACTINGOFFICER",
   "type": "esriFieldTypeString",
   "alias": "CONTRACTINGOFFICER",
   "length": 765,
   "domain": null
  },
  {
   "name": "SUPPLIER",
   "type": "esriFieldTypeString",
   "alias": "SUPPLIER",
   "length": 765,
   "domain": null
  },
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "ROW_ID",
   "type": "esriFieldTypeDouble",
   "alias": "ROW_ID",
   "domain": null
  },
  {
   "name": "CONTRACTAMOUNT",
   "type": "esriFieldTypeDouble",
   "alias": "CONTRACTAMOUNT",
   "domain": null
  },
  {
   "name": "ENDDATE",
   "type": "esriFieldTypeDate",
   "alias": "ENDDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "CONTRACTNUMBER",
   "type": "esriFieldTypeString",
   "alias": "CONTRACTNUMBER",
   "length": 150,
   "domain": null
  },
  {
   "name": "STARTDATE",
   "type": "esriFieldTypeDate",
   "alias": "STARTDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "FISCALYEAR",
   "type": "esriFieldTypeString",
   "alias": "FISCALYEAR",
   "length": 50,
   "domain": null
  },
  {
   "name": "COMMODITYCODE",
   "type": "esriFieldTypeString",
   "alias": "COMMODITYCODE",
   "length": 300,
   "domain": null
  },
  {
   "name": "COMMODITYDESCRIPTION",
   "type": "esriFieldTypeString",
   "alias": "COMMODITYDESCRIPTION",
   "length": 765,
   "domain": null
  },
  {
   "name": "CURRENTOPTIONPERIOD",
   "type": "esriFieldTypeString",
   "alias": "CURRENTOPTIONPERIOD",
   "length": 300,
   "domain": null
  },
  {
   "name": "TOTALOPTIONPERIODS",
   "type": "esriFieldTypeString",
   "alias": "TOTALOPTIONPERIODS",
   "length": 300,
   "domain": null
  },
  {
   "name": "DESCRIPTION",
   "type": "esriFieldTypeString",
   "alias": "DESCRIPTION",
   "length": 4000,
   "domain": null
  },
  {
   "name": "CONTRACTTYPEDESCRIPTION",
   "type": "esriFieldTypeString",
   "alias": "CONTRACTTYPEDESCRIPTION",
   "length": 300,
   "domain": null
  },
  {
   "name": "CONTRACTINGOFFICEREMAIL",
   "type": "esriFieldTypeString",
   "alias": "CONTRACTINGOFFICEREMAIL",
   "length": 765,
   "domain": null
  },
  {
   "name": "VENDORADDRESS",
   "type": "esriFieldTypeString",
   "alias": "VENDORADDRESS",
   "length": 1000,
   "domain": null
  },
  {
   "name": "VENDORCITY",
   "type": "esriFieldTypeString",
   "alias": "VENDORCITY",
   "length": 500,
   "domain": null
  },
  {
   "name": "VENDORSTATE",
   "type": "esriFieldTypeString",
   "alias": "VENDORSTATE",
   "length": 500,
   "domain": null
  },
  {
   "name": "VENDORZIP",
   "type": "esriFieldTypeString",
   "alias": "VENDORZIP",
   "length": 60,
   "domain": null
  },
  {
   "name": "PUBLISHEDVERSIONID",
   "type": "esriFieldTypeInteger",
   "alias": "PUBLISHEDVERSIONID",
   "domain": null
  },
  {
   "name": "DOCUMENTVERSION",
   "type": "esriFieldTypeInteger",
   "alias": "DOCUMENTVERSION",
   "domain": null
  },
  {
   "name": "CONTRACTINGSPLST",
   "type": "esriFieldTypeString",
   "alias": "CONTRACTINGSPLST",
   "length": 255,
   "domain": null
  },
  {
   "name": "CONTRACTINGSPLSTEMAIL",
   "type": "esriFieldTypeString",
   "alias": "CONTRACTINGSPLSTEMAIL",
   "length": 200,
   "domain": null
  },
  {
   "name": "SOURCE",
   "type": "esriFieldTypeString",
   "alias": "SOURCE",
   "length": 300,
   "domain": null
  },
  {
   "name": "CONTRACTADMINISTRATORNAME",
   "type": "esriFieldTypeString",
   "alias": "CONTRACTADMINISTRATORNAME",
   "length": 255,
   "domain": null
  },
  {
   "name": "CONTRACTADMINISTRATOREMAIL",
   "type": "esriFieldTypeString",
   "alias": "CONTRACTADMINISTRATOREMAIL",
   "length": 255,
   "domain": null
  },
  {
   "name": "CONTRACTADMINISTRATORPHONE",
   "type": "esriFieldTypeString",
   "alias": "CONTRACTADMINISTRATORPHONE",
   "length": 50,
   "domain": null
  },
  {
   "name": "CONTRACTOFFICERPHONE",
   "type": "esriFieldTypeString",
   "alias": "CONTRACTOFFICERPHONE",
   "length": 50,
   "domain": null
  },
  {
   "name": "CWINTERNALID",
   "type": "esriFieldTypeString",
   "alias": "CWINTERNALID",
   "length": 150,
   "domain": null
  },
  {
   "name": "CORPORATEPHONE",
   "type": "esriFieldTypeString",
   "alias": "CORPORATEPHONE",
   "length": 50,
   "domain": null
  },
  {
   "name": "CORPORATEEMAILADDRESS",
   "type": "esriFieldTypeString",
   "alias": "CORPORATEEMAILADDRESS",
   "length": 255,
   "domain": null
  },
  {
   "name": "REC_CREATED_DATE",
   "type": "esriFieldTypeDate",
   "alias": "REC_CREATED_DATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "REC_UPDATED_DATE",
   "type": "esriFieldTypeDate",
   "alias": "REC_UPDATED_DATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "DCS_LAST_MOD_DTTM",
   "type": "esriFieldTypeDate",
   "alias": "DCS_LAST_MOD_DTTM",
   "length": 8,
   "domain": null
  },
  {
   "name": "AGENCY_ACRONYM",
   "type": "esriFieldTypeString",
   "alias": "AGENCY_ACRONYM",
   "length": 500,
   "domain": null
  },
  {
   "name": "AGENCY_NAME",
   "type": "esriFieldTypeString",
   "alias": "AGENCY_NAME",
   "length": 3000,
   "domain": null
  },
  {
   "name": "CONTRACT_DETAILS_LINK",
   "type": "esriFieldTypeString",
   "alias": "CONTRACT_DETAILS_LINK",
   "length": 4000,
   "domain": null
  }
 ],
 "indexes": null,
 "subtypes": [],
 "relationships": [],
 "capabilities": "Data,Map,Query",
 "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,
  "supportsCurrentUserQueries": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": {
  "timeZone": "Eastern Standard Time",
  "respectsDaylightSaving": true
 },
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 }
}