1. Tables and Views for HCM
  2. PER_ASSIGNMENT_NOTES_V

PER_ASSIGNMENT_NOTES_V

Details

  • Schema: FUSION

  • Object owner: PER

  • Object type: VIEW

Columns

Name

ASSIGNMENT_NOTE_ID

ASSIGNMENT_ID

ASG_EFFECTIVE_START_DATE

ASG_EFFECTIVE_SEQUENCE

ASG_ACTION_OCCURRENCE_ID

PERSON_ID

RECORD_CREATOR

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

NOTES

Query

SQL_Statement

SELECT ASSIGNMENT_NOTE_ID,

ASSIGNMENT_ID,

ASG_EFFECTIVE_START_DATE,

ASG_EFFECTIVE_SEQUENCE,

ASG_ACTION_OCCURRENCE_ID,

PERSON_ID,

RECORD_CREATOR,

OBJECT_VERSION_NUMBER,

CREATED_BY,

CREATION_DATE,

LAST_UPDATED_BY,

LAST_UPDATE_DATE,

LAST_UPDATE_LOGIN,

NOTES

FROM per_assignment_notes