1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113
|
CREATE TABLE [dbo].[T_TICKETS](
[PERSID] [varchar](100) NULL,
[REF_NUM] [varchar](600) NULL,
[CHILD_SUM] [decimal](18, 0) NULL,
[PARENT_NUM] [varchar](100) NULL,
[Pending] [varchar](5) NULL,
[AFLAG] [decimal](18, 0) NULL,
[SHORT_DESCRIPT] [varchar](240) NULL,
[STATUS] [varchar](100) NULL,
[O_DATE] [datetime] NULL,
[C_DATE] [datetime] NULL,
[NDT] [decimal](18, 0) NULL,
[INCHANNEL] [varchar](100) NULL,
[TYP] [varchar](100) NULL,
[PRIO] [varchar](24) NULL,
[SHORT_CATEGORY] [varchar](100) NULL,
[LONG_CATEGORY] [varchar](100) NULL,
[Customer] [varchar](100) NULL,
[CUS_COSTCENTER] [varchar](100) NULL,
[CUS_ENHCONTYP] [varchar](100) NULL,
[CUS_LOCATION] [varchar](100) NULL,
[CUS_LOC_DETAIL] [varchar](240) NULL,
[CREATOR_GROUP] [varchar](100) NULL,
[CREATOR_LEVEL] [varchar](100) NULL,
[FIXED_TIME] [datetime] NULL,
[FIXED_GROUP] [varchar](200) NULL,
[FIXED_LEVEL] [varchar](100) NULL,
[OWNER_GROUP] [varchar](100) NULL,
[OWNER_LEVEL] [varchar](100) NULL,
[AKT_GROUP] [varchar](100) NULL,
[AKT_LEVEL] [varchar](100) NULL,
[FIRST_QUALIFIER] [varchar](100) NULL,
[DOWN_START] [datetime] NULL,
[DOWN_ENDE] [datetime] NULL,
[ACTION] [varchar](max) NULL,
[RISKS_AND_TEST] [varchar](100) NULL,
[FALLBACK] [varchar](100) NULL,
[AFFECTED_SERVICES] [varchar](100) NULL,
[date_CT1] [datetime] NULL,
[taux_N1] [varchar](100) NULL,
[type] [varchar](100) NULL,
[population] [varchar](100) NULL,
[durée_résolution] [float] NULL,
[time_stamp_fr] [datetime] NULL,
[groupe] [varchar](100) NULL,
[assignation_1H] [bit] NULL,
[durée_résolution_HPC] [float] NULL,
[sla_ok] [int] NULL,
[time_stamp] [int] NULL,
[VIP] [varchar](100) NULL,
[sousgroupe] [varchar](200) NULL,
[quantity] [int] NULL,
[poids_IMAC] [float] NULL,
[code_ATF] [varchar](100) NULL,
[type_IMAC] [varchar](100) NULL,
[code_IMAC] [varchar](100) NULL,
[dossier_unitaire] [int] NULL,
[sla_3J] [int] NULL,
[sla_5J] [int] NULL,
[sla_10J] [int] NULL,
[created_by] [varchar](100) NULL,
[last_name] [varchar](100) NULL,
[first_name] [varchar](100) NULL,
[email_address] [varchar](100) NULL,
[alt_phone_number] [varchar](100) NULL,
[userid] [varchar](100) NULL,
[fixed_by] [varchar](100) NULL,
[date_log] [datetime] NULL,
[zapprover_group] [varchar](200) NULL,
[groupe_départ] [varchar](200) NULL,
[groupe_arrivée] [varchar](200) NULL,
[extern_ref] [varchar](100) NULL,
[assignee] [varchar](100) NULL,
[org_name] [varchar](100) NULL,
[callback] [datetime] NULL,
[solution] [varchar](200) NULL,
[z_iman_jobtrans] [varchar](100) NULL,
[type_sla] [int] NULL,
[BaseSLA3] [int] NULL,
[BaseSLA5] [int] NULL,
[BaseSLA10] [int] NULL,
[Date_qualite] [datetime] NULL,
[Now] [datetime] NULL,
[z_iman_abend_code] [varchar](100) NULL,
[description] [varchar](255) NULL,
[comment1_value] [varchar](max) NULL,
[comment1_date] [datetime] NULL,
[comment2_value] [varchar](max) NULL,
[comment2_date] [datetime] NULL,
[durée_résolution_brute] [int] NULL,
[nbroutages] [int] NULL,
[first_assignment_group] [varchar](150) NULL,
[first_assignment_date] [datetime] NULL,
[nb_log_comment] [int] NULL,
[Nombres] [varchar](100) NULL,
[sous_population] [varchar](100) NULL,
[TYPESTATUS] [varchar](100) NULL,
[Last_Date] [datetime] NULL,
[First_Date] [datetime] NULL,
[X1] [float] NULL,
[X2] [float] NULL,
[X3] [float] NULL,
[X4] [float] NULL,
[X5] [float] NULL,
[X6] [float] NULL,
[X7] [float] NULL,
[X8] [float] NULL,
[O1] [float] NULL,
[LAST_MOD_BY] [varchar](100) NULL
) ON [PRIMARY]
GO |
Partager