[dbo].[View_Change_to_Change_Act_Log] [dbo].[View_Change_to_Change_Act_Log]| Property | Value |
|---|---|
| ANSI Nulls On |  |
| Quoted Identifier On | |
| Created | 10:24:47 AM Sunday, December 05, 2010 |
| Last Modified | 10:24:47 AM Sunday, December 05, 2010 |
| Name |
|---|
| id |
| persid |
| chg_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 |
| project |
| tenant |
| chgtype |
| sched_start_date |
| sched_end_date |
| sched_duration |
| actual_start_date |
| actual_end_date |
| business_case |
| cab |
| cab_approval |
| closure_code |
| risk |
| external_system_ticket |
| orig_user_admin_org |
| orig_user_cost_center |
| orig_user_dept |
| orig_user_organization |
| requested_by |
| target_closed_count |
| target_closed_last |
| target_hold_count |
| target_hold_last |
| target_resolved_count |
| target_resolved_last |
| target_start_last |
| caextwf_instance_id |
| status_name |
| priority_num |
| category_name |
| organization_name |
| affected_end_user_lastname |
| affected_end_user_firstname |
| affected_end_user_middlename |
| requester_lastname |
| requester_firstname |
| requester_middlename |
| business |
| 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 |
| chgalg_id |
| chgalg_persid |
| change_id |
| chgalg_last_mod_dt |
| time_spent |
| time_stamp |
| system_time |
| analyst |
| chgalg_description |
| action_desc |
| type |
| internal |
| knowledge_session |
| knowledge_tool |
| chgalg_analyst_id |
| Type | Action | Owning Principal |
|---|---|---|
| Grant | Select | service_desk_admin_group |
| Grant | Select | service_desk_ro_group |