Tables:

Table: PIP Staging Table (0)

Name: PIP Staging Table

Display Field: CREATED_USER

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 5752acc6ef614ba6863577956f3caa43

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
Feature Draw Order:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• CREATED_USER ( type: esriFieldTypeString, alias: created_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CREATED_USER )
• CREATED_DATE ( type: esriFieldTypeDate, alias: created_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DATE )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: last_edited_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LAST_EDITED_USER )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: last_edited_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDITED_DATE )
• METRIC ( type: esriFieldTypeString, alias: Metric, editable: true, nullable: true, length: 255, defaultValue: null, modelName: METRIC )
• REPORTED_DATE ( type: esriFieldTypeDate, alias: Reported Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: REPORTED_DATE )
• METRIC_FREQUENCY ( type: esriFieldTypeString, alias: Metric Frequency, editable: true, nullable: true, length: 255, defaultValue: null, modelName: METRIC_FREQUENCY )
• FISCAL_OR_CALENDAR_YEAR ( type: esriFieldTypeString, alias: Fiscal or Calendar Year, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FISCAL_OR_CALENDAR_YEAR )
• METRIC_TYPE ( type: esriFieldTypeString, alias: Metric Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: METRIC_TYPE )
• SUM_OR_AVERAGE ( type: esriFieldTypeString, alias: Sum or Average, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SUM_OR_AVERAGE )
• PERCENTAGE ( type: esriFieldTypeString, alias: Percent, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PERCENTAGE )
• VALUE_TEXT ( type: esriFieldTypeString, alias: Value Text, editable: true, nullable: true, length: 255, defaultValue: null, modelName: VALUE_TEXT )
• VALUE_TIME ( type: esriFieldTypeString, alias: Value (Time), editable: true, nullable: true, length: 255, defaultValue: null, modelName: VALUE_TIME )
• GOAL ( type: esriFieldTypeString, alias: CoC Goal?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GOAL )
• METRIC_GOAL_TEXT ( type: esriFieldTypeString, alias: Metric Goal (Text), editable: true, nullable: true, length: 255, defaultValue: null, modelName: METRIC_GOAL_TEXT )
• METRIC_GOAL_TIME ( type: esriFieldTypeString, alias: Metric Goal (Time), editable: true, nullable: true, length: 255, defaultValue: null, modelName: METRIC_GOAL_TIME )
• OTHER_GOAL ( type: esriFieldTypeString, alias: Other Goal/Standard?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OTHER_GOAL )
• OTHER_GOAL_COUNT ( type: esriFieldTypeDouble, alias: Number of Goals/Standards, editable: true, nullable: true, defaultValue: null, modelName: OTHER_GOAL_COUNT )
• OTHER_GOAL_ONE_TEXT ( type: esriFieldTypeString, alias: Other Goal One (Text), editable: true, nullable: true, length: 255, defaultValue: null, modelName: OTHER_GOAL_ONE_TEXT )
• OTHER_GOAL_ONE_TIME ( type: esriFieldTypeString, alias: Other Goal One (Time), editable: true, nullable: true, length: 255, defaultValue: null, modelName: OTHER_GOAL_ONE_TIME )
• OTHER_GOAL_TWO_TEXT ( type: esriFieldTypeString, alias: Other Goal Two (Text), editable: true, nullable: true, length: 255, defaultValue: null, modelName: OTHER_GOAL_TWO_TEXT )
• OTHER_GOAL_TWO_TIME ( type: esriFieldTypeString, alias: Other Goal Two (Time), editable: true, nullable: true, length: 255, defaultValue: null, modelName: OTHER_GOAL_TWO_TIME )
• SURVEY_GLOBALID ( type: esriFieldTypeString, alias: Survey GlobalID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SURVEY_GLOBALID )
• DELETED ( type: esriFieldTypeString, alias: Deleted, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DELETED )
• VALUE ( type: esriFieldTypeDouble, alias: VALUE, editable: true, nullable: true, defaultValue: null, modelName: VALUE )
• OTHER_GOAL_ONE ( type: esriFieldTypeDouble, alias: OTHER_GOAL_ONE, editable: true, nullable: true, defaultValue: null, modelName: OTHER_GOAL_ONE )
• METRIC_GOAL ( type: esriFieldTypeDouble, alias: METRIC_GOAL, editable: true, nullable: true, defaultValue: null, modelName: METRIC_GOAL )
• OTHER_GOAL_TWO ( type: esriFieldTypeDouble, alias: OTHER_GOAL_TWO, editable: true, nullable: true, defaultValue: null, modelName: OTHER_GOAL_TWO )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )
• COMMITTED ( type: esriFieldTypeSmallInteger, alias: COMMITTED, editable: true, nullable: true, defaultValue: 0, modelName: COMMITTED )
• FOCUS_AREA ( type: esriFieldTypeString, alias: FOCUS_AREA, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FOCUS_AREA )
• MAIN_TABLE_GUID ( type: esriFieldTypeString, alias: MAIN_TABLE_GUID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MAIN_TABLE_GUID )
Templates:
• Name: PIP Staging Table
  Description:
  Prototype:
  FOCUS_AREA: null
  COMMITTED: 0
  CREATED_USER: null
  CREATED_DATE: null
  LAST_EDITED_USER: null
  LAST_EDITED_DATE: null
  METRIC: null
  REPORTED_DATE: null
  METRIC_FREQUENCY: null
  FISCAL_OR_CALENDAR_YEAR: null
  METRIC_TYPE: null
  SUM_OR_AVERAGE: null
  PERCENTAGE: null
  VALUE_TEXT: null
  VALUE_TIME: null
  GOAL: null
  METRIC_GOAL_TEXT: null
  METRIC_GOAL_TIME: null
  OTHER_GOAL: null
  OTHER_GOAL_COUNT: null
  OTHER_GOAL_ONE_TEXT: null
  OTHER_GOAL_ONE_TIME: null
  OTHER_GOAL_TWO_TEXT: null
  OTHER_GOAL_TWO_TIME: null
  SURVEY_GLOBALID: null
  DELETED: null
  VALUE: null
  OTHER_GOAL_ONE: null
  METRIC_GOAL: null
  OTHER_GOAL_TWO: null
  MAIN_TABLE_GUID: null
  
  Drawing Tool: esriFeatureEditToolNone