QuestionnaireResponsesquestionnaireResponseSectionsquestionnaireResponseDetailsquestionAttachments
Manages files attached to specific question responses, such as certificates or documentation supporting the respondent’s claims.
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 questionnaire response. Example: 1001 for Questionnaire Response Header 1001. |
| QuestionnaireresponsesectionsQuestionnaireRespSectionId [KEY] | Long | The unique identifier for the questionnaire response section, linking the attachment to a specific section within the questionnaire response. Example: 2001 for Section ID 2001. |
| QuestionnaireresponsedetailsQuestionnaireResponseId [KEY] | Long | The unique identifier for the questionnaire response, linking the attachment to a specific questionnaire response record. Example: 3001 for Questionnaire Response ID 3001. |
| AttachedDocumentId [KEY] | Long | The unique identifier for the document attached to the questionnaire response, linking the attachment to a specific document. Example: 4001 for Document ID 4001. |
| LastUpdateDate | Datetime | The date and time when the attachment was last updated. Example: '2023-06-15 14:00:00' for when the attachment was last modified. |
| LastUpdatedBy | String | The username or identifier of the person who last updated the attachment. Example: 'admin' for the administrator responsible for the last update. |
| DatatypeCode | String | The code representing the data type of the attachment file, such as PDF, image, or text. Example: 'PDF' for a PDF file. |
| FileName | String | The name of the attached file. Example: 'response_document.pdf' for the name of the document attached to the questionnaire response. |
| DmFolderPath | String | The folder path in the document management system where the attachment is stored. Example: '/docs/questionnaire_responses/'. |
| DmDocumentId | String | The unique identifier for the document in the document management system, linking the attachment to the source document. Example: 'DOC1234' for Document ID DOC1234. |
| DmVersionNumber | String | The version number of the attached document, indicating which version of the document the attachment corresponds to. Example: 'V2' for version 2. |
| Url | String | The URL pointing to the attachment, used to access the document online. Example: 'http://example.com/file/12345' for accessing the document through a URL. |
| CategoryName | String | The category or type of the attached document. Example: 'Supplier Feedback' for documents related to supplier feedback. |
| UserName | String | The username or credentials of the person who uploaded the attachment. Example: 'jdoe' for the user who uploaded the file. |
| Uri | String | The URI (Uniform Resource Identifier) used to identify the attachment's location. Example: 'doc://attachments/12345' for the URI of the attachment. |
| FileUrl | String | The direct URL to access the attachment file. Example: 'http://example.com/file/attachment.pdf' for the link to download the file. |
| UploadedText | String | The text content of the uploaded file if it is a text-based document. Example: 'This is a questionnaire response from Supplier ABC.' |
| UploadedFileContentType | String | The content type of the uploaded file, indicating its format. |
| UploadedFileLength | Long | The size of the uploaded file in bytes. Example: 1048576 for a file that is 1 MB in size. |
| UploadedFileName | String | The name of the file as assigned during the upload process. 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 or name of the attachment. Example: 'Supplier Feedback Response' for the title of the uploaded document. |
| Description | String | A description of the attachment, providing additional context or information about the file. Example: 'This document contains the feedback from Supplier ABC.' |
| ErrorStatusCode | String | The error code associated with the attachment, if any, indicating a problem with the file or its processing. Example: 'FILE_ERR' for a file error. |
| ErrorStatusMessage | String | The error message describing the issue encountered with the attachment. Example: 'File format not supported' for an unsupported file type error. |
| CreatedBy | String | The username or identifier of the person who initially created or uploaded the attachment. Example: 'admin' for the administrator who uploaded the document. |
| CreationDate | Datetime | The date and time when the attachment was initially created or uploaded. Example: '2023-06-01 09:00:00' for when the attachment was first added. |
| FileContents | String | The contents of the file if it is a text-based file. Example: 'This is the text content of the questionnaire response attachment.' |
| ExpirationDate | Datetime | The expiration date after which the attachment will no longer be accessible or valid. Example: '2023-12-31 23:59:59' for the expiration of the document. |
| LastUpdatedByUserName | String | The username of the person who last updated the attachment. Example: 'jdoe' for 'John Doe' who last updated the file. |
| CreatedByUserName | String | The username of the person who created the attachment. Example: 'admin' for the person who initially uploaded the document. |
| AsyncTrackerId | String | An identifier used to track the asynchronous upload or processing of the attachment. Example: 'upload12345' for tracking the file 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 file, such as download links or metadata. Example: '{url |
| PostProcessingAction | String | The action to be performed after the attachment is uploaded, such as validation or conversion. Example: 'Approve Attachment' or 'Verify File Integrity'. |
| Finder | String | A reference or placeholder used for searching and locating the attachment within the system. Example: 'Search by Document ID' or 'Search by Category'. |
| QuestionnaireRespHeaderId | Long | The unique identifier for the questionnaire response header, linking the attachment to the specific questionnaire response. Example: 1001 for Questionnaire Response Header 1001. |