Wednesday, October 11, 2006

SAP R/3 : Benefit - Vision File (VSP)

A copied file of the PMI (medical) benefit file was being used to modify to suit VSP file and the logic was a little different from it. VSP is a vision plan benefit that will capture all employees eligible for its plan. Several changes was defined and required some minimal logic alteration.

1. The structure. There are two structures that VSP is using for file extraction. The employee and the dependent.

2. The logic. Several logic has been tuned and modify (minimal but heavy testing for quality assurance) was made to suit VSP. The process requires first, filteration of all employees who are active either in employment or in COBRA. Retirees or Terminated employees are excluded from the extraction. However, retirees or terminated employee with health plans (0167) and COBRA (0212) still valid, they can be included into the file. So far this is the only difference comparing to PPO file. Other than these, its the arrangement of items in the file. There are VSP Plan Date begin and VSP Plan Date end. End date should only be display if its within the selection period.

3. Other standard functions used in this program is the GUI_Download_File call function.

The work was scoped for 29 hours. Most of the hours were used for corrections and testing. Loads and loads of batch testing was conducted to minimize errors.

Is sky the limit... benefit vision plan file

No comments: