JDBC Driver for Oracle Fusion Cloud HCM

Build 24.0.9062

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 CreatedBy of PersonNotes
LastUpdateDate Datetime LastUpdateDate of PersonNotes
LastUpdatedBy String LastUpdatedBy of PersonNotes
CreationDate Datetime CreationDate of PersonNotes
AuthorName String AuthorName of PersonNotes
WorkerName String WorkerName of PersonNotes
AuthorKnownAs String AuthorKnownAs of PersonNotes
WorkerKnownAs String WorkerKnownAs of PersonNotes
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.
CheckInMeetingId Long CheckInMeetingId of PersonNotes
ContextTypeDB String ContextTypeDB of PersonNotes
Finder String Finder of PersonNotes
SysEffectiveDate String SysEffectiveDate of PersonNotes

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