in business for people. prosoft hrms resource booking configuration guide
Post on 26-Dec-2015
217 Views
Preview:
TRANSCRIPT
- Slide 1
- In business for people. PROSOFT HRMS RESOURCE BOOKING Configuration Guide
- Slide 2
- In business for people. Page 2Proprietary and Confidential Overview IIS Configuration ISAPI and CGI Restriction Run the application for the first time Maintain database & mapping Setup system admin
- Slide 3
- In business for people. Page 3Proprietary and Confidential IIS Configuration
- Slide 4
- In business for people. Page 4Proprietary and Confidential ISAPI & CGI Restriction
- Slide 5
- In business for people. Page 5Proprietary and Confidential Run the application for the first time
- Slide 6
- In business for people. Page 6Proprietary and Confidential Maintain database & mapping TableSQL Command Employee INSERT INTO RBSData..TblEmployee ( EmployeeCode, EmployeeName, DateJoin, DateResign, CompanyCode, DepartmentCode, LocationCode, Email, LoginCode, ContactNo) SELECT EmployeeCode, EmployeeName, DateJoin, DateResign, CompanyCode, DepartmentCode, LocationCode, Email, LoginCode, AddressPhone1 FROM..TblEmployee CompanyINSERT INTO RBSData..TblCompany ( CompanyCode, CompanyName, DateStart, DateEnd) SELECT CompanyCode, CompanyName, DateEffective, DateExpiry FROM..TblCompany DepartmentINSERT INTO RBSData..TblDepartment ( DepartmentCode, DepartmentName, DateStart, DateEnd) SELECT DepartmentCode, DepartmentName, DateEffective, DateExpiry FROM..TblDepartment LocationINSERT INTO RBSData..TblLocation ( LocationCode, LocationName, DateStart, DateEnd) SELECT LocationCode, LocationName, DateEffective, DateExpiry FROM..TblLocation Notes: is PROSOFT HR database located in the same SQL server
- Slide 7
- In business for people. Page 7Proprietary and Confidential Setup system admin
- Slide 8
- In business for people. Thank You!
top related