Name: tSignMaint

Display Field: strSignMaintComments

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: intSignMaintID

Unique ID Field:

Name : intSignMaintID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• intSignMaintID (type: esriFieldTypeOID, alias: intSignMaintID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• intSignID (type: esriFieldTypeInteger, alias: intSignID, SQL Type: sqlTypeOther, nullable: false, editable: true)
• dtmSignMaintDate (type: esriFieldTypeDate, alias: Sign Maint Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• intSignMaintActionID (type: esriFieldTypeInteger, alias: Action, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Replaced], [2: Removed], [3: Installed], ... 3 more ...)
• intSignMaintReason1ID (type: esriFieldTypeInteger, alias: SignMaintReason1, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Accident], [2: Deterioration], [3: New], ... 10 more ...)
• intSignMaintReason2ID (type: esriFieldTypeInteger, alias: SignMaintReason2, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Min. Retro Reflectivity], [2: Unspecified], [3: New Regulation])
• intSignMaintPersonID (type: esriFieldTypeInteger, alias: Person, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2: Tommy Medina], [4: Juan Anguiano], [5: Other (see comments)])
• strSignMaintComments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SignGlobalID (type: esriFieldTypeGUID, alias: SignGlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: tSignMaint
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• intSignID: 0

Relationships:

• tSign (2) -- Related To: tSign (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/25/2019 5:14:37 PM

Schema Last Edit Date: 9/25/2019 5:14:37 PM

Data Last Edit Date: 9/25/2019 5:14:37 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat