WorkConfirmationsattachments
Associates files (for example, progress photos, sign-off sheets) with a work confirmation, substantiating the claimed progress or deliverables.
Columns
| Name | Type | Description |
| WorkConfirmationsWorkConfirmationId [KEY] | Long | The unique identifier for the work confirmation associated with this attachment. It links the attachment to a specific work confirmation record. |
| AttachedDocumentId [KEY] | Long | The unique identifier of the document attached to the work confirmation. This ID helps associate the attachment with its corresponding document in the system. |
| LastUpdateDate | Datetime | The date and time when the record was last updated. This timestamp is important for tracking when the attachment record was last modified. |
| LastUpdatedBy | String | The user who last updated the attachment record. This provides accountability and helps trace any changes made to the attachment. |
| DatatypeCode | String | A value that indicates the data type of the attachment. This code specifies the type of data stored within the attachment, such as 'image', 'PDF', or 'text'. |
| FileName | String | The name of the attachment file. This is used to identify the file in the system and helps with file management and retrieval. |
| DmFolderPath | String | The folder path from which the attachment was created. This specifies the location of the document management folder that contains the attachment. |
| DmDocumentId | String | The document ID associated with the attachment. This helps identify the specific document in the document management system from which the attachment was created. |
| DmVersionNumber | String | The version number of the document associated with the attachment. This ensures that the correct version of the document is linked to the attachment. |
| Url | String | The URL for the attachment, especially for web-based attachments. This URL points to the online location where the attachment can be accessed or viewed. |
| CategoryName | String | The category of the attachment. This helps organize and classify attachments into different types, such as 'Invoice', 'Contract', or 'Report'. |
| UserName | String | The login credentials of the user who created the attachment. This attribute helps identify the user responsible for uploading the file. |
| Uri | String | The URI (Uniform Resource Identifier) of the attachment, especially for Topology Manager-type attachments. This provides a reference to the location of the attachment. |
| FileUrl | String | The URL or path that directly points to the attachment file. This is used for file retrieval and access. |
| UploadedText | String | The text content for a new text attachment. This is used when the attachment is a text-based document and allows users to upload textual data directly. |
| UploadedFileContentType | String | The content type of the uploaded file, indicating its format. |
| UploadedFileLength | Long | The size of the attachment file, measured in bytes. This helps determine the storage space required for the attachment. |
| UploadedFileName | String | The name given to the uploaded attachment file. This helps in file management and ensuring the file is named appropriately for its content. |
| ContentRepositoryFileShared | Bool | Indicates whether the attachment is shared across multiple users or systems. If true, the file is shared; otherwise, it is private. |
| Title | String | The title of the attachment. This provides a brief, descriptive name for the attachment that helps users understand its content. |
| Description | String | A more detailed description of the attachment. This field helps provide context and additional information about the attachment's purpose or contents. |
| ErrorStatusCode | String | The error code, if any, associated with the attachment. This code helps identify any issues that occurred during the upload or processing of the attachment. |
| ErrorStatusMessage | String | The error message, if any, related to the attachment. This provides a human-readable explanation of the error encountered during processing. |
| CreatedBy | String | The user who created the attachment record. This field helps track the origin of the record and provides accountability. |
| CreationDate | Datetime | The date and time when the attachment record was created. This helps track when the file was initially uploaded into the system. |
| FileContents | String | The contents of the attachment, typically used for text or encoded file data. This field stores the actual content of the attachment. |
| ExpirationDate | Datetime | The expiration date of the attachment's contents. This indicates when the attachment's data will no longer be valid or accessible. |
| LastUpdatedByUserName | String | The user name of the person who last updated the record. This attribute helps with accountability and audit tracking. |
| CreatedByUserName | String | The user name of the person who created the attachment record. This helps with tracking who initiated the attachment process. |
| AsyncTrackerId | String | An identifier used by the Attachment UI components for tracking the asynchronous upload process. This helps monitor file uploads. |
| FileWebImage | String | The Base64 encoded image of the attachment, displayed as a .png format if the source file is convertible to an image. |
| DownloadInfo | String | A JSON-formatted string containing necessary information to programmatically retrieve large file attachments. This helps manage file downloads. |
| PostProcessingAction | String | The name of the action to be performed after the attachment is uploaded, such as 'validate', 'archive', or 'approve'. |
| Finder | String | A general-purpose search or filter attribute for locating specific work confirmation attachments in the system. |
| Intent | String | The intent or purpose of the attachment, which helps categorize or clarify its use in the work confirmation process. |
| SysEffectiveDate | String | The system effective date, used to fetch records that are effective as of a specified date. This helps retrieve attachments based on their validity date. |
| WorkConfirmationId | Long | The unique identifier of the work confirmation. This ID links the attachment to a specific work confirmation record. |
| EffectiveDate | Date | The date used for querying attachments that are effective as of the specified start date. This ensures data is retrieved according to its valid time range. |