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 |