Views [dbo].[View_Change_to_Change_WF]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created10:24:47 AM Sunday, December 05, 2010
Last Modified10:24:47 AM Sunday, December 05, 2010
Columns
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
wf_id
wf_persid
del
object_type
object_id
task
wf_template
sequence
wf_status
group_task
asset
creator
date_created
wf_assignee
done_by
wf_start_date
wf_est_comp_date
est_duration
completion_date
actual_duration
wf_est_cost
cost
wf_description
wf_last_mod_dt
wf_last_mod_by
Permissions
TypeActionOwning Principal
GrantSelectservice_desk_admin_group
GrantSelectservice_desk_ro_group
SQL Script
create view  View_Change_to_Change_WF AS SELECT View_Change.*, wf.id wf_id, wf.persid wf_persid, wf.del, wf.object_type, wf.object_id, wf.task, wf.wf_template, wf.sequence, wf.status wf_status, wf.group_task, wf.asset, wf.creator, wf.date_created, wf.assignee wf_assignee, wf.done_by, wf.start_date wf_start_date, wf.est_comp_date wf_est_comp_date, wf.est_duration, wf.completion_date, wf.actual_duration, wf.est_cost wf_est_cost, wf.cost, wf.description wf_description, wf.last_mod_dt wf_last_mod_dt, wf.last_mod_by wf_last_mod_by FROM ( View_Change inner join  wf ON View_Change.id = wf.object_id)
GO
GRANT SELECT ON  [dbo].[View_Change_to_Change_WF] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[View_Change_to_Change_WF] TO [service_desk_ro_group]
GO
Uses