Name: ODHS_Workforce_Resource_Survey

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Has Views: true

Source Schema Changes Allowed: true

Views

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":"ODHS Workforce Resource Survey","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

Time Info:

Start Time Field: survey_start_time
End Time Field: survey_end_time
Track ID Field: null
Time Extent
[12/29/2021 4:55:32 AM UTC, 12/29/2021 5:07:36 AM UTC]

Time Reference: UTC
Time Interval: 0
Time Interval Units: esriTimeUnitsMilliseconds
Has Live Data: false
Export Options:

Use Time: false
Time Data Cumulative: false
Time Offset: 0
Time Offset Units: esriTimeUnitsCenturies

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)
• user_name (type: esriFieldTypeString, alias: Enter your full name:, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• user_or_number (type: esriFieldTypeString, alias: Enter your employee OR Number:, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• agency_abbrv (type: esriFieldTypeString, alias: agency_abbrv, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• agency_program (type: esriFieldTypeString, alias: Select office program:, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• agency_dept (type: esriFieldTypeString, alias: Select office department:, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• office (type: esriFieldTypeString, alias: Select a reporting office address:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• office_address (type: esriFieldTypeString, alias: Address:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• office_city (type: esriFieldTypeString, alias: City:, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• office_state (type: esriFieldTypeString, alias: State:, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• office_zip (type: esriFieldTypeString, alias: Zip Code:, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• office_county (type: esriFieldTypeString, alias: County:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• office_latitude (type: esriFieldTypeDouble, alias: office_latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• office_longitude (type: esriFieldTypeDouble, alias: office_longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• report_date (type: esriFieldTypeDate, alias: Date of Report, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• office_condition (type: esriFieldTypeString, alias: Office Staffing Status, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Fully Staffed: Fully Staffed], [Projected to be Understaffed: Projected to be Understaffed], [Currently Understaffed: Currently Understaffed], ... 1 more ...)
• vacancy_total (type: esriFieldTypeInteger, alias: How many vacant positions?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• status_explained (type: esriFieldTypeString, alias: Current staffing status explained, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• office_impacts (type: esriFieldTypeString, alias: Impact of current staffing shortage, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• office_actions (type: esriFieldTypeString, alias: Actions to resolve, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• vacancy_30days (type: esriFieldTypeInteger, alias: Number of forcasted vacancies in 30 days?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• positions_30days (type: esriFieldTypeString, alias: List type of vacancies, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• vacancy_60days (type: esriFieldTypeInteger, alias: Number of forcasted vacancies in 60 days?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• positions_60days (type: esriFieldTypeString, alias: List type of vacancies, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• vacancy_90days (type: esriFieldTypeInteger, alias: Number of forcasted vacancies in 90 days?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• positions_90days (type: esriFieldTypeString, alias: List type of vacancies, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• shortage_impact (type: esriFieldTypeString, alias: Impact of current or forecasted staffing shortage, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• pd_created (type: esriFieldTypeString, alias: Has a position description (PD) been created and approved for these positions?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• pd_txt (type: esriFieldTypeString, alias: Why has a PD note been created or approved?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• frm3076_txt (type: esriFieldTypeString, alias: 3076 Hiring Exception Request Form / program position management approval status?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• management_2376 (type: esriFieldTypeString, alias: Has a 2376 Hire Request Form been submitted to program position management?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: N/A])
• frm2376_txt (type: esriFieldTypeString, alias: Why has form 2376 not been submitted?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• frm_url (type: esriFieldTypeString, alias: DHS/OHA Publications and Forms, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• outreach (type: esriFieldTypeString, alias: Have you worked with recruitment to implement an outreach plan to attract diversity in the workplace?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: N/A])
• outreach_txt (type: esriFieldTypeString, alias: Why has recruitment not been engaaged with?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• resolve_text (type: esriFieldTypeString, alias: What additional actions are needed to resolve?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• survey_username (type: esriFieldTypeString, alias: survey_username, SQL Type: sqlTypeOther, length: 50, 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)
• survey_deviceid (type: esriFieldTypeString, alias: survey_deviceid, 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)

Templates:

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

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/12/2022 5:11:19 PM

Schema Last Edit Date: 1/12/2022 5:11:19 PM

Data Last Edit Date: 1/12/2022 5:11:19 PM

Supported Operations:   Add Features   Apply Edits   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat