Additional columns
Additional columns
The following columns appear in each CV view for a form. Each column is updated when data on the form is added or modified. In addition, each column is updated when the review schema is recreated.
Note:
These columns are not updated when you perform tasks such as adding a comment, working with a query, making changes to source verification status, and so on.
| Column | Description | Element folder |
|---|---|---|
| CREATEDBYUSERID | User ID of the user who started the form by entering data on the form or triggering a rule that entered data on the form. | Basic Data |
| CREATEDDATETIME | Date and time when the reported form was started; that is, when a user entered data on the form or triggered a rule that entered data on the form. | Basic Data |
| MODIFIEDBYUSERID | User ID of the user who started or modified the form by entering or modifying data or triggering a rule that entered or modified data on the form. | Basic Data |
| MODIFIEDDATETIME | Date and time when the reported form was most recently started or modified; that is, when a user entered or modified data on the form or triggered a rule that entered or modified data on the form. | Basic Data |
Parent topic: Built-in columns for views