How to input the Worker Info with the excel template

  1. Download the Worker Info template.
  2. Verify the worksheet format is correct by :
      - Highlight the whole column A (Record_No), right click on the mouse, select "Format Cell". On the "Number" tab, verify that the "Category" is set to "Number" and the "Decimal Places" is 0.
    - Hightlight the remaining column (B to U), right click on the mouse, select "Format Cell". On the "Number" tab, verify that the "Category" is set to "Text".
    - Hightlight the cell B2, right click on the mouse, select "Format Cell". On the "Number" tab, verify that the "Category" is set to "Number" and the "Decimal Places" is set to 0.
    - Go to "Format -> Sheet -> Rename", verify that the worksheet name is set to "WorkersData".
  3. For each worker records, key in the following data. If you are copying the data from another excel file, please verify that the cell format is the same as in step (2).
      - Record_No : Compulsory field. This is a running number starting from 1.
    - WorkPermit : Compulsory field if NRIC_FIN is empty.
    - NRIC_FIN : Compulsory field if WorkPermit is empty.
    - WorkPermitValidFromDate : Compulsory field if WorkPermit is not empty. The data must be in the format of "YYYYMMDD". (Eg. Type as "20021025" for 25 Dec 2002).
    - WorkPermitExpiryDate : Compulsory field if WorkPermit is not empty. And it must be later than date when you submit the excel file. The data must be in the format of "YYYYMMDD". (Eg. Type as "20021025" for 25 Dec 2002).
    - Welder ID : Leave this blank if the welder is a new welder. The system will generate a new Welder ID for this new worker. If the workers already registered in PRIMOS, leave this blank as well.
    - Name : Compulsory field. The name of the worker.
    - DOB : Compulsory field. The date of birth of the worker. The data must be in the format of "YYYYMMDD". (Eg. Type as "20021025" for 25 Dec 2002).
    - Gender : Compulsory field. M or F.
    - Race : Compulsory field. (Bangladeshi, Chinese, Malay, Indian, Filipino, Thai, or Others)
    - Nationality : Compulsory field. (Bangladesh, Burma, Cambodia, India, Indonesia, Malaysia, Phillipines, Sri Lanka, Thailand, Vietnam, Others).
    - Citizenship : Compulsory field. (1 year work permit, 2 years work permit, Employment pass, Permanent Resident, Singaporean, Others. Please note that if you select 1 year work permit or 2 year work permit, the WorkerPermitExpiryDate and WorkPermitValidFromDate must be exactly 1 year or 2 year respectively, please select "Others" otherwise.)
    - Skillset : Compulsory field. Must be one of the following: Electrical Fitting, General Fitting, Instrument Fitting, Metal Scaffolding, Painting & Blasting, Pipe Fitting, Plant Equipment Fitting, Refractory, Rigging & Material Handling, Thermal Insulation, Plant Civil Works, Machine Fitting, Welding. You may key in more than one skillset by separating each with comma.
    - Occupation : Compulsory field. The worker's occupation. Must be one of the following: Class 3 Driver, Clerk, Construction Manager, Crane Operator, Draughtsman, Foreman, Forklift Operator, Heavy Duty Driver, PCM Worker, Project Engineer, Project Manager, QC Manager, Safety Officer/Manager, Site Manager, Supervisor, Welder, Others.
    - Education : Compulsory field.
    - SOCCertNum : The OPSOC Number.
    - SOCRegisDate : Compulsory field if SOCCertNum is not empty. The data must be in the format of "YYYYMMDD". (Eg. Type as "20021025" for 25 Dec 2002).
    - CommenceDate : Compulsory field. The employment date of the worker. The data must be in the format of "YYYYMMDD". (Eg. Type as "20021025" for 25 Dec 2002). Please note that all activities including OJT, Pre-Q, Test Application, etc, must be after this CommenceDate.
    - Sponsor : Compulsory field if WorkPermit is not empty.
    - Sub-Contractor : Optional field. The name of the sub-contractor.
    - Remarks : Optional field. Any remarks.
  4. Verify that cell A2 is set to 0.
  5. In cell B2, type in the number of worker records that are to be uploaded in this file. For example, if you have key in 125 workers records, type "125" in cell B2.
  6. Save the Excel Template.
  7. Login to Primos, go to "Worker Administration -> Batch Upload"
  8. Select the excel template that you have saved.
  9. Click on the submit button.
  10. The result of the batch uploaded will be emailed to you.