HRT_NOTES_FOR_PERSON_SEC_V

Details

• Schema: FUSION

• Object owner: HRT

• Object type: VIEW

Columns

Name

OBJECT_VERSION_NUMBER ENTERPRISE_ID NOTE_ID OBJECT_TYPE OBJECT_ID CONTEXT_TYPE CONTEXT_TYPE2 CONTEXT_ID CONTEXT_ID2 CREATED_BY LAST_UPDATE_DATE NOTE_TEXT NOTE_TEXT_AUDIT NOTE_LAST_UPDATE_DATE AUTHOR_ID NOTE_TYPE_CODE LAST_UPDATED_BY NOTE_CREATION_DATE LAST_UPDATE_LOGIN NOTE_VISIBILITY_CODE CONTEXT_NAME_VO CONTEXT_NAME_VO2 CREATION_DATE HIDDEN_FLAG CARD_TITLE IMAGE_REFERENCE_URL REFERENCE_COUNT PERSON_ID

Query

SQL_Statement

SELECT HRT_NOTES.OBJECT_VERSION_NUMBER, HRT_NOTES.ENTERPRISE_ID, HRT_NOTES.NOTE_ID, HRT_NOTES.OBJECT_TYPE, HRT_NOTES.OBJECT_ID, HRT_NOTES.CONTEXT_TYPE, HRT_NOTES.CONTEXT_TYPE2, HRT_NOTES.CONTEXT_ID, HRT_NOTES.CONTEXT_ID2, HRT_NOTES.CREATED_BY, HRT_NOTES.LAST_UPDATE_DATE, HRT_NOTES.NOTE_TEXT, HRT_NOTES.NOTE_TEXT_AUDIT, HRT_NOTES.NOTE_LAST_UPDATE_DATE, HRT_NOTES.AUTHOR_ID, HRT_NOTES.NOTE_TYPE_CODE, HRT_NOTES.LAST_UPDATED_BY, HRT_NOTES.NOTE_CREATION_DATE, HRT_NOTES.LAST_UPDATE_LOGIN, HRT_NOTES.NOTE_VISIBILITY_CODE, HRT_NOTES.CONTEXT_NAME_VO, HRT_NOTES.CONTEXT_NAME_VO2, HRT_NOTES.CREATION_DATE, HRT_NOTES.HIDDEN_FLAG, HRT_NOTES.CARD_TITLE, HRT_NOTES.IMAGE_REFERENCE_URL, HRT_NOTES.REFERENCE_COUNT, PER_PERSONS.PERSON_ID FROM HRT_NOTES HRT_NOTES, PER_PERSONS PER_PERSONS where HRT_NOTES.OBJECT_ID = PER_PERSONS.PERSON_ID and HRT_NOTES.OBJECT_TYPE = 'PER_PERSON'