Name: PASS Contracts

Display Field: AGENCY_NAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: false
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• AGENCY_ACRONYM ( type: esriFieldTypeString, alias: AGENCY_ACRONYM, length: 500 )
• AGENCY_NAME ( type: esriFieldTypeString, alias: AGENCY_NAME, length: 3000 )
• ROW_ID ( type: esriFieldTypeDouble, alias: ROW_ID )
• SUPPLIER_ID ( type: esriFieldTypeString, alias: SUPPLIER_ID, length: 25 )
• AGENCY ( type: esriFieldTypeString, alias: AGENCY, length: 384 )
• AWARDDATE ( type: esriFieldTypeDate, alias: AWARDDATE, length: 8 )
• CONTRACTAMOUNT ( type: esriFieldTypeDouble, alias: CONTRACTAMOUNT )
• ENDDATE ( type: esriFieldTypeDate, alias: ENDDATE, length: 8 )
• CONTRACTNUMBER ( type: esriFieldTypeString, alias: CONTRACTNUMBER, length: 150 )
• STARTDATE ( type: esriFieldTypeDate, alias: STARTDATE, length: 8 )
• CONTRACTSTATUS ( type: esriFieldTypeString, alias: CONTRACTSTATUS, length: 90 )
• TITLE ( type: esriFieldTypeString, alias: TITLE, length: 1017 )
• CONTRACTINGOFFICER ( type: esriFieldTypeString, alias: CONTRACTINGOFFICER, length: 765 )
• FISCALYEAR ( type: esriFieldTypeString, alias: FISCALYEAR, length: 50 )
• MARKETTYPE ( type: esriFieldTypeString, alias: MARKETTYPE, length: 300 )
• COMMODITYCODE ( type: esriFieldTypeString, alias: COMMODITYCODE, length: 300 )
• COMMODITYDESCRIPTION ( type: esriFieldTypeString, alias: COMMODITYDESCRIPTION, length: 765 )
• CURRENTOPTIONPERIOD ( type: esriFieldTypeString, alias: CURRENTOPTIONPERIOD, length: 300 )
• TOTALOPTIONPERIODS ( type: esriFieldTypeString, alias: TOTALOPTIONPERIODS, length: 300 )
• SUPPLIER ( type: esriFieldTypeString, alias: SUPPLIER, length: 765 )
• DESCRIPTION ( type: esriFieldTypeString, alias: DESCRIPTION, length: 4000 )
• CONTRACTTYPEDESCRIPTION ( type: esriFieldTypeString, alias: CONTRACTTYPEDESCRIPTION, length: 300 )
• CONTRACTINGOFFICEREMAIL ( type: esriFieldTypeString, alias: CONTRACTINGOFFICEREMAIL, length: 765 )
• VENDORADDRESS ( type: esriFieldTypeString, alias: VENDORADDRESS, length: 1000 )
• VENDORCITY ( type: esriFieldTypeString, alias: VENDORCITY, length: 500 )
• VENDORSTATE ( type: esriFieldTypeString, alias: VENDORSTATE, length: 500 )
• VENDORZIP ( type: esriFieldTypeString, alias: VENDORZIP, length: 60 )
• PUBLISHEDVERSIONID ( type: esriFieldTypeInteger, alias: PUBLISHEDVERSIONID )
• DOCUMENTVERSION ( type: esriFieldTypeInteger, alias: DOCUMENTVERSION )
• LASTMODIFIED ( type: esriFieldTypeDate, alias: LASTMODIFIED, length: 8 )
• CONTRACTINGSPLST ( type: esriFieldTypeString, alias: CONTRACTINGSPLST, length: 255 )
• CONTRACTINGSPLSTEMAIL ( type: esriFieldTypeString, alias: CONTRACTINGSPLSTEMAIL, length: 200 )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, length: 300 )
• CONTRACTADMINISTRATORNAME ( type: esriFieldTypeString, alias: CONTRACTADMINISTRATORNAME, length: 255 )
• CONTRACTADMINISTRATOREMAIL ( type: esriFieldTypeString, alias: CONTRACTADMINISTRATOREMAIL, length: 255 )
• CONTRACTADMINISTRATORPHONE ( type: esriFieldTypeString, alias: CONTRACTADMINISTRATORPHONE, length: 50 )
• CONTRACTOFFICERPHONE ( type: esriFieldTypeString, alias: CONTRACTOFFICERPHONE, length: 50 )
• CWINTERNALID ( type: esriFieldTypeString, alias: CWINTERNALID, length: 150 )
• CORPORATEPHONE ( type: esriFieldTypeString, alias: CORPORATEPHONE, length: 50 )
• CORPORATEEMAILADDRESS ( type: esriFieldTypeString, alias: CORPORATEEMAILADDRESS, length: 255 )
• REC_CREATED_DATE ( type: esriFieldTypeDate, alias: REC_CREATED_DATE, length: 8 )
• REC_UPDATED_DATE ( type: esriFieldTypeDate, alias: REC_UPDATED_DATE, length: 8 )
• DCS_LAST_MOD_DTTM ( type: esriFieldTypeDate, alias: DCS_LAST_MOD_DTTM, length: 8 )
• CONTRACT_DETAILS_LINK ( type: esriFieldTypeString, alias: CONTRACT_DETAILS_LINK, length: 4000 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata