Friday, February 25, 2011

Employee Self Service Table Updates

1. Tables updated/inserted by N0800044 (F08330 Transaction Business Function) 

F060116          Employee Master
F06106            Employee Pay Instructions
F08330            Employee Enrollment
F08330B         Employee Enrollment Tag File
F08501                  Employee Pension Activity Master

2. Tables updated/inserted by R054104 (Update Employee Personal Information to Live Tables) 

F0101                                     Address Book Master                                                                                                  
F0111                                     Address Book - Who's Who                                                  
F0115                                     Address Book - Contact Phone Numbers                   
F01151                                   Electronic Address                                                      
F0116                                     Address by Date                                                                     
F01161                                   Alternate Address                                                       
F060116                                 Employee Master                                                         
F054101                                 Employee Personal Profile Information History Table                                                
F054101W                             Employee Personal Profile Information Work Table                                
F054111                                 Employee Emergency Contact History Table             
F054111W                             Employee Emergency Contact Work Table                
F054115                                 Employee Phone Number History Table                     
F054115W                             Employee Phone Number Work Table                        
F05420                                   Workflow Approval Table                                                      Once updated, cannot update again.
F085528                                 ESS History Table Cross Reference                            
                                               F08901ParticipantFile 

3. Tables updated/inserted by R085524 (Update Benefits Information to Live Tables)


F05420                                   Workflow Approval Table                                          
F06106                                   Employee Pay Instructions                                          
F08330                                   Employee Enrollment                                                  
F08330B                                Employee Enrollment Tag File                                    
F08336                                   Dep/Ben to Employee Plan X-Reference                    
F08336B                                Dep/Ben X-Reference Tag Table                                
F08338                                   Primary Care Physician Table                                      
F08338B                                Primary Care Physician Tag Table                               
F085520                                 Available Plans and Options by Employee History Table                        
F085520W                             Available Plans and Options by Employee Work Table                           
F085528                                 ESS History Table Cross Reference                            
F085536                                 Dependent/Beneficiary X-Reference History Table   
F085536W                             Dependent/Beneficiary X-Reference Work Table      

4. Tables updated/inserted by R085520 (Available Plans Work File Build)

F085520W      Available Plans and Options by Employee Work Table

5. Tables updated/inserted by R085530 (Current Enrollment Work File Build)

F085530W      Employee Current/Pending Elections Work Table

6. Tables updated/inserted by R085537 (Build Current Dep/Ben Work File)

F085537W      Current Dep/Ben X-Reference Work Table

No comments:

Post a Comment