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 |