Name: ActualProjectFunding

Display Field: ProjectFundingClass

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• TIP_ID ( type: esriFieldTypeInteger, alias: TIP_ID, editable: true, nullable: false, defaultValue: null, modelName: TIP_ID )
• ProjectFundingClass ( type: esriFieldTypeString, alias: ProjectFundingClass, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectFundingClass , Coded Values: [Federal: Federal] , [State: State] , [Other: Other] )
• ProjectFundingType ( type: esriFieldTypeString, alias: ProjectFundingType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectFundingType , Coded Values: [BUILDGrant: BUILDGrant] , [CRISIGrant: CRISIGrant] , [TIGERGrant: TIGERGrant] , ...35 more... )
• ProjectFundingAmount ( type: esriFieldTypeDouble, alias: ProjectFundingAmount, editable: true, nullable: true, defaultValue: null, modelName: ProjectFundingAmount )
• RIC ( type: esriFieldTypeString, alias: RIC, editable: true, nullable: true, length: 20, defaultValue: null, modelName: RIC )
• PriorYearObligated ( type: esriFieldTypeDouble, alias: PriorYearObligated, editable: true, nullable: true, defaultValue: null, modelName: PriorYearObligated )
• CurrentYearObligated ( type: esriFieldTypeDouble, alias: CurrentYearObligated, editable: true, nullable: true, defaultValue: null, modelName: CurrentYearObligated )
• PriorYearExpense ( type: esriFieldTypeDouble, alias: PriorYearExpense, editable: true, nullable: true, defaultValue: null, modelName: PriorYearExpense )
• CurrentYearExpense ( type: esriFieldTypeDouble, alias: CurrentYearExpense, editable: true, nullable: true, defaultValue: null, modelName: CurrentYearExpense )
• FY_2021 ( type: esriFieldTypeDouble, alias: FY_2021, editable: true, nullable: true, defaultValue: null, modelName: FY_2021 )
• FY_2022 ( type: esriFieldTypeDouble, alias: FY_2022, editable: true, nullable: true, defaultValue: null, modelName: FY_2022 )
• FY_2023 ( type: esriFieldTypeDouble, alias: FY_2023, editable: true, nullable: true, defaultValue: null, modelName: FY_2023 )
• FY_2024 ( type: esriFieldTypeDouble, alias: FY_2024, editable: true, nullable: true, defaultValue: null, modelName: FY_2024 )
• FY_2025 ( type: esriFieldTypeDouble, alias: FY_2025, editable: true, nullable: true, defaultValue: null, modelName: FY_2025 )
• FY_2026 ( type: esriFieldTypeDouble, alias: FY_2026, editable: true, nullable: true, defaultValue: null, modelName: FY_2026 )
• FY_2027 ( type: esriFieldTypeDouble, alias: FY_2027, editable: true, nullable: true, defaultValue: null, modelName: FY_2027 )
• FY_2028 ( type: esriFieldTypeDouble, alias: FY_2028, editable: true, nullable: true, defaultValue: null, modelName: FY_2028 )
• FY_2029 ( type: esriFieldTypeDouble, alias: FY_2029, editable: true, nullable: true, defaultValue: null, modelName: FY_2029 )
• FY_2030 ( type: esriFieldTypeDouble, alias: FY_2030, editable: true, nullable: true, defaultValue: null, modelName: FY_2030 )
• TotalFunding ( type: esriFieldTypeDouble, alias: TotalFunding, editable: true, nullable: true, defaultValue: null, modelName: TotalFunding )
• TotalExpended ( type: esriFieldTypeDouble, alias: TotalExpended, editable: true, nullable: true, defaultValue: null, modelName: TotalExpended )
• ProjectPhase ( type: esriFieldTypeString, alias: ProjectPhase, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ProjectPhase , Coded Values: [Design: Design] , [Construction: Construction] , [Other: Other] )
• ProjectFundingTypeID ( type: esriFieldTypeSmallInteger, alias: ProjectFundingTypeID, editable: true, nullable: true, defaultValue: null, modelName: ProjectFundingTypeID )
• FY_2018 ( type: esriFieldTypeDouble, alias: FY_2018, editable: true, nullable: true, defaultValue: null, modelName: FY_2018 )
• FY_2019 ( type: esriFieldTypeDouble, alias: FY_2019, editable: true, nullable: true, defaultValue: null, modelName: FY_2019 )
• FY_2020 ( type: esriFieldTypeDouble, alias: FY_2020, editable: true, nullable: true, defaultValue: null, modelName: FY_2020 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )

Templates:

• Name: ActualProjectFunding
  Description:
  Prototype:
  FY_2020: null
  TIP_ID: 0
  ProjectFundingClass: null
  ProjectFundingType: null
  ProjectFundingAmount: null
  RIC: null
  PriorYearObligated: null
  CurrentYearObligated: null
  PriorYearExpense: null
  CurrentYearExpense: null
  FY_2021: null
  FY_2022: null
  FY_2023: null
  FY_2024: null
  FY_2025: null
  FY_2026: null
  FY_2027: null
  FY_2028: null
  FY_2029: null
  FY_2030: null
  TotalFunding: null
  TotalExpended: null
  ProjectPhase: null
  ProjectFundingTypeID: null
  FY_2018: null
  FY_2019: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• TIP_Projects (3) -- Related To: TIP_Projects (13)

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata