Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ApprovedBy | Unknown | 0 | null |
|
|
Approver user ID - Reference to user who approved the submission |
|||||
| ApprovedDate | Unknown | 0 | null |
|
|
Approval timestamp - When the submission was approved |
|||||
| AssignedTo | Unknown | 0 | null |
|
|
Assigned processor - User assigned to process this submission |
|||||
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each form submission, auto-incrementing integer |
||||
| FormDesignId | int | 4 | null |
|
|
Form design reference - Reference to form design used |
|||||
| Values | nvarchar | 1073741823 | √ | null |
|
|
Form values - Serialized form field values |
||||
| EntryID | varchar | 100 | √ | null |
|
|
Entry identifier - Reference to data entry record |
||||
| FillableFileId | nvarchar | 100 | √ | null |
|
|
Fillable file reference - Reference to fillable file template |
||||
| SubmitDate | datetime | 16,3 | null |
|
|
Submit timestamp - When the form was submitted |
|||||
| SubmitBy | int | 4 | null |
|
|
Submit user - User who submitted the form |
|||||
| IsLocked | bit | 1 | null |
|
|
Lock status - Boolean indicating if submission is locked from further changes |
|||||
| ModifiedDate | datetime | 16,3 | √ | null |
|
|
Modification timestamp - When submission was last modified |
||||
| ModifiedBy | int | 4 | √ | null |
|
|
Modifier user ID - User who last modified the submission |
||||
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion timestamp - When the submission was deleted |
||||
| DeletedBy | int | 4 | √ | null |
|
|
Deletion user - User who deleted the submission |
||||
| Referrer | nvarchar | 520 | √ | null |
|
|
Referrer URL - URL that referred to the form |
||||
| IPAddress | varchar | 128 | √ | null |
|
|
IP address - IP address from which form was submitted |
||||
| OperatingSystem | nvarchar | 256 | √ | null |
|
|
Operating system - OS used to submit the form |
||||
| Browser | nvarchar | 256 | √ | null |
|
|
Browser information - Browser used to submit the form |
||||
| City | nvarchar | 256 | √ | null |
|
|
Submission city - City where the form was submitted |
||||
| CompletedDate | Unknown | 0 | null |
|
|
Completion timestamp - When processing was completed |
|||||
| Country | nvarchar | 256 | √ | null |
|
|
Submission country - Country where the form was submitted |
||||
| DueDate | Unknown | 0 | null |
|
|
Processing due date - When processing of this submission is due |
|||||
| FormId | Unknown | 0 | null |
|
|
Form reference - Reference to the custom form that was submitted |
|||||
| IsDraft | bit | 1 | ((0)) |
|
|
Draft flag - Boolean indicating if submission is a draft |
|||||
| Table | varchar | 50 | √ | null |
|
|
Target table - Database table where processed data should be stored |
||||
| CreateByCategory | nvarchar | 30 | √ | null |
|
|
Creation category - Category of user who created the submission |
||||
| FileType | int | 4 | √ | null |
|
|
File type - Type of file associated with submission |
||||
| FormStatus | varchar | 20 | √ | null |
|
|
Form status - Current status of the form submission |
||||
| AdmitId | int | 4 | √ | null |
|
|
Admit identifier - Reference to admission record associated with submission |
||||
| LockedBy | Unknown | 0 | null |
|
|
Lock user - User who locked the submission |
|||||
| LockedDate | Unknown | 0 | null |
|
|
Lock timestamp - When the submission was locked |
|||||
| Notes | Unknown | 0 | null |
|
|
Processing notes - Additional notes or comments about the submission |
|||||
| Priority | Unknown | 0 | null |
|
|
Submission priority - Priority level for processing this submission |
|||||
| ProcessedBy | Unknown | 0 | null |
|
|
Processor user ID - Reference to user who processed or reviewed the submission |
|||||
| ProcessedDate | Unknown | 0 | null |
|
|
Processing timestamp - When the submission was processed or reviewed |
|||||
| RecordId | Unknown | 0 | null |
|
|
Target record ID - Primary key of the record created or updated from this submission |
|||||
| RejectedBy | Unknown | 0 | null |
|
|
Rejector user ID - Reference to user who rejected the submission |
|||||
| RejectedDate | Unknown | 0 | null |
|
|
Rejection timestamp - When the submission was rejected |
|||||
| RejectionReason | Unknown | 0 | null |
|
|
Rejection reason - Reason provided for rejecting the submission |
|||||
| SubmissionData | Unknown | 0 | null |
|
|
Form data - Serialized form field data as submitted by user |
|||||
| SubmissionDate | Unknown | 0 | null |
|
|
Submission timestamp - When the form was initially submitted |
|||||
| SubmissionStatus | Unknown | 0 | null |
|
|
Processing status - Current status of the submission (Pending, Processing, Approved, Rejected) |
|||||
| SubmittedBy | Unknown | 0 | null |
|
|
Submitter user ID - Reference to user who submitted the form |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_FormSubmissions | Primary key | Asc | ID |
| IX_FormSubmissions | Performance | Asc/Asc/Asc | DeletedDate + SubmitDate + IsDraft |
| IX_FormSubmissions_EntryId | Performance | Asc/Asc | EntryID + DeletedDate |
| IX_FormSubmissions_FormDesignId | Performance | Asc | FormDesignId |