dbo.primeExportJobsRegistered

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

Columns

#	Column	Type	Nullable	Flags	Description
1	JobNumber	nvarchar(100)	yes		Human-readable job number/reference used in Prime Ecosystem
2	InstructingClient	nvarchar(200)	yes		Name of the client/insurer instructing the job
3	LossAdjuster	nvarchar(100)	yes		Name of the loss adjuster overseeing the claim
4	CreatedDate	datetime2(3)	yes		Timestamp the record was created
5	CurrentStatus	nvarchar(200)	yes		Current status of the job/record
6	Assigned	nvarchar(100)	yes		Display name of the user this job/record is assigned to
7	CaseManager	nvarchar(100)	yes		Display name of the case manager
8	Estimator	nvarchar(100)	yes		Display name of the estimator
9	Supervisor	nvarchar(100)	yes		Display name of the supervisor
10	SiteAddress	nvarchar(200)	yes		Full site/property address for the job
11	Peril	nvarchar(100)	yes		Insurance peril (cause of loss) description
12	CatastropheCode	nvarchar(100)	yes		Catastrophe event code/name
13	AccountsReceivableTotal	decimal(19,12)	yes		Total accounts-receivable amount
14	AuthorisedWorksAccountsReceivableTotal	decimal(19,12)	yes		Total accounts-receivable amount for authorised works
15	Type	nvarchar(100)	yes		Category/type classification of this record
16	AuthorisedTotalExTax	decimal(19,12)	yes		Total authorised job value excluding tax
17	AllocationCountNonCancelled	decimal(4,2)	yes		Count of non-cancelled allocations
18	StatusQuoteSubmittedDate	datetime2(3)	yes		Date the status changed to quote submitted
19	QuoteFYLabel	varchar(25)	no	computed	Financial year label the quote was submitted in
20	CreatedFYLabel	varchar(25)	no	computed	Financial year label the job was created in

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
IX_pEJR_QuoteFYLabel_Client_Estimator	NONCLUSTERED			QuoteFYLabel, InstructingClient, Estimator	AuthorisedTotalExTax, CurrentStatus, JobNumber, StatusQuoteSubmittedDate
IX_pEJR_CreatedFYLabel_Client_Estimator	NONCLUSTERED			CreatedFYLabel, InstructingClient, Estimator	AuthorisedTotalExTax, CreatedDate, CurrentStatus, JobNumber
IX_pEJR_SubmitDate_Client_Estimator	NONCLUSTERED			StatusQuoteSubmittedDate, InstructingClient, Estimator	AuthorisedTotalExTax, CurrentStatus, JobNumber, QuoteFYLabel
nci_msft_1_primeExportJobsRegistered_0DDC8772C6BDBCD2EDAD19B8F752FFAA	NONCLUSTERED			JobNumber	AuthorisedTotalExTax, CreatedDate, CurrentStatus, InstructingClient, LossAdjuster

Relationships (inferred)

From	To	Confidence
dbo.primeExportJobsRegistered.CurrentStatus	dbo.ethFactStatus.StatusName	medium
dbo.primeExportJobsRegistered.CurrentStatus	dbo.primeStatuses.name	medium
dbo.primeExportJobsRegistered.JobNumber	dbo.primeJobs.JobNumber	medium

Referenced by

Views: dbo.vReportFilterClient, dbo.vReportFilterJobType

Procedures: dbo.spPrimeUpsertExportJobsRegistered