Name: telus_bdo_address_li

Display Field: name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 188f357da6bc4c82b3f9b7cb305f818e

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: false
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: false
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• list_name ( modelName: list_name, nullable: true, editable: true, defaultValue: null, length: 8000, alias: list_name, type: esriFieldTypeString )
• name ( modelName: name, nullable: true, editable: true, defaultValue: null, length: 8000, alias: name, type: esriFieldTypeString )
• label ( modelName: label, nullable: true, editable: true, defaultValue: null, length: 8000, alias: label, type: esriFieldTypeString )
• area ( modelName: area, nullable: true, editable: true, defaultValue: null, length: 8000, alias: area, type: esriFieldTypeString )
• fsa ( modelName: fsa, nullable: true, editable: true, defaultValue: null, length: 8000, alias: fsa, type: esriFieldTypeString )
• postal_code ( modelName: postal_code, nullable: true, editable: true, defaultValue: null, length: 8000, alias: postal_code, type: esriFieldTypeString )
• dpo_num ( modelName: dpo_num, nullable: true, editable: true, defaultValue: null, length: 8000, alias: DPO_num, type: esriFieldTypeString )
• addr_lpds_id ( modelName: addr_lpds_id, nullable: true, editable: true, defaultValue: null, alias: Addr_LPDS_Id, type: esriFieldTypeInteger )
• addr_fms_id ( modelName: addr_fms_id, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Addr_FMS_ID, type: esriFieldTypeString )
• coid ( modelName: coid, nullable: true, editable: true, defaultValue: null, length: 8000, alias: COID, type: esriFieldTypeString )
• drop_status ( modelName: drop_status, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Drop_Status, type: esriFieldTypeString )
• pinned_to_vendor_date ( modelName: pinned_to_vendor_date, nullable: true, editable: true, defaultValue: null, alias: Pinned_To_Vendor_Date, type: esriFieldTypeDateOnly )
• vendor_due_date ( modelName: vendor_due_date, nullable: true, editable: true, defaultValue: null, alias: Vendor_Due_Date, type: esriFieldTypeDateOnly )
• estimated_completion_date ( modelName: estimated_completion_date, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Estimated_Completion_Date, type: esriFieldTypeString )
• delay_reason_code ( modelName: delay_reason_code, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Delay_Reason_Code, type: esriFieldTypeString )
• delay_reason_comments ( modelName: delay_reason_comments, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Delay_Reason_Comments, type: esriFieldTypeString )
• drop_cancelled_date ( modelName: drop_cancelled_date, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Drop_Cancelled_Date, type: esriFieldTypeString )
• drop_cancelled_reason ( modelName: drop_cancelled_reason, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Drop_Cancelled_Reason, type: esriFieldTypeString )
• drop_cancelled_reason_description ( modelName: drop_cancelled_reason_description, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Drop_Cancelled_Reason_Description, type: esriFieldTypeString )
• dcc_customr_cbr_1 ( modelName: dcc_customr_cbr_1, nullable: true, editable: true, defaultValue: null, alias: DCC_Customr_CBR_1, type: esriFieldTypeBigInteger )
• dcc_customer_cbr_2 ( modelName: dcc_customer_cbr_2, nullable: true, editable: true, defaultValue: null, length: 8000, alias: DCC_Customer_CBR_2, type: esriFieldTypeString )
• dcc_customer_cbr_3 ( modelName: dcc_customer_cbr_3, nullable: true, editable: true, defaultValue: null, alias: DCC_Customer_CBR_3, type: esriFieldTypeBigInteger )
• dcc_customer_email ( modelName: dcc_customer_email, nullable: true, editable: true, defaultValue: null, length: 8000, alias: DCC_Customer_Email, type: esriFieldTypeString )
• dcc_customr_name_1 ( modelName: dcc_customr_name_1, nullable: true, editable: true, defaultValue: null, length: 8000, alias: DCC_Customr_Name_1, type: esriFieldTypeString )
• dcc_customer_name_2 ( modelName: dcc_customer_name_2, nullable: true, editable: true, defaultValue: null, length: 8000, alias: DCC_Customer_Name_2, type: esriFieldTypeString )
• fifa_sales_order_id ( modelName: fifa_sales_order_id, nullable: true, editable: true, defaultValue: null, alias: FIFA_Sales_Order_ID, type: esriFieldTypeInteger )
• fifa_sales_order_appointment_date ( modelName: fifa_sales_order_appointment_date, nullable: true, editable: true, defaultValue: null, length: 8000, alias: FIFA_Sales_Order_Appointment_Date, type: esriFieldTypeString )
• vendor_completed_date ( modelName: vendor_completed_date, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Vendor_Completed_Date, type: esriFieldTypeString )
• completed_by_other_date ( modelName: completed_by_other_date, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Completed_By_Other_Date, type: esriFieldTypeString )
• occupancy_status ( modelName: occupancy_status, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Occupancy_Status, type: esriFieldTypeString )
• owner_first_name ( modelName: owner_first_name, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Owner_First_Name, type: esriFieldTypeString )
• owner_last_name ( modelName: owner_last_name, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Owner_Last_Name, type: esriFieldTypeString )
• owner_name ( modelName: owner_name, nullable: true, editable: true, defaultValue: null, length: 8000, alias: owner_name, type: esriFieldTypeString )
• owner_num ( modelName: owner_num, nullable: true, editable: true, defaultValue: null, alias: owner_num, type: esriFieldTypeBigInteger )
• occupant_name ( modelName: occupant_name, nullable: true, editable: true, defaultValue: null, length: 8000, alias: occupant_name, type: esriFieldTypeString )
• occupant_num ( modelName: occupant_num, nullable: true, editable: true, defaultValue: null, alias: occupant_num, type: esriFieldTypeBigInteger )
• addr_nap ( modelName: addr_nap, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Addr_NAP, type: esriFieldTypeString )
• dp_occupant_email ( modelName: dp_occupant_email, nullable: true, editable: true, defaultValue: null, length: 8000, alias: DP_Occupant_Email, type: esriFieldTypeString )
• bpo_survey_status ( modelName: bpo_survey_status, nullable: true, editable: true, defaultValue: null, length: 8000, alias: BPO_Survey_status, type: esriFieldTypeString )
• full_service_address ( modelName: full_service_address, nullable: true, editable: true, defaultValue: null, length: 8000, alias: full_service_address, type: esriFieldTypeString )
• bdo_submitted ( modelName: bdo_submitted, nullable: true, editable: true, defaultValue: null, length: 8000, alias: bdo_submitted, type: esriFieldTypeString )
• bsw_submitted ( modelName: bsw_submitted, nullable: true, editable: true, defaultValue: null, length: 8000, alias: bsw_submitted, type: esriFieldTypeString )

Templates:

• Name: telus_bdo_address_li
  Description:
  Prototype:
  dcc_customer_name_2: null
  dp_occupant_email: null
  drop_cancelled_reason: null
  fifa_sales_order_appointment_date: null
  list_name: null
  bsw_submitted: null
  dcc_customer_cbr_3: null
  dcc_customer_cbr_2: null
  bdo_submitted: null
  addr_nap: null
  pinned_to_vendor_date: null
  drop_cancelled_reason_description: null
  dcc_customr_cbr_1: null
  dcc_customer_email: null
  delay_reason_comments: null
  occupant_name: null
  completed_by_other_date: null
  owner_first_name: null
  area: null
  fifa_sales_order_id: null
  owner_name: null
  owner_num: null
  coid: null
  label: null
  bpo_survey_status: null
  addr_lpds_id: null
  occupant_num: null
  full_service_address: null
  addr_fms_id: null
  dcc_customr_name_1: null
  fsa: null
  drop_status: null
  occupancy_status: null
  name: null
  delay_reason_code: null
  vendor_due_date: null
  drop_cancelled_date: null
  vendor_completed_date: null
  postal_code: null
  dpo_num: null
  owner_last_name: null
  estimated_completion_date: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata