Name: Work Order Info.

Display Field: craft_name

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• wo_no ( type: esriFieldTypeString, alias: wo_no, editable: true, nullable: true, length: 10, defaultValue: null, modelName: wo_no )
• issued ( type: esriFieldTypeDate, alias: issued, editable: true, nullable: true, length: 8, defaultValue: null, modelName: issued )
• target ( type: esriFieldTypeDate, alias: target, editable: true, nullable: true, length: 8, defaultValue: null, modelName: target )
• closed ( type: esriFieldTypeDate, alias: closed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: closed )
• wo_status ( type: esriFieldTypeString, alias: wo_status, editable: true, nullable: true, length: 1, defaultValue: null, modelName: wo_status )
• system_id ( type: esriFieldTypeString, alias: system_id, editable: true, nullable: true, length: 25, defaultValue: null, modelName: system_id )
• wo_task ( type: esriFieldTypeString, alias: wo_task, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: wo_task )
• wo_type ( type: esriFieldTypeString, alias: wo_type, editable: true, nullable: true, length: 10, defaultValue: null, modelName: wo_type )
• problem ( type: esriFieldTypeString, alias: problem, editable: true, nullable: true, length: 500, defaultValue: null, modelName: problem )
• reason ( type: esriFieldTypeString, alias: reason, editable: true, nullable: true, length: 500, defaultValue: null, modelName: reason )
• wo_udf1 ( type: esriFieldTypeString, alias: wo_udf1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: wo_udf1 )
• wo_udf2 ( type: esriFieldTypeString, alias: wo_udf2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: wo_udf2 )
• wo_udf3 ( type: esriFieldTypeString, alias: wo_udf3, editable: true, nullable: true, length: 50, defaultValue: null, modelName: wo_udf3 )
• wo_udf4 ( type: esriFieldTypeString, alias: wo_udf4, editable: true, nullable: true, length: 50, defaultValue: null, modelName: wo_udf4 )
• wo_udf5 ( type: esriFieldTypeString, alias: wo_udf5, editable: true, nullable: true, length: 50, defaultValue: null, modelName: wo_udf5 )
• elapsed_hr ( type: esriFieldTypeDouble, alias: elapsed_hr, editable: true, nullable: true, defaultValue: null, modelName: elapsed_hr )
• wo_udf6 ( type: esriFieldTypeString, alias: wo_udf6, editable: true, nullable: true, length: 50, defaultValue: null, modelName: wo_udf6 )
• wo_udf7 ( type: esriFieldTypeString, alias: wo_udf7, editable: true, nullable: true, length: 50, defaultValue: null, modelName: wo_udf7 )
• wo_udf8 ( type: esriFieldTypeString, alias: wo_udf8, editable: true, nullable: true, length: 50, defaultValue: null, modelName: wo_udf8 )
• wo_udf9 ( type: esriFieldTypeString, alias: wo_udf9, editable: true, nullable: true, length: 50, defaultValue: null, modelName: wo_udf9 )
• wo_acct ( type: esriFieldTypeString, alias: wo_acct, editable: true, nullable: true, length: 21, defaultValue: null, modelName: wo_acct )
• project_no ( type: esriFieldTypeString, alias: project_no, editable: true, nullable: true, length: 50, defaultValue: null, modelName: project_no )
• sup_notes ( type: esriFieldTypeString, alias: sup_notes, editable: true, nullable: true, length: 500, defaultValue: null, modelName: sup_notes )
• county_prob ( type: esriFieldTypeString, alias: county_prob, editable: true, nullable: true, length: 20, defaultValue: null, modelName: county_prob )
• claim_filed ( type: esriFieldTypeString, alias: claim_filed, editable: true, nullable: true, length: 20, defaultValue: null, modelName: claim_filed )
• cust_prob ( type: esriFieldTypeString, alias: cust_prob, editable: true, nullable: true, length: 20, defaultValue: null, modelName: cust_prob )
• action_next ( type: esriFieldTypeString, alias: action_next, editable: true, nullable: true, length: 20, defaultValue: null, modelName: action_next )
• work_code ( type: esriFieldTypeString, alias: work_code, editable: true, nullable: true, length: 20, defaultValue: null, modelName: work_code )
• priority_cd ( type: esriFieldTypeString, alias: priority_cd, editable: true, nullable: true, length: 10, defaultValue: null, modelName: priority_cd )
• maint_code ( type: esriFieldTypeString, alias: maint_code, editable: true, nullable: true, length: 12, defaultValue: null, modelName: maint_code )
• wk_code ( type: esriFieldTypeString, alias: wk_code, editable: true, nullable: true, length: 10, defaultValue: null, modelName: wk_code )
• wo_udf10 ( type: esriFieldTypeString, alias: wo_udf10, editable: true, nullable: true, length: 50, defaultValue: null, modelName: wo_udf10 )
• wo_udf11 ( type: esriFieldTypeString, alias: wo_udf11, editable: true, nullable: true, length: 50, defaultValue: null, modelName: wo_udf11 )
• w_in_progress ( type: esriFieldTypeString, alias: w_in_progress, editable: true, nullable: true, length: 10, defaultValue: null, modelName: w_in_progress )
• work_request_no ( type: esriFieldTypeString, alias: work_request_no, editable: true, nullable: true, length: 10, defaultValue: null, modelName: work_request_no )
• approved_by ( type: esriFieldTypeString, alias: approved_by, editable: true, nullable: true, length: 25, defaultValue: null, modelName: approved_by )
• approved_by_descr ( type: esriFieldTypeString, alias: approved_by_descr, editable: true, nullable: true, length: 20, defaultValue: null, modelName: approved_by_descr )
• assign_to ( type: esriFieldTypeString, alias: assign_to, editable: true, nullable: true, length: 25, defaultValue: null, modelName: assign_to )
• assign_to_descr ( type: esriFieldTypeString, alias: assign_to_descr, editable: true, nullable: true, length: 20, defaultValue: null, modelName: assign_to_descr )
• loc_id ( type: esriFieldTypeString, alias: loc_id, editable: true, nullable: true, length: 10, defaultValue: null, modelName: loc_id )
• loc_desc ( type: esriFieldTypeString, alias: loc_desc, editable: true, nullable: true, length: 500, defaultValue: null, modelName: loc_desc )
• craft_name ( type: esriFieldTypeString, alias: craft_name, editable: true, nullable: true, length: 20, defaultValue: null, modelName: craft_name )
• ttl_hrs ( type: esriFieldTypeDouble, alias: ttl_hrs, editable: true, nullable: true, defaultValue: null, modelName: ttl_hrs )
• ttl_cost ( type: esriFieldTypeDouble, alias: ttl_cost, editable: true, nullable: true, defaultValue: null, modelName: ttl_cost )
• ttl_qty ( type: esriFieldTypeDouble, alias: ttl_qty, editable: true, nullable: true, defaultValue: null, modelName: ttl_qty )
• labor_cost ( type: esriFieldTypeDouble, alias: labor_cost, editable: true, nullable: true, defaultValue: null, modelName: labor_cost )
• parts_cost ( type: esriFieldTypeDouble, alias: parts_cost, editable: true, nullable: true, defaultValue: null, modelName: parts_cost )
• misc_cost ( type: esriFieldTypeDouble, alias: misc_cost, editable: true, nullable: true, defaultValue: null, modelName: misc_cost )
• contractor_cost ( type: esriFieldTypeDouble, alias: contractor_cost, editable: true, nullable: true, defaultValue: null, modelName: contractor_cost )
• wrkqty_cost ( type: esriFieldTypeDouble, alias: wrkqty_cost, editable: true, nullable: true, defaultValue: null, modelName: wrkqty_cost )
• equipment_cost ( type: esriFieldTypeDouble, alias: equipment_cost, editable: true, nullable: true, defaultValue: null, modelName: equipment_cost )
• wo_cost ( type: esriFieldTypeDouble, alias: wo_cost, editable: true, nullable: true, defaultValue: null, modelName: wo_cost )
• crew_cost ( type: esriFieldTypeDouble, alias: crew_cost, editable: true, nullable: true, defaultValue: null, modelName: crew_cost )
• crew_ctr ( type: esriFieldTypeDouble, alias: crew_ctr, editable: true, nullable: true, defaultValue: null, modelName: crew_ctr )
• misc_ctr ( type: esriFieldTypeDouble, alias: misc_ctr, editable: true, nullable: true, defaultValue: null, modelName: misc_ctr )
• contractor_ctr ( type: esriFieldTypeDouble, alias: contractor_ctr, editable: true, nullable: true, defaultValue: null, modelName: contractor_ctr )
• wrkqty_ctr ( type: esriFieldTypeDouble, alias: wrkqty_ctr, editable: true, nullable: true, defaultValue: null, modelName: wrkqty_ctr )
• equipment_ctr ( type: esriFieldTypeDouble, alias: equipment_ctr, editable: true, nullable: true, defaultValue: null, modelName: equipment_ctr )
• first_name ( type: esriFieldTypeString, alias: first_name, editable: true, nullable: true, length: 15, defaultValue: null, modelName: first_name )
• last_name ( type: esriFieldTypeString, alias: last_name, editable: true, nullable: true, length: 15, defaultValue: null, modelName: last_name )
• phone1 ( type: esriFieldTypeString, alias: phone1, editable: true, nullable: true, length: 16, defaultValue: null, modelName: phone1 )
• phone2 ( type: esriFieldTypeString, alias: phone2, editable: true, nullable: true, length: 16, defaultValue: null, modelName: phone2 )
• email ( type: esriFieldTypeString, alias: email, editable: true, nullable: true, length: 99, defaultValue: null, modelName: email )
• street_number ( type: esriFieldTypeString, alias: street_number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: street_number )
• street_name ( type: esriFieldTypeString, alias: street_name, editable: true, nullable: true, length: 30, defaultValue: null, modelName: street_name )
• cross_street ( type: esriFieldTypeString, alias: cross_street, editable: true, nullable: true, length: 30, defaultValue: null, modelName: cross_street )
• city ( type: esriFieldTypeString, alias: city, editable: true, nullable: true, length: 30, defaultValue: null, modelName: city )
• state ( type: esriFieldTypeString, alias: state, editable: true, nullable: true, length: 30, defaultValue: null, modelName: state )
• zip_code ( type: esriFieldTypeString, alias: zip_code, editable: true, nullable: true, length: 10, defaultValue: null, modelName: zip_code )
• loc_desc2 ( type: esriFieldTypeString, alias: loc_desc2, editable: true, nullable: true, length: 500, defaultValue: null, modelName: loc_desc2 )
• complaint ( type: esriFieldTypeString, alias: complaint, editable: true, nullable: true, length: 500, defaultValue: null, modelName: complaint )
• comments ( type: esriFieldTypeString, alias: comments, editable: true, nullable: true, length: 500, defaultValue: null, modelName: comments )
• problem_street_number ( type: esriFieldTypeString, alias: problem_street_number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: problem_street_number )
• problem_street_name ( type: esriFieldTypeString, alias: problem_street_name, editable: true, nullable: true, length: 30, defaultValue: null, modelName: problem_street_name )
• problem_cross_street ( type: esriFieldTypeString, alias: problem_cross_street, editable: true, nullable: true, length: 30, defaultValue: null, modelName: problem_cross_street )
• problem_city ( type: esriFieldTypeString, alias: problem_city, editable: true, nullable: true, length: 30, defaultValue: null, modelName: problem_city )
• problem_state ( type: esriFieldTypeString, alias: problem_state, editable: true, nullable: true, length: 30, defaultValue: null, modelName: problem_state )
• problem_zip_code ( type: esriFieldTypeString, alias: problem_zip_code, editable: true, nullable: true, length: 10, defaultValue: null, modelName: problem_zip_code )
• notes ( type: esriFieldTypeString, alias: notes, editable: true, nullable: true, length: 500, defaultValue: null, modelName: notes )
• use_cust_address ( type: esriFieldTypeString, alias: use_cust_address, editable: true, nullable: true, length: 1, defaultValue: null, modelName: use_cust_address )
• rating ( type: esriFieldTypeDouble, alias: rating, editable: true, nullable: true, defaultValue: null, modelName: rating )
• unit_id ( type: esriFieldTypeString, alias: unit_id, editable: true, nullable: true, length: 25, defaultValue: null, modelName: unit_id )
• unit_type ( type: esriFieldTypeString, alias: unit_type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: unit_type )
• sub_type ( type: esriFieldTypeString, alias: sub_type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: sub_type )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )

Templates:

• Name: Work Order Info.
  Description:
  Prototype:
  sub_type: null
  wo_no: null
  issued: null
  target: null
  closed: null
  wo_status: null
  system_id: null
  wo_task: null
  wo_type: null
  problem: null
  reason: null
  wo_udf1: null
  wo_udf2: null
  wo_udf3: null
  wo_udf4: null
  wo_udf5: null
  elapsed_hr: null
  wo_udf6: null
  wo_udf7: null
  wo_udf8: null
  wo_udf9: null
  wo_acct: null
  project_no: null
  sup_notes: null
  county_prob: null
  claim_filed: null
  cust_prob: null
  action_next: null
  work_code: null
  priority_cd: null
  maint_code: null
  wk_code: null
  wo_udf10: null
  wo_udf11: null
  w_in_progress: null
  work_request_no: null
  approved_by: null
  approved_by_descr: null
  assign_to: null
  assign_to_descr: null
  loc_id: null
  loc_desc: null
  craft_name: null
  ttl_hrs: null
  ttl_cost: null
  ttl_qty: null
  labor_cost: null
  parts_cost: null
  misc_cost: null
  contractor_cost: null
  wrkqty_cost: null
  equipment_cost: null
  wo_cost: null
  crew_cost: null
  crew_ctr: null
  misc_ctr: null
  contractor_ctr: null
  wrkqty_ctr: null
  equipment_ctr: null
  first_name: null
  last_name: null
  phone1: null
  phone2: null
  email: null
  street_number: null
  street_name: null
  cross_street: null
  city: null
  state: null
  zip_code: null
  loc_desc2: null
  complaint: null
  comments: null
  problem_street_number: null
  problem_street_name: null
  problem_cross_street: null
  problem_city: null
  problem_state: null
  problem_zip_code: null
  notes: null
  use_cust_address: null
  rating: null
  unit_id: null
  unit_type: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Channels (0) -- Related To: Channels (1)

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Related Records   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata