Layers:

Layer: SACU_Maintenance_Request_form (0)


Name: SACU_Maintenance_Request_form

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Has Views: true

Source Schema Changes Allowed: true

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)


Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"SACU Maintenance Request form","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True


Global ID Field: globalid

Type ID Field:

Fields:
• objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• house_name (type: esriFieldTypeString, alias: House Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• submitter_name (type: esriFieldTypeString, alias: Name of person reporting the issues:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• supervisor_approval (type: esriFieldTypeString, alias: Has a supervisor observed all issues reported in this form?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• supervisor (type: esriFieldTypeString, alias: If you submit this request without a supervisor observing the issues, then maintenance staff will need to confirm all issues prior to issuing a maintance ticket., SQL Type: sqlTypeOther, length: 255, 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)
• review_statement (type: esriFieldTypeString, alias: These questions will be hidden and are for maintenance staff to complete after the survey has been submitted., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• reviewer_name (type: esriFieldTypeString, alias: Name of maintenance person who reviewed the request, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• review_date (type: esriFieldTypeDate, alias: Date request was review, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• status (type: esriFieldTypeString, alias: Status of report, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true, Coded Values: [approved: Approved], [rejected: Rejected], [more_info: More information needed], ... 4 more ...)
• staff_notes (type: esriFieldTypeString, alias: Maintenance Staff Notes / Comment, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• survey_start_time (type: esriFieldTypeDate, alias: survey_start_time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• survey_end_time (type: esriFieldTypeDate, alias: survey_end_time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:


Relationships:
• SACU_Maintenance_Request_form_issue_repeat (1) -- Related To: issue_repeat (1)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/13/2021 6:23:25 AM

Schema Last Edit Date: 10/13/2021 6:23:25 AM

Data Last Edit Date: 10/13/2021 6:23:25 AM

Tables:

issue_repeat (1)


Name: issue_repeat

Display Field: objectid

Type: Table

Has Views: true

Source Schema Changes Allowed: true

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True


Global ID Field: globalid

Type ID Field:

Fields:
• objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• issue_date (type: esriFieldTypeDate, alias: Date issue was identified, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• priority_level (type: esriFieldTypeString, alias: Priority of Issue, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Immediate: Immediate Action Needed], [Critical: Critical], [Medium: Medium], ... 2 more ...)
• issue_type (type: esriFieldTypeString, alias: Select an issue to report, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Appliance Repair: Appliance Repair], [TV Box: TV Box installation or relocation])
• tv_box_outlet (type: esriFieldTypeString, alias: Is there an outlet on the same wall?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• tv_box_conduit (type: esriFieldTypeString, alias: Does conduit need to be ran or not?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• tv_box_devices (type: esriFieldTypeString, alias: Are all of the devices present for installation?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• issue_notes (type: esriFieldTypeString, alias: Description of issue for maintenance staff, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, 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)

Relationships:
• SACU_Maintenance_Request_form_issue_repeat (1) -- Related To: SACU_Maintenance_Request_form (0)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/13/2021 6:23:25 AM

Schema Last Edit Date: 10/13/2021 6:23:25 AM

Data Last Edit Date: 10/13/2021 6:23:25 AM