Logicwala
Oracle HRMS Database
Oracle HRMS Database Details with discussion and questions to Ponder.
HRMS Database tables:
HR Work structuresPER Personnel and AssignmentPAY Compensation and BenefitsBEN Benefit related
informationFF Fast Formula related
VIEWS IN HRMS Database:
Forms are front-end screens displaying information from various tables. Views are created to collect the same
information in one place. Then the Oracle applications form will call the view to retrieve the data.
This will simplify data presentation to the users of HRMS by hiding underlying tables, views and joins.
Some views are used just to present the current data and not historical data.
Some views are used in multiple forms rather than just one.
Example: PER_PEOPLE_V view retrieves data from HR_LOOKUPS, PER_PERSON_TYPES,
PER_PERIODS_OF_SERVICE tables and PER_PEOPLE view.
PER_PEOPLE_V is used behind the Person form. When we query a person in the Person form, it will bring
i) Last name, First name, Middle name, etc., details from PER_PEOPLE view which in-turn retrieves the data from
PER_PEOPLE_F table.
ii) Type of person like Employee or Ex-Employee from PER_PERSON_TYPES table.
iii) Title of the person from HR_LOOKUPS table.
MAJOR TABLES IN HRMS DATABASE:
HR_LOCATIONS – Definition of locations.
HR_ORGANIZATION_INFORMATION – Additional information about organization based on type of organization
HR_ALL_ORGANIZATION_UNITS – Definition of Organization and its parameters.
HR_ASSIGNMNET_SETS – Definition of Assignment sets.
http://logicwala.com Powered by Joomla! Generated: 23 January, 2011, 05:40
Logicwala
PER_ALL_PEOPLE_F – People related information.
PER_PERSON_TYPES – Types of people like employee, applicant, ex-employee and contact.
PER_CONTACT_RELATIONSHIPS – Relationship between Employee and contacts.
PER_ADDRESSES – Address information of all types of persons.
PER_ABSENCE_ATTENDANCE_TYPES – Types of attendance’s.
PER_ABSENCE_ATTENDANCES – Absence information of employees.
PER_PEOPLE_EXTRA_INFO – Extra information types at the person level.
PER_ASSIGNMENTS_F – Information about employee assignments.
PER_GRADES & PER_GRADE_DEFINITIONS
PER_JOBS & PER_JOB_DEFINITIONS
PER_POSITIONS
PER_ORG_STRUCTURE_ELEMENTS – Organization Hierarchy information.
PER_PAY_PROPOSALS – Salary proposals and performance info at assignment level.
PER_PAY_PROPOSAL_COMPONENTS – Components of Salary proposals.
PER_PEOPLE_INFO_TYPES – Extra information types at a person level.
PER_TIME_PERIODS – Time period details of each pay period as defined in Payroll.
PER_PERIODS_OF_SERVICE – Service details at employee level.PAY_PEOPLE_GROUPS – Information about how
employees are grouped together in the people group flexfield.
PAY_PAYROLLS_F – Define the payroll and its details.
PAY_ELEMENT_CLASSIFICATIONS – Classifying elements based on legislation and other information.
PAY_ELEMENT_TYPES_F – Definition of elements and its parameters.
PAY_ELEMENT_LINKS_F – Definition of element links.
PAY_INPUT_VALUES_F – Definition of input values.
PAY_ELEMENT_ENTRIES_F – Information on Element entry to the assignment.
PAY_ELEMENT_ENTRY_VALUES_F – Values of input values at the assignment level.
PAY_FORMULA_RESULT_RULES -- Rules for some of the fast formula results.
PAY_PAYROLL_ACTIONS --
PAY_ASSIGNMENT_ACTIONS -- PAY_RUN_RESULTS –
PAY_RUN_RESULT_VALUES --
PAY_BALANCE_TYPES --
PAY_BALANCE_FEEDS
PAY_BALANCE_DIMENSIONS – What type of balance: ITD, YTD, QTD, MTD, and PTD
PAY_DEFINED_BALANCES – Relationship or list of dimensions to balance types.
http://logicwala.com Powered by Joomla! Generated: 23 January, 2011, 05:40
Logicwala
PAY_US_EMP_FED_TAX_RULES_F – Federal tax rules at the employee level.
PAY_US_GARN_FEE_RULES_F – Used to hold Garnishment rules.
FND_COMMON_LOOKUPS – Definition of Lookup types.
FND_COMMON_LOOKUP_TYPES – Lookup values for Quickcodes.
ALL_TABLES – List of all tables in HRMS database.
ALL_VIEWS – List of views.
NEW HIRE PROCESS
When a new hire is entered into the HRMS database (either from the web or from the application) the following tables are
affected.
PER_PEOPLE_F
PER_PERIODS_OF_SERVICE
http://logicwala.com Powered by Joomla! Generated: 23 January, 2011, 05:40
Logicwala
PER_PERSON_TYPES
PER_ADDRESSES
PER_ASSIGNMENTS_F
PAY_PEOPLE_GROUPS
PAY_US_EMP_FED_TAX_RULES_F
HR_SOFT_CODING_KEYFLEX
PAY_ELEMENT_ENTRIES_FPAY_ELEMENT_ENTRY_VALUES_F
PAY_US_EMP_STATE_TAX_RULES_F
PAY_US_ASG_REPORTING
PAY_US_EMP_COUNTY_TAX_RULES_F
PAY_US_EMP_CITY_TAX_RULES_F
PER_PAY_PROPOSALS
PER_ASSIGNMENT_EXTRA_INFO
PER_ANALYSIS_CRITERIA
PER_PERSON_ANALYSES
Will show how the tables are changing while making update in HRMS application.
Payroll Process
The following tables are a few of them that are accessed/updated while running a payroll:
Fast Formula tables.
Database Items (DB items)
PAY_RUN_RESULTS
Element related tables.
Tax tables
PER_PERIODS_OF_SERVICE
PER_PEOPLE_F
PER_ASSIGNMENTS_F
Questions to Ponder:
http://logicwala.com Powered by Joomla! Generated: 23 January, 2011, 05:40
Logicwala
Why SOE takes so long to populate data?
How are balances created and what does Custom Balgen do for us?
Why do indexes go away?
How package headers/Package bodies are useful in the Oracle HRMS?
Things that can go wrong in Payroll process.
Date Tracking in the HRMS.
http://logicwala.com Powered by Joomla! Generated: 23 January, 2011, 05:40
