Views [dbo].[View_Change_to_Change_WF]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created11:10:19 AM Wednesday, March 07, 2007
Last Modified9:09:08 PM Friday, December 05, 2008
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
zusmrequestid
zusmrequestitemid
zend_date
zstart_date
zTest
tenant
chgtype
sched_start_date
sched_end_date
sched_duration
actual_start_date
actual_end_date
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