IdeasAttachments
Manages attachments linked to ideas for supporting documentation.
Columns
Name | Type | Description |
IdeasIdeaId [KEY] | Long | The unique identifier of the idea associated with this attachment. This identifier establishes the relationship between an idea and its supporting documents. |
AttachedDocumentId [KEY] | Long | A system-generated unique identifier for the attached document. This identifier is used for tracking and managing attachments linked to ideas. |
LastUpdateDate | Datetime | The timestamp of the most recent update to the attachment. This timestamp helps in auditing modifications and tracking the latest version. |
LastUpdatedBy | String | The username or identifier of the last user who modified the attachment. This identifier is useful for monitoring document changes and accountability. |
DatatypeCode | String | A short code representing the data type of the attachment, such as text, image, or PDF. This code helps in categorizing and processing attachments. |
FileName | String | The original name of the uploaded file. This name provides a human-readable reference to identify the document. |
DmFolderPath | String | The repository folder path where the attachment is stored. This path defines the document’s location in the content management system. |
DmDocumentId | String | The unique identifier assigned to the document within the document management system. This identifier is used for version control and retrieval. |
DmVersionNumber | String | The version number of the document in the document management system. This number helps in tracking changes and ensuring access to the latest version. |
Url | String | The direct Uniform Resource Locator (URL) of the attachment, allowing users to access it via a web browser or API. |
CategoryName | String | The classification or category assigned to the attachment. This classification helps in organizing and filtering attachments based on purpose or content type. |
UserName | String | The username of the individual who uploaded or owns the attachment. This username provides visibility into content ownership. |
Uri | String | The URI of the attachment, which serves as a unique reference for retrieval in content management systems. |
FileUrl | String | The URL specifically pointing to the attached file, enabling direct access and downloads. |
UploadedText | String | The textual content of the attachment. This field is used for storing plain text-based attachments. |
UploadedFileContentType | String | The content type of the uploaded file. This content type helps in correctly handling file types in processing and display. |
UploadedFileLength | Long | The file size of the uploaded attachment in bytes. This metric is used for storage management and file size restrictions. |
UploadedFileName | String | The name of the file when uploaded, which can differ from the original file name if renaming occurs during processing. |
ContentRepositoryFileShared | Bool | Indicates whether the attachment is shared with other users. Possible values include 'true' (shared) or 'false' (not shared). The default is 'false'. |
Title | String | The title or display name of the attachment. This title is used for identifying attachments in lists and reports. |
Description | String | A brief description of the attachment's contents. This description provides context for users reviewing attachments related to an idea. |
ErrorStatusCode | String | A system-generated error code, if any, related to the attachment. This error code is used for diagnosing upload or processing issues. |
ErrorStatusMessage | String | A descriptive error message providing details about an issue encountered while processing the attachment. |
CreatedBy | String | The username or identifier of the user who originally uploaded the attachment. This identifier helps track content ownership and submission history. |
CreationDate | Datetime | The timestamp when the attachment was first uploaded. This timestamp provides historical tracking of content additions. |
FileContents | String | The raw content of the attachment, typically used for inline storage of file data in text-based formats. |
ExpirationDate | Datetime | The date when the attachment expires or is scheduled for removal. This date helps in content lifecycle management. |
LastUpdatedByUserName | String | The username of the last user who modified the attachment. This username is useful for tracking recent changes. |
CreatedByUserName | String | The username of the individual who initially uploaded the attachment. This username provides a human-readable identifier for the creator. |
AsyncTrackerId | String | A system-generated identifier used to track the upload process for asynchronous file processing. |
FileWebImage | String | The URL or reference to a web-friendly version of the attachment, typically used for displaying images or previewing files in a browser. |
DownloadInfo | String | A JSON object represented as a string containing metadata and parameters needed to programmatically retrieve a file attachment. This information is used for system integrations and automated file access. |
PostProcessingAction | String | The name of the action that can be performed after an attachment is uploaded. This can include actions such as validation, conversion, or notification triggers. |
Finder | String | The name of the predefined finder query used to retrieve attachments dynamically. Finders help optimize attachment searches based on criteria such as associated ideas or upload dates. |
IdeaId | Long | The unique identifier of the idea associated with this attachment. This identifier establishes a direct relationship between an idea and its supporting documents. |