[dbo].[View_Issue_to_Properties] [dbo].[View_Issue_to_Properties]| Property | Value |
|---|---|
| ANSI Nulls On |  |
| Quoted Identifier On | |
| Created | 11:10:19 AM Wednesday, March 07, 2007 |
| Last Modified | 9:09:09 PM Friday, December 05, 2008 |
| Name |
|---|
| id |
| persid |
| ref_num |
| summary |
| description |
| status |
| active_flag |
| start_date |
| open_date |
| last_mod_dt |
| last_mod_by |
| close_date |
| resolve_date |
| rootcause |
| est_total_time |
| actual_total_time |
| log_agent |
| assignee |
| organization |
| group_id |
| affected_contact |
| requestor |
| category |
| priority |
| need_by |
| est_comp_date |
| actual_comp_date |
| est_cost |
| actual_cost |
| justification |
| backout_plan |
| impact |
| parent |
| effort |
| support_lev |
| template_name |
| sla_violation |
| predicted_sla_viol |
| macro_predict_viol |
| created_via |
| call_back_date |
| call_back_flag |
| string1 |
| string2 |
| string3 |
| string4 |
| string5 |
| string6 |
| service_date |
| service_num |
| product |
| actions |
| type_of_contact |
| reporting_method |
| person_contacting |
| flag1 |
| flag2 |
| flag3 |
| flag4 |
| flag5 |
| flag6 |
| user1 |
| user2 |
| user3 |
| cawf_procid |
| ticket_avoided |
| tenant |
| status_name |
| priority_num |
| category_name |
| organization_name |
| affected_end_user_lastname |
| affected_end_user_firstname |
| affected_end_user_middlename |
| assignee_lastname |
| assignee_firstname |
| assignee_middlename |
| groupID |
| group_name |
| service_type |
| impact_num |
| product_sym |
| type_of_contact_sym |
| rpting_method_sym |
| person_contacting_sym |
| created_via_sym |
| rootcause_sym |
| prp_id |
| prp_persid |
| sequence |
| prp_description |
| label |
| value |
| required |
| sample |
| owning_iss |
| prp_last_mod_dt |
| prp_last_mod_by |
| Type | Action | Owning Principal |
|---|---|---|
| Grant | Select | service_desk_admin_group |
| Grant | Select | service_desk_ro_group |