All Layers and Tables (service_9b15b486e470473b94efda1f4f726686

Layers:

Layer: survey (0)

Name:

Display Field:

Type:

Geometry Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"Private Detention Facility Complaints","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:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

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)
reporting_person (type: esriFieldTypeString, alias: Are you reporting for yourself or someone else?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yourself: Yourself], [someone_else: Someone else])
relationship (type: esriFieldTypeString, alias: Your relationship to complainant, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [family member: Family Member], [community member: Community Member], [advocate: Advocate], ... 3 more ...)
relationship_other (type: esriFieldTypeString, alias: Please describe your relationship to complainant., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
organization_name (type: esriFieldTypeString, alias: Organization, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
reporter_name (type: esriFieldTypeString, alias: Your Full Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
email_reporting_person (type: esriFieldTypeString, alias: Your Email Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
phone_reporting_person (type: esriFieldTypeString, alias: Your Phone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
facility_confirm (type: esriFieldTypeString, alias: Does this pertain to a Private Detention Facility in Washington State?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [idk: I don't know])
facility_confirm_idk (type: esriFieldTypeString, alias: Please share why you are unsure, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
facility_confirm_yes (type: esriFieldTypeString, alias: What is the name of the private detention facility you are submitting a concern?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
sorry (type: esriFieldTypeString, alias: Sorry, we are not able to collect complaints concerning facilities outside of Washington State., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
primary_language (type: esriFieldTypeString, alias: Primary Language, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [English: English], [Spanish: Español], [Vietnamese: Tiếng Việt], ... 36 more ...)
primary_language_other (type: esriFieldTypeString, alias: Not listed, please specify:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
origin_country (type: esriFieldTypeString, alias: Country of Origin, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [afghanistan: Afghanistan], [albania: Albania], [algeria: Algeria], ... 194 more ...)
origin_country_other (type: esriFieldTypeString, alias: Not listed, please specify:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
date_incident_happened (type: esriFieldTypeDate, alias: Date and Time Incident Happened, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
concern_description (type: esriFieldTypeString, alias: Describe your concern, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
resolution_rec (type: esriFieldTypeString, alias: What is your suggested resolution and/or remedy?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
personal_information (type: esriFieldTypeString, alias: Privacy Notice, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
first_name (type: esriFieldTypeString, alias: First Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
last_name (type: esriFieldTypeString, alias: Last Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
unit (type: esriFieldTypeString, alias: Unit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
unit_total (type: esriFieldTypeString, alias: Number of People in your Unit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
email_complainant (type: esriFieldTypeString, alias: Email Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
phone_complainant (type: esriFieldTypeString, alias: Phone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
sub_date (type: esriFieldTypeDate, alias: Submission Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ticketID (type: esriFieldTypeString, alias: Confirmation Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
facility_name (type: esriFieldTypeString, alias: Private Detention Facility Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [nwipc: Northwest ICE Processing Center (NWIPC)], [martin_hall: Martin Hall Juvenile Detention Facility])
facility_address (type: esriFieldTypeString, alias: Facility Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
complaint_method (type: esriFieldTypeString, alias: Method of Complaint, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
complaint_method_other (type: esriFieldTypeString, alias: Describe other method of complaint, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
tracking_status (type: esriFieldTypeString, alias: Tracking Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [new: New Complaint], [in_review: In Review], [closed: Closed])
date_status_in_review (type: esriFieldTypeDate, alias: Date status changed to in review, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
date_status_closed (type: esriFieldTypeDate, alias: Date status changed to closed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
due_date_7_days (type: esriFieldTypeDate, alias: Due Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
case_number (type: esriFieldTypeString, alias: Case Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
person_id (type: esriFieldTypeString, alias: Person ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
translation (type: esriFieldTypeString, alias: Translation needed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
translation_progress_notes (type: esriFieldTypeString, alias: Translation progress notes, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
translation_status (type: esriFieldTypeString, alias: Translation status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [new_not_sent: New, not sent], [sent_translation_in_progress: Sent to Translation/In Progress], [complete_returned_from_translation: Complete/Returned from Translation])
date_translation_in_progress (type: esriFieldTypeDate, alias: Date translation status changed to in progress/sent to translation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
date_translation_complete (type: esriFieldTypeDate, alias: Date translation status changed to complete/received from translation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
language (type: esriFieldTypeString, alias: Language, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
translated_concern_description (type: esriFieldTypeString, alias: Translated concern description, SQL Type: sqlTypeOther, length: 12000, nullable: true, editable: true)
translated_resolution_rec (type: esriFieldTypeString, alias: Translated suggested resolution and/or remedy, SQL Type: sqlTypeOther, length: 12000, nullable: true, editable: true)
notes_needed (type: esriFieldTypeString, alias: Select if applicable, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [notes_needed: Start recording notes])
all_notes (type: esriFieldTypeString, alias: Combined All Notes, SQL Type: sqlTypeOther, length: 500000, nullable: true, editable: true)
complaint_cat (type: esriFieldTypeString, alias: Complaint Category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
complaint_other (type: esriFieldTypeString, alias: Other complaint category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
complaint_subcat (type: esriFieldTypeString, alias: Complaint Sub Category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
complaint_subcat_other (type: esriFieldTypeString, alias: Other sub-complaint category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
referral_needed (type: esriFieldTypeString, alias: Select if applicable, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [referral_needed: Refer to someone else])
send_invoice (type: esriFieldTypeString, alias: Select if applicable, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [invoice_needed: Invoicing needed])
retention_date (type: esriFieldTypeDate, alias: Retention date, 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)
collected_date (type: esriFieldTypeDate, alias: Complaint Collected Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
doh_pull_date (type: esriFieldTypeDate, alias: DOH recieves/pulls complaints Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
agency_type (type: esriFieldTypeString, alias: Agency Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [federal_govn: Federal Government], [city_local_govn: City or Local Government], [advocate_grassroots_org: Advocate or Grassroots Organization], ... 1 more ...)
agency_type_other (type: esriFieldTypeString, alias: Describe other agency type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
date_translation_new (type: esriFieldTypeDate, alias: Date translation status was identfied as needed (new), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Relationships:

Private_Detention_Facility_Complaints_investigation_notes (1) -- Related To: investigation_notes (1)
Private_Detention_Facility_Complaints_referral_repeat (2) -- Related To: referral_repeat (2)
Private_Detention_Facility_Complaints_invoicing_repeat (3) -- Related To: invoicing_repeat (3)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

Tables:

investigation_notes (1)

Name:

Display Field:

Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

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)
notes (type: esriFieldTypeString, alias: Investigator Notes, SQL Type: sqlTypeOther, length: 10000, nullable: true, editable: true)
contact_type (type: esriFieldTypeString, alias: Complaint Contact Note Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [complainant: Complainant], [facility: Facility], [other: Other])
contact_type_other (type: esriFieldTypeString, alias: Please specify contact type otther, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
contact_method (type: esriFieldTypeString, alias: Contact Method, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [phone: Phone], [email: Email])
note_datetime (type: esriFieldTypeDate, alias: Note date/time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
note_username_record (type: esriFieldTypeString, alias: User who recorded these notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
concat_notes (type: esriFieldTypeString, alias: Combined Notes, SQL Type: sqlTypeOther, length: 12000, 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:

Private_Detention_Facility_Complaints_investigation_notes (1) -- Related To: survey (0)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

referral_repeat (2)

Name:

Display Field:

Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

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)
referral (type: esriFieldTypeString, alias: Select below to refer to another entity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
referral_other (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
referral_datetime (type: esriFieldTypeDate, alias: Referral datetime, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
oig_confirmation_number (type: esriFieldTypeString, alias: OIG Confirmation #, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
crcl_confirmation_number (type: esriFieldTypeString, alias: CRCL Confirmation #, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
referral_contact_method (type: esriFieldTypeString, alias: Method, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
referral_contact_name (type: esriFieldTypeString, alias: Contact name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
referral_contact_phone (type: esriFieldTypeString, alias: Contact phone number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
referral_email (type: esriFieldTypeString, alias: Email address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
referral_message (type: esriFieldTypeString, alias: Email message, SQL Type: sqlTypeOther, length: 50000, nullable: true, editable: true)
draft_message (type: esriFieldTypeString, alias: draft_message, SQL Type: sqlTypeOther, length: 255, 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:

Private_Detention_Facility_Complaints_referral_repeat (2) -- Related To: survey (0)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

invoicing_repeat (3)

Name:

Display Field:

Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

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)
InvoiceStatus (type: esriFieldTypeString, alias: Invoice Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
InvoiceTypeName (type: esriFieldTypeString, alias: Invoice Type Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [private_detention: Private Detention Chapter 70.395 RCW])
FeeName (type: esriFieldTypeString, alias: Fee Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [private_detention_adult: Violation Chapter 70.395 RCW - Private Detention Adult], [private_detention_juvenile: Violation Chapter 70.395 RCW - Private Detention Juvenile])
InvoiceItemAmount (type: esriFieldTypeDouble, alias: Invoice Item Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
InvoiceContactName (type: esriFieldTypeString, alias: Invoice Contact Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
InvoiceContactMailingAddress (type: esriFieldTypeString, alias: Invoice Contact Mailing Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DueDate (type: esriFieldTypeDate, alias: Payment Due Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Comment (type: esriFieldTypeString, alias: Comment included on invoice, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
UBI (type: esriFieldTypeString, alias: UBI, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
BusinessName (type: esriFieldTypeString, alias: Business Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
BusinessAddress (type: esriFieldTypeString, alias: Business Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DateTimeSubmitted (type: esriFieldTypeDate, alias: Submission date and time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
invoice_username (type: esriFieldTypeString, alias: User who submitted the invoice, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
InvoiceId (type: esriFieldTypeString, alias: Invoice Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DueDate_EH (type: esriFieldTypeDate, alias: Due Date from EH Invoicing, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
InvoiceTotal (type: esriFieldTypeDouble, alias: Invoice Total from EH Invoicing, SQL Type: sqlTypeOther, nullable: true, editable: true)
ScanCode (type: esriFieldTypeString, alias: Scan Code for Invoice Report, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
appeal (type: esriFieldTypeString, alias: Select if applicable, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [appeal_requested: Appeal Requested])
date_appeal_requested (type: esriFieldTypeDate, alias: Date appleal requested, SQL Type: sqlTypeOther, length: 255, 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:

Private_Detention_Facility_Complaints_invoicing_repeat (3) -- Related To: survey (0)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date: