dbo.primeExportFeedbackRegister

Info Generated by scripts/Generate-DataDictionary.ps1 - do not edit by hand. Edit descriptions in schemas/tables/dbo.primeExportFeedbackRegister.json and regenerate.

Columns

#	Column	Type	Nullable	Flags	Description
2	Created	datetime	yes		Timestamp the record was created
3	DateLastUpdated	datetime	yes		Timestamp the record was last updated
4	IssueStatus	varchar(50)	yes		Status of the issue/feedback item
5	IssueType	varchar(50)	yes		Type/category of the issue
6	RaisedBy	varchar(255)	yes		Person who raised the issue/feedback
7	Description	text(16)	yes		Free-text description
8	FeedbackAssigned	varchar(255)	yes		Person assigned to handle the feedback item
9	ResolvedDate	datetime	yes		Date the issue/item was resolved
10	Notes	text(16)	yes		Free-text internal notes
11	JobNumber	varchar(50)	yes		Human-readable job number/reference used in Prime Ecosystem
12	JobAssigned	varchar(255)	yes		Person assigned to the job
13	CaseManager	varchar(255)	yes		Display name of the case manager
14	Supervisor	varchar(255)	yes		Display name of the supervisor
15	InstructingClient	varchar(255)	yes		Name of the client/insurer instructing the job
16	CustomerName	varchar(255)	yes		Display name of the customer
17	SiteAddress	varchar(500)	yes		Full site/property address for the job
18	DaysSinceCreated	int	yes		Number of days since the job was created
19	DaysSinceLastUpdated	int	yes		Number of days since the job/record was last updated
20	TimeTakenToResolve	float	yes		Time taken to resolve the issue
21	TargetResolutionDate	datetime	yes		Target date by which the issue should be resolved
22	NextReviewDate	datetime	yes		Date this job/record is next due for review
23	RelatedToContact	varchar(255)	yes		Contact this record relates to

Relationships (inferred)

From	To	Confidence
dbo.primeExportFeedbackRegister.JobNumber	dbo.primeJobs.JobNumber	medium

Referenced by

Views: dbo.vPrimeExportFeedbackRegister

Procedures: dbo.spPrimeDeleteExportFeedbackRegister, dbo.spPrimeInsertExportFeedbackRegister