Layer: user_survey_JPMorgan_date_submitted_as_string_but_not_unix

View In: Map Viewer

Name: user_survey_JPMorgan_date_submitted_as_string_but_not_unix_epoch

Display Field: casenum

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:

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"user survey-JPMorgan date submitted as string but not unix epoch","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:

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)
casenum (type: esriFieldTypeString, alias: Case Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
casetype (type: esriFieldTypeString, alias: Case Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [physec: Physical Security], [wkplcv: Workplace Violence])
subtype (type: esriFieldTypeString, alias: Sub Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
category (type: esriFieldTypeString, alias: Category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
subcat (type: esriFieldTypeString, alias: Sub Category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
incidentdate (type: esriFieldTypeDate, alias: Incident Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
incidenttime (type: esriFieldTypeString, alias: Incident Time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
timezone (type: esriFieldTypeString, alias: Timezone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [cdt: CDT], [cst: CST], [edt: EDT], ... 5 more ...)
datereported (type: esriFieldTypeDate, alias: Date Reported, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
summarylob (type: esriFieldTypeString, alias: LOB, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [assetmanagement: Asset Management], [commericalbanking: Commerical Banking], [consumercommunitybanking: Consumer and Community Banking], ... 4 more ...)
summarycountry (type: esriFieldTypeString, alias: Country, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [argentina: Argentina], [bahamas: Bahamas], [bermuda: Bermuda], ... 9 more ...)
securityregion (type: esriFieldTypeString, alias: Security Region, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [apac: APAC], [central: Central], [emea: EMEA], ... 8 more ...)
incidentdescription (type: esriFieldTypeString, alias: Incident Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
takersid (type: esriFieldTypeString, alias: SID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
takerfname (type: esriFieldTypeString, alias: First Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
takerlname (type: esriFieldTypeString, alias: Last Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
takerphone (type: esriFieldTypeString, alias: Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
takeremail (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
lob (type: esriFieldTypeString, alias: LOB, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [assetmanagement: Asset Management], [commericalbanking: Commerical Banking], [consumercommunitybanking: Consumer and Community Banking], ... 4 more ...)
usersubmitter (type: esriFieldTypeString, alias: usersubmitter, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
emailofintake (type: esriFieldTypeString, alias: emailofintake, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
intakefirstname (type: esriFieldTypeString, alias: Intake Specialist First Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
intakelastname (type: esriFieldTypeString, alias: Intake Specialist Last Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
intakephone (type: esriFieldTypeString, alias: Intake Specialist Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
police (type: esriFieldTypeString, alias: Law Enforcement, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
agency (type: esriFieldTypeString, alias: Agency, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
officer (type: esriFieldTypeString, alias: Officer Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
policephone (type: esriFieldTypeString, alias: Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
incident (type: esriFieldTypeString, alias: Incident Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ems (type: esriFieldTypeString, alias: EMS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
hospital (type: esriFieldTypeString, alias: Hospital, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
injury (type: esriFieldTypeString, alias: Injury, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
healthservices (type: esriFieldTypeString, alias: Health Services, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
firehazard (type: esriFieldTypeString, alias: Fire or Hazardous Materials, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
firehazardagency (type: esriFieldTypeString, alias: Fire or Hazardous Materials Agency, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
firehazardphone (type: esriFieldTypeString, alias: Fire or Hazardous Materials Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
firehazardcomments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
bolo (type: esriFieldTypeString, alias: BOLO, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
addguards (type: esriFieldTypeString, alias: Additional Guards, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
armedguards (type: esriFieldTypeString, alias: Armed or Unarmed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [armed: Armed], [unarmed: Unarmed])
notrespassletter (type: esriFieldTypeString, alias: No Trespass Letter, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
ods (type: esriFieldTypeString, alias: ODS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
iddeactivate (type: esriFieldTypeString, alias: ID Deactivated, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
btalarms (type: esriFieldTypeString, alias: Badge / Trace Alarms, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
otheractions (type: esriFieldTypeString, alias: Other Actions, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
otheractionscomments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
gsisid (type: esriFieldTypeString, alias: SID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
gsifn (type: esriFieldTypeString, alias: First Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
gsiln (type: esriFieldTypeString, alias: Last Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
gsiofficenum (type: esriFieldTypeString, alias: Office Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
gsimobilenum (type: esriFieldTypeString, alias: Mobile Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
gisemail (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
psbrief (type: esriFieldTypeString, alias: PS Briefing, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
privbreif (type: esriFieldTypeString, alias: Privacy Briefing, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
relowk (type: esriFieldTypeString, alias: Relocate Work Site, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
relowkcomments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
hidephonebk (type: esriFieldTypeString, alias: Hide in Phonebook, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
hidephonebkcomments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
redirectemail (type: esriFieldTypeString, alias: Redirect Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
redirectemailcomments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
q1 (type: esriFieldTypeString, alias: What motivated the individual to make the statement or take the action that caused him/her to come to attention?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
q1comment (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
q2 (type: esriFieldTypeString, alias: Has the individual communicated to anyone concerning his/her perceived grievance(s) or intentions to resolve the greivance?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
q2comment (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
q3 (type: esriFieldTypeString, alias: Has the individual shown an interest in targeted violence, perpetrators of targeted violence, weapons, extremist groups, or murder?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
q3comment (type: esriFieldTypeString, alias: comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
q4 (type: esriFieldTypeString, alias: Has the individual been involved in previous acts of violence or engaged in attack-related behavior, including any menacing, harassing, and/or stalking-type behavior?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
q4comment (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
q5 (type: esriFieldTypeString, alias: Does the individual present behavior or have a known history indicative of mental illness or personality disorder such as command hallucinations, delusional ideas, feelings of persecution, etc., with indications that the individual has acted on those beliefs?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
q5comment (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
q6 (type: esriFieldTypeString, alias: Is there evidence that the individual's behavior is being affected negatively by any type of substance abuse?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
q6comment (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
q7 (type: esriFieldTypeString, alias: Has the individual experienced a recent loss and/or loss of status, and has this led to feelings of desperation, despair or thoughts of suicide?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
q7comment (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
q8 (type: esriFieldTypeString, alias: Corroboration: What is the individual saying, and is it consistent with his/her actions?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
q8comment (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
q9 (type: esriFieldTypeString, alias: Is there concern among those that know the individual that he/she might take action based on inappropriate ideas?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
q9comment (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
q10 (type: esriFieldTypeString, alias: What factors in the individual’s life and/or environment might increase/decrease the likelihood of the individual attempting to attack a target? (Calm, reasonable disposition; steady employment; honorable or favorable reputation; support system of family or friends; interests or hobbies outside work; stable routine; dignity) Lack of these factors increases risk of escalation., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
q10comment (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
jaca1 (type: esriFieldTypeString, alias: violence is justified?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown], ... 1 more ...)
jaca1comment (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
jaca2 (type: esriFieldTypeString, alias: there are no alternatives to violence?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown], ... 1 more ...)
jaca2comment (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
jaca3 (type: esriFieldTypeString, alias: the consequences of violence are acceptable?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown], ... 1 more ...)
jaca3comment (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
jaca4 (type: esriFieldTypeString, alias: they have the ability to commit violence?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown], ... 1 more ...)
jaca4comment (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
readytoclose (type: esriFieldTypeString, alias: Is this case ready for closure?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
suptype (type: esriFieldTypeString, alias: Was the correct Case Type assigned to the case?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
suptypecomment (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
supdocs (type: esriFieldTypeString, alias: Has adequate supporting documentation been associated to the case?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
supdocscomment (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
supinfo (type: esriFieldTypeString, alias: Is all required case information completed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
supinfocomments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
supsubj (type: esriFieldTypeString, alias: Are subjects correctly associated to the case?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
supsubjcomments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
supfac (type: esriFieldTypeString, alias: Are facilities correctly associated to the case?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
supfaccomments (type: esriFieldTypeString, alias: Comments, 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: 50, 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: 50, nullable: true, editable: false)

Templates:

Relationships:

Relationship_assocfacs (1) -- Related To: assocfacs (1)
Relationship_policecommentsrpt (2) -- Related To: policecommentsrpt (2)
Relationship_emscomments (3) -- Related To: emscomments (3)
Relationship_injurycommentsrpt (4) -- Related To: injurycommentsrpt (4)
Relationship_healthservicescommentsrpt (5) -- Related To: healthservicescommentsrpt (5)
Relationship_bolourlrpt (6) -- Related To: bolourlrpt (6)
Relationship_boloimagerpt (7) -- Related To: boloimagerpt (7)
Relationship_bolocommentsrpt (8) -- Related To: bolocommentsrpt (8)
Relationship_addguardsurlrpt (9) -- Related To: addguardsurlrpt (9)
Relationship_addguardsimagerpt (10) -- Related To: addguardsimagerpt (10)
Relationship_addguardscommentsrpt (11) -- Related To: addguardscommentsrpt (11)
Relationship_notrespassletterurlrpt (12) -- Related To: notrespassletterurlrpt (12)
Relationship_notrespassletterimagerpt (13) -- Related To: notrespassletterimagerpt (13)
Relationship_notrespasslettercommentrpt (14) -- Related To: notrespasslettercommentrpt (14)
Relationship_odscommentsrpt (15) -- Related To: odscommentsrpt (15)
Relationship_iddeactivatecommentrpt (16) -- Related To: iddeactivatecommentrpt (16)
Relationship_btalarmscommentsrpt (17) -- Related To: btalarmscommentsrpt (17)
Relationship_suspectrpt (18) -- Related To: suspectrpt (18)
Relationship_victimrpt (19) -- Related To: victimrpt (22)
Relationship_witnessrpt (20) -- Related To: witnessrpt (26)
Relationship_gsicommentsrpt (21) -- Related To: gsicommentsrpt (30)
Relationship_erinvrpt (22) -- Related To: erinvrpt (31)
Relationship_wpvrpt (23) -- Related To: wpvrpt (33)
Relationship_eaprpt (24) -- Related To: eaprpt (35)
Relationship_othergrprpt (25) -- Related To: othergrprpt (37)
Relationship_commentsrpt (26) -- Related To: commentsrpt (38)
Relationship_evidenceurlrpt (27) -- Related To: evidenceurlrpt (39)
Relationship_evidenceimage (28) -- Related To: evidenceimage (40)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/19/2018 11:43:54 AM

Schema Last Edit Date: 3/19/2018 11:43:54 AM

Data Last Edit Date: 3/19/2018 11:43:54 AM

Supported Operations: Query 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

Layer: user_survey_JPMorgan_date_submitted_as_string_but_not_unix_epoch (ID:0)