Differences

This shows you the differences between two versions of the page.

--- start [2024/01/08 15:02] – admin
+++ start [2024/01/20 18:38] (current) – admin
@@ Line 269: / Line 269: @@
 __Good afternoon Megan__,
-My name is __Nqophisa Mtshonisi__, an email data consultant from Gradesmatch. At Gradesmatch we produce educational technologies that assist students with career guidance and applying to higher learning institutions. As part of the process, we provide our users with a unique email address that they can access and we notify them via WhatsApp or SMS when a new email is received so they may read it and track it. The domain name we use is @gradesmatch.com, for example, __nqophisam@gradesmatch.com__ could be a version for myself if I were a student.
+My name is __Nqophisa Mtshonisi__, an email _data consultant_ from Gradesmatch. At Gradesmatch we produce educational technologies that assist students with career guidance and applying to higher learning institutions. As part of the process, we provide our users with a unique email address that they can access and we notify them via WhatsApp or SMS when a new email is received so they may read it and track it. The domain name we use is @gradesmatch.com, for example, __nqophisam@gradesmatch.com__ could be a version for myself if I were a student.
 We received an email with the subject "__Provisional Acceptance to study at Nelson Mandela University 2024 - Medical Evaluation and Acceptance of Offer Forms__" from you, however, our technology was unable to allocate the email to the correct learner and thus notify them as it did not have a clear "To" address. I would like to assist with helping you connect with the correct learners with this subject. As mentioned earlier, our email domain is @gradesmatch.com so if you send emails to those learners, you may share it so I may ensure they receive the correct emails and are able to adequately take note or respond to your email.
@@ Line 275: / Line 275: @@
 If you have any questions please feel free to contact me
-NB: You will always need to edit the underlined. When you send the email always cc Unathi and Lebo. Remember that Stellies, NWU, and UFS will not share any information because of the POPI act. Instutions other institutions are more accepting.
+NB: You will always need to edit the underlined. When you send the email always cc Unathi and Lebo. Remember that Stellies, NWU, and UFS will not share any information because of the POPI Act. Institutions other institutions are more accepting.
+**APS Calculator**
+[[https://docs.google.com/document/d/1P-TBXKihbQ40zWhjeML_bb-PIRytZGPMqDqnM5UgzoA/edit]]
+**Institutionemail**
+This is a collection on MongoDB, gradesmatch_reference.institutionemail
+If an institution on message collection has the field of InstitutionName as "other" then the institution email needs to be added to the institutionemail collection.  Follow how other documents are done.
+**Central Application Institution**
+This is a collection in MongoDB, gradesmatch_reference.central_application_institution. The collection is designed for different institutions that share the same email address, allowing Gradesmatch to distinguish their communication.
+If the institution belongs to CAO or Coltech, it needs to be added to the relevant document within central_application_institution.
+Assuming we want to add "Gradesmatch Institution" to Coltech:
+  - From the central_application_institution collection, navigate to the "Coltech Application Admin" document.
+  - Add the InstitutionId of "Gradesmatch Institution" to the InstitutionIds field.
+         - If you don't know the Gradesmatch Institution Id, find it in the gradesmatch_reference.institution collection by filtering it by its name.
+  - Add the settings to the Institutions field.
+{
+      "ID": 896254,
+      "Abbreviation": "GM Inst",
+      "Name": "Gradesmatch Institution",
+      "Search": [
+        "Gradesmatch Institution",
+        "Gradesmatch"
+      ]
+    }
+Search is an array, and you need to find the unique text within the email that differentiates the institution from other communications originating from the From address.
+**MONGO QUERIES FOR FIRM OFFERS**
+Query to find the offers for: VUT, UNIZULU, SPU, SMU, CUT, UFH
+{CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 37,$or: [{ Subject: 'Application Admitted'},{ Subject: 'Application Offered'}]}
+Query for Wits:
+{CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 30, Attachments:"UW_AD_UGF0_N.pdf"}
+Query for UP:
+  - {CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 22, Attachments:/_A41.PDF/}
+  - {CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 22, Attachments:/_AT4.PDF/}
+  - {CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 22, Attachments:/_A39.PDF/}
+Query for UWC:
+{CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 31, Subject:/Offer to study at UWCCK Ref:/}
+Query for UJ:
+{CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 28, $or: [{ Subject: 'Univ. of Johannesburg - Orange Carpet Admitted'},{ Subject: 'University of Johannesburg - Admittance Letter'}]}
+Query for NWU:
+{CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 14, Attachments:"PVA014.pdf"}
+Query for NWU:
+{CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 14, Subject:/Final Acceptance/}
+Query for RU:
+  - {CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 17, Attachments:"Offer Confirmed"}
+  - {CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 17, Attachments:/O1/}
+Query for UFS:
+{CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 21, $or: [{ Attachments: 'UV_ADMIT_COV.pdf'},{ Attachments: 'NAS_FINAL.pdf'}]}
+Query for UCT:
+{CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 19, Html:/OFFER/}
+Query for SU:
+{CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 12, Subject:"ADMISSIONS COMMUNICATION FROM STELLENBOSCH UNIVERSITY", Attachments:/Offer_Letter_/}
+**In all the queries you'll need to amend the time and institutionId where applicable**