QuestionnaireResponsesquestionnaireAttachments
Stores attachments linked to questionnaire responses (for example, supporting documents, references), providing additional context for responses.
Columns
| Name | Type | Description |
| QuestionnaireResponsesQuestionnaireRespHeaderId [KEY] | Long | The unique identifier for the questionnaire response header associated with the attachment, linking the attachment to a specific response. Example: 1001 for Questionnaire Response Header 1001. |
| AttachedDocumentId [KEY] | Long | The unique identifier for the attached document, linking the attachment to the specific document. Example: 2001 for 'Document 2001'. |
| LastUpdateDate | Datetime | The date and time when the attachment was last updated. Example: '2023-06-15 14:00:00' for the latest modification time. |
| LastUpdatedBy | String | The username or identifier of the person who last updated the attachment record. Example: 'admin' for the administrator. |
| DatatypeCode | String | The code representing the type of data in the attachment, such as 'PDF', 'JPEG', or 'TEXT'. Example: 'PDF' for a PDF document attachment. |
| FileName | String | The name of the file associated with the attachment. Example: 'questionnaire_response.pdf' for a PDF file. |
| DmFolderPath | String | The folder path where the attachment is stored in the document management system. Example: '/docs/attachments/2023/'. |
| DmDocumentId | String | The unique identifier for the document in the document management system from which the attachment is derived. Example: 'DOC1234' for Document ID DOC1234. |
| DmVersionNumber | String | The version number of the document from which the attachment is created. Example: 'V2' for version 2 of the document. |
| Url | String | The URL pointing to the attachment in a web-based location. Example: 'http://example.com/attachment/12345' for a web URL. |
| CategoryName | String | The category of the attachment, which helps classify the document type. Example: 'Invoice' for an invoice-related attachment. |
| UserName | String | The username or credentials of the person who uploaded the attachment. Example: 'jdoe' for 'John Doe'. |
| Uri | String | The URI (Uniform Resource Identifier) for the attachment, indicating its location in a system or network. Example: 'doc://attachments/12345'. |
| FileUrl | String | The URL to directly access the file for viewing or download. Example: 'http://example.com/file/attachment.pdf'. |
| UploadedText | String | The text content of the attachment if it is a text-based document. Example: 'This is the content of the questionnaire response attachment.' |
| UploadedFileContentType | String | The content type of the attached file, indicating its format. |
| UploadedFileLength | Long | The size of the attached file in bytes. Example: 1048576 for a 1 MB file. |
| UploadedFileName | String | The name assigned to the uploaded file, which may differ from the original file name. Example: 'response_document_2023.pdf'. |
| ContentRepositoryFileShared | Bool | Indicates whether the file is shared within the content repository. Example: True if the file is shared, False if it is not. |
| Title | String | The title of the attachment, providing a brief description or name of the file. Example: 'Supplier Feedback Response'. |
| Description | String | A detailed description of the attachment, explaining its purpose or content. Example: 'This document contains the supplier's feedback for Q2.' |
| ErrorStatusCode | String | The error code, if any, associated with the attachment, indicating the nature of the error. Example: 'FILE_ERR' for a file error. |
| ErrorStatusMessage | String | The error message providing further explanation about the issue with the attachment. Example: 'File format not supported' or 'File upload failed'. |
| CreatedBy | String | The username or identifier of the person who initially created the attachment record. Example: 'admin' for the system administrator. |
| CreationDate | Datetime | The date and time when the attachment was initially created or uploaded. Example: '2023-06-01 09:30:00' for when the attachment was uploaded. |
| FileContents | String | The contents of the file if it is a text-based file. Example: 'This is a sample questionnaire response text.' |
| ExpirationDate | Datetime | The expiration date when the attachment is no longer valid or accessible. Example: '2023-12-31 23:59:59' for the expiration of the attachment. |
| LastUpdatedByUserName | String | The username of the person who last updated the attachment record. Example: 'jdoe' for 'John Doe'. |
| CreatedByUserName | String | The username of the person who created the attachment. Example: 'admin' for 'Administrator'. |
| AsyncTrackerId | String | An identifier used for tracking the asynchronous upload process of the attachment. Example: 'upload12345' for tracking the upload process. |
| FileWebImage | String | A Base64-encoded image of the file, displayed in PNG format if the source is a convertible image. Example: 'iVBORw0KGgoAAAANSUhEU...'. |
| DownloadInfo | String | A JSON object as a string containing information used to retrieve the attachment programmatically. Example: '{url |
| PostProcessingAction | String | The action to be performed after the attachment is uploaded, such as validation or conversion. Example: 'Approve Attachment'. |
| Finder | String | A reference or placeholder used for searching and locating the attachment record in the system. Example: 'Search by Document ID' or 'Search by Category'. |
| QuestionnaireRespHeaderId | Long | The unique identifier for the questionnaire response header associated with the attachment, linking the attachment to a specific response header. Example: 1001 for Questionnaire Response Header 1001. |