Name: ActiveContractExport_15036
Display Field: Vendor_Name
Type: Table
Description:
Copyright Text:
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- Active (type: esriFieldTypeString, alias: Active, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- District (type: esriFieldTypeString, alias: District, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Contract_ID (type: esriFieldTypeString, alias: Contract ID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Work_Begin (type: esriFieldTypeString, alias: Work Begin, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Project_Id (type: esriFieldTypeDouble, alias: Project Id, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Description (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Work_Mix (type: esriFieldTypeString, alias: Work Mix, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Vendor_Name (type: esriFieldTypeString, alias: Vendor Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Vendor_ID (type: esriFieldTypeString, alias: Vendor ID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Project_Engineer_Manager_Name (type: esriFieldTypeString, alias: Project Engineer/Manager Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Original_Contract_Days (type: esriFieldTypeInteger, alias: Original Contract Days, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Adjusted_Contract_Days (type: esriFieldTypeInteger, alias: Adjusted Contract Days, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Current_Contract_Days (type: esriFieldTypeInteger, alias: Current Contract Days, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Project_Type (type: esriFieldTypeString, alias: Project Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Days_Used (type: esriFieldTypeInteger, alias: Days Used, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Original_Contract_Amount (type: esriFieldTypeDouble, alias: Original Contract Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Current_Contract_Amount (type: esriFieldTypeDouble, alias: Current Contract Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Estimate_Paid_to_Date (type: esriFieldTypeDouble, alias: Estimate Paid to Date, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Project_Work_Type (type: esriFieldTypeString, alias: Project Work Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Contract_Type (type: esriFieldTypeString, alias: Contract Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Letting_Date (type: esriFieldTypeString, alias: Letting Date, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Award_Date (type: esriFieldTypeString, alias: Award Date, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Executed_Date (type: esriFieldTypeString, alias: Executed Date, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Time_Began_Date (type: esriFieldTypeString, alias: Time Began Date, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Final_Acceptance_Date (type: esriFieldTypeString, alias: Final Acceptance Date, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Start_Date (type: esriFieldTypeString, alias: Start Date, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- Estimated_Completion_Date (type: esriFieldTypeString, alias: Estimated Completion Date, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Templates:
Name: ActiveContractExport_15036
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 1/7/2023 1:05:51 AM
Schema Last Edit Date: 1/7/2023 1:05:51 AM
Data Last Edit Date: 1/7/2023 1:05:51 AM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat