Some of the important tables and views related to Employee in Fusion HCM. This tables and views will be used when we try to create a custom report for employee.
Person:
PER_ALL_PEOPLE_F
PER_PERSON_NAMES_F_V
PER_PERSON_TYPES_VL
Person Email,User,Address:
PER_USERS
PER_EMAIL_ADDRESSES_V
PER_PERSON_ADDRESSES_V
Assignment:
PER_ALL_ASSIGNMENTS_F
PER_ALL_ASSIGNMENTS_M
PER_ASSIGNMENT_SUPERVISORS_F_V
PER_ASSIGNMENT_STATUS_TYPES_VL
PER_PERIODS_OF_SERVICE_V
Integration Table: This table is used to get the source system id for each object like person,assignment,email,work relationship,Work terms etc. This table will have data when you integrate other system to fusion cloud HCM to load employees into fusion.
HRC_INTEGRATION_KEY_MAP
Grade,Job,Location,Actions:
HR_ORGANIZATION_UNITS
PER_GRADES_F_VL
PER_JOBS_F_VL
HR_ALL_POSITIONS_F_VL
PER_LOCATION_DETAILS_F_VL
PER_ACTIONS_VL
PER_ACTION_REASONS_VL
PER_ACTION_OCCURRENCES