dbo.primeExportWIPUpdates

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

Columns

#	Column	Type	Nullable	Flags	Description
1	JobNumber	varchar(20)	yes		Human-readable job number/reference used in Prime Ecosystem
2	CaseManager	varchar(100)	yes		Display name of the case manager
3	InstructingClient	varchar(100)	yes		Name of the client/insurer instructing the job
4	SpecificContactRelationship	varchar(100)	yes		Specific relationship type between this contact and the job
5	ClientReference	varchar(50)	yes		Reference number/code supplied by the client (e.g. insurer claim number)
6	AdditionalReference	varchar(100)	yes		Secondary/additional reference number supplied by the client
7	SiteAddress	varchar(255)	yes		Full site/property address for the job
8	CurrentStatus	varchar(100)	yes		Current status of the job/record
9	CreatedDate	date	yes		Timestamp the record was created
10	EndDate	date	yes		End date of this record/job
11	LockedEstimateTotal	decimal(15,2)	yes		Total value of the locked (finalised) estimate
12	AccountsReceivableTo	varchar(100)	yes		Entity the accounts-receivable amount is owed to
13	NetPaidAccountsReceivableTo	varchar(100)	yes		Entity to which the net paid accounts-receivable amount relates
14	SpecificCustomField1	varchar(255)	yes		Value of custom field 1 for this specific record type
15	FirstAppointmentStart	datetime	yes		Start time of the first scheduled appointment for this job
16	ContractStatusChanged	datetime	yes		Timestamp the contract status last changed
17	OverdueAccountsReceivableDue	int	yes		Count/amount of overdue accounts-receivable items
18	PaidAccountsReceivableTotal	int	yes		Total amount of accounts-receivable that has been paid
19	SpecificStatus	varchar(255)	yes		Detailed/specific status label beyond the main status
20	SpecificCustomField2	varchar(255)	yes		Value of custom field 2 for this specific record type
21	StartDate	date	yes		Start date of this record/job
22	Supervisor	varchar(100)	yes		Display name of the supervisor
23	LastContact	varchar(100)	yes		Date/details of the last contact made
24	SpecificCustomField3	varchar(255)	yes		Value of custom field 3 for this specific record type
25	Description	varchar(255)	yes		Free-text description
26	SpecificCustomField4	varchar(255)	yes		Value of custom field 4 for this specific record type
27	SpecificStatus1	varchar(255)	yes		Additional specific status value 1
28	SpecificStatus2	varchar(255)	yes		Additional specific status value 2
29	SpecificStatus3	varchar(255)	yes		Additional specific status value 3
30	AssignedTo	varchar(100)	yes		Display name/identifier of the user or contact this record is assigned to

Relationships (inferred)

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

Referenced by

Procedures: dbo.spPrimeUpsertExportWIPUpdates