ODBC Driver for Oracle Fusion Cloud HCM

Build 23.0.8839

TalentPersonProfileseducationSectionseducationItemseducationItemAttachments

TalentPersonProfileseducationSectionseducationItemseducationItemAttachments

Columns

Name Type Description
TalentPersonProfilesProfileId [KEY] Long Surrogate identifier for the person profile.
EducationsectionsProfileSectionId [KEY] Long Surrogate identifier for the education section.
EducationitemsEducationId [KEY] Long Surrogate identifier for the education item.
AttachedDocumentId [KEY] Long Surrogate identifier for the attachment document of the education 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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839