Tables:

Table: ApprovedBudgetPublic (0)

Name: ApprovedBudgetPublic

Display Field: OBJECTID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 9a95361375f94d78bf862872c6945182

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

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
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: false
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:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• accountNumber ( type: esriFieldTypeString, alias: accountNumber, editable: true, nullable: true, length: 30, defaultValue: null, modelName: accountNumber )
• accountType ( type: esriFieldTypeString, alias: accountType, editable: true, nullable: true, length: 255, defaultValue: null, modelName: accountType )
• fund ( type: esriFieldTypeString, alias: fund, editable: true, nullable: true, length: 64, defaultValue: null, modelName: fund )
• department ( type: esriFieldTypeString, alias: department, editable: true, nullable: true, length: 64, defaultValue: null, modelName: department )
• division ( type: esriFieldTypeString, alias: division, editable: true, nullable: true, length: 64, defaultValue: null, modelName: division )
• accountDescription ( type: esriFieldTypeString, alias: accountDescription, editable: true, nullable: true, length: 255, defaultValue: null, modelName: accountDescription )
• fiscalYearNumber ( type: esriFieldTypeSmallInteger, alias: fiscalYearNumber, editable: true, nullable: true, defaultValue: null, modelName: fiscalYearNumber )
• fiscalYear ( type: esriFieldTypeString, alias: fiscalYear, editable: true, nullable: true, length: 15, defaultValue: null, modelName: fiscalYear )
• amount ( type: esriFieldTypeDouble, alias: amount, editable: true, nullable: true, defaultValue: null, modelName: amount )
• basicType ( type: esriFieldTypeString, alias: basicType, editable: true, nullable: true, length: 255, defaultValue: null, modelName: basicType )
• subType ( type: esriFieldTypeString, alias: subType, editable: true, nullable: true, length: 255, defaultValue: null, modelName: subType )
• element ( type: esriFieldTypeString, alias: element, editable: true, nullable: true, length: 255, defaultValue: null, modelName: element )
• approvedRevised ( type: esriFieldTypeString, alias: approvedRevised, editable: true, nullable: true, length: 255, defaultValue: null, modelName: approvedRevised )
Templates:
• Name: ApprovedBudgetPublic
  Description:
  Prototype:
  element: null
  approvedRevised: null
  accountNumber: null
  accountType: null
  fund: null
  department: null
  division: null
  accountDescription: null
  fiscalYearNumber: null
  fiscalYear: null
  amount: null
  basicType: null
  subType: null
  
  Drawing Tool: esriFeatureEditToolNone

Table: CashReceiptsPublic (1)

Name: CashReceiptsPublic

Display Field: OBJECTID

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

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
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: false
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:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• date ( type: esriFieldTypeDate, alias: date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: date )
• fiscalYear ( type: esriFieldTypeSmallInteger, alias: fiscalYear, editable: true, nullable: true, defaultValue: null, modelName: fiscalYear )
• fiscalMonth ( type: esriFieldTypeSmallInteger, alias: fiscalMonth, editable: true, nullable: true, defaultValue: null, modelName: fiscalMonth )
• accountNumber ( type: esriFieldTypeString, alias: accountNumber, editable: true, nullable: true, length: 30, defaultValue: null, modelName: accountNumber )
• fund ( type: esriFieldTypeString, alias: fund, editable: true, nullable: true, length: 255, defaultValue: null, modelName: fund )
• description ( type: esriFieldTypeString, alias: description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: description )
• amount ( type: esriFieldTypeDouble, alias: amount, editable: true, nullable: true, defaultValue: null, modelName: amount )
• basicType ( type: esriFieldTypeString, alias: basicType, editable: true, nullable: true, length: 255, defaultValue: null, modelName: basicType )
• subType ( type: esriFieldTypeString, alias: subType, editable: true, nullable: true, length: 255, defaultValue: null, modelName: subType )
Templates:
• Name: CashReceiptsPublic
  Description:
  Prototype:
  basicType: null
  subType: null
  date: null
  fiscalYear: null
  fiscalMonth: null
  accountNumber: null
  fund: null
  description: null
  amount: null
  
  Drawing Tool: esriFeatureEditToolNone

Table: EmployeeCompensationPublic (2)

Name: EmployeeCompensationPublic

Display Field: OBJECTID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 9a95361375f94d78bf862872c6945182

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

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
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: false
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:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Employee ( type: esriFieldTypeString, alias: Employee Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Employee )
• Department ( type: esriFieldTypeString, alias: Department, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Department )
• Title ( type: esriFieldTypeString, alias: Job Title, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Title )
• FiscalYear ( type: esriFieldTypeInteger, alias: Fiscal Year, editable: true, nullable: true, defaultValue: null, modelName: FiscalYear )
• RegularEarnings ( type: esriFieldTypeDouble, alias: Regular Earnings, editable: true, nullable: true, defaultValue: null, modelName: RegularEarnings )
• HealthandDental ( type: esriFieldTypeDouble, alias: Health And Dental, editable: true, nullable: true, defaultValue: null, modelName: HealthandDental )
• MedicareSocialSecurity ( type: esriFieldTypeDouble, alias: Medicare and Social Security, editable: true, nullable: true, defaultValue: null, modelName: MedicareSocialSecurity )
• Pension ( type: esriFieldTypeDouble, alias: Pension, editable: true, nullable: true, defaultValue: null, modelName: Pension )
• ClothingAllowance ( type: esriFieldTypeDouble, alias: Clothing Allowance, editable: true, nullable: true, defaultValue: null, modelName: ClothingAllowance )
• VehicleAllowance ( type: esriFieldTypeDouble, alias: Vehicle Allowance, editable: true, nullable: true, defaultValue: null, modelName: VehicleAllowance )
• OtherEarnings ( type: esriFieldTypeDouble, alias: Other Earnings, editable: true, nullable: true, defaultValue: null, modelName: OtherEarnings )
• OtherBenefits ( type: esriFieldTypeDouble, alias: Other Benefits, editable: true, nullable: true, defaultValue: null, modelName: OtherBenefits )
• TotalCompensation ( type: esriFieldTypeDouble, alias: Total Compensation, editable: true, nullable: true, defaultValue: null, modelName: TotalCompensation )
• calendarYear ( type: esriFieldTypeInteger, alias: Calendar Year, editable: true, nullable: true, defaultValue: null, modelName: calendarYear )
• payPeriods ( type: esriFieldTypeInteger, alias: Number of Pay Periods, editable: true, nullable: true, defaultValue: null, modelName: payPeriods )
Templates:
• Name: EmployeeCompensationPublic
  Description:
  Prototype:
  calendarYear: null
  payPeriods: null
  Employee: null
  Department: null
  Title: null
  FiscalYear: null
  RegularEarnings: null
  HealthandDental: null
  MedicareSocialSecurity: null
  Pension: null
  ClothingAllowance: null
  VehicleAllowance: null
  OtherEarnings: null
  OtherBenefits: null
  TotalCompensation: null
  
  Drawing Tool: esriFeatureEditToolNone

Table: FixedAssetsPublic (3)

Name: FixedAssetsPublic

Display Field: OBJECTID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 9a95361375f94d78bf862872c6945182

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

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
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: false
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:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• assetNumber ( type: esriFieldTypeInteger, alias: assetNumber, editable: true, nullable: true, defaultValue: null, modelName: assetNumber )
• acquiredDate ( type: esriFieldTypeDate, alias: acquiredDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: acquiredDate )
• description ( type: esriFieldTypeString, alias: description, editable: true, nullable: true, length: 100, defaultValue: null, modelName: description )
• assetType ( type: esriFieldTypeString, alias: assetType, editable: true, nullable: true, length: 100, defaultValue: null, modelName: assetType )
• department ( type: esriFieldTypeString, alias: department, editable: true, nullable: true, length: 64, defaultValue: null, modelName: department )
• division ( type: esriFieldTypeString, alias: division, editable: true, nullable: true, length: 64, defaultValue: null, modelName: division )
• purchasePrice ( type: esriFieldTypeDouble, alias: purchasePrice, editable: true, nullable: true, defaultValue: null, modelName: purchasePrice )
• depreciation ( type: esriFieldTypeDouble, alias: depcreciation, editable: true, nullable: true, defaultValue: null, modelName: depreciation )
Templates:
• Name: FixedAssetsPublic
  Description:
  Prototype:
  purchasePrice: null
  depreciation: null
  assetNumber: null
  acquiredDate: null
  description: null
  assetType: null
  department: null
  division: null
  
  Drawing Tool: esriFeatureEditToolNone

Table: TransactionLogPublic (4)

Name: TransactionLogPublic

Display Field: OBJECTID

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

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
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: false
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:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• accountNumber ( type: esriFieldTypeString, alias: accountNumber, editable: true, nullable: true, length: 25, defaultValue: null, modelName: accountNumber )
• fund ( type: esriFieldTypeString, alias: fund, editable: true, nullable: true, length: 64, defaultValue: null, modelName: fund )
• department ( type: esriFieldTypeString, alias: department, editable: true, nullable: true, length: 64, defaultValue: null, modelName: department )
• division ( type: esriFieldTypeString, alias: division, editable: true, nullable: true, length: 64, defaultValue: null, modelName: division )
• fiscalYear ( type: esriFieldTypeSmallInteger, alias: fiscalYear, editable: true, nullable: true, defaultValue: null, modelName: fiscalYear )
• fiscalMonth ( type: esriFieldTypeSmallInteger, alias: fiscalMonth, editable: true, nullable: true, defaultValue: null, modelName: fiscalMonth )
• date ( type: esriFieldTypeDate, alias: date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: date )
• journal ( type: esriFieldTypeString, alias: journal, editable: true, nullable: true, length: 5, defaultValue: null, modelName: journal )
• description ( type: esriFieldTypeString, alias: description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: description )
• vendorName ( type: esriFieldTypeString, alias: vendorName, editable: true, nullable: true, length: 255, defaultValue: null, modelName: vendorName )
• vendorNo ( type: esriFieldTypeString, alias: vendorNo, editable: true, nullable: true, length: 255, defaultValue: null, modelName: vendorNo )
• amount ( type: esriFieldTypeDouble, alias: amount, editable: true, nullable: true, defaultValue: null, modelName: amount )
Templates:
• Name: TransactionLogPublic
  Description:
  Prototype:
  vendorNo: null
  amount: null
  accountNumber: null
  fund: null
  department: null
  division: null
  fiscalYear: null
  fiscalMonth: null
  date: null
  journal: null
  description: null
  vendorName: null
  
  Drawing Tool: esriFeatureEditToolNone

Table: VendorsPublic (5)

Name: VendorsPublic

Display Field: OBJECTID

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

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
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: false
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:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• vendorNumber ( type: esriFieldTypeInteger, alias: vendorNumber, editable: true, nullable: true, defaultValue: null, modelName: vendorNumber )
• vendorName ( type: esriFieldTypeString, alias: vendorName, editable: true, nullable: true, length: 100, defaultValue: null, modelName: vendorName )
• city ( type: esriFieldTypeString, alias: city, editable: true, nullable: true, length: 100, defaultValue: null, modelName: city )
• state ( type: esriFieldTypeString, alias: state, editable: true, nullable: true, length: 255, defaultValue: null, modelName: state )
• zip ( type: esriFieldTypeString, alias: zip, editable: true, nullable: true, length: 20, defaultValue: null, modelName: zip )
Templates:
• Name: VendorsPublic
  Description:
  Prototype:
  state: null
  zip: null
  vendorNumber: null
  vendorName: null
  city: null
  
  Drawing Tool: esriFeatureEditToolNone