TalentPersonProfileshonorSectionshonorItemshonorItemAttachments
TalentPersonProfileshonorSectionshonorItemshonorItemAttachments
Columns
Name | Type | Description |
TalentPersonProfilesProfileId [KEY] | Long | Surrogate identifier for the person profile. |
HonorsectionsProfileSectionId [KEY] | Long | Surrogate identifier for the honor section. |
HonoritemsHonorId [KEY] | Long | Surrogate identifier for the honor item. |
AttachedDocumentId [KEY] | Long | Surrogate identifier for the attachment document of the certification item. |
LastUpdateDate | Datetime | Date and time when the attachment was last updated. |
LastUpdatedBy | String | User who last updated the attachment. |
DatatypeCode | String | Attachment Type such as FILE, TEXT, or WEB_PAGE. |
FileName | String | Name of the attachment file. |
DmFolderPath | String | Path of the folder. |
DmDocumentId | String | Unique identifier of the document. |
DmVersionNumber | String | Version number of the attachment. |
Url | String | URL of the attachment. |
CategoryName | String | Category name of the attachment. |
UserName | String | User name of person who uploaded the attachment. |
Uri | String | URI of the attachment. |
FileUrl | String | File URL of the attachment. |
UploadedText | String | Text uploaded in the attachment. |
UploadedFileContentType | String | Content type of the uploaded file. |
UploadedFileLength | Long | Length of the uploaded file. |
UploadedFileName | String | Name of the uploaded file. |
ContentRepositoryFileShared | Bool | Content repository file shared. |
Title | String | Title of the attachment. |
Description | String | Description of the attachment. |
ErrorStatusCode | String | Error status code of the attachment. |
ErrorStatusMessage | String | Error status message of the attachment. |
CreatedBy | String | User who created the attachment. |
CreationDate | Datetime | Date and time when the attachment was created. |
FileContents | String | File contents of the attachment. |
ExpirationDate | Datetime | Expiration date of the attachment. |
LastUpdatedByUserName | String | User name of the user who last updated the attachment. |
CreatedByUserName | String | User name of the user who created the attachment. |
AsyncTrackerId | String | Attribute provided for the exclusive use by the Attachment UI components to assist in uploading files. |
FileWebImage | String | Base64 encoded image of the file displayed in .png format if the source is a convertible image. |
DownloadInfo | String | JSON object represented as a string containing information used to programmatically retrieve a file attachment. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
Group | String | Group |
PersonId | Long | PersonId |
ProfileId | Long | ProfileId |
SysEffectiveDate | String | SysEffectiveDate |
Finder | String | finder |