PersonNotes
PersonNotes
Columns
| Name | Type | Description |
| NoteId [KEY] | Long | System-generated primary key of the note. |
| AuthorId | Long | Person identifier of the author of the note. |
| AuthorNumber | String | Unique person identifier of the author of the note. |
| WorkerId | Long | Person identifier of the worker who's the subject of the note. |
| WorkerNumber | String | Unique person identifier of the worker who's the subject of the note. |
| ContextType | String | Context type of the note. Supply value is ORA_NO_CONTEXT. |
| NoteText | String | Text of the note. |
| NoteVisibilityCode | String | Visibility of the note. Valid options are: ALL, MANAGERS, MANAGERS_AND_SUBJECT, PRIVATE, SUBJECT, MANAGERS_SUBJECT_PEERS. Administrators can remove any of the options via configuration for the specified context type. |
| ContextId | Long | Context identifier of the note. |
| ContextType2 | String | Additional context type of the note. |
| ContextId2 | Long | Additional context identifier of the note. |
| HiddenFlag | Bool | Indicates whether the note is hidden or shown. The default value is Show. |
| CreatedBy | String | User who created the note. |
| LastUpdateDate | Datetime | Date and time when the note was last updated. |
| LastUpdatedBy | String | User who last updated the note. |
| CreationDate | Datetime | Date and time when the note was created. |
| AuthorName | String | Name of the note author. |
| WorkerName | String | Name of the worker who's the subject of the note. |
| AuthorKnownAs | String | Preferred name of the author of the note. |
| WorkerKnownAs | String | Preferred name of the worker who's the subject of the note. |
| HideShowNonRecipientFlag | Bool | Indicates whether a user who isn't the recipient or the author of the note has the Hide or Show privilege. The default value is false. |
| DeleteNonAuthorFlag | Bool | Indicates whether a user who isn't the author of the note has the Delete privilege. The default value is false. |
| ThankYouFlag | Bool | Indicates whether the user can send a thank you note. The default value is false. |
| ForeignKeyReferenceFlag | Bool | Indicates whether another application has created a reference to a note. The default value is false. |
| NoteVisibilityMeaning | String | Meaning of the visibility code. |
| CardTitle | String | Card title of a celebration note. |
| ImageReferenceURL | String | Image reference URL of a celebration note. |
| HideShowFlag | Bool | Indicates whether a user has the Hide or Show privilege. The default value is false. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| CheckInMeetingId | Long | CheckInMeetingId |
| SysEffectiveDate | String | SysEffectiveDate |
| Finder | String | finder |