Hi Sanjay,

'Team CCEP is seeking cost for the following change request in LMS Sucessfactor.
The changes are required in the following two areas:

1. Dataview: Named -HRM - Employee Details Success Factor
2. Integration: FMISFileExport>LT_SYS_Integration_FileDataExport_SuccessFactor 

Environment Details: 

1. http://lLINKQA1-EBS/Client-CCEP-Linksoft
   

Additional Coloums as pr attached Doc "AJ" and "BA". 

Email Content

We have received a request earlier last month regarding the success factor reports (SP - LT_SYS_Integration_FileDataExport_SuccessFactor) that are currently being generated from Linksoft.

We want to populate 2 more fields used in another CCEP portal.

I have attached the Excel for your review if I can request for efforts required for these changes.

Teams meeting: Sitla and Sanjay

1. Column BA to contain data from LinkSOFT Menu: "Employee Maintenance" Tab: "Grade History". 
   1. If there are mulltiple, pick the Active entry. If there are multiple "Active", pick the one with the most recent "Effective Date"
   2. If there are no Active Grades, leave Blank
2. Column AJ, Place the Emplyee "Service End Date"
   1. If there is no Service End date, leave Bank.

Figure 1 - Grade code

Next step: 

1. Setup test environment
2. Create a pay with 5 employees, some of which have Grades and Service End dates
3. Prepare a table with the expected results

Effort: 

1. Change will be in the current released version
2. Effort 8 hrs

Hi Sanjay,

The customer has given their approval for this work.

Please proceed,
Sitla. 

Hi Sanjay,

The following was populated in the QA5 Machine with data entry and expected test results populated in Figures 1 and 2 below:

Figure 1: - Updated fields with below records.

Figure 2: Expected Test results reflected in Red below. Note: Columns were hidden to show results. Full Excel is in the attachments. 

Do let me know if you need anything else on this. - PAY generation is not required for this Test.
Sitla.

1. The change will be available in version: 15.60 and Patch 15.50.240926P

2. The following changes were made (Include Database object names, Program classes, and any other relevant information):

1. Added fields "Service End Date" and "Grade Description" to:
   1. Data View named: "HRM - Employee Details Success Factor"
   2. Success Factor File Data
       

3. Affected Areas:

1. Data View and Integration File

4. The issue was caused by:

1. Change Request

5. Other Relevant Notes: 
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT

Next Step: Hi Sitla, please verify this on client's environment and update with UAT results. Thanks.

Hi Sanjay,

I have output files on both menus.

1. Dataview: Named -HRM - Employee Details Success Factor
2. Integration: FMISFileExport>LT_SYS_Integration_FileDataExport_SuccessFacto

Dataview & Integration Output

Next Step: Closure 

Sitla