Project

General

Profile

Bug #1093

تقرير حصر العمالة المتواجدة

Added by Abdelhalim Abu Qamar about 6 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
High
Assignee:
Abdelhalim Abu Qamar
Start date:
04/09/2019
Due date:
04/17/2019
% Done:

100%

Co-Workers:
Severity:
Normal
Category:
inspection report
Sub-Category:
Step_Description:
Pre_Conditions:
Expected Result:
Actual Result:
Environment:
Production
Transaction Number:
Username:
Browser:
URL:
Test Case ID:

Description

kindly update report (INSRep_Exist_Emp_servelt) to show اسم العامل that must read from WORKER_NAME from table
INS_VISIT_EXISTING_WORKERS
to find real example @prod.
report url :
https://e-portal.manpower.gov.kw/PampReportsII/INSRep_Exist_Emp_servelt?visitid=199818&userid=U01101093862588
----------------------------------

History

#1 Updated by Ahmad Amer about 6 years ago

  • Assignee changed from Ahmad Amer to Abdelhalim Abu Qamar
  • % Done changed from 0 to 100

done on prod

#2 Updated by Abdelhalim Abu Qamar about 6 years ago

  • Status changed from Open to In Progress
  • Assignee changed from Abdelhalim Abu Qamar to Ahmad Amer

also to show NATIONALITY description for the same example by NATIONALITY_ID

#3 Updated by Ahmad Amer about 6 years ago

  • Assignee changed from Ahmad Amer to Abdelhalim Abu Qamar

done on production using table V_HR_G_COUNTRY by* COUNTRY_CODE#* as ID, COUNTRY_DESC

#4 Updated by Abdelhalim Abu Qamar about 6 years ago

  • Due date set to 04/10/2019
  • Status changed from In Progress to Closed
  • Environment Production added
  • Environment deleted (Development)

#5 Updated by Abdelhalim Abu Qamar about 6 years ago

  • Status changed from Closed to In Progress
  • Assignee changed from Abdelhalim Abu Qamar to Ahmad Amer
  • Environment Development added
  • Environment deleted (Production)

while NATIONALITY_ID = 0
kindly used :
SELECT
(SELECT con.COUNTRY_DESC
FROM MOSAL_USER.V_HR_G_COUNTRY con
WHERE COUNTRY_CODE# = info.NATIONALITY
)
FROM NDB.CIVIL_INFO info
WHERE info.CIVIL_ID = :p_CIVIL_ID ;

#6 Updated by Ahmad Amer about 6 years ago

  • Due date changed from 04/10/2019 to 04/11/2019
  • Assignee changed from Ahmad Amer to Abdelhalim Abu Qamar

done on both production and test

#7 Updated by Abdelhalim Abu Qamar about 6 years ago

  • Status changed from In Progress to Closed
  • Environment Production added
  • Environment deleted (Development)

#8 Updated by Abdelhalim Abu Qamar about 6 years ago

  • Status changed from Closed to In Progress

while WORKER_NAME is null and IDENTIFICATION_TYPE_ID = 1 then
kindly used :
SELECT info.NAME FROM NDB.CIVIL_INFO info WHERE CIVIL_ID = :P_IDENTIFIC_NUM;

to fill اسم العامل

#9 Updated by Abdelhalim Abu Qamar about 6 years ago

  • Assignee changed from Abdelhalim Abu Qamar to Ahmad Amer
  • Environment Development added
  • Environment deleted (Production)

#10 Updated by Ahmad Amer about 6 years ago

  • Due date changed from 04/11/2019 to 04/17/2019
  • Assignee changed from Ahmad Amer to Abdelhalim Abu Qamar

done on prod

#11 Updated by Abdelhalim Abu Qamar about 6 years ago

  • Status changed from In Progress to Closed
  • Environment Production added
  • Environment deleted (Development)

Also available in: Atom PDF