Oracle HRMS Database |
|
HRMS Database tables: HR Work structures PER Personnel and Assignment PAY Compensation and Benefits BEN Benefit related information FF 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. 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. 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 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_F PAY_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: 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. Trackback(0)
Comments (0)
 Write comment
|
TrackBack URI for this entry
Subscribe to this comment's feed
| < Prev | Next > |
|---|