PER — Human Resources
592 documented tables · 734 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
HR_ALL_ORGANIZATION_UNITS |
Organization unit definitions. | hub |
HR_LOCATIONS_ALL |
Work location definitions. | hub |
HR_SOFT_CODING_KEYFLEX |
Legislation specific information for payrolls, organizations and assignments. | hub-leaning |
HR_EFC_ACTIONS |
Contains one row for each time the EFC conversion process or delete _EFC table data process is run. | hub |
PER_JOB_GROUPS |
Holds Job Group Information. Each Job will be a member of a Job Group and a Job Group can optionally be within | hub |
PER_JOBS |
Jobs defined for a Business Group. | hub |
HR_FORM_WINDOWS_B |
Definition of windows for use in configurable forms | hub-leaning |
PER_WORK_INCIDENTS |
Holds information on Incidents that happen at work or en route to work, for example, an industrial accident | hub-leaning |
HR_FORM_CANVASES_B |
Canvas definition for configurable forms | hub |
PER_ALL_POSITIONS |
Dual-maintained position definition information. | hub |
PER_ORGANIZATION_STRUCTURES |
Organization hierarchy names. | hub |
PER_SECURITY_PROFILES |
Security profile definitions to restrict user access to specific HRMS records. | hub |
PER_TIME_PERIOD_TYPES |
Predefined list of valid period types for payroll and HR budget calendars. | hub |
HR_FORM_TEMPLATES_B |
Definition of template used by configurable forms | hub |
HR_FORM_TAB_PAGES_B |
Definition of form tab page for configurable forms | hub |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
PER_WORK_INCIDENT_API |
API | 3 | 10 packages |
PER_SUPPLEMENTARY_ROLE_API |
API | 3 | 9 packages |
PER_EVENTS_API |
API | 3 | 8 packages |
PER_DISABILITY_API |
API | 3 | 7 packages |
PER_HIERARCHY_NODES_API |
API | 4 | 6 packages |
PER_OTHERBG_APL_API |
API | 5 | 6 packages |
PER_QUALIFICATIONS_API |
API | 3 | 6 packages |
PER_HIERARCHY_API |
API | 4 | 4 packages |
PER_MEDICAL_ASSESSMENT_API |
API | 3 | 4 packages |
PER_RI_CONFIGURATION_API |
API | 3 | 4 packages |