Thursday, February 14, 2013

HRMS Tables


Oracle HRMS Table Name
Table Description
HR_ALL_ORGANIZATION_UNITS
Organization unit definitions.
HR_ALL_ORGANIZATION_UNITS_TL
Translated organization unit name definitions.
HR_ALL_POSITIONS_F
Position definition information.
HR_ALL_POSITIONS_F_TL
Translation table
HR_API_TRANSACTIONS
Kiosk processes in progress
HR_API_TRANSACTION_STEPS
Kiosk workflow data rows
HR_API_TRANSACTION_VALUES
Kiosk workflow data columns and values
HR_ASSIGNMENT_SETS
Formula definitions that identify sets of assignments.
HR_ASSIGNMENT_SET_AMENDMENTS
Identifies explicit include and exclude rules for an assignment set.
HR_ASSIGNMENT_SET_CRITERIA
Identifies individual criteria in the definition of an assignment set.
HR_DM_SEQUENCE_DEFINITIONS
Table containing Sequence Name information for the PER/PAY/DT/FF/OTA/SSP/GHR/HXT/BEN applications.
HR_DM_SEQUENCE_HISTORIES
Table containing sequence information from the different Fidelity databases. To be updated before any changes to sequences are made to enable sequence history tracking.
HR_LEGISLATION_INSTALLATIONS
Status of each product/legislation combination installed
HR_LOCATIONS_ALL
Work location definitions.
HR_LOCATIONS_ALL_TL
Translated location codes and descriptions.
HR_LOCATION_EXTRA_INFO
Extra information for a location.
HR_LOCATION_INFO_TYPES
Types of extra information that may be held against a Location.
HR_NAME_FORMATS
Contains the format masks used to determine the displayed formats of personal names in Applications. Oracle will seed rows in this table which cannot be deleted, but can be modified by customers. Additional rows can be created.
HR_ORGANIZATION_INFORMATION
Additional attributes of an organization, dependent on class or organization information type.
HR_ORG_INFORMATION_TYPES
Information types that are used to add information for an organization.
HR_ORG_INFO_TYPES_BY_CLASS
Defines organization information types for specific organization classifications.
HR_SOFT_CODING_KEYFLEX
Legislation specific information for payrolls, organizations and assignments.
PER_ABSENCE_ATTENDANCES
Records of absence, or attendance for an employee.
PER_ABSENCE_ATTENDANCES_EFC
This is a copy of the PER_ABSENCE_ATTENDANCES  table which is populated by the EFC (Euro as Functional Currency) process.
PER_ABSENCE_ATTENDANCE_TYPES
User defined absence types.
PER_ABS_ATTENDANCE_REASONS
Valid absence reasons for an absence type.
PER_ABS_ATTENDANCE_TYPES_TL
Holds translated information for Absence Types
PER_ADDRESSES
Address information for people.
PER_ALL_ASSIGNMENTS_F
Employee and applicant assignment details.
PER_ALL_PEOPLE_F
DateTracked table holding personal information for employees, applicants and other people.
PER_ALL_POSITIONS
Dual-maintained position definition information.
PER_ALL_VACANCIES
Vacancies within a specific requisition.
PER_ANALYSIS_CRITERIA
Flexfield combination table for the personal analysis key flexfield.
PER_APPLICATIONS
Applications for employment.
PER_APPRAISALS
An  appraisal is a record of an evaluation of a person by others.
PER_COMPETENCES
A competence is a definition of knowledge, skills, abilities or other charactaristics that a person may possess.
PER_COMPETENCES_TL
This table is used for language translations
PER_COMPETENCE_DEFINITIONS
COMPETENCES Key flexfield combinations table
PER_COMPETENCE_ELEMENTS
A competence element is used to record an individual competence and an evaluation rating.
PER_COMPETENCE_OUTCOMES
Competence outcomes
PER_COMP_ELEMENT_OUTCOMES
The outcomes achieved towards a given Competency .
PER_CONTACT_EXTRA_INFO_F
Extra information for a contact relationship.
PER_CONTACT_INFO_TYPES
Types of extra information that may be held against a contact relationship.
PER_GRADES
Grade definitions for a business group.
PER_GRADES_TL
Trnslated fields for per_grades
PER_GRADE_DEFINITIONS
Grade key flexfield combinations table.
PER_IMAGES
Images for a designated row in a designated table.
PER_INFO_TYPE_SECURITY
Cross table between Responsibilty and Info_type tables, used to secure info types based on responsibility.
PER_JOBS
Jobs defined for a Business Group.
PER_JOBS_TL
Translated  columns for per_jobs
PER_JOB_DEFINITIONS
Job key flexfield combinations table.
PER_JOB_EVALUATIONS
Job evaluation details for specific jobs or positions.
PER_JOB_EXTRA_INFO
Extra information for a job.
PER_MEDICAL_ASSESSMENTS
Hold Medical Assessment information for one person
PER_PAY_BASES
Definitions of specific salary bases.
PER_PAY_PROPOSALS
Salary proposals and performance review information for employee assignments.
PER_PERIODS_OF_SERVICE
Period of service details for an employee.
PER_PERSON_ANALYSES
Special information types for a person.
PER_PERSON_TYPES
Person types visible to specific Business Groups.
PER_PERSON_TYPES_TL
Translated person types information.
PER_PERSON_TYPE_USAGES_F
Identifies the types a person may be.
PER_PHONES
PER_PHONES holds phone numbers for current and ex-employees, current and ex-applicants and employee contacts.
PER_POSITION_DEFINITIONS
Combinations of segments stored in the PER_POSTIONS table.
PER_POSITION_EXTRA_INFO
Extra information for a position.
PER_POSITION_INFO_TYPES
Types of extra information that may be held against a position.
PER_POSITION_STRUCTURES
Position Hierarchy names.
PER_POS_STRUCTURE_ELEMENTS
Position hierarchy details showing parent-child reporting relationships between positions.
PER_PREVIOUS_EMPLOYERS

PER_QUALIFICATIONS
A record of educational qualification, certificates, licenses, etc that a person holds or is acquiring.
PER_QUALIFICATIONS_TL
Translated qualification details.
PER_QUALIFICATION_TYPES
Maintains the list of qualiification types that can be attained.
PER_QUALIFICATION_TYPES_TL
Maintains the list of qualiification type translations
PER_SPECIAL_INFO_TYPES
Special information types available to a Business Group.
PER_SPECIAL_INFO_TYPE_USAGES
Limits usage of special information types to specific windows.
PER_VALID_GRADES
Lists valid grades for jobs and positions.
PER_WORK_INCIDENTS
Holds information on Incidents that happen at work or en route to work, for example, an industrial accident
PER_WORK_INCIDENTS_EFC
This is a copy of the PER_WORK_INCIDENTS  table which is populated by the EFC (Euro as Functional Currency) process.


No comments:

Post a Comment

Best Blogger TipsGet Flower Effect