I've added another sheet named
"Timeline-Stage2" to the existing
Google SS which will track all applications (161 in total as of now) that got accepted in Stage1. This will be in use to find processing time from app received/payment charged to sponsorship approval. Same as Timeline-Stage1, this is locked to all and hence you will have to use 'New Entry' sheet to add/update info. 'New Entry' has been modified in order to collaborate both Stage1 and Stage2 databases.
-
For existing users, you don't have to fill out each column in 'New Entry' if they are already available in Stage1 (but if you need to make corrections, please use whichever applicable).
-
For new users, you have to fill out both Stage1 and Stage2 info in 'New Entry' sheet. If your name and info haven't been added in Timeline-Stage1; they won't make it to Timeline-Stage2.
Here's a summary of the new sheet Timeline-Stage2 (Sponsorship Eligibility)
Col 'C'/Relationship to Applicant(s): This is where you select whom you sponsored (i.e. Mom, Dad, Both Mom & Dad, w/wo Dependents etc.). I added this selection because this may determine where your files will be transferred later. What I heard is if your application has dependents; it may be transferred to regional global office. Otherwise, it may stay in Ottawa. Please, select your relationship next time you use 'New Entry' to add/update info.
Col 'F'/1st AOR Date: This is where you indicate when you receive a confirmation from CIC that they received/accepted your application. For 2014 applicants, this occurred in Jun-Jul/2014 period.
Col 'G'/Additional Doc Request Date: Generally, CIC asks for recent NOA once they issue 1st AOR. They may ask for something else. Insert the date when they request it.
Col 'H'/2nd AOR Date: I called it '2nd AOR' since CIC gives you another confirmation once they receive the additional docs they requested before.
Col 'I'/Eligibility: It's a Yes/No options for you whether you were found Eligible to Sponsor or not.
Col 'J'/Eligibility or Rejection Date: Put the date once you hear from CIC that you were approved/rejected as a Sponsor.
Col 'K'/Processing Time: It's calculated automatically in months from Application Received Date to Eligibility/Rejection Date. You don't see this column in 'New Entry' sheet as you don't have to fill out.
Col 'L'/File Transferred to Local Office: Insert the Date when CIC transfers PR file to the local office.
Col 'M'/Local Office: Insert the place/city/country of the local office (i.e. Ottawa, Singapore etc.).
Col 'N'/Comments: This is open for you to write any informative comments.
PS: I made this sheet based on things I heard from this forum. As we are all new to this PGP processing; things may be added/deleted as we go on. I will accept any comment/suggestion you have to offer. I hope this will serve the purpose if you're looking for it