EmployeeResourceAttachments
The contact picture attachment resource is used to view, create, and update the resource's picture.Get a resource's picture
Columns
| Name | Type | References | Description |
| AttachedDocumentId [KEY] | Long | This is the hash key of the attributes which make up the composite key--- AttachedDocumentId and DocumentId1 ---for the Attachments resource and used to uniquely identify an instance of Attachments. The client should not generate the hash key value. Instead, the client should query on the Attachments collection resource with a filter on the primary key values in order to navigate to a specific instance of Attachments. | |
| PartyNumber [KEY] | String | The unique identifier for the resource party. | |
| ContentRepositoryFileShared | Boolean | Indicates if the attachment is shared. | |
| CreatedBy | String | The user who uploaded the picture attachment. | |
| CreationDate | Datetime | The date when the picture attachment was uploaded. | |
| DatatypeCode | String | The data type for the picture attachment. | |
| Description | String | The description of the picture attachment. | |
| DmFolderPath | String | The folder path where the picture attachment exists. | |
| ErrorStatusCode | String | The error code, if any, for the attachment. | |
| ErrorStatusMessage | String | The error message, if any, for the attachment. | |
| ExpirationDate | Datetime | The expiration date of the contents in the attachment. | |
| FileContents | String | The contents of the attachment. | |
| FileName | String | The name of the attachment file. | |
| FileUrl | String | The URL of the attachment file. | |
| LastUpdateDate | Datetime | The date when the record was last updated. | |
| LastUpdatedBy | String | The user who last updated the record. | |
| Title | String | The title of the attachment. | |
| UploadedFileContentType | String | The content type of the attachment. | |
| UploadedFileLength | Long | The length of the attachment file. | |
| UploadedFileName | String | The name of the attachment file. | |
| UploadedText | String | The text uploaded in the attachment. | |
| Uri | String | The URI of the attachment. | |
| Url | String | The URL of the attachment. | |
| UserName | String | The login associated with the attachment. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| Finder | String | Input specifying the Finder type. | |
| EmailAddress | String | The e-mail address of the resource. | |
| BindSysdate | String | The identifier for the resource based on the manager reports flag. | |
| PartyId | String | The unique identifier for the resource party. | |
| ResourceProfileId | String | The unique primary key identifier for the resource profile. |