[dbo].[ci_twa

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	1
Created	8:40:29 PM Wednesday, August 12, 2009
Last Modified	4:36:01 PM Wednesday, March 24, 2010

Name	Data Type	Max Length (Bytes)
id	int	4
del	int	4
tenant	binary(16)	16
last_mod_by	nvarchar(64)	128
last_mod_dt	int	4
tran_message	nvarchar(240)	480
tran_status	int	4
tran_apply_after_dt	int	4
tran_dt	int	4
tran_chg_ref_num	nvarchar(30)	60
tgt_id	binary(16)	16
tgt_delete_flag	nvarchar(20)	40
tgt_tenant	nvarchar(287)	574
acquire_date	nvarchar(70)	140
active	nvarchar(12)	24
active_date	nvarchar(70)	140
addr_class	nvarchar(50)	100
alarm_id	nvarchar(64)	128
alignment	nvarchar(12)	24
app_id	nvarchar(50)	100
appl	nvarchar(50)	100
array_name	nvarchar(50)	100
array_serial_num	nvarchar(50)	100
asset_count	nvarchar(12)	24
asset_num	nvarchar(64)	128
avail	nvarchar(50)	100
availability_end	nvarchar(70)	140
availability_start	nvarchar(70)	140
bandwidth	nvarchar(15)	30
base_contact	nvarchar(132)	264
base_location	nvarchar(132)	264
base_organization	nvarchar(132)	264
bios_ver	nvarchar(50)	100
bm_label	nvarchar(255)	510
bm_rep	nvarchar(100)	200
bm_status	nvarchar(100)	200
business_contacts	nvarchar(300)	600
business_impact	nvarchar(30)	60
business_owner	nvarchar(300)	600
business_priority	nvarchar(30)	60
business_risk	nvarchar(30)	60
business_unit	nvarchar(300)	600
cancel_date	nvarchar(70)	140
carrier	nvarchar(15)	30
category	nvarchar(50)	100
cd_rom_type	nvarchar(255)	510
channel_address	nvarchar(15)	30
charge_code	nvarchar(100)	200
ci_license_number	nvarchar(50)	100
ci_priority	nvarchar(12)	24
SLA	nvarchar(300)	600
circuit_number	nvarchar(15)	30
circuit_type	nvarchar(15)	30
class	nvarchar(132)	264
cobit_objective	nvarchar(300)	600
company_bought_for_uuid	nvarchar(132)	264
con_comments	nvarchar(200)	400
con_end_date	nvarchar(70)	140
con_num	nvarchar(50)	100
con_ref	nvarchar(50)	100
con_renewal_date	nvarchar(70)	140
con_start_date	nvarchar(70)	140
con_status	nvarchar(100)	200
con_type	nvarchar(50)	100
confidentiality_level	nvarchar(50)	100
contact_1	nvarchar(132)	264
contact_2	nvarchar(132)	264
contact_3	nvarchar(132)	264
contract_number	nvarchar(50)	100
cpu_shares	nvarchar(15)	30
cpu_type	nvarchar(50)	100
creation_date	nvarchar(70)	140
creation_user	nvarchar(64)	128
currency	nvarchar(3)	6
current_memory	nvarchar(15)	30
current_processors	nvarchar(15)	30
date_installed	nvarchar(70)	140
db_id	nvarchar(50)	100
delete_time	nvarchar(70)	140
department	nvarchar(132)	264
dependencies	nvarchar(2000)	4000
description	nvarchar(255)	510
design_end_date	nvarchar(70)	140
design_start_date	nvarchar(70)	140
desired_memory	nvarchar(15)	30
desired_processors	nvarchar(12)	24
disk_type	nvarchar(255)	510
dns_name	nvarchar(100)	200
doc_category	nvarchar(50)	100
doc_end_date	nvarchar(70)	140
doc_id	nvarchar(50)	100
doc_start_date	nvarchar(70)	140
doc_status	nvarchar(100)	200
doc_type	nvarchar(50)	100
doc_version	nvarchar(15)	30
domain	nvarchar(50)	100
environment	nvarchar(255)	510
escalation_contacts	nvarchar(300)	600
est_finish_date	nvarchar(70)	140
est_start_date	nvarchar(70)	140
exclude_registration	nvarchar(12)	24
existing_initiative_impact	nvarchar(2000)	4000
expense_code	nvarchar(132)	264
expiration_date	nvarchar(70)	140
family	nvarchar(132)	264
federated_asset_id	nvarchar(255)	510
financial_num	nvarchar(40)	80
finish_date	nvarchar(70)	140
flow	nvarchar(50)	100
frequency	nvarchar(15)	30
gateway_id	nvarchar(50)	100
general_notes	nvarchar(2000)	4000
goal	nvarchar(2000)	4000
graphics_card	nvarchar(50)	100
hard_drive_capacity	nvarchar(15)	30
harddrive_capacity	nvarchar(15)	30
harddrive_used	nvarchar(15)	30
highavail_appl_resources	nvarchar(255)	510
highly_avail	nvarchar(50)	100
idea_priority	nvarchar(30)	60
inhouse_or_vendor	nvarchar(15)	30
install_date	nvarchar(70)	140
install_dir	nvarchar(255)	510
integrity_level	nvarchar(50)	100
investment_priority	nvarchar(12)	24
investment_status	nvarchar(240)	480
ip_mgmt_addr	nvarchar(50)	100
is_asset	nvarchar(100)	200
is_ci	nvarchar(100)	200
last_mtce_date	nvarchar(70)	140
lease_cost_per_month	nvarchar(15)	30
lease_effective_date	nvarchar(70)	140
lease_end_date	nvarchar(70)	140
lease_renewal_date	nvarchar(70)	140
lease_start_date	nvarchar(70)	140
lease_termination_date	nvarchar(70)	140
leased_or_owned_status	nvarchar(255)	510
license_expiration_date	nvarchar(70)	140
license_number	nvarchar(32)	64
lifecycle_state	nvarchar(50)	100
lifecycle_status	nvarchar(50)	100
line_id	nvarchar(15)	30
line_speed	nvarchar(15)	30
line_type	nvarchar(15)	30
loc_cabinet	nvarchar(30)	60
loc_floor	nvarchar(30)	60
loc_room	nvarchar(30)	60
loc_shelf	nvarchar(30)	60
loc_slot	nvarchar(30)	60
location	nvarchar(132)	264
mac_address	nvarchar(64)	128
main_extension	nvarchar(50)	100
main_process	nvarchar(255)	510
maintenance_fee	nvarchar(12)	24
maintenance_period	nvarchar(50)	100
manager	nvarchar(2000)	4000
manufacturer	nvarchar(132)	264
max_memory	nvarchar(15)	30
max_processors	nvarchar(12)	24
mdr_class	nvarchar(50)	100
mdr_name	nvarchar(50)	100
media_drive_num	nvarchar(15)	30
media_type	nvarchar(255)	510
mem_cache_proc	nvarchar(15)	30
mem_capacity	nvarchar(15)	30
memory_available	nvarchar(15)	30
memory_shares	nvarchar(15)	30
memory_used	nvarchar(15)	30
min_memory	nvarchar(15)	30
min_processors	nvarchar(12)	24
model	nvarchar(132)	264
modem_card	nvarchar(15)	30
modem_type	nvarchar(15)	30
monitor	nvarchar(255)	510
mtce_contract_number	nvarchar(50)	100
mtce_level	nvarchar(50)	100
mtce_type	nvarchar(50)	100
name	nvarchar(100)	200
name_type	nvarchar(12)	24
net_card	nvarchar(255)	510
network_address	nvarchar(50)	100
network_name	nvarchar(50)	100
nic_card	nvarchar(15)	30
nsm_id	nvarchar(40)	80
num_mips	nvarchar(15)	30
number_mips	nvarchar(15)	30
number_net_card	nvarchar(15)	30
number_net_port	nvarchar(15)	30
number_net_port_conn	nvarchar(15)	30
number_ports	nvarchar(12)	24
number_ports_used	nvarchar(12)	24
number_proc_inst	nvarchar(12)	24
number_slot_proc	nvarchar(12)	24
number_smips	nvarchar(15)	30
operation_end_date	nvarchar(70)	140
operation_start_date	nvarchar(70)	140
org_bought_for_uuid	nvarchar(132)	264
os_id	nvarchar(50)	100
os_version	nvarchar(15)	30
owner	nvarchar(2000)	4000
panel_display	nvarchar(15)	30
phone_number	nvarchar(50)	100
phys_mem	nvarchar(15)	30
portfolio	nvarchar(50)	100
printer	nvarchar(255)	510
priority	nvarchar(100)	200
proc_spd	nvarchar(15)	30
proc_speed	nvarchar(15)	30
proc_type	nvarchar(255)	510
processor_affinity	nvarchar(15)	30
processor_count	nvarchar(12)	24
product_version	nvarchar(16)	32
profile	nvarchar(15)	30
progress	nvarchar(50)	100
proj_code	nvarchar(50)	100
project_priority	nvarchar(12)	24
project_status	nvarchar(240)	480
protocol	nvarchar(15)	30
purchase_amount	nvarchar(12)	24
purchase_amountc	nvarchar(30)	60
quorum	nvarchar(15)	30
repair_org	nvarchar(132)	264
resource_alias	nvarchar(30)	60
resource_contact	nvarchar(132)	264
resource_disk	nvarchar(15)	30
resource_file	nvarchar(15)	30
resource_group_type	nvarchar(15)	30
resource_mount_point	nvarchar(50)	100
resource_owner_uuid	nvarchar(132)	264
resource_type	nvarchar(15)	30
response_time	nvarchar(12)	24
retire_date	nvarchar(70)	140
risk	nvarchar(30)	60
risks	nvarchar(2000)	4000
role	nvarchar(255)	510
rout_prot	nvarchar(50)	100
scsi_card	nvarchar(50)	100
security_id	nvarchar(50)	100
security_patch_level	nvarchar(50)	100
serial_number	nvarchar(64)	128
server	nvarchar(255)	510
server_id	nvarchar(50)	100
server_type	nvarchar(255)	510
service_alignment	nvarchar(50)	100
service_goal	nvarchar(300)	600
service_hours	nvarchar(100)	200
service_manager	nvarchar(300)	600
service_org	nvarchar(132)	264
service_type	nvarchar(100)	200
site	nvarchar(50)	100
sla_category	nvarchar(50)	100
sla_date_active	nvarchar(70)	140
sla_end_date	nvarchar(70)	140
sla_id	nvarchar(50)	100
sla_start_date	nvarchar(70)	140
sla_type	nvarchar(50)	100
sla_version	nvarchar(15)	30
slot_mem_used	nvarchar(15)	30
slot_total_mem	nvarchar(15)	30
smag_1	nvarchar(40)	80
smag_2	nvarchar(40)	80
smag_3	nvarchar(40)	80
smag_4	nvarchar(40)	80
smag_5	nvarchar(40)	80
smag_6	nvarchar(40)	80
stage	nvarchar(2000)	4000
standard_ci	nvarchar(287)	574
start_date	nvarchar(70)	140
status	nvarchar(132)	264
status_comment	nvarchar(2000)	4000
status_indicator	nvarchar(20)	40
storage_used	nvarchar(15)	30
subject	nvarchar(300)	600
subnet_mask	nvarchar(50)	100
supervision_mode	nvarchar(255)	510
supplier	nvarchar(132)	264
support_end_date	nvarchar(70)	140
support_start_date	nvarchar(70)	140
support_type	nvarchar(255)	510
svclvl	nvarchar(50)	100
swap_size	nvarchar(15)	30
system_name	nvarchar(255)	510
target_manager	nvarchar(2000)	4000
technology	nvarchar(255)	510
total_capacity	nvarchar(15)	30
total_cost	nvarchar(30)	60
total_effort	nvarchar(30)	60
transaction_alignment	nvarchar(50)	100
transaction_goal	nvarchar(300)	600
transaction_manager	nvarchar(300)	600
transition_end_date	nvarchar(70)	140
transition_start_date	nvarchar(70)	140
type	nvarchar(50)	100
type_net_conn	nvarchar(255)	510
ufam	nvarchar(10)	20
unavailability_end	nvarchar(70)	140
unavailability_start	nvarchar(70)	140
uptime	nvarchar(12)	24
used_space	nvarchar(15)	30
vendor_repair	nvarchar(132)	264
vendor_restore	nvarchar(132)	264
version	nvarchar(255)	510
virtual_ip	nvarchar(15)	30
virtual_processors	nvarchar(12)	24
warehouse_loc	nvarchar(50)	100
warranty_end	nvarchar(70)	140
warranty_start	nvarchar(70)	140
service_id	nvarchar(50)	100
end_date	nvarchar(70)	140
milestone	nvarchar(255)	510
not_ambiguous	nvarchar(20)	40
superseded_by	binary(16)	16
billing_contact_uuid	nvarchar(132)	264
support_contact1_uuid	nvarchar(132)	264
support_contact2_uuid	nvarchar(132)	264
support_contact3_uuid	nvarchar(132)	264
disaster_recovery_contact_uuid	nvarchar(132)	264
backup_services_contact_uuid	nvarchar(132)	264
network_contact_uuid	nvarchar(132)	264

	Name	Columns	Unique
	XPKCI_TWA_CI	id
	CI_TWA_CI_IDX_01	name
	CI_TWA_CI_IDX_02	tgt_id

Name	ANSI Nulls On	Quoted Identifier On	On
tgr_insert_for_ci_twa_ci			After Insert

Type	Action	Owning Principal
Grant	Delete	service_desk_admin_group
Grant	Insert	service_desk_admin_group
Grant	Select	service_desk_admin_group
Grant	Update	service_desk_admin_group
Grant	Select	service_desk_ro_group

Name	Value
Comment	This is a new table for CMDB PES.

SQL Script

CREATE TABLE [dbo].[ci_twa_ci]
(
[id] [int] NOT NULL,
[del] [int] NULL,
[tenant] [binary] (16) NULL,
[last_mod_by] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_mod_dt] [int] NULL,
[tran_message] [nvarchar] (240) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[tran_status] [int] NULL,
[tran_apply_after_dt] [int] NULL,
[tran_dt] [int] NULL,
[tran_chg_ref_num] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[tgt_id] [binary] (16) NULL,
[tgt_delete_flag] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[tgt_tenant] [nvarchar] (287) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[acquire_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[active] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[active_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[addr_class] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[alarm_id] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[alignment] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[app_id] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[appl] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[array_name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[array_serial_num] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[asset_count] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[asset_num] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[avail] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[availability_end] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[availability_start] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[bandwidth] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[base_contact] [nvarchar] (132) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[base_location] [nvarchar] (132) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[base_organization] [nvarchar] (132) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[bios_ver] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[bm_label] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[bm_rep] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[bm_status] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[business_contacts] [nvarchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[business_impact] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[business_owner] [nvarchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[business_priority] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[business_risk] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[business_unit] [nvarchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[cancel_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[carrier] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[category] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[cd_rom_type] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[channel_address] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[charge_code] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ci_license_number] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ci_priority] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SLA] [nvarchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[circuit_number] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[circuit_type] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[class] [nvarchar] (132) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[cobit_objective] [nvarchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[company_bought_for_uuid] [nvarchar] (132) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[con_comments] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[con_end_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[con_num] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[con_ref] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[con_renewal_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[con_start_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[con_status] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[con_type] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[confidentiality_level] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[contact_1] [nvarchar] (132) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[contact_2] [nvarchar] (132) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[contact_3] [nvarchar] (132) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[contract_number] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[cpu_shares] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[cpu_type] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[currency] [nvarchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[current_memory] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[current_processors] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[date_installed] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[db_id] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[delete_time] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[department] [nvarchar] (132) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[dependencies] [nvarchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[description] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[design_end_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[design_start_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[desired_memory] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[desired_processors] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[disk_type] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[dns_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[doc_category] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[doc_end_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[doc_id] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[doc_start_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[doc_status] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[doc_type] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[doc_version] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[domain] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[environment] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[escalation_contacts] [nvarchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[est_finish_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[est_start_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[exclude_registration] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[existing_initiative_impact] [nvarchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[expense_code] [nvarchar] (132) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[expiration_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[family] [nvarchar] (132) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[federated_asset_id] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[financial_num] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[finish_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[flow] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[frequency] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[gateway_id] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[general_notes] [nvarchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[goal] [nvarchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[graphics_card] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hard_drive_capacity] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[harddrive_capacity] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[harddrive_used] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[highavail_appl_resources] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[highly_avail] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[idea_priority] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[inhouse_or_vendor] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[install_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[install_dir] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[integrity_level] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[investment_priority] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[investment_status] [nvarchar] (240) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ip_mgmt_addr] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[is_asset] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[is_ci] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_mtce_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[lease_cost_per_month] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[lease_effective_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[lease_end_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[lease_renewal_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[lease_start_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[lease_termination_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[leased_or_owned_status] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[license_expiration_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[license_number] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[lifecycle_state] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[lifecycle_status] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[line_id] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[line_speed] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[line_type] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[loc_cabinet] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[loc_floor] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[loc_room] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[loc_shelf] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[loc_slot] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[location] [nvarchar] (132) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[mac_address] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[main_extension] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[main_process] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[maintenance_fee] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[maintenance_period] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[manager] [nvarchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[manufacturer] [nvarchar] (132) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[max_memory] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[max_processors] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[mdr_class] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[mdr_name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[media_drive_num] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[media_type] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[mem_cache_proc] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[mem_capacity] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[memory_available] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[memory_shares] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[memory_used] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[min_memory] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[min_processors] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[model] [nvarchar] (132) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[modem_card] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[modem_type] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[monitor] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[mtce_contract_number] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[mtce_level] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[mtce_type] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[name_type] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[net_card] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[network_address] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[network_name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[nic_card] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[nsm_id] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[num_mips] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[number_mips] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[number_net_card] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[number_net_port] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[number_net_port_conn] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[number_ports] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[number_ports_used] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[number_proc_inst] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[number_slot_proc] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[number_smips] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[operation_end_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[operation_start_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[org_bought_for_uuid] [nvarchar] (132) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[os_id] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[os_version] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[owner] [nvarchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[panel_display] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[phone_number] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[phys_mem] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[portfolio] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[printer] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[priority] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[proc_spd] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[proc_speed] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[proc_type] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[processor_affinity] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[processor_count] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[product_version] [nvarchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[profile] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[progress] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[proj_code] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[project_priority] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[project_status] [nvarchar] (240) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[protocol] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[purchase_amount] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[purchase_amountc] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[quorum] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[repair_org] [nvarchar] (132) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[resource_alias] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[resource_contact] [nvarchar] (132) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[resource_disk] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[resource_file] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[resource_group_type] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[resource_mount_point] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[resource_owner_uuid] [nvarchar] (132) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[resource_type] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[response_time] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[retire_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[risk] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[risks] [nvarchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[role] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[rout_prot] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[scsi_card] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[security_id] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[security_patch_level] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[serial_number] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[server] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[server_id] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[server_type] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[service_alignment] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[service_goal] [nvarchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[service_hours] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[service_manager] [nvarchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[service_org] [nvarchar] (132) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[service_type] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[site] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sla_category] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sla_date_active] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sla_end_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sla_id] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sla_start_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sla_type] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sla_version] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[slot_mem_used] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[slot_total_mem] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[smag_1] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[smag_2] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[smag_3] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[smag_4] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[smag_5] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[smag_6] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[stage] [nvarchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[standard_ci] [nvarchar] (287) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[start_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[status] [nvarchar] (132) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[status_comment] [nvarchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[status_indicator] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[storage_used] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[subject] [nvarchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[subnet_mask] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[supervision_mode] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[supplier] [nvarchar] (132) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[support_end_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[support_start_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[support_type] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[svclvl] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[swap_size] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[system_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[target_manager] [nvarchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[technology] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[total_capacity] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[total_cost] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[total_effort] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[transaction_alignment] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[transaction_goal] [nvarchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[transaction_manager] [nvarchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[transition_end_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[transition_start_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[type] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[type_net_conn] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ufam] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[unavailability_end] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[unavailability_start] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[uptime] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[used_space] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[vendor_repair] [nvarchar] (132) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[vendor_restore] [nvarchar] (132) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[version] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[virtual_ip] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[virtual_processors] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[warehouse_loc] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[warranty_end] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[warranty_start] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[service_id] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[end_date] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[milestone] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[not_ambiguous] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[superseded_by] [binary] (16) NULL,
[billing_contact_uuid] [nvarchar] (132) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[support_contact1_uuid] [nvarchar] (132) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[support_contact2_uuid ] [nvarchar] (132) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[support_contact3_uuid ] [nvarchar] (132) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[disaster_recovery_contact_uuid] [nvarchar] (132) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[backup_services_contact_uuid] [nvarchar] (132) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[network_contact_uuid] [nvarchar] (132) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
/**********************************************************************************************************/
    /*************Affected Table   : ci_twa_ci                                                               **/
    /*************Affected Columns : tran_dt, last_mod_dt, id, creation_date, del, tran_status**/
    /**********************************************************************************************************/

    /*NOTE : If any changes are made to this trigger then make sure to change trigger tgr_insert_for_ci_twa_relation, because the logic is same expect the table names referred here*/

CREATE TRIGGER tgr_insert_for_ci_twa_ci ON ci_twa_ci
FOR INSERT
AS
     DECLARE      @computed_id      integer;
     DECLARE      @max_limit        integer;
     DECLARE      @number_of_rows   integer;
     DECLARE      @epoch_date       datetime;
     DECLARE      @ERROR_STRING     nvarchar;

     DECLARE      @tran_dt             integer;
     DECLARE      @last_mod_dt         integer;
     DECLARE      @id                  integer;
     DECLARE      @creation_date       integer;
     DECLARE      @del                 integer;
     DECLARE      @tran_status         integer;

BEGIN
     DECLARE datacursor CURSOR for select id,del,tran_dt,tran_status,last_mod_dt from INSERTED;

     SET @max_limit  =  1999999999;
     SET @epoch_date =  '19700101';

     OPEN datacursor;
     FETCH NEXT FROM datacursor INTO @id,@del,@tran_dt,@tran_status,@last_mod_dt;

     WHILE @@FETCH_STATUS = 0
     BEGIN
        if(@id = 0)
        BEGIN
           select @number_of_rows=count(id) from ci_twa_ci where (id between 0 and @max_limit);
           if(@number_of_rows = 0)
           BEGIN
             set @computed_id = 1;
           END
           ELSE
           BEGIN
                select @computed_id = max(id) from ci_twa_ci where (id between 0 and @max_limit);
                if(@computed_id = @max_limit) -- Max. limit has been exceeded
                BEGIN
                        --set @ERROR_STRING = 'The limit exceeds max. limit , contact db administrator for details!';
                        RAISERROR ('CMDB_DBMS_TRIGGER2000:ERROR TABLE (ci_twa_ci table) id > %i', 15, -1,@max_limit) WITH NOWAIT;
                        ROLLBACK TRAN;
                        RETURN;
                END
                set @computed_id = @computed_id + 1;
           END
        END
        ELSE
        BEGIN
           set @computed_id = @id;
        END

        set @creation_date = DATEDIFF(s, @epoch_date, GETDATE());  -- Creation date should always be equal to current datetime, ignore what is supplied by the application

        IF(@tran_dt is null)   --If the user doesn't supply this, then populate with the current date and time
        BEGIN
           set @tran_dt = @creation_date;
        END

        IF(@last_mod_dt is null)   --If the user doesn't supply this, then populate with the current date and time
        BEGIN
           set @last_mod_dt = @creation_date;
        END

        IF(@del is null)
        BEGIN
           set @del = 0;
        END

        IF(@tran_status is null)
        BEGIN
           set @tran_status = 0;
        END

        BEGIN TRY

           BEGIN TRANSACTION
              UPDATE ci_twa_ci SET creation_date = @creation_date, tran_dt = @tran_dt,del = @del, id = @computed_id,
              tran_status = @tran_status, last_mod_dt = @last_mod_dt WHERE id=@id;
           COMMIT TRANSACTION

        END TRY

        BEGIN CATCH
            IF @@TRANCOUNT > 0 --some error has occurred
                ROLLBACK TRAN; --so rollback all transactions
            RAISERROR ('CMDB_DBMS_TRIGGER2001:ERROR TABLE (ci_twa_ci table) update failed  - could not populate default values', 15, -1) WITH NOWAIT;
            BREAK;
        END CATCH
        FETCH NEXT FROM datacursor INTO @id,@del,@tran_dt,@tran_status,@last_mod_dt;
     END
     CLOSE datacursor
     DEALLOCATE datacursor
  END
GO
ALTER TABLE [dbo].[ci_twa_ci] ADD CONSTRAINT [XPKCI_TWA_CI] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [CI_TWA_CI_IDX_01] ON [dbo].[ci_twa_ci] ([name]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [CI_TWA_CI_IDX_02] ON [dbo].[ci_twa_ci] ([tgt_id]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ci_twa_ci] TO [service_desk_admin_group]
GRANT INSERT ON  [dbo].[ci_twa_ci] TO [service_desk_admin_group]
GRANT DELETE ON  [dbo].[ci_twa_ci] TO [service_desk_admin_group]
GRANT UPDATE ON  [dbo].[ci_twa_ci] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[ci_twa_ci] TO [service_desk_ro_group]
GO
EXEC sp_addextendedproperty N'Comment', N'This is a new table for CMDB PES.', 'SCHEMA', N'dbo', 'TABLE', N'ci_twa_ci', NULL, NULL
GO