{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 47, "name": "MaintenancePRV_History", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "GIS_PROD.GDB_ADMIN.PRV", "relatedTableId": 45, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "GUID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Condition_of_Bolts", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Condition_of_Bolts", "type": "esriFieldTypeString", "alias": "Condition of Bolts", "domain": { "type": "codedValue", "name": "PRV_BoltCondition", "description": "", "codedValues": [ { "name": "Like New", "code": "Like New" }, { "name": "Rusted", "code": "Rusted" }, { "name": "Heavily Rusted", "code": "Heavily Rusted" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Condition_of_Bolts" }, { "name": "High_Side_Valve_Operational", "type": "esriFieldTypeString", "alias": "High Side Valve Operational", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Active Work", "code": "Active Work" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "High_Side_Valve_Operational" }, { "name": "Low_Side_Valve_Operational", "type": "esriFieldTypeString", "alias": "Low Side Valve Operational", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Active Work", "code": "Active Work" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Low_Side_Valve_Operational" }, { "name": "PRV_Status", "type": "esriFieldTypeString", "alias": "PRV Status", "domain": { "type": "codedValue", "name": "OnlineOffline", "description": "Online/Offline", "codedValues": [ { "name": "Online", "code": "Online" }, { "name": "Offline", "code": "Offline" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PRV_Status" }, { "name": "Sounding_Results", "type": "esriFieldTypeString", "alias": "Sounding Results", "domain": { "type": "codedValue", "name": "Sounding", "description": "Sounding", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Quiet", "code": "Quiet" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Sounding_Results" }, { "name": "High_Gauge_Port_Flow", "type": "esriFieldTypeString", "alias": "High Gauge Port Flow", "domain": { "type": "codedValue", "name": "GoodBad", "description": "Good/Bad", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Bad", "code": "Bad" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "High_Gauge_Port_Flow" }, { "name": "Low_Gauge_Port_Flow", "type": "esriFieldTypeString", "alias": "Low Gauge Port Flow", "domain": { "type": "codedValue", "name": "GoodBad", "description": "Good/Bad", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Bad", "code": "Bad" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Low_Gauge_Port_Flow" }, { "name": "High_Side_Control_Port_Flow", "type": "esriFieldTypeString", "alias": "High Side Control Port Flow", "domain": { "type": "codedValue", "name": "GoodBad", "description": "Good/Bad", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Bad", "code": "Bad" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "High_Side_Control_Port_Flow" }, { "name": "Low_Side_Control_Port_Flow", "type": "esriFieldTypeString", "alias": "Low Side Control Port Flow", "domain": { "type": "codedValue", "name": "GoodBad", "description": "Good/Bad", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Bad", "code": "Bad" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Low_Side_Control_Port_Flow" }, { "name": "Bonnet_Flush_Flow", "type": "esriFieldTypeString", "alias": "Bonnet Flush Flow", "domain": { "type": "codedValue", "name": "GoodBad", "description": "Good/Bad", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Bad", "code": "Bad" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Bonnet_Flush_Flow" }, { "name": "Needle_Valve_Clear", "type": "esriFieldTypeString", "alias": "Needle Valve Clear", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Active Work", "code": "Active Work" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Needle_Valve_Clear" }, { "name": "Does_PRV_Open", "type": "esriFieldTypeString", "alias": "Does PRV Fully Open", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Active Work", "code": "Active Work" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Does_PRV_Open" }, { "name": "Does_PRV_Close", "type": "esriFieldTypeString", "alias": "Does PRV Fully Close", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Active Work", "code": "Active Work" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Does_PRV_Close" }, { "name": "High_Side_Pressure", "type": "esriFieldTypeInteger", "alias": "High Side Pressre", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "High_Side_Pressure" }, { "name": "Low_Side_Pressure", "type": "esriFieldTypeInteger", "alias": "Low Side Pressure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Low_Side_Pressure" }, { "name": "Activation_Pressure", "type": "esriFieldTypeInteger", "alias": "Activation Pressure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Activation_Pressure" }, { "name": "Ending_PRV_Status", "type": "esriFieldTypeString", "alias": "Ending PRV Status", "domain": { "type": "codedValue", "name": "OnlineOffline", "description": "Online/Offline", "codedValues": [ { "name": "Online", "code": "Online" }, { "name": "Offline", "code": "Offline" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Ending_PRV_Status" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Comments" }, { "name": "Needs_Replacement", "type": "esriFieldTypeString", "alias": "Needs Replacement", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Active Work", "code": "Active Work" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Needs_Replacement" }, { "name": "WorkOrderID", "type": "esriFieldTypeString", "alias": "Work Order ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WorkOrderID" }, { "name": "WorkDate", "type": "esriFieldTypeDate", "alias": "Work Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WorkDate" }, { "name": "WorkBy", "type": "esriFieldTypeString", "alias": "Work By", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WorkBy" }, { "name": "WorkType", "type": "esriFieldTypeString", "alias": "Work Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": "PRV Inspection", "modelName": "WorkType" }, { "name": "AdditionalWorkNeeded", "type": "esriFieldTypeString", "alias": "Additional Work Needed", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Active Work", "code": "Active Work" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AdditionalWorkNeeded" }, { "name": "DataValidComment", "type": "esriFieldTypeString", "alias": "Data Valid Comment", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DataValidComment" }, { "name": "assetkey", "type": "esriFieldTypeString", "alias": "Asset Key", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "assetkey" }, { "name": "attachmentid1", "type": "esriFieldTypeInteger", "alias": "attachmentid1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "attachmentid1" }, { "name": "attachmentid2", "type": "esriFieldTypeInteger", "alias": "attachmentid2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "attachmentid2" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "GUID", "type": "esriFieldTypeGUID", "alias": "GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "GUID" }, { "name": "additionalwork", "type": "esriFieldTypeString", "alias": "Additional Work Needed", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Active Work", "code": "Active Work" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "additionalwork" }, { "name": "UpstreamPSI", "type": "esriFieldTypeInteger", "alias": "Upstream PSI", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "UpstreamPSI" }, { "name": "DownstreamPSI", "type": "esriFieldTypeInteger", "alias": "Downstream PSI", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DownstreamPSI" }, { "name": "DataValid", "type": "esriFieldTypeString", "alias": "Data Valid", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Active Work", "code": "Active Work" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DataValid" }, { "name": "AdditionalWorkComment", "type": "esriFieldTypeString", "alias": "Additional Work Comment", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AdditionalWorkComment" }, { "name": "PRV_Full_Close", "type": "esriFieldTypeString", "alias": "PRV_Full_Close", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Active Work", "code": "Active Work" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "Yes", "modelName": "PRV_Full_Close" }, { "name": "DS_ValveIsolate", "type": "esriFieldTypeString", "alias": "DS_ValveIsolate", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DS_ValveIsolate" }, { "name": "PF_HS_Pressure", "type": "esriFieldTypeDouble", "alias": "PF_HS_Pressure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PF_HS_Pressure" }, { "name": "PF_LS_Pressure", "type": "esriFieldTypeDouble", "alias": "PF_LS_Pressure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PF_LS_Pressure" }, { "name": "PV_Adjust", "type": "esriFieldTypeString", "alias": "PV_Adjust", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Active Work", "code": "Active Work" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "Yes", "modelName": "PV_Adjust" }, { "name": "PV_Adjust_Comment", "type": "esriFieldTypeString", "alias": "PV_Adjust_Comment", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PV_Adjust_Comment" }, { "name": "ReplacementRecomendation", "type": "esriFieldTypeInteger", "alias": "ReplacementRecomendation", "domain": { "type": "codedValue", "name": "PRV_ReplaceTier", "description": "", "codedValues": [ { "name": "1", "code": 1 }, { "name": "2", "code": 2 }, { "name": "3", "code": 3 }, { "name": "4", "code": 4 }, { "name": "5", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "ReplacementRecomendation" }, { "name": "ReplacementComment", "type": "esriFieldTypeString", "alias": "ReplacementComment", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ReplacementComment" }, { "name": "PilotryReplace", "type": "esriFieldTypeString", "alias": "PilotryReplace", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Active Work", "code": "Active Work" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "Yes", "modelName": "PilotryReplace" }, { "name": "PilotryReplaceComment", "type": "esriFieldTypeString", "alias": "PilotryReplaceComment", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PilotryReplaceComment" } ], "indexes": [ { "name": "R462_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_462", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_5992_Additio", "fields": "AdditionalWorkNeeded", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_462", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_5992_GUID", "fields": "GUID", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "MaintenancePRV_History", "description": "", "prototype": { "attributes": { "PilotryReplace": "Yes", "ReplacementComment": null, "Condition_of_Bolts": null, "High_Side_Valve_Operational": null, "Low_Side_Valve_Operational": null, "PRV_Status": null, "Sounding_Results": null, "High_Gauge_Port_Flow": null, "Low_Gauge_Port_Flow": null, "High_Side_Control_Port_Flow": null, "Low_Side_Control_Port_Flow": null, "Bonnet_Flush_Flow": null, "Needle_Valve_Clear": null, "Does_PRV_Open": null, "Does_PRV_Close": null, "High_Side_Pressure": null, "Low_Side_Pressure": null, "Activation_Pressure": null, "Ending_PRV_Status": null, "Comments": null, "Needs_Replacement": null, "WorkOrderID": null, "WorkDate": null, "WorkBy": null, "WorkType": "PRV Inspection", "AdditionalWorkNeeded": null, "DataValidComment": null, "assetkey": null, "attachmentid1": null, "attachmentid2": null, "PilotryReplaceComment": null, "GUID": null, "additionalwork": null, "UpstreamPSI": null, "DownstreamPSI": null, "DataValid": null, "AdditionalWorkComment": null, "PRV_Full_Close": "Yes", "DS_ValveIsolate": null, "PF_HS_Pressure": null, "PF_LS_Pressure": null, "PV_Adjust": "Yes", "PV_Adjust_Comment": null, "ReplacementRecomendation": 1 } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }