Incident Record Classifications

Incident Type Classification

These Definitions are held in Data Table ltbEventType. Note that there is an 'Unspecified' entry.

The entry is held on target records in [tblIncidents] IREventType.

Full Classification List

TypeId	Prefix	Caption
17	Aone+VEH	A-one+ Vehicle Damage
2	CLQ	Client Enquiry
19	COM	Compliment
4	CUC	Customer Complaint
3	CUQ	Customer Enquiry
7	HAIL	HAIL Notice
1	INT	Internal Raised
8	LAQ	Local Authority Enquiry
11	MNQ	Ministerial Enquiry
10	MPQ	Member Parliament Enquiry
15	NMS	Near Miss
18	OBS	Observations
6	ORI	ORI Notice
5	PLN	Planning Enquiry
16	SHE	SHE + Personal Incident
9	SVQ	Services Enquiry (Police/Fire)
0	UNS	Unspecified
12	UTQ	Utilities Enquiry
14	WID	Watchman Idea
13	WOB	Watchman Observation

Data Control and Flow

Set Default Class

Each of the Event Type Class may be used to seed the Event Class in the following Pull-down control on the Add Incident Panel. [Limited use of this is made].

This is controlled through references in table fields: EventTypeDefaultClass, and EventTypeDefaultClassId.

Set Follow-on Action

Each of the Event Type Class may be used to seed the Follow-on Action for the first Action Record saved as part of the Add Incident Panel. [No use of this is made].

This is controlled through references in table fields: EventTypeDefFollowAction.

Set Action Officer

Each of the Event Type Class may be used to seed the Action Officer later on the Add Incident Panel. [No use of this is made].

This is controlled through references in table fields: EventTypeDefActionOfficer.

Set Default Filing Reference

Each of the Event Type Class may be used to seed the Filing Reference later on the Add Incident Panel. [No use of this is made].

This is controlled through references in table fields: EventTypeDefFilingRef.

Set KPI Target Completion Dates

Each of the Event Type Class may be used to set the KPI Target Completion Date for the entered Incident Record. [Use of this is made for Customer Enquiry class records].

This is controlled through references in table fields: EventTypeKPIAction, EventTypeKPIActionAdd. Entries of 'W+' and '2' set a target date two weeks hence, 'D+' and '1' is one day hence (24 Hours).

Incident Class Classification

Overview

These Definitions are held in Data Table ltbEventClass.

The entry is held on target records in [tblIncidents] IREventClass.

The display list is determined by the Primary Source for the parent Incident Record. The values held against the data fields EventClassPS1 [for Incidents], EventClassPS2 [for Customer Enquiries], EventClassPS3 [for Post Log] are used to determine the display options:

2 - Common entries - Displayed under class 'C'

1 - Basic Entries - Displayed under class 'B' and 'C'

0 - All Entry - Displayed under class 'A', 'B' and 'C'

-1 - Not applicable to Primary Source

Full List Classification List

ClassId	Prefix	Caption	EventClassPS1	EventClassPS2	EventClassPS3
2	ABL	Abnormal Loads	0	0	0
1	ABV	Abandoned Vehicles	2	0	1
3	ACC	Access Alterations	0	-1	0
4	ADH	Adopted Highways	0	-1	0
117	AIR	Accident/Incident Reporting	-1	2	0
5	AND	Advanced Notice	0	-1	0
6	ARB	Arboriculture	0	2	0
8	BDV	Broken Down Vehicle	2	-1	1
7	BOL	Bollards	1	1	0
9	BUS	Buses	0	-1	0
139	CCL	Compensation Claims	0	0	0
105	CCO	Customer Compliment	0	-1	2
104	CCP	Customer Complaint	0	-1	2
17	CDL	Current Delays	0	0	1
108	CEQ	Customer Enquiry	0	-1	2
11	CHW	Condition of Highway	0	1	1
10	CLO	Closures	1	1	1
13	COH	Construction over the Highway	0	-1	0
96	COM	COMMS	1	-1	0
14	CON	Consultations/Letterdrops	0	-1	0
15	CRA	Crane Licences	0	-1	0
16	CRO	Crossings	0	-1	0
24	DAN	Dangerous Land Adjoining Street	0	-1	0
18	DBF	Damage to Boundary Fences	2	1	0
25	DEA	Dead Animals	2	0	1
26	DEB	Debris	2	1	1
27	DEL	Delays	0	2	1
28	DEV	Development	0	-1	0
23	DFC	Danger to Forecourts	0	-1	0
19	DFW	Damage to Footway	1	1	0
95	DRA	Drainage Systems	2	-1	0
20	DRW	Damage to Retaining Walls	2	-1	0
21	DSF	Damage to Safety Fencing/Barriers	2	0	0
22	DST	Damage to Structures	2	0	0
29	DST	Dust	0	0	0
97	EAR	Earthworks	0	-1	0
30	ELC	Electrical Failure	1	2	0
148	ERT	Emergency Roadside Telephones	0	0	0
31	FIR	Fire Related Issues	1	-1	0
32	FLO	Flooding	2	1	1
33	FLY	Fly Tipping	1	1	1
150	GCL	Green Claims	0	0	0
35	GEN	General	0	2	1
36	GRA	Graffiti	2	2	1
37	GRI	Grit Bins	0	0	0
68	GUL	Road Gully Maintenance	2	-1	0
147	HAT	HATO's	0	0	0
38	HGR	Highway Gritting	1	0	1
39	HOA	Hoardings	1	-1	0
40	HOR	Horticultural	1	2	0
124	HSP	High Speed Police Pursuit	1	0	0
42	IBO	Illuminated Bollard	2	0	0
41	ICE	Ice/Snow	1	0	0
130	IPH	Improve Personnel Health & Safety	0	0	0
45	IRN	Ironwork	0	-1	0
129	IRS	Improve Road Safety	0	0	0
43	ISG	Illuminated Signs	2	0	0
44	ISO	Information Systems Other	0	-1	0
67	ISS	Related Issues	0	-1	0
100	KER	Road Kerbs	1	-1	1
46	LCE	Lamp Column Emergency	2	0	0
47	LCO	Lamp Column Outage	1	0	0
52	LIA	Live Animals	2	-1	1
49	LIC	Licencing of Amenities	0	-1	0
99	LIG	Lighting (General)	1	2	1
50	LIN	Lining & Studs	0	-1	0
51	LIT	Litter	0	2	1
48	LNO	Land Issues Other	0	1	0
101	MAN	Manhole Covers	1	2	0
106	MCM	Ministerial Commitment	0	-1	2
107	MCR	Ministerial Correspondence	0	-1	2
53	MUD	Mud	1	-1	1
54	NAV	Navigation Sytems	0	-1	0
56	NON	Non Motorist	0	-1	0
143	NPL	New Planting	0	0	0
57	NRS	NRSWA	0	1	0
146	NTC	NTCC	0	0	0
55	NVW	No Visible Works	0	0	0
138	OEN	Ownership Query	0	0	0
109	OEQ	Other Enquiry	1	1	0
64	PBU	Public Utilities	0	0	0
61	PDL	Potential Delays	0	1	0
142	PDR	Pollution: Drainage	0	0	0
59	PED	Pedestrians on Carriageway	1	-1	0
137	PEN	Purchasing Query	0	0	0
58	PKG	Parking	0	-1	1
103	PLN	Planning Application	0	0	2
62	POT	Pothole in Highway	2	1	1
63	PRJ	Projections from Buildings	0	-1	0
134	PRO	Procurement	0	0	0
60	PSG	Poor Sign Information	0	0	0
102	PUD	Public Utility Defect	0	-1	0
65	QLT	Quality of Lighting	0	-1	1
140	RAG	Ragwort etc.	0	0	0
66	RAI	Rail	0	-1	0
144	RCC	Regional Control Centre	0	0	0
128	RDC	Road Closures	0	0	0
127	RDL	Road Layouts	0	0	0
132	RDM	Road Markings	0	0	0
145	REC	Recruitment	0	0	0
111	RED	Red Claim	-1	1	0
113	RFI	Request for Information	-1	2	0
133	RFI	Request for Information	0	0	0
135	RFS	Request For Sign (tourist, other)	0	0	0
112	RLT	Road Layout	-1	1	0
114	RMK	Road Markings	-1	1	0
69	RTC	Road Traffic Collision	2	-1	1
141	RTE	Respect the Environment	0	0	0
115	RWT	Ragwort	-1	1	0
152	SAF	Safety	0	0	0
71	SCA	Scaffold Licences	0	1	0
122	SCH	Scheme Information	2	0	0
116	SCI	Scheme Information	-1	0	0
72	SCI	Scheme Ideas	0	-1	0
73	SGA	Sign Absence	0	1	0
74	SGC	Sign Condition	1	1	1
123	SGI	Signage Issues	1	0	0
151	SGL	Sign Location	0	0	0
126	SGS	Sign Size	0	0	0
75	SGV	Signs Visibility	1	-1	0
76	SKP	Skip Licences	0	0	0
77	SPD	Speed Problems	0	0	0
78	SPL	Spillages on Highway	2	0	0
70	SRU	Safety Road Users	0	-1	0
34	STF	Street Furniture	0	1	0
79	STR	Structures General	0	2	0
98	SWE	Sweeping and Cleaning	0	-1	1
82	TIM	Timing of Works	0	1	1
12	TMC	Traffic Management / Cones	1	1	0
81	TPC	Third Party Claims	0	1	0
136	TRA	Travellers	0	0	0
83	TRN	Traffic Noise	0	1	0
84	TRO	Traffic Orders	0	-1	0
80	TRO	Temporary Restriction Orders	0	-1	0
85	TRS	Traffic Signals	2	2	1
131	TSC	Temporary Speed Cameras	0	0	0
86	USG	Unauthorised Signs	2	0	0
87	VMS	Variable Message Signing	1	0	0
149	VOT	Volume of Traffic	0	0	0
88	VRG	Verge Cutting	0	-1	1
125	WEA	Weather	0	0	0
94	WKO	Works in Progress Other	0	-1	0
93	WKS	Work Site Signage	1	-1	0
118	WMA	Winter Maintenance	1	2	0
89	WPL	Water Pollution	0	0	0
92	WSF	Work Site Safety	0	-1	0
90	WSL	Work Site Lighting	0	-1	0
91	WSN	Work Site Noise	0	-1	1

Incident Class - Incidents

ClassId	Prefix	Caption	DisplayLevel
1	ABV	Abandoned Vehicles	2
8	BDV	Broken Down Vehicle	2
18	DBF	Damage to Boundary Fences	2
25	DEA	Dead Animals	2
26	DEB	Debris	2
95	DRA	Drainage Systems	2
20	DRW	Damage to Retaining Walls	2
21	DSF	Damage to Safety Fencing/Barriers	2
22	DST	Damage to Structures	2
32	FLO	Flooding	2
36	GRA	Graffiti	2
68	GUL	Road Gully Maintenance	2
42	IBO	Illuminated Bollard	2
43	ISG	Illuminated Signs	2
46	LCE	Lamp Column Emergency	2
52	LIA	Live Animals	2
62	POT	Pothole in Highway	2
69	RTC	Road Traffic Collision	2
122	SCH	Scheme Information	2
78	SPL	Spillages on Highway	2
85	TRS	Traffic Signals	2
86	USG	Unauthorised Signs	2
7	BOL	Bollards	1
10	CLO	Closures	1
96	COM	COMMS	1
19	DFW	Damage to Footway	1
30	ELC	Electrical Failure	1
31	FIR	Fire Related Issues	1
33	FLY	Fly Tipping	1
38	HGR	Highway Gritting	1
39	HOA	Hoardings	1
40	HOR	Horticultural	1
124	HSP	High Speed Police Pursuit	1
41	ICE	Ice/Snow	1
100	KER	Road Kerbs	1
47	LCO	Lamp Column Outage	1
99	LIG	Lighting (General)	1
101	MAN	Manhole Covers	1
53	MUD	Mud	1
109	OEQ	Other Enquiry	1
59	PED	Pedestrians on Carriageway	1
74	SGC	Sign Condition	1
123	SGI	Signage Issues	1
75	SGV	Signs Visibility	1
12	TMC	Traffic Management / Cones	1
87	VMS	Variable Message Signing	1
93	WKS	Work Site Signage	1
118	WMA	Winter Maintenance	1
2	ABL	Abnormal Loads	0
3	ACC	Access Alterations	0
4	ADH	Adopted Highways	0
5	AND	Advanced Notice	0
6	ARB	Arboriculture	0
9	BUS	Buses	0
139	CCL	Compensation Claims	0
105	CCO	Customer Compliment	0
104	CCP	Customer Complaint	0
17	CDL	Current Delays	0
108	CEQ	Customer Enquiry	0
11	CHW	Condition of Highway	0
13	COH	Construction over the Highway	0
14	CON	Consultations/Letterdrops	0
15	CRA	Crane Licences	0
16	CRO	Crossings	0
24	DAN	Dangerous Land Adjoining Street	0
27	DEL	Delays	0
28	DEV	Development	0
23	DFC	Danger to Forecourts	0
29	DST	Dust	0
97	EAR	Earthworks	0
148	ERT	Emergency Roadside Telephones	0
150	GCL	Green Claims	0
35	GEN	General	0
37	GRI	Grit Bins	0
147	HAT	HATO's	0
130	IPH	Improve Personnel Health & Safety	0
45	IRN	Ironwork	0
129	IRS	Improve Road Safety	0
44	ISO	Information Systems Other	0
67	ISS	Related Issues	0
49	LIC	Licencing of Amenities	0
50	LIN	Lining & Studs	0
51	LIT	Litter	0
48	LNO	Land Issues Other	0
106	MCM	Ministerial Commitment	0
107	MCR	Ministerial Correspondence	0
54	NAV	Navigation Sytems	0
56	NON	Non Motorist	0
143	NPL	New Planting	0
57	NRS	NRSWA	0
146	NTC	NTCC	0
55	NVW	No Visible Works	0
138	OEN	Ownership Query	0
64	PBU	Public Utilities	0
61	PDL	Potential Delays	0
142	PDR	Pollution: Drainage	0
137	PEN	Purchasing Query	0
58	PKG	Parking	0
103	PLN	Planning Application	0
63	PRJ	Projections from Buildings	0
134	PRO	Procurement	0
60	PSG	Poor Sign Information	0
102	PUD	Public Utility Defect	0
65	QLT	Quality of Lighting	0
140	RAG	Ragwort etc.	0
66	RAI	Rail	0
144	RCC	Regional Control Centre	0
128	RDC	Road Closures	0
127	RDL	Road Layouts	0
132	RDM	Road Markings	0
145	REC	Recruitment	0
133	RFI	Request for Information	0
135	RFS	Request For Sign (tourist, other)	0
141	RTE	Respect the Environment	0
152	SAF	Safety	0
71	SCA	Scaffold Licences	0
72	SCI	Scheme Ideas	0
73	SGA	Sign Absence	0
151	SGL	Sign Location	0
126	SGS	Sign Size	0
76	SKP	Skip Licences	0
77	SPD	Speed Problems	0
70	SRU	Safety Road Users	0
34	STF	Street Furniture	0
79	STR	Structures General	0
98	SWE	Sweeping and Cleaning	0
82	TIM	Timing of Works	0
81	TPC	Third Party Claims	0
136	TRA	Travellers	0
83	TRN	Traffic Noise	0
84	TRO	Traffic Orders	0
80	TRO	Temporary Restriction Orders	0
131	TSC	Temporary Speed Cameras	0
149	VOT	Volume of Traffic	0
88	VRG	Verge Cutting	0
125	WEA	Weather	0
94	WKO	Works in Progress Other	0
89	WPL	Water Pollution	0
92	WSF	Work Site Safety	0
90	WSL	Work Site Lighting	0
91	WSN	Work Site Noise	0

Incident Class - Customer Enquiries

ClassId	Prefix	Caption	DisplayLevel
6	ARB	Arboriculture	2
27	DEL	Delays	2
30	ELC	Electrical Failure	2
35	GEN	General	2
36	GRA	Graffiti	2
40	HOR	Horticultural	2
99	LIG	Lighting (General)	2
51	LIT	Litter	2
101	MAN	Manhole Covers	2
79	STR	Structures General	2
85	TRS	Traffic Signals	2
118	WMA	Winter Maintenance	2
7	BOL	Bollards	1
11	CHW	Condition of Highway	1
10	CLO	Closures	1
18	DBF	Damage to Boundary Fences	1
26	DEB	Debris	1
19	DFW	Damage to Footway	1
32	FLO	Flooding	1
33	FLY	Fly Tipping	1
48	LNO	Land Issues Other	1
57	NRS	NRSWA	1
109	OEQ	Other Enquiry	1
61	PDL	Potential Delays	1
62	POT	Pothole in Highway	1
71	SCA	Scaffold Licences	1
73	SGA	Sign Absence	1
74	SGC	Sign Condition	1
34	STF	Street Furniture	1
82	TIM	Timing of Works	1
12	TMC	Traffic Management / Cones	1
81	TPC	Third Party Claims	1
83	TRN	Traffic Noise	1
2	ABL	Abnormal Loads	0
1	ABV	Abandoned Vehicles	0
139	CCL	Compensation Claims	0
17	CDL	Current Delays	0
25	DEA	Dead Animals	0
21	DSF	Damage to Safety Fencing/Barriers	0
22	DST	Damage to Structures	0
29	DST	Dust	0
148	ERT	Emergency Roadside Telephones	0
150	GCL	Green Claims	0
37	GRI	Grit Bins	0
147	HAT	HATO's	0
38	HGR	Highway Gritting	0
124	HSP	High Speed Police Pursuit	0
42	IBO	Illuminated Bollard	0
41	ICE	Ice/Snow	0
130	IPH	Improve Personnel Health & Safety	0
129	IRS	Improve Road Safety	0
43	ISG	Illuminated Signs	0
46	LCE	Lamp Column Emergency	0
47	LCO	Lamp Column Outage	0
143	NPL	New Planting	0
146	NTC	NTCC	0
55	NVW	No Visible Works	0
138	OEN	Ownership Query	0
64	PBU	Public Utilities	0
142	PDR	Pollution: Drainage	0
137	PEN	Purchasing Query	0
103	PLN	Planning Application	0
134	PRO	Procurement	0
60	PSG	Poor Sign Information	0
140	RAG	Ragwort etc.	0
144	RCC	Regional Control Centre	0
128	RDC	Road Closures	0
127	RDL	Road Layouts	0
132	RDM	Road Markings	0
145	REC	Recruitment	0
133	RFI	Request for Information	0
135	RFS	Request For Sign (tourist, other)	0
141	RTE	Respect the Environment	0
152	SAF	Safety	0
122	SCH	Scheme Information	0
123	SGI	Signage Issues	0
151	SGL	Sign Location	0
126	SGS	Sign Size	0
76	SKP	Skip Licences	0
77	SPD	Speed Problems	0
78	SPL	Spillages on Highway	0
136	TRA	Travellers	0
131	TSC	Temporary Speed Cameras	0
86	USG	Unauthorised Signs	0
87	VMS	Variable Message Signing	0
149	VOT	Volume of Traffic	0
125	WEA	Weather	0
89	WPL	Water Pollution	0
3	ACC	Access Alterations	-1
4	ADH	Adopted Highways	-1
5	AND	Advanced Notice	-1
8	BDV	Broken Down Vehicle	-1
9	BUS	Buses	-1
105	CCO	Customer Compliment	-1
104	CCP	Customer Complaint	-1
108	CEQ	Customer Enquiry	-1
13	COH	Construction over the Highway	-1
96	COM	COMMS	-1
14	CON	Consultations/Letterdrops	-1
15	CRA	Crane Licences	-1
16	CRO	Crossings	-1
24	DAN	Dangerous Land Adjoining Street	-1
28	DEV	Development	-1
23	DFC	Danger to Forecourts	-1
95	DRA	Drainage Systems	-1
20	DRW	Damage to Retaining Walls	-1
97	EAR	Earthworks	-1
31	FIR	Fire Related Issues	-1
68	GUL	Road Gully Maintenance	-1
39	HOA	Hoardings	-1
45	IRN	Ironwork	-1
44	ISO	Information Systems Other	-1
67	ISS	Related Issues	-1
100	KER	Road Kerbs	-1
52	LIA	Live Animals	-1
49	LIC	Licencing of Amenities	-1
50	LIN	Lining & Studs	-1
106	MCM	Ministerial Commitment	-1
107	MCR	Ministerial Correspondence	-1
53	MUD	Mud	-1
54	NAV	Navigation Sytems	-1
56	NON	Non Motorist	-1
59	PED	Pedestrians on Carriageway	-1
58	PKG	Parking	-1
63	PRJ	Projections from Buildings	-1
102	PUD	Public Utility Defect	-1
65	QLT	Quality of Lighting	-1
66	RAI	Rail	-1
69	RTC	Road Traffic Collision	-1
72	SCI	Scheme Ideas	-1
75	SGV	Signs Visibility	-1
70	SRU	Safety Road Users	-1
98	SWE	Sweeping and Cleaning	-1
80	TRO	Temporary Restriction Orders	-1
84	TRO	Traffic Orders	-1
88	VRG	Verge Cutting	-1
94	WKO	Works in Progress Other	-1
93	WKS	Work Site Signage	-1
92	WSF	Work Site Safety	-1
90	WSL	Work Site Lighting	-1
91	WSN	Work Site Noise	-1

Incident Class - Post Log

ClassId	Prefix	Caption	DisplayLevel
105	CCO	Customer Compliment	2
104	CCP	Customer Complaint	2
108	CEQ	Customer Enquiry	2
106	MCM	Ministerial Commitment	2
107	MCR	Ministerial Correspondence	2
103	PLN	Planning Application	2
1	ABV	Abandoned Vehicles	1
8	BDV	Broken Down Vehicle	1
17	CDL	Current Delays	1
11	CHW	Condition of Highway	1
10	CLO	Closures	1
25	DEA	Dead Animals	1
26	DEB	Debris	1
27	DEL	Delays	1
32	FLO	Flooding	1
33	FLY	Fly Tipping	1
35	GEN	General	1
36	GRA	Graffiti	1
38	HGR	Highway Gritting	1
100	KER	Road Kerbs	1
52	LIA	Live Animals	1
99	LIG	Lighting (General)	1
51	LIT	Litter	1
53	MUD	Mud	1
58	PKG	Parking	1
62	POT	Pothole in Highway	1
65	QLT	Quality of Lighting	1
69	RTC	Road Traffic Collision	1
74	SGC	Sign Condition	1
98	SWE	Sweeping and Cleaning	1
82	TIM	Timing of Works	1
85	TRS	Traffic Signals	1
88	VRG	Verge Cutting	1
91	WSN	Work Site Noise	1
2	ABL	Abnormal Loads	0
3	ACC	Access Alterations	0
4	ADH	Adopted Highways	0
5	AND	Advanced Notice	0
6	ARB	Arboriculture	0
7	BOL	Bollards	0
9	BUS	Buses	0
139	CCL	Compensation Claims	0
13	COH	Construction over the Highway	0
96	COM	COMMS	0
14	CON	Consultations/Letterdrops	0
15	CRA	Crane Licences	0
16	CRO	Crossings	0
24	DAN	Dangerous Land Adjoining Street	0
18	DBF	Damage to Boundary Fences	0
28	DEV	Development	0
23	DFC	Danger to Forecourts	0
19	DFW	Damage to Footway	0
95	DRA	Drainage Systems	0
20	DRW	Damage to Retaining Walls	0
21	DSF	Damage to Safety Fencing/Barriers	0
22	DST	Damage to Structures	0
29	DST	Dust	0
97	EAR	Earthworks	0
30	ELC	Electrical Failure	0
148	ERT	Emergency Roadside Telephones	0
31	FIR	Fire Related Issues	0
150	GCL	Green Claims	0
37	GRI	Grit Bins	0
68	GUL	Road Gully Maintenance	0
147	HAT	HATO's	0
39	HOA	Hoardings	0
40	HOR	Horticultural	0
124	HSP	High Speed Police Pursuit	0
42	IBO	Illuminated Bollard	0
41	ICE	Ice/Snow	0
130	IPH	Improve Personnel Health & Safety	0
45	IRN	Ironwork	0
129	IRS	Improve Road Safety	0
43	ISG	Illuminated Signs	0
44	ISO	Information Systems Other	0
67	ISS	Related Issues	0
46	LCE	Lamp Column Emergency	0
47	LCO	Lamp Column Outage	0
49	LIC	Licencing of Amenities	0
50	LIN	Lining & Studs	0
48	LNO	Land Issues Other	0
101	MAN	Manhole Covers	0
54	NAV	Navigation Sytems	0
56	NON	Non Motorist	0
143	NPL	New Planting	0
57	NRS	NRSWA	0
146	NTC	NTCC	0
55	NVW	No Visible Works	0
138	OEN	Ownership Query	0
109	OEQ	Other Enquiry	0
64	PBU	Public Utilities	0
61	PDL	Potential Delays	0
142	PDR	Pollution: Drainage	0
59	PED	Pedestrians on Carriageway	0
137	PEN	Purchasing Query	0
63	PRJ	Projections from Buildings	0
134	PRO	Procurement	0
60	PSG	Poor Sign Information	0
102	PUD	Public Utility Defect	0
140	RAG	Ragwort etc.	0
66	RAI	Rail	0
144	RCC	Regional Control Centre	0
128	RDC	Road Closures	0
127	RDL	Road Layouts	0
132	RDM	Road Markings	0
145	REC	Recruitment	0
133	RFI	Request for Information	0
135	RFS	Request For Sign (tourist, other)	0
141	RTE	Respect the Environment	0
152	SAF	Safety	0
71	SCA	Scaffold Licences	0
122	SCH	Scheme Information	0
72	SCI	Scheme Ideas	0
73	SGA	Sign Absence	0
123	SGI	Signage Issues	0
151	SGL	Sign Location	0
126	SGS	Sign Size	0
75	SGV	Signs Visibility	0
76	SKP	Skip Licences	0
77	SPD	Speed Problems	0
78	SPL	Spillages on Highway	0
70	SRU	Safety Road Users	0
34	STF	Street Furniture	0
79	STR	Structures General	0
12	TMC	Traffic Management / Cones	0
81	TPC	Third Party Claims	0
136	TRA	Travellers	0
83	TRN	Traffic Noise	0
84	TRO	Traffic Orders	0
80	TRO	Temporary Restriction Orders	0
131	TSC	Temporary Speed Cameras	0
86	USG	Unauthorised Signs	0
87	VMS	Variable Message Signing	0
149	VOT	Volume of Traffic	0
125	WEA	Weather	0
94	WKO	Works in Progress Other	0
93	WKS	Work Site Signage	0
118	WMA	Winter Maintenance	0
89	WPL	Water Pollution	0
92	WSF	Work Site Safety	0
90	WSL	Work Site Lighting	0

Point of Contact Reference

Overview

The Point of Contact is a list of Contract Offices and Depots and is specified as the prime contact location for an Incident.

The data table in HighStone is [ltbPointContact].

Typical Data Definition

ItemId	Caption
0	Not Specified
1	Birchwood (Main Office)
2	Westhoughton
3	Preston Brook
4	NWRCC (Rob Lane)
5	Newton-le-Willows
6	Charnock Richard
7	Whitebirk
8	Milnrow
9	Brinnington
10	Knutsford
11	Darlington
12	Bristol (Design Office)
13	Hale
14	Tarbuck
15	Glenburn
16	Sandbach
17	Clatterbridge

Network Area / Manager Reference

Overview

The Network Area Reference is also used as a classification of Manager within a Contract on Incident Records. The usage (particularly the Caption given on forms) does vary between different installations, however the usage is similar. The table definition contains a number of values that are used to seed other data fields and actions.

Network Area Manager Link

The prime one of these is the User Id of the Manager who is responsible for the Network Area - held in field [NAManagerId]. On Incident Records, this reference is used to seed the Action By selection when the Manager (or Network Area) is specified.

The data table in HighStone is [ltbNetworkAreas].

Typical Data Definition

ItemId	Prefix	Caption	AreaManager
1	South	South Region	3784
2	Central	Central Region	3885
3	North	North Region	3847
9	SHE	Health & Safety	4532
10	Watchman	Watchman	3927
5	Environ	Environmental	0
6	Struct	Structures	0
7	Fleet	Fleet	0
8	Light	Lighting	0
0	Undef	Undefined	0

Incident Area to Scheme Class Reference

Emergency Response Incidents are classified by Network Area - and this link is used to allocate raised Works Orders to the correct Parent Scheme Reference. The field name is [NAIncidSchemeNo].

ItemId	Prefix	Caption	SchemeRef
1	South	South Region	100062
2	Central	Central Region	100063
3	North	North Region	100061

Incident Area to Point of Contact Link

A link is defined to between the Network Area (Manager) and the Prime Depot or Point of Contact within the Contract. A direct link to the table [ltbPointContact] is given in the field [NAPointContact].

A further entry has been added to cater for configurations where more than one Network Area (or discipline) is handled by the same Point of Contact (Depot). This additional field [NANotifyCentre] is used by HighStone to seed the Works Package Notifications (emails) by linking the Network Area (Manager) to the required expansion of target Email Addresses.

ItemId	Prefix	Caption	PointContactId	NotifyCentreId
1	South	South Region	3	3
2	Central	Central Region	2	2
3	North	North Region	2	1

Incidents Action Entry Reference

Overview

The Incident Actions Records (held in [tblIncidentActions]) holds a reference to the Action Undertaken by the current User (as defined when the Action is logged). This entry is taken from a definition list in [ltbActionMethod], and this table defines links to the Media Type (Field [ICAMedia] is linked to table [ltbActionMethod]), and the default Follow-up Action (as defined in ltbFollowupAction).

Action Reference Table (ltbIncidentAction)

The following table definition gives the list of definitions and Defaults that are used to seed other fields on the display.

ItemId	Prefix	Action Taken	Method	Follow Up Action	StndPrompt	AddPrompt
1	EQL	Enquiry Logged	Telephone		TRUE	TRUE
2	EQA	Enquiry Answered and Logged	Telephone	No Further Action	TRUE	TRUE
3	IRI	Incident Response Initiated	Telephone		TRUE	TRUE
4	CPN	Complaint No Corrective Action	Telephone		FALSE	FALSE
5	CPY	Complaint Yes Corrective Action	Telephone		TRUE	FALSE
6	WRH	Sent Holding Letter / Email	Letter		TRUE	TRUE
7	WRC	Closing Reply Made / Issued	Letter	No Further Action	TRUE	TRUE
8	WRO	Open Reply Made / Issued	Letter		TRUE	TRUE
9	PUT	Passed to Utility - NFA	Email	No Further Action	TRUE	TRUE
10	PLA	Passed to Local Authority - NFA	Email	No Further Action	TRUE	TRUE
11	ROP	Re-Open Incident Log	Database		FALSE	FALSE
12	PSC	Passed to Sub-Contractor - NFA	Email		TRUE	TRUE
13	EVN	Environment Agency Notified	Letter		TRUE	TRUE
14	INC	Inspection Completed - NFA	Not Specified	No Further Action	TRUE	FALSE
15	INW	Inspection - Works Identified	Not Specified		TRUE	FALSE
16	LAN	Local Authority Notified	Not Specified		TRUE	TRUE
17	UTN	Utilities Notified	Not Specified		TRUE	TRUE
18	CBF	Call Back - Failed to Contact	Telephone	Call Back Required	TRUE	FALSE
19	CBM	Call Back - Message Left	Telephone		TRUE	FALSE
20	CBR	Call Back - Resolved	Telephone	No Further Action	TRUE	FALSE
21	CBU	Call Back - Unresolved	Telephone		TRUE	FALSE
22	IWO	Immediate Repair WO Raised	Database		FALSE	FALSE
23	PWO	Permanent Repair WO Raised	Database		FALSE	FALSE
24	RPC	Immediate Repairs Completed	Not Specified		TRUE	TRUE
25	WKC	Works Completed - NFA	Not Specified	No Further Action	TRUE	TRUE
26	PID	Passed to Internal Department	Not Specified	Action Required	TRUE	TRUE
27	CML	Compliment Logged	Telephone		FALSE	FALSE
28	CPI	Copied for Information	Database	Receipt Acknowledge Req'd	TRUE	FALSE
29	EQF	Enquiry Logged/Forwarded	Telephone	Action Required	TRUE	TRUE
30	CLS	Incident Closed / Cancelled	Not Specified	No Further Action	TRUE	FALSE
31	ACK	Action Acknowledged/Closed	Database	No Further Action	FALSE	FALSE
32	CAD	Contact Name Added	Database	No Further Action	TRUE	FALSE
33	RUD	Response Unit Deployed	Telephone	No Further Action	FALSE	TRUE
34	IMP	Watchman Innovation	Not Specified		FALSE	FALSE
35	OBS	Watchman Observation	Not Specified		FALSE	FALSE
36	MD	Mis-Directed	Not Specified		FALSE	FALSE
37	IPI	Incident (Proactive) Initiated	Telephone		TRUE	TRUE
38	PWM	Passed to Watchman	Not Specified	Action Required	TRUE	TRUE
39	PHA	Passed Back To HA	Not Specified	Action Required	TRUE	TRUE
40	FSP	Passed to Forward Scheme Program	Not Specified	Action Required	TRUE	TRUE
41	EMR	Issue Email Reminder	Database	Email Reminder Scheduled	TRUE	TRUE

Follow-up Actions Definitions

This table defines a list of valid Follow-up Actions that are held against the Incident Actions Record [tblIncidentsActions].

Each definition includes an optional definition on the required Response Time, with NFA indicating No Further Action. Other entries may define the Period Tag (W+, D+ etc), and a numeric Duration value which is taken in to the calculation.

A full list of standard Follow-up Periods are held in Lookup Table [ltbFollowupPrompt].

Follow-up Actions Definitions (ltbFollowOnActions)

ItemId	Prefix	Caption	ActionTag	ActionDurn
1	ARQ	Action Required		0
2	CBK	Call Back Required		0
3	NFA	No Further Action	NFA	0
12	R1W	Response Required (1 Week)	W+	1
18	RAR	Receipt Acknowledge Req'd		0
13	R2W	Response Required (2 Weeks)	W+	2
14	R4W	Response Required (4 Weeks)	W+	4
15	R6M	Response Required (6 Months)	M+	6
19	PWM	Watchman Response Required		0
4	WRI	Written Reply Required		0
5	HRP	Holding Reply Required		0
6	AWD	Awaiting Incoming Documents		0
7	DIS	Documents to be Issued		0
8	INS	Inspection Required		0
16	PID	Passed to Internal Department		0
9	TWO	Temporary Repair WO Required		0
10	PWO	Permanent Repair WO Required		0
11	CYC	Leave for Cyclic Maintenance	NFA	0
17	HAI	HAIL Response Required	D+	10
20	EMR	Email Reminder Scheduled	D+	10