AbsencesabsenceAttachments
AbsencesabsenceAttachments
Columns
| Name | Type | Description |
| AbsencespersonAbsenceEntryId [KEY] | Long | AbsencespersonAbsenceEntryId of AbsencesabsenceAttachments |
| AttachedDocumentId [KEY] | Long | Surrogate identifier for the record. Applicable to existing records only. |
| LastUpdateDate | Datetime | LastUpdateDate of AbsencesabsenceAttachments |
| LastUpdatedBy | String | LastUpdatedBy of AbsencesabsenceAttachments |
| DatatypeCode | String | Attachment type such as FILE, TEXT, or WEB_PAGE. |
| FileName | String | Name of the file attached by the user. |
| DmFolderPath | String | Path of the folder where the attachment is stored. |
| DmDocumentId | String | Unique identifier for the document created in UCM directory. |
| DmVersionNumber | String | Version number of the attachment. |
| Url | String | Uniform Resource Identifier of the document attachment. |
| CategoryName | String | Category name for the absence attachment type such as MISC. |
| UserName | String | UserName of AbsencesabsenceAttachments |
| Uri | String | Uniform Resource Identifier of the uploaded file. |
| FileUrl | String | Relative path for downloading the attachment file. |
| UploadedText | String | Text that is uploaded to the content repository. |
| UploadedFileContentType | String | Type of the content file uploaded such as plain/text, image/jpeg etc. |
| UploadedFileLength | Long | Length of the content file uploaded. |
| UploadedFileName | String | Name of uploaded file. |
| ContentRepositoryFileShared | Bool | Indicates whether the file can be shared from the content repository. The default value is false. |
| Title | String | Title of the attachment. |
| Description | String | Description of the attachment. |
| ErrorStatusCode | String | Status code of the error. |
| ErrorStatusMessage | String | Error message that is displayed. |
| CreatedBy | String | CreatedBy of AbsencesabsenceAttachments |
| CreationDate | Datetime | CreationDate of AbsencesabsenceAttachments |
| FileContents | String | Attribute for providing the file content. |
| ExpirationDate | Datetime | Expiry date of the absence record attachment. |
| LastUpdatedByUserName | String | LastUpdatedByUserName of AbsencesabsenceAttachments |
| CreatedByUserName | String | CreatedByUserName of AbsencesabsenceAttachments |
| AsyncTrackerId | String | Attribute provided for the exclusive use by the Attachment UI components to assist in uploading files. |
| FileWebImage | String | FileWebImage of AbsencesabsenceAttachments |
| DownloadInfo | String | JSON object represented as a string containing information used to programmatically retrieve a file attachment. |
| DatatypeCodeMeaning | String | DatatypeCodeMeaning of AbsencesabsenceAttachments |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| AbsenceTypeId | Long | absenceTypeId |
| EndDate | Date | endDate |
| Finder | String | finder |
| PersonAbsenceEntryId | Long | personAbsenceEntryId |
| PersonId | Long | personId |
| StartDate | Date | startDate |