xpms.v_sheet_inspection_compliance

Vista

The Playbook Inspection Compliance sheet as the database holds it: one row per source row, computed columns reproduced in SQL.

Columnas de xpms.v_sheet_inspection_compliance
Columna	Tipo	Admite nulos	Descripción
source_row	integer	Sí	Row number in the source sheet.
record_id	text	Sí	RECORD ID (column A), field.
department	text	Sí	DEPARTMENT (column D), field.
category	text	Sí	CATEGORY (column E), field.
sub_category	text	Sí	SUB CATEGORY (column F), field.
inspection_type	text	Sí	INSPECTION TYPE (column G), field.
agency	text	Sí	AGENCY (column H), field.
ahj_jurisdiction_code	text	Sí	AHJ JURISDICTION CODE (column I), field.
permit_number	text	Sí	PERMIT NUMBER (column J), field.
permit_doc_id	text	Sí	PERMIT DOC ID (column K), field.
location_id	text	Sí	LOCATION ID (column L), field.
vendor_id	text	Sí	VENDOR ID (column M), field.
inspector_name	text	Sí	INSPECTOR NAME (column N), field.
scheduled_date	text	Sí	SCHEDULED DATE (column O), field.
completed_date	text	Sí	COMPLETED DATE (column P), field.
result	text	Sí	RESULT (column Q), field.
deficiency_summary	text	Sí	DEFICIENCY SUMMARY (column R), field.
sign_off_date	text	Sí	SIGN-OFF DATE (column S), field.
sign_off_url	text	Sí	SIGN-OFF URL (column T), field.
status	text	Sí	STATUS (column U), field.
flag	text	Sí	FLAG (column V), field.
notes	text	Sí	NOTES (column W), field.
created_by	text	Sí	CREATED BY (column X), field.
created_at	text	Sí	CREATED AT (column Y), field.
updated_at	text	Sí	UPDATED AT (column Z), field.
organization	text	Sí	ORGANIZATION (column B), computed.
project_id	text	Sí	PROJECT ID (column C), computed.