USE [mdb]
GO

/****** Object:  Table [dbo].[call_req]    Script Date: 7/5/2022 7:29:10 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[call_req](
	[id] [int] NOT NULL,
	[persid] [nvarchar](30) NULL,
	[ref_num] [nvarchar](30) NOT NULL,
	[summary] [nvarchar](255) NULL,
	[description] [ntext] NULL,
	[status] [nvarchar](12) NULL,
	[active_flag] [int] NOT NULL,
	[open_date] [int] NULL,
	[time_spent_sum] [int] NULL,
	[last_mod_dt] [int] NULL,
	[last_mod_by] [binary](16) NULL,
	[close_date] [int] NULL,
	[resolve_date] [int] NULL,
	[rootcause] [int] NULL,
	[log_agent] [binary](16) NOT NULL,
	[assignee] [binary](16) NULL,
	[group_id] [binary](16) NULL,
	[customer] [binary](16) NOT NULL,
	[charge_back_id] [nvarchar](12) NULL,
	[affected_rc] [binary](16) NULL,
	[support_lev] [nvarchar](30) NULL,
	[category] [nvarchar](30) NULL,
	[solution] [nvarchar](30) NULL,
	[impact] [int] NULL,
	[priority] [int] NOT NULL,
	[urgency] [int] NULL,
	[severity] [int] NULL,
	[extern_ref] [nvarchar](30) NULL,
	[last_act_id] [nvarchar](12) NULL,
	[cr_tticket] [int] NULL,
	[parent] [nvarchar](30) NULL,
	[template_name] [nvarchar](30) NULL,
	[sla_violation] [int] NULL,
	[predicted_sla_viol] [int] NULL,
	[macro_predict_viol] [int] NULL,
	[created_via] [int] NULL,
	[call_back_date] [int] NULL,
	[call_back_flag] [int] NULL,
	[event_token] [nvarchar](80) NULL,
	[sched_token] [nvarchar](128) NULL,
	[type] [nvarchar](10) NULL,
	[string1] [nvarchar](40) NULL,
	[string2] [nvarchar](40) NULL,
	[string3] [nvarchar](40) NULL,
	[string4] [nvarchar](40) NULL,
	[string5] [nvarchar](40) NULL,
	[string6] [nvarchar](40) NULL,
	[problem] [nvarchar](30) NULL,
	[incident_priority] [int] NULL,
	[change] [int] NULL,
	[ticket_avoided] [int] NULL,
	[tenant] [binary](16) NULL,
	[cawf_procid] [nvarchar](40) NULL,
	[caused_by_chg] [int] NULL,
	[outage_start_time] [int] NULL,
	[outage_end_time] [int] NULL,
	[affected_service] [binary](16) NULL,
	[external_system_ticket] [ntext] NULL,
	[incorrectly_assigned] [int] NULL,
	[major_incident] [int] NULL,
	[orig_user_admin_org] [binary](16) NULL,
	[orig_user_cost_center] [int] NULL,
	[orig_user_dept] [int] NULL,
	[orig_user_organization] [binary](16) NULL,
	[outage_detail_what] [ntext] NULL,
	[outage_detail_who] [ntext] NULL,
	[outage_detail_why] [ntext] NULL,
	[outage_reason_desc] [ntext] NULL,
	[outage_type] [int] NULL,
	[pct_service_restored] [int] NULL,
	[remote_control_used] [int] NULL,
	[requested_by] [binary](16) NULL,
	[resolution_code] [int] NULL,
	[resolution_method] [int] NULL,
	[resolvable_at_lower] [int] NULL,
	[return_to_service] [int] NULL,
	[symptom_code] [int] NULL,
	[target_closed_count] [int] NULL,
	[target_closed_last] [int] NULL,
	[target_hold_count] [int] NULL,
	[target_hold_last] [int] NULL,
	[target_resolved_count] [int] NULL,
	[target_resolved_last] [int] NULL,
	[target_start_last] [int] NULL,
	[caextwf_instance_id] [int] NULL,
	[sap_category] [nvarchar](32) NULL,
	[sap_client] [nvarchar](3) NULL,
	[sap_component] [nvarchar](32) NULL,
	[sap_cprog] [nvarchar](24) NULL,
	[sap_dbsys] [nvarchar](12) NULL,
	[sap_frontend] [nvarchar](12) NULL,
	[sap_instance] [nvarchar](12) NULL,
	[sap_msg] [nvarchar](12) NULL,
	[sap_os] [nvarchar](32) NULL,
	[sap_priority] [int] NULL,
	[sap_sftwcomp] [nvarchar](32) NULL,
	[sap_sftwcomppatch] [nvarchar](10) NULL,
	[sap_sftwcomprel] [nvarchar](32) NULL,
	[sap_solman] [nvarchar](1) NULL,
	[sap_state] [int] NULL,
	[sap_status] [nvarchar](32) NULL,
	[sap_subject] [nvarchar](32) NULL,
	[sap_syshost] [nvarchar](64) NULL,
	[sap_sysid] [nvarchar](3) NULL,
	[sap_systyp] [nvarchar](12) NULL,
	[sap_userstatus] [nvarchar](40) NULL,
	[sap_xnum] [nvarchar](32) NULL,
	[fcr] [int] NULL,
	[zusmrequestid] [int] NULL,
	[zusmrequestitemid] [int] NULL,
	[zcategory_init] [nvarchar](30) NULL,
	[heat] [int] NULL,
	[call_back_text] [nvarchar](255) NULL,
	[reminder_duration] [int] NULL,
	[start_date] [int] NULL,
	[est_comp_date] [int] NULL,
	[actual_comp_date] [int] NULL,
	[current_wrkshft] [nvarchar](40) NULL,
 CONSTRAINT [XPKcall_req] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO