dbo.primeExportJobWIPList

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

Columns

#	Column	Type	Nullable	Flags	Description
1	JobWIPListID	int	no	identity	Foreign key to the WIP job list export batch
2	Supervisor	nvarchar(50)	yes		Display name of the supervisor
3	OverdueActions	int	yes		Count of overdue actions
4	PrimeLink	nvarchar(500)	yes		Deep link URL to this record in Prime Ecosystem
5	JobNumber	nvarchar(20)	no		Human-readable job number/reference used in Prime Ecosystem
6	CaseManager	nvarchar(100)	yes		Display name of the case manager
7	InstructingClient	nvarchar(200)	yes		Name of the client/insurer instructing the job
8	SiteAddress	nvarchar(500)	yes		Full site/property address for the job
9	AuthorisedTotal	decimal(18,2)	yes		Total authorised (approved) job value
10	Budget	decimal(18,2)	yes		Budgeted amount
11	CommittedCosts	decimal(18,2)	yes		Total committed (ordered but not yet incurred) costs
12	CostIncurred	decimal(18,3)	yes		Actual cost incurred to date
13	StartDate	date	yes		Start date of this record/job
14	OriginalPCDate	date	yes		Original date recorded by Prime Ecosystem
15	CurrentPCDate	date	yes		Current date as recorded by Prime Ecosystem at export time
16	CurrentStatus	nvarchar(100)	yes		Current status of the job/record
17	DaysAtStatus	nvarchar(20)	yes		Number of days the job has been at its current status
18	DaysSinceLastCustomerContact	nvarchar(20)	yes		Number of days since the customer was last contacted
19	CMNotes	nvarchar(MAX)	yes		Free-text notes from the case manager
20	PCPSDetails	nvarchar(MAX)	yes		Prime Ecosystem payment schedule details

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK__primeExp__B65CE4967275C035	CLUSTERED	yes	yes	JobWIPListID

Referenced by

Procedures: dbo.spPrimeExportJobWIPListUpsert