Menu
Here is a step by step guide to create WPS Sif File to transfer salaries through WPS
New WPS format is circulated by QCB with additional new fields. New Validate SIF file using V1 file validator available here (External Link) The decommission of current existing WPS format will be announced by QCB separately. To help you creating the SIF required by MOL, please check below our QNB file creator tool. This video is an introduction of how to set Format Cells in WPS Spreadsheet. If you are a beginner of Spreadsheet, it is an excellent video to help you how you begin a perfect Excel. Try # WPS for # FREE at.
Definition of WPS: Wages Protection System, SIF File: Salary Information File. Adobe reader 11 mac.
Here is a step by step guide to create WPS Sif File to transfer salaries through WPS
1. Opening a new salary file (Excel)
2. Entering the requisite Employee Salary details
3. Entering the requisite Employer details
4. Saving the file as .CSV file
5. Renaming the file as .SIF file
1. Open New Excel File
2 - Enter Row-wise all EMPLOYEE RECORD DETAILS in below order:
Column A: Type 'EDR' in all rows.
Column B: Enter the 14 digit Person ID number provided by Ministry of Labour. This information is printed on the Employee Labour cards. If the number mentioned is less than 14 digits, in the file the field should be prefixed with zeros to add the count to 14 digits.
Column C: Enter Agent ID. This is the 9 digit routing code which is assigned to the Employee’s Bank/ Agent where their account is held. All UAE Banks and Exchanges have their routing codes, so you can obtain list from banks.
Column D: Enter the Employee’s account number or Salary Card Number from the bank where the salary is to be credited. Should be max 16 characters.
Column E: Provide the PAY START DATE. Should be entered in format 'YYYY-MM-DD”. For example if the pay period is for the month of October 2018, then the PAY START DATE mentioned will be 2018-10-01.
Column F: Provide the PAY END DATE. Should be entered in format 'YYYY-MM-DD”. For example if the pay period is for the month of October 2018, then the PAY START DATE mentioned will be 2018-10-31.
Painting mop brush. Column G: Enter the number of days for which the salary is being paid. For example if the salary is being paid for the full month of July which has 31 days in total, then the value entered will be '31”
Column H: Enter the FIXED INCOME AMOUNT to be paid to the employee. This would include all fixed payouts such as Basic salary, Accommodation, and Transportation etc. The amount should be entered without ',” and with or without two decimals e.g. 3500.00. If no contribution for this component then type 0.00 in this column.
Column I: Enter the VARIABLE INCOME AMOUNT to be paid to the worker. Examples would be Overtime, any incentives or bonus etc. The amount should be entered without ',” and with or without two decimals e.g. 1500.00 etc. If no contribution from this component then send 0.00 in this column.
Column J: DAYS ON LEAVE FOR PERIOD. This shall be the number of days the employee has been on leave without pay in the pay period. If no leave has been availed off then enter '0” in this column.
3 - Create the Last Row, with Employer information called SALARY CONTROL RECORD (SCR).:
The Last Row should contain Employer related information called SALARY CONTROL RECORD (SCR). Please note that this should be created at the end after completing the creation of Employee Salary details. The fields should be entered in the below order:
Column A: Type 'SCR”.
Column B: Enter the 13 digit Employer Unique ID (Establishment Number) of the company issued by Ministry of Labour. This field will have to be padded with leading zeros if the length is less than the maximum specified length of 13 digits. This field is validated against the database held in WPS.
Column C: Enter Bank code of the Employer. This is the 9 digit routing code which is assigned to the Employer’s Bank where the corporate account is held.
Column D: Enter the File Creation Date. Must be in the format YYYY-MM-DD. For e.g. is the file is prepared by the employer on 28th October 2018, and then the date mentioned will be 2018-10-28.
Column E: Enter the File Creation Time. Must be in the format HHMM. For e.g. if the file is prepared by the employer at 3:30 pm then the time mentioned will be 1530.
Column F: Enter the Salary Month. Must be in the format MMYYYY. If the payment is being done for the month of October 2018, then the month mentioned will be 102018.
Column G: Enter the EDR count. This is the total number of employees for whom the salary is being paid.
Column H: Enter TOTAL SALARY AMOUNT paid to the workers. The amount should be entered without ',” and with or without two decimals e.g. 62000.00 etc. It will be validated to be equal to the sum of all Fixed and Variable components indicated in all the EDR records in the file.
Column I: Enter the Payment Currency. This is always to be entered as AED
Firefox Browser Developer Edition The browser made for developers All the latest developer tools in beta, plus experimental features like the Multi-line Console Editor and WebSocket Inspector. A separate profile and path so you can easily run it alongside Release or Beta Firefox. Firefox quantum developer edition. The latest Firefox engine: Firefox Quantum. Firefox Quantum was a revolution in Firefox development. In 2017, we created a new, lightning fast browser that constantly improves. Firefox Quantum is the Firefox Browser. Download Firefox Firefox Privacy Notice. Learn more about Firefox Quantum.
Column J: Enter EMPLOYER REFERENCE NUMBER if applicable. This is an optional field to be entered by the employer only if they maintain a unique file identifier at their end. If not applicable then the field can be left blank. Many exchanges ask to write your company name in this column.
4 - Saving the file as .CSV file.:
'File Name' should be saved as 'EMPLOYER UNIQUE ID FILE CREATION DATE FILE CREATION TIME'
Example: If your Ministry of Labour Employer ID is 654321 and file was created on 28th October, 2018 at 3.30pm, then the file name should be: 654321181028153000
Save as Type / extension should be selected as CSV (Comma delimited).
5 - Rename the file as '.SIF” instead of '.CSV”. Example: 654321181028153000.sif
Note: This article is shared as a general guideline, use or apply with your own understanding and accountability.
Let us first understand what is wps? A Welding Procedure Specification (WPS) is a formal written document describing welding procedures, which provides direction to the welder or welding operators for making sound and quality production welds as per the applicable code requirements . The purpose of the wps document is to guide welders to perform their work in accordance with the accepted procedures so that repeatable and trusted welding techniques are used. WPS or welding procedure specification is developed for each material alloy and for each welding type used. Specific codes and/or engineering societies are often the driving force behind the development of a company’s WPS.
Relation Between WPS & PQR
A WPS is supported by a Procedure Qualification Record (PQR or WPQR). A PQR is a record of a test weld performed and tested (more rigorously) as per the wps to ensure that the procedure will produce a good weld. Individual welders are certified with a qualification test documented in a Welder Qualification Test Record (WQTR) that shows they have the understanding and demonstrated ability to work within the specified WPS for specific type of welding.
How To Prepare WPS & PQR
Now you can download WPS & PQR in Excel format which you can use for preparing the specific welding procedure specification and procedure qualification record for your own use and for monitoring the performance of welders of your company.
You will only need to put some information for your specific project and welding requirements and your WPS and PQR shall be ready for approval from third party or client or consultant etc. The template contains all necessary welding requirements like joint design dimensions, type and size of filler material, welding machine parameters and current ranges etc.
Wps Format In Excel With Multiple
Download WPS & PQR
Wps Format In Excel
The file is in Excel format and instantly available after you pay the cost of only 1.99$.
Click Below “Buy Now” link and Download Instantly.
How To Convert Wps File To Excel
2Checkout.com Inc. (Ohio, USA) is a payment facilitator for goods and services provided by MethodstatementHQ. |