v_fd_permit
Table Name: v_fd_permit
Last Updated: June 01, 2026 at 01:21 AM
Columns
| Column Name | Data Type | Nullable | Default |
|---|---|---|---|
| id | integer | Yes | - |
| notes | text | Yes | - |
| created_at | timestamp | Yes | - |
| submit_date | date | Yes | - |
| start_date | date | Yes | - |
| expiration_date | date | Yes | - |
| permit_number | character | Yes | - |
| user_creator_public_name | character | Yes | - |
| reference_permit_number | character | Yes | - |
| fd_permit_status_code | character | Yes | - |
| fd_permit_status_name | text | Yes | - |
| is_archived | boolean | Yes | - |
| workflow_name | text | Yes | - |
| fd_permit_type_name | character | Yes | - |
| user_assigned_public_name | character | Yes | - |
| based_on_date_status_code | character | Yes | - |
| response_deadline_date | date | Yes | - |
| fd_permit_category_name | character | Yes | - |
| is_manual_workflow_fd_permit_enabled | boolean | Yes | - |
| authority_name | character | Yes | - |
| project_name | character | Yes | - |
| pre_application_number | character | Yes | - |
| is_final_status | boolean | Yes | - |
| preplan_id | integer | Yes | - |
| address_id | integer | Yes | - |
| location_cache | text | Yes | - |
| business_name | character | Yes | - |
| vendor_contact_names | text | Yes | - |
| contact_names | text | Yes | - |
| client_code | character | Yes | - |
| assigned_to | integer | Yes | - |
| created_by | integer | Yes | - |
This documentation is automatically generated from the ODBC Data Warehouse schema.