- When – by the 15th of the month following the end of each calendar quarter – April 15, July 15, October 15 and Jan 15
- Email to Tracie Frost, cc Melan DeBeese (or whoever the current contacts are)
- Data for file processing can be found here: S:\enroll_files\REFERENCE\TRICARE_TRACKER_2017.xlsx
- Filter records; select SHBP Georgia
- Data for ID card is an SSRS report under Account Management -- ID Card Report for Client 0001690
- Open prior quarter’s .xlsx file
- Save as using current quarter in file name – example 2022 Q2 Performance Guarntee.xlsx would be saved as 2022 Q3 Performance Guarantee.xlsx
- Delete prior quarter’s data
- Change title row 3 to current quarter – example, Second Quarter 2022 would be changed to Third Quarter 2022
- Copy/paste data from TRICARE Tracker file into the current quarter’s file
- Be sure to get the data into the correct columns – the columns in TRICARE Tracker file are not the same order as the columns in the Performance Guarantee file
- If there is a number other than “0” in the Number of New Enrollments column, then find the date the ID card was printed for that enrollment
- You might need to check the completed enrollment files here: S:\enroll_files\834\COMPLETED\2022
- The Completed files might be in the folder for the year they were received (2022 for example) or they might be in the general Completed file if they are very recent