Fusion HCM - For Starters

Here are few terminologies in Fusion that we need to look at - 

• Legal Employer - an entity that employs the workers. A legal employer is captured at the work relationship level. And all the employment terms and assignments within that relationship will automatically get assigned to that legal employer.

Top 5 Mistakes while implementing ERP

The promises of an integrated ERP (Enterprise Resource Planning) solution can inspire any business owner to approve a costly, time-consuming planning and execution process.  However, not all ERP implementations are successful; many end in frustration, failure and wasted resources. To prevent a disaster with your implementation, arm yourself with the right resources to avoid failure, including this article from Software ThinkTank (thinktank.net).

Thinking through the Top 5 Mistakes made when implementing an ERP system, we can identify the common problem areas most customers face and take the proper steps to avoid them.

Extracting maximum benefit out of you Payroll Data

Unused or underutilized payroll data causes wasted HR staff time, as duplicated efforts and work often ensue to make up for this data gap. Here are several significant areas where your HRMS payroll data can add value to your business:

Oracle SQL Statement Types and Usage - Part III

Data Control Language (DCL) 

The Data Control Language (DCL) is a subset of the Structured Query Lanaguge (SQL) that allows database administrators to configure security access to relational databases.Two types of DCL commands are GRANT and REVOKE. Only Database Administrator’s or owner’s of the database object can provide/remove privileges on a database object.

GRANT:
Gives user’s access privileges to database.

Oracle SQL Statement Types and Usage - Part II

Data Retrieval or Query Language (DQL or DRL) :

SELECT clause will come under this category. Main usage of select to identify the result set column list.

Oracle SQL Statement Types and Usage - Part I

Let me introduce SQL by statements type, here statements defines set of commands. Generally statements can fall under the following category

• Data definition Language (DDL)
• Data Retrieval or Query Language (DQL or DRL)
• Data Manipulation Language (DML)
• Data Control Language (DCL)
• Transaction Control Language (TCL)