Name: PUBF_CONSTRUCTION_PROJECT_WORK_DETAILS
Display Field: PROJECT_NAME
Type: Table
Geometry Type: N/A
Description:
Copyright Text:
Default Visibility: false
MaxRecordCount: 20000
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:
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
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
)
-
PROJECT_ID
(
type: esriFieldTypeInteger, alias: PROJECT_ID, editable: true, nullable: true, defaultValue: null, modelName: PROJECT_ID
)
-
PROJECT_NAME
(
type: esriFieldTypeString, alias: PROJECT_NAME, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: PROJECT_NAME
)
-
PROJ_LEAD
(
type: esriFieldTypeString, alias: PROJ_LEAD, editable: true, nullable: true, length: 80, defaultValue: null, modelName: PROJ_LEAD
)
-
PROJ_LEAD_EMAIL
(
type: esriFieldTypeString, alias: PROJ_LEAD_EMAIL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PROJ_LEAD_EMAIL
)
-
PROJECT_BRANCH
(
type: esriFieldTypeString, alias: PROJECT_BRANCH, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PROJECT_BRANCH
)
-
CONSTRUCTION_ID
(
type: esriFieldTypeInteger, alias: CONSTRUCTION_ID, editable: true, nullable: true, defaultValue: null, modelName: CONSTRUCTION_ID
)
-
CONSTRUCTION_MAJOR_CAT_ID
(
type: esriFieldTypeSmallInteger, alias: CONSTRUCTION_MAJOR_CAT_ID, editable: true, nullable: true, defaultValue: null, modelName: CONSTRUCTION_MAJOR_CAT_ID
)
-
CONSTRUCTION_MAJOR_CAT_NAME
(
type: esriFieldTypeString, alias: CONSTRUCTION_MAJOR_CAT_NAME, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CONSTRUCTION_MAJOR_CAT_NAME
)
-
CONST_CATEGORY_CODE
(
type: esriFieldTypeString, alias: CONST_CATEGORY_CODE, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CONST_CATEGORY_CODE
)
-
CONS_LEAD
(
type: esriFieldTypeString, alias: CONS_LEAD, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONS_LEAD
)
-
CONS_LEAD_EMAIL
(
type: esriFieldTypeString, alias: CONS_LEAD_EMAIL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONS_LEAD_EMAIL
)
-
SITE_WORK_ID
(
type: esriFieldTypeDouble, alias: SITE_WORK_ID, editable: true, nullable: true, defaultValue: null, modelName: SITE_WORK_ID
)
-
SITE_NAME
(
type: esriFieldTypeString, alias: SITE_NAME, editable: true, nullable: true, length: 200, defaultValue: null, modelName: SITE_NAME
)
-
ACTUAL_WORK_START_DATE
(
type: esriFieldTypeDate, alias: ACTUAL_WORK_START_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ACTUAL_WORK_START_DATE
)
-
ACTUAL_WORK_END_DATE
(
type: esriFieldTypeDate, alias: ACTUAL_WORK_END_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ACTUAL_WORK_END_DATE
)
-
STATUS_CODE
(
type: esriFieldTypeString, alias: STATUS_CODE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: STATUS_CODE
)
-
NEW_SW_MAIL_SENT
(
type: esriFieldTypeString, alias: NEW_SW_MAIL_SENT, editable: true, nullable: true, length: 5, defaultValue: null, modelName: NEW_SW_MAIL_SENT
)
-
PLANNED_START_DATE
(
type: esriFieldTypeDate, alias: PLANNED_START_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PLANNED_START_DATE
)
-
PLANNED_END_DATE
(
type: esriFieldTypeDate, alias: PLANNED_END_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PLANNED_END_DATE
)
-
PROXIMITY_CHECKED
(
type: esriFieldTypeString, alias: PROXIMITY_CHECKED, editable: true, nullable: true, length: 5, defaultValue: null, modelName: PROXIMITY_CHECKED
)
-
NEW_SW_MAIL_SEND_DATE
(
type: esriFieldTypeDate, alias: NEW_SW_MAIL_SEND_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: NEW_SW_MAIL_SEND_DATE
)
-
SR_LINK
(
type: esriFieldTypeString, alias: Service Request question about a project?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SR_LINK
)
-
MAJOR_CAPITAL_PROJECT_FLAG
(
type: esriFieldTypeString, alias: Major Capital Project Flag, editable: true, nullable: true, length: 3, defaultValue: null, modelName: MAJOR_CAPITAL_PROJECT_FLAG
)
-
CAPITAL_PROJECT_LINK
(
type: esriFieldTypeString, alias: Capital Project Link, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CAPITAL_PROJECT_LINK
)
-
CAPITAL_PROJECT_NAME_ALIAS
(
type: esriFieldTypeString, alias: Project Name Alias for Major Capital Projects, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CAPITAL_PROJECT_NAME_ALIAS
)
Templates:
-
Name: PUBF_CONSTRUCTION_PROJECT_WORK_DETAILS
Description:
Prototype:
CAPITAL_PROJECT_LINK: null
PROJECT_ID: null
PROJECT_NAME: null
PROJ_LEAD: null
PROJ_LEAD_EMAIL: null
PROJECT_BRANCH: null
CONSTRUCTION_ID: null
CONSTRUCTION_MAJOR_CAT_ID: null
CONSTRUCTION_MAJOR_CAT_NAME: null
CONST_CATEGORY_CODE: null
CONS_LEAD: null
CONS_LEAD_EMAIL: null
SITE_WORK_ID: null
SITE_NAME: null
ACTUAL_WORK_START_DATE: null
ACTUAL_WORK_END_DATE: null
STATUS_CODE: null
NEW_SW_MAIL_SENT: null
PLANNED_START_DATE: null
PLANNED_END_DATE: null
PROXIMITY_CHECKED: null
NEW_SW_MAIL_SEND_DATE: null
SR_LINK: null
MAJOR_CAPITAL_PROJECT_FLAG: null
CAPITAL_PROJECT_NAME_ALIAS: null
Drawing Tool: esriFeatureEditToolNone
Capabilities: Query
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 Analytic
Calculate
Validate SQL
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata