Difference between revisions of "JCM Table: dbo.AT FormDataReview"
From Sherlock Software
(Created page with "===TABLE NAME: dbo.AT_FormDataReview=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || FormID || int || |- | 2 || Category || nvarchar(255) ||...") |
|||
| Line 1: | Line 1: | ||
===TABLE NAME: dbo.AT_FormDataReview=== | ===TABLE NAME: dbo.AT_FormDataReview=== | ||
Records data adulting review results. | |||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
! Col ID !! Name !! Data Type !! Description | ! Col ID !! Name !! Data Type !! Description | ||
|- | |- | ||
| 1 || FormID || int || | | 1 || FormID || int || ID of form | ||
|- | |- | ||
| 2 || Category || nvarchar(255) || | | 2 || Category || nvarchar(255) || Category | ||
|- | |- | ||
| 3 || Completed || bit || | | 3 || Completed || bit || Review complete indicator | ||
|- | |- | ||
| 4 || IncompleteItems || nvarchar || | | 4 || IncompleteItems || nvarchar || Review incomplete items | ||
|- | |- | ||
| 5 || Comments || ntext || | | 5 || Comments || ntext || Comments | ||
|- | |- | ||
| 6 || DateRecorded || datetime || | | 6 || DateRecorded || datetime || Date and time the record was recorded | ||
|} | |} | ||
</br> | </br> | ||
Latest revision as of 17:16, 3 January 2022
TABLE NAME: dbo.AT_FormDataReview
Records data adulting review results.
| Col ID | Name | Data Type | Description |
|---|---|---|---|
| 1 | FormID | int | ID of form |
| 2 | Category | nvarchar(255) | Category |
| 3 | Completed | bit | Review complete indicator |
| 4 | IncompleteItems | nvarchar | Review incomplete items |
| 5 | Comments | ntext | Comments |
| 6 | DateRecorded | datetime | Date and time the record was recorded |
Back to JCM Database tables
