dbo.primeExportFormConstructionReport

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

Columns

#	Column	Type	Nullable	Flags	Description
1	Job_Number	nvarchar(50)	no		Human-readable job number/reference used in Prime Ecosystem
2	Category	nvarchar(100)	yes		Category of the construction form
3	Description	nvarchar(300)	yes		Free-text description
4	File_Name	nvarchar(300)	yes		Original file name of the uploaded attachment
5	Created_Date	date	yes		Timestamp the record was created
6	Case_Manager	nvarchar(50)	yes		Display name of the case manager
7	Supervisor	nvarchar(50)	yes		Display name of the supervisor
8	Site_Address	nvarchar(100)	yes		Full site/property address for the job
9	Uploaded_At_Date	date	yes		Date the attachment was uploaded
10	Current_Status	nvarchar(100)	yes		Current status of the job/record
11	Site_Address_State	nvarchar(50)	yes		State/territory of the site address
12	Type	nvarchar(50)	yes		Category/type classification of this record
13	Current_Status_Type	nvarchar(50)	yes		Category/type of the current status
14	Initial_Start_Date	date	yes		Originally scheduled/planned start date, before any rescheduling
15	Initial_End_Date	date	yes		Originally scheduled/planned end date, before any rescheduling
16	Tags	nvarchar(300)	yes		Comma-separated list of tags
17	Closed_at	date	yes		Timestamp the job/record was closed