(Human Resource Management System)

Organization & Position

QUERY: SELECT Original, Name, Account, Security, Access1, Access2, Access3, Access4, Access5 FROM Department

SELECT Original, Name, Level FROM Position

Payroll Base

Note Payroll Code as payroll, rent, hardship allowance, travel allowance, over time, fuel, tax, provident fund

QUERY: SELECT PayrollBase.Original, PayrollBase.Department, PayrollBase.Position, PayrollBase.JobClass, PayrollBase.Salary, PayrollGroupMaster.PayrollCode, PayrollGroupMaster.PerUnit, PayrollGroupMaster.RateFlag, PayrollGroupMaster.TaxFlag, PayrollGroupMaster.PayrollType, PayrollGroupMaster.RateOrAmount FROM PayrollBase, PayrollGroupMaster WHERE PayrollBase.Original=PayrollGroupMaster.Original and PayrollBase.Department =PayrollGroupMaster.Department and PayrollBase.Position = PayrollGroupMaster.Position and PayrollBase.JobClass = PayrollGroupMaster.JobClass

Welfare

QUERY: SELECT Original, ContractOriginal, ContractDate, Library, JobClass, Quantity, PerAmount, Unit, LimitAmount, DiscountRate FROM Welfare

Seminar

QUERY: SELECT Original, SeminarCourse, Department, Position, JobClass FROM Seminar

Evaluation

QUERY: SELECT Original, Name, Department, Position, JobClass, Level, Weight, AddedScore FROM Evaluation

Manpower Plan

QUERY: SELECTOriginal, TransactionType, TransactionNo, TransactionDate, CostCenter, AccountCode, Department, Position, Quantity, Price, Unit, Amount FROM Budget

Manpower Request

QUERY: SELECT RecruitTransaction.Original, RecruitTransaction.Department, RecruitTransaction.Position, RecruitTransaction.RecruitDate, RecruitTransaction.Quantity, RecruitTransaction.RequestPopulate, RecruitTransaction.Approval, RecruitTransaction.Reason, RecruitTransaction.Status, Position.CodeType FROM RecruitTransaction, PositionDetail WHERE RecruitTransaction.Original = Position.Original and RecruitTransaction.Position = Position.Name

Recruitment (Applicant)

Select Applicant

Matching between request position, knowledge, experience with applicant position, knowledge, experience.

Employee History

QUERY: SELECT Original, Employee, Date, Department, Position, JobClass, Salary, SeminarCourse, SeminarDate, Leave, WelfareContract, WelfareType, Amount, Virtue, Fault, Result FROM EmployeeHistory

Working Time Table

QUERY: SELECT Original, Department, DateOfWeek, People, WorkTime, EffectiveDate, WorkLoad, Status FROM DepartmentStatus

Working Time Transaction

QUERY: SELECT Original, Department, People, Doctor, Date, Time, Status FROM DepartmentTransaction

Working Expense ( in Payment Voucher)

Fiscal Payroll

Note Payroll Code as payroll, rent, hardship allowance, travel allowance, over time, fuel, tax, provident fund

Payroll

Compensation

Seminar Transaction

Welfare Transaction

Fiscal Evaluation

Last update : Monday, 7 January 2002 07:00 ( Thailand )

Apple, Mac, iMac, iPhone and iPod are trademarks of Apple, Inc.

Jini, Java and all Java-based are trademarks of Oracle Corporation.

JiniSoft Corporation

Copyright @ 1990 - 2012   Mr. Roongroj Rojanapo ( )

89/1 Khao Lam Road, Saen Suk, Chon buri District, Chon buri 20130, Thailand

E-mail

:

roongroj @ jinisoft.com ( JiniSoft @ Facebook & Line )