August 5, 2010

HRMS BASICS

Functional setups Needed:



Administration:  Define Key Flexfields,Descriptive Flexfields,Extra Information Types(EITs), currencies, “View All” HRMS User, lookups and Application Data Exchange (ADE).

Work Structures: Define Key Flexfields with organizations, jobs, positions, grades and payrolls

❑ Compensation and Benefits (Optional):Payroll elements descriptions are included.compensation elements, input value validation, balances,formulas, salary administration, absence management/accruals of paid time off and element sets.

❑ Total Compensation: (Optional)Includes online benefits services, benefits eligibility, eligibility factors, life events, program setup and flex credits calculations.

❑ People and Assignments: (Required)Includes person types, assignment statuses and special personal information.

❑ Specific Business Functions: (Optional)Includes human resource budgets, evaluation systems and requirements matching.Also includes Workers’ Compensation,provincial medical, and vacation banking.

❑ Career and Succession Management: (Optional)Includes recruitment, career management, evaluation and appraisals and succession planning.

Few Concepts To be Noted:-
There are six Key Flexfield Structures you must define before you can


Define a business group in Oracle HRMS. These are:
• Job
• Position
• Grade
• People Group
• Cost Allocation
• Competence


DateTrack:

Keeping History for change in records.i.e The details of a employee needs to be chaged at a point of time,the change can be made with the history of date and time.
This change can be activated form the date that we want and can ahev the previous records also.
The date tracked columns are Effective_Start_date and Effective_end_date.
The types available are:


1.UPDATE – Updated values are written to the database as a new row, effective from today until 31–DEC–4712. The old values remain effective up to and including yesterday.
2.CORRECTION – The updated values override the old record values and inherit the same effective dates.
if UPDATE was selected, DateTrack checks whether the record being updated has already had future updates entered.

UPDATE_CHANGE_INSERT (Insert) – The changes that the user makes remain in effect until the effective end date of the current record. At that point the future scheduled changes take
effect.
UPDATE_OVERRIDE (Replace) – The user’s changes take effect from now until the end date of the last record in the future. All future dated changes are deleted.

Delete The record

When deleting a record, the user is prompted for the type of delete.
There are four options, as follows:
• DELETE (End Date) – The record has its effective end date set to today’s date.
• ZAP (Purge) – This is the total delete. All records matching the key value, whatever their date stamps, are deleted.
• FUTURE CHANGE (All) – This choice causes any future dated changes to the current record,to be removed. The current record has its effective end date set to 31–DEC–4712.
• DELETE NEXT CHANGE (Next Change) – This choice causes the next change to the current DateTracked record to be removed.

No comments:

Post a Comment

Thanks for your comments submitted.,will review and Post soon! by admin.

COALESCE-SQL

Coalesce- return the null values from the expression. It works similar to a case statement where if expression 1 is false then goes to expr...