نموذج طلب استئذان .Iنموذج طلب استئذان رقم الموظف: اسم الموظف: االدارة: يوم االستئذان: بداية االستئذان: / / نهاية االستئذان: عدد ساعات االستئذان: التوقيع التاريخ .IIموافقة مدير االدارة التوقيع التاريخ .IIIإدارة الموارد البشرية مالحظات: التوقيع التاريخ نموذج طلب اجازة .Iبيانات الموظف: اسم الموظف: االدارة: رقم الموظف: تاريخ االلتحاق بالعمل: نوع االجازة:
Premium Overtime Leave Human resources
Conceptual Design For a Strategic Human Resources Quality Management System Dr. Sherif A. Mazen (*) Dina I. El-Kayaly (*) ABSTRACT As companies begin to compete in the challenging business environment of the new millennium‚ an ever-increasing reason for success lies in the function of effective human resource management (HRM). Controlling these resources (physical‚ organizational‚ information and human) gives the company the competitive advantage. The main purpose of this paper is to deliver a decision
Premium Human resources Human resource management Management
Scorelogix® India Global Talent Management Experts By Kiran Srinivas K 8/22/2006 -1- Scorelogix® India Global Talent Management Experts 1. INTRODUCTION Induction is a systematic process‚ which enables new employees to become familiar with their job‚ the PCT‚ and the other people with whom they will be working. Induction is equally important for staffs that move jobs within the PCT as for new starters. 2. PURPOSE Systematic induction will: 2.1 Introduce new employees
Premium Employment Human resource management Occupational safety and health
SEPARATED MOTHER ’S MAIDEN NAME MOBILE PHONE No. HOME TEL. No. TIN BIRTHDATE mm dd BIRTHPLACE yyyy Pag-IBIG ID No. SSS/GSIS ID No. COMPANY/EMPLOYER NAME COMPANY/EMPLOYER ADDRESS (Pls. indicate complete address) FOR AFP EMP-SERIAL/ACCOUNT No. FOR DECS EMP - DIV. CODE/STATION CODE/ EMPLOYEE No. OFFICE TEL. NO. TYPE OF LOAN LOAN PURPOSE NEW RENEWAL PAYMENT OF HOUSING LOAN ARREARAGES (Mo.Yr.) FROM(Mo./Yr.) TO (Mo./Yr.) OTHER HOUSINGRELATED NONHOUSING RELATED EMPLOYMENT HISTORY FROM DATE
Premium Debt Loan Default
all the information of the EMP table? A) select * from emp; 2. Display unique Jobs from EMP table? A) select distinct job from emp; B) select unique job from emp; 3. List the emps in the asc order of their Salaries? A) select * from emp order by sal asc; 4. List the details of the emps in asc order of the Dptnos and desc of Jobs? A)select * from emp order by deptno asc‚job desc; 5. Display all the unique job groups in the descending order? A)select distinct job from emp order by job desc; 6. Display
Premium Salary
Questions 1. Display all information in the tables EMP and DEPT. SELECT * FROM emp; SELECT * FROM dept; 2. 3. 4. 5. 6. 7. Display only the hire date and employee name for each employee. SELECT hiredate‚ ename FROM emp; Display the hire date‚ name and department number for all clerks. SELECT hiredate‚ ename‚ deptno FROM emp WHERE job = ’CLERK’; Display the names and salaries of all employees with a salary greater than 2000. SELECT ename‚ sal FROM emp WHERE sal > 2000; Display the names of all employees
Premium SQL Employment
loc VARCHAR2(20) No No Ans: CREATE TABLE dept (deptno NUMBER(2) NOT NULL‚ dname VARCHAR2(30) NOT NULL‚ loc VARCHAR2(20) CONSTRAINT deptno_pk PRIMARY KEY (deptno)); b. Table name: EMP i. Column datatype Mandatory? PK? FK? Empno NUMBER(4) Yes Yes
Premium Output Data Member of Parliament
3 Section-B(PL/SQL) 16. Write a Pl/Sql program to raise the employee salary by 30%‚ who have completed their 40 years of service. declare cursor c3 is select * from emp where extract(year from sysdate)-extract(year from hiredate)>40 for update; e emp%rowtype; begin open c3; loop fetch c3 into e; exit when c3%notfound; update emp set sal=e.sal+(30/100)*e.sal where current of c3; end loop; close c3; end; / 17. Write a Pl/Sql program to check the given number is Armstrong ‘or’ not. declare n number(3);
Premium SQL
effects of expansionary and contractionary policy on income inequality. Expansionary Monetary Policy: Expansionary monetary policy (EMP) is a policy through which the central bank increases the money supply in an effort to boost economic activity in a country. The short and long-run effects of EMP are important in analyzing its effects on income inequality. EMP affects individuals differentially as individuals earn income from different sources. Most individuals earn income through labour while
Premium Inflation Monetary policy Economics
Oracle/SQL Tutorial1 Michael Gertz Database and Information Systems Group Department of Computer Science University of California‚ Davis gertz@cs.ucdavis.edu http://www.db.cs.ucdavis.edu This Oracle/SQL tutorial provides a detailed introduction to the SQL query language and the Oracle Relational Database Management System. Further information about Oracle and SQL can be found on the web site www.db.cs.ucdavis.edu/dbs. Comments‚ corrections‚ or additions to these notes are welcome. Many
Premium SQL