Versions Compared

Version Old Version 3 New Version Current
Changes made by

Helen Williams

Helen Williams

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Page Properties
idbug-detail

Slate Instance

TUP

Requestor/Reporter

Helen Williams

TTS Staff

Helen Williams

Date

10/24/2023

Status

Complete

Bug Description

Change to TUSMGP CNAME/subdomain changed the CAS/Liaison Service Account username and broke the API subscriptions.

Issue:

TUSMGP requested a change to the CNAME/sub-domain for their database (from phpd.admissions.tufts.edu to tusmgp.admissions.tufts.edu) When this change went into effect on 8/25/2023, the CAS/Liaison service account username was also changed in their instance of Slate (from liaison_service@phpd.admissions.tufts.edu to liaison_service@tusmgp.admissions.tufts.edu). This caused the existing API subscriptions to fail and data to stop importing between the CAS and Slate.

Solution:

Existing API subscriptions were deleted, the subscription configurations updated with the correct email address for the sftpUser, the subscriptions re-created, and then replays After running the solution below, we also discovered that we had four applicants for the DPT-Boston program who did not have applications in Slate. All 4 had started their application 6/20-21, which meant it was likely they had been a problem before this specific issue. Most likely when the subscription was setup at the beginning of the cycle, those in progress files were missed by the process to replay the in progress subscription.

Solution:

Existing API subscriptions were deleted, the subscription configurations updated with the correct email address for the sftpUser, the subscriptions re-created, and then replays made for each subscription to cover time between when the files stopped sending (roughly 8/25/2023 at 4:45 PM EST) to when each subscription was restarted.

...

Expand
titleIn Progress Subscription (8014)
Code Block
{
    "subscription": {
        "id": 8014,
        "notificationEmailAddress": "tts-slate-team@elist.tufts.edu",
        "expirationDate": "2025-08-28",
        "createdBy": "TuftsUni",
        "updatedBy": "TuftsUni",
        "userLevel": "institution",
        "disabled": false,
        "createdDate": "2023-08-29 17:16:24",
        "updatedDate": "2023-08-29 17:16:24",
        "subscriptionDetails": [
            {
                "id": 48215,
                "event": "application.program.selected",
                "responseType": "fullResponse",
                "responseLevel": "program",
                "responseOptions": "expand=all,includeNulls=true,contentType=text/csv,columnSeparator=COMMA,csvHeaderTruncationSize=4,csvShortName=question",
                "destinationType": "SFTP",
                "createdBy": "TuftsUni",
                "updatedBy": "TuftsUni",
                "apiVersion": "v2",
                "disabled": false,
                "createdDate": "2023-08-29 17:16:24",
                "updatedDate": "2023-08-29 17:16:24",
                "sftpDestination": {
                    "id": 12073,
                    "sftpHost": "ft.technolutions.net",
                    "sftpPort": 22,
                    "sftpBaseDirectory": "/incoming/liaison/PTCAS/data/",
                    "sftpPathTemplate": "PTCAS-app-started_<instanceId>_<organizationId>_<programId>_<applicationId>_<casApplicantId>.csv",
                    "sftpUser": "liaison_service@tusmgp.admissions.tufts.edu",
                    "sftpPassword": "2717fef375e24a1ab89a376a86cbe358",
                    "createdBy": "TuftsUni",
                    "updatedBy": "TuftsUni",
                    "createdDate": "2023-08-29 17:16:24",
                    "updatedDate": "2023-08-29 17:16:24"
                }
            }
        ]
    }
}
Expand
titleIn Progress Replay
Code Block
{
    "replay": {
        "id": 8232,
        "status": "PENDING",
        "fromDate": "2023-08-25 17:45:00",
        "toDate": "2023-08-29 17:00:00",
        "createdDate": "2023-08-29 17:17:11",
        "updatedDate": "2023-08-29 17:17:11",",
        "subscription": {
            "subscriptionId": 8014
        }
    }
}
Expand
titleApplication Data Subscription (8017)
Code Block
languagejson
{
    "subscription": {
        "id": 8017,
        "notificationEmailAddress": "tts-slate-team@elists.tufts.edu",
        "expirationDate": "2025-08-29",
        "createdBy": "TuftsUni",
        "updatedBy": "TuftsUni",
        "userLevel": "institution",
        "disabled": false,
        "createdDate": "2023-08-30 10:08:43",
        "updatedDate": "2023-08-30 10:08:43",
        "subscriptionDetails": [
            {
                "id": 48218,
                "event": "application.program.received",
                "responseType": "fullResponse",
                "responseLevel": "program",
                "responseOptions": "expand=all,includeNulls=true,contentType=text/csv,columnSeparator=COMMA,csvHeaderTruncationSize=4,csvShortName=question",
                "destinationType": "SFTP",
                "createdBy": "TuftsUni",
                "updatedBy": "TuftsUni",
                "apiVersion": "v2",
                "disabled": false,
                "createdDate": "2023-08-30 10:08:43",
                "updatedDate": "2023-08-30 10:08:43",
                "sftpDestination": {
                    "id": 12076,
                    "sftpHost": "ft.technolutions.net",
                    "sftpPort": 22,
                    "sftpBaseDirectory": "/incoming/liaison/PTCAS/data",
                    "sftpPathTemplate": "PTCAS-app-s-<instanceId>_<organizationId>_<programId>_<applicationId>_<casApplicantId>.csv",
                    "sftpUser": "liaison_service@tusmgp.admissions.tufts.edu",
                    "sftpPassword": "2717fef375e24a1ab89a376a86cbe358",
                    "createdBy": "TuftsUni",
                    "updatedBy": "TuftsUni",
                    "createdDate": "2023-08-30 10:08:43",
                    "updatedDate": "2023-08-30 10:08:43"
                }
            },
            {
                "id": 48219,
                "event": "application.program.completed",
                "responseType": "fullResponse",
                "responseLevel": "program",
                "responseOptions": "expand=all,includeNulls=true,contentType=text/csv,columnSeparator=COMMA,csvHeaderTruncationSize=4,csvShortName=question",
                "destinationType": "SFTP",
                "createdBy": "TuftsUni",
                "updatedBy": "TuftsUni",
                "apiVersion": "v2",
                "disabled": false,
                "createdDate": "2023-08-30 10:08:43",
                "updatedDate": "2023-08-30 10:08:43",
                "sftpDestination": {
                    "id": 12077,
                    "sftpHost": "ft.technolutions.net",
                    "sftpPort": 22,
                    "sftpBaseDirectory": "/incoming/liaison/PTCAS/data",
                    "sftpPathTemplate": "PTCAS-app-s-<instanceId>_<organizationId>_<programId>_<applicationId>_<casApplicantId>.csv",
                    "sftpUser": "liaison_service@tusmgp.admissions.tufts.edu",
                    "sftpPassword": "2717fef375e24a1ab89a376a86cbe358",
                    "createdBy": "TuftsUni",
                    "updatedBy": "TuftsUni",
                    "createdDate": "2023-08-30 10:08:43",
                    "updatedDate": "2023-08-30 10:08:43"
                }
            },
            {
                "id": 48220,
                "event": "application.program.verified",
                "responseType": "fullResponse",
                "responseLevel": "program",
                "responseOptions": "expand=all,includeNulls=true,contentType=text/csv,columnSeparator=COMMA,csvHeaderTruncationSize=4,csvShortName=question",
                "destinationType": "SFTP",
                "createdBy": "TuftsUni",
                "updatedBy": "TuftsUni",
                "apiVersion": "v2",
                "disabled": false,
                "createdDate": "2023-08-30 10:08:43",
                "updatedDate": "2023-08-30 10:08:43",
                "sftpDestination": {
                    "id": 12078,
                    "sftpHost": "ft.technolutions.net",
                    "sftpPort": 22,
                    "sftpBaseDirectory": "/incoming/liaison/PTCAS/data",
                    "sftpPathTemplate": "PTCAS-app-s-<instanceId>_<organizationId>_<programId>_<applicationId>_<casApplicantId>.csv",
                    "sftpUser": "liaison_service@tusmgp.admissions.tufts.edu",
                    "sftpPassword": "2717fef375e24a1ab89a376a86cbe358",
                    "createdBy": "TuftsUni",
                    "updatedBy": "TuftsUni",
                    "createdDate": "2023-08-30 10:08:43",
                    "updatedDate": "2023-08-30 10:08:43"
                }
            }
        ]
    }
}
Expand
titleApplication Data Replay
Code Block
{
    "replay": {
        "id": 8238,
        "status": "PENDING",
        "fromDate": "2023-08-25 00:00:01",
        "toDate": "2023-08-25 23:59:59",
        "createdDate": "2023-08-30 14:06:02",
        "updatedDate": "2023-08-30 14:06:02",
        "subscription": {
            "subscriptionId": 8020
        }
    }
}

{
    "replay": {
        "id": 8239,
        "status": "PENDING",
        "fromDate": "2023-08-26 00:00:01",
        "toDate": "2023-08-26 23:59:59",
        "createdDate": "2023-08-30 14:07:08",
        "updatedDate": "2023-08-30 14:07:08",
        "subscription": {
            "subscriptionId": 8020
        }
    }
}

{
    "replay": {
        "id": 8240,
        "status": "PENDING",
        "fromDate": "2023-08-27 00:00:01",
        "toDate": "2023-08-27 23:59:59",
        "createdDate": "2023-08-30 14:08:45",
        "updatedDate": "2023-08-30 14:08:45",
        "subscription": {
            "subscriptionId": 8020
        }
    }
}

{
    "replay": {
        "id": 8241,
        "status": "PENDING",
        "fromDate": "2023-08-29 00:00:01",
        "toDate": "2023-08-29 23:59:59",
        "createdDate": "2023-08-30 14:09:19",
        "updatedDate": "2023-08-30 14:09:19",
        "subscription": {
            "subscriptionId": 8020
        }
    }
}
Expand
titleDocument Data Subscription (8027)
Code Block
{
    "subscription": {
        "id": 8027,
        "notificationEmailAddress": "tts-slate-team@elists.tufts.edu",
        "expirationDate": "2025-08-29",
        "createdBy": "TuftsUni",
        "updatedBy": "TuftsUni",
        "userLevel": "institution",
        "disabled": false,
        "createdDate": "2023-08-30 16:45:05",
        "updatedDate": "2023-08-30 16:45:05",
        "subscriptionDetails": [
            {
                "id": 48273,
                "event": "file.attachment.updated",
                "responseType": "fullResponse",
                "responseLevel": "organization",
                "destinationType": "SFTP",
                "createdBy": "TuftsUni",
                "updatedBy": "TuftsUni",
                "dataHold": "InProgress",
                "apiVersion": "v1",
                "disabled": false,
                "createdDate": "2023-08-30 16:45:05",
                "updatedDate": "2023-08-30 16:45:05",
                "sftpDestination": {
                    "id": 12105,
                    "sftpHost": "ft.technolutions.net",
                    "sftpPort": 22,
                    "sftpBaseDirectory": "/incoming/liaison/",
                    "sftpPathTemplate": "PTCAS_pers_<casApplicantId>__<documentSubType>__<fileId>!<deliveredDate>.pdf",
                    "sftpUser": "liaison_service@tusmgp.admissions.tufts.edu",
                    "sftpPassword": "2717fef375e24a1ab89a376a86cbe358",
                    "createdBy": "TuftsUni",
                    "updatedBy": "TuftsUni",
                    "createdDate": "2023-08-30 16:45:05",
                    "updatedDate": "2023-08-30 16:45:05"
                }
            },
            {
                "id": 48274,
                "event": "file.supplementalAttachment.updated",
                "responseType": "fullResponse",
                "responseLevel": "program",
                "destinationType": "SFTP",
                "createdBy": "TuftsUni",
                "updatedBy": "TuftsUni",
                "dataHold": "InProgress",
                "apiVersion": "v1",
                "disabled": false,
                "createdDate": "2023-08-30 16:45:05",
                "updatedDate": "2023-08-30 16:45:05",
                "sftpDestination": {
                    "id": 12106,
                    "sftpHost": "ft.technolutions.net",
                    "sftpPort": 22,
                    "sftpBaseDirectory": "/incoming/liaison/",
                    "sftpPathTemplate": "PTCAS_app_<casApplicantId>_<programId>_<documentSubType>__<fileId>!<deliveredDate>.pdf",
                    "sftpUser": "liaison_service@tusmgp.admissions.tufts.edu",
                    "sftpPassword": "2717fef375e24a1ab89a376a86cbe358",
                    "createdBy": "TuftsUni",
                    "updatedBy": "TuftsUni",
                    "createdDate": "2023-08-30 16:45:05",
                    "updatedDate": "2023-08-30 16:45:05"
                }
            },
            {
                "id": 48275,
                "event": "file.evaluation.updated",
                "responseType": "fullResponse",
                "responseLevel": "program",
                "destinationType": "SFTP",
                "createdBy": "TuftsUni",
                "updatedBy": "TuftsUni",
                "dataHold": "InProgress",
                "apiVersion": "v1",
                "disabled": false,
                "createdDate": "2023-08-30 16:45:05",
                "updatedDate": "2023-08-30 16:45:05",
                "sftpDestination": {
                    "id": 12107,
                    "sftpHost": "ft.technolutions.net",
                    "sftpPort": 22,
                    "sftpBaseDirectory": "/incoming/liaison/",
                    "sftpPathTemplate": "PTCAS_app_<casApplicantId>_<programId>_<docType>__<fileId>!<deliveredDate>.pdf",
                    "sftpUser": "liaison_service@tusmgp.admissions.tufts.edu",
                    "sftpPassword": "2717fef375e24a1ab89a376a86cbe358",
                    "createdBy": "TuftsUni",
                    "updatedBy": "TuftsUni",
                    "createdDate": "2023-08-30 16:45:05",
                    "updatedDate": "2023-08-30 16:45:05"
                }
            },
            {
                "id": 48276,
                "event": "file.transcript.updated",
                "responseType": "fullResponse",
                "responseLevel": "organization",
                "destinationType": "SFTP",
                "createdBy": "TuftsUni",
                "updatedBy": "TuftsUni",
                "dataHold": "InProgress",
                "apiVersion": "v1",
                "disabled": false,
                "createdDate": "2023-08-30 16:45:05",
                "updatedDate": "2023-08-30 16:45:05",
                "sftpDestination": {
                    "id": 12108,
                    "sftpHost": "ft.technolutions.net",
                    "sftpPort": 22,
                    "sftpBaseDirectory": "/incoming/liaison/",
                    "sftpPathTemplate": "PTCAS_pers_<casApplicantId>__<docType><transcriptType>_<collegeAttendedId>_<fileId>!<deliveredDate>.pdf",
                    "sftpUser": "liaison_service@tusmgp.admissions.tufts.edu",
                    "sftpPassword": "2717fef375e24a1ab89a376a86cbe358",
                    "createdBy": "TuftsUni",
                    "updatedBy": "TuftsUni",
                    "createdDate": "2023-08-30 16:45:05",
                    "updatedDate": "2023-08-30 16:45:05"
                }
            },
            {
                "id": 48277,
                "event": "file.vendorTranscriptEval.updated",
                "responseType": "fullResponse",
                "responseLevel": "organization",
                "destinationType": "SFTP",
                "createdBy": "TuftsUni",
                "updatedBy": "TuftsUni",
                "dataHold": "InProgress",
                "apiVersion": "v1",
                "disabled": false,
                "createdDate": "2023-08-30 16:45:05",
                "updatedDate": "2023-08-30 16:45:05",
                "sftpDestination": {
                    "id": 12109,
                    "sftpHost": "ft.technolutions.net",
                    "sftpPort": 22,
                    "sftpBaseDirectory": "/incoming/liaison/",
                    "sftpPathTemplate": "PTCAS_pers_<casApplicantId>__<docType>_<collegeAttendedId>_<fileId>!<deliveredDate>.pdf",
                    "sftpUser": "liaison_service@tusmgp.admissions.tufts.edu",
                    "sftpPassword": "2717fef375e24a1ab89a376a86cbe358",
                    "createdBy": "TuftsUni",
                    "updatedBy": "TuftsUni",
                    "createdDate": "2023-08-30 16:45:05",
                    "updatedDate": "2023-08-30 16:45:05"
                }
            }
        ]
    }
}
Expand
titleDocument Data Replay
Code Block
{
    "replay": {
        "id": 8252,
        "status": "PENDING",
        "fromDate": "2023-08-25 00:00:01",
        "toDate": "2023-08-30 23:59:59",
        "createdDate": "2023-08-30 16:45:32",
        "updatedDate": "2023-08-30 16:45:32",
        "subscription": {
            "subscriptionId": 8027
        }
    }
}

DPT-PHX

Expand
titleIn Progress Subscription (8015)
Code Block
{
    "subscription": {
        "id": 8015,
        "notificationEmailAddress": "tts-slate-team@elist.tufts.edu",
        "expirationDate": "2025-08-28",
        "createdBy": "TuftsUni",
        "updatedBy": "TuftsUni",
        "userLevel": "institution",
        "disabled": false,
        "createdDate": "2023-08-29 17:38:24",
        "updatedDate": "2023-08-29 17:38:24",
        "subscriptionDetails": [
            {
                "id": 48216,
                "event": "application.program.selected",
                "responseType": "fullResponse",
                "responseLevel": "program",
                "responseOptions": "expand=all,includeNulls=true,contentType=text/csv,columnSeparator=COMMA,csvHeaderTruncationSize=4,csvShortName=question",
                "destinationType": "SFTP",
                "createdBy": "TuftsUni",
                "updatedBy": "TuftsUni",
                "apiVersion": "v2",
                "disabled": false,
                "createdDate": "2023-08-29 17:38:24",
                "updatedDate": "2023-08-29 17:38:24",
                "sftpDestination": {
                    "id": 12074,
                    "sftpHost": "ft.technolutions.net",
                    "sftpPort": 22,
                    "sftpBaseDirectory": "/incoming/liaison/PTCAS/data/",
                    "sftpPathTemplate": "PTCAS-app-started_<instanceId>_<organizationId>_<programId>_<applicationId>_<casApplicantId>.csv",
                    "sftpUser": "liaison_service@tusmgp.admissions.tufts.edu",
                    "sftpPassword": "2717fef375e24a1ab89a376a86cbe358",
                    "createdBy": "TuftsUni",
                    "updatedBy": "TuftsUni",
                    "createdDate": "2023-08-29 17:38:24",
                    "updatedDate": "2023-08-29 17:38:24"
                }
            }
        ]
    }
}
Expand
titleIn Progress Replay
Code Block
{
    "replay": {
        "id": 8233,
        "status": "PENDING",
        "fromDate": "2023-08-25 17:45:00",
        "toDate": "2023-08-29 17:00:00",
        "createdDate": "2023-08-29 17:38:37",
        "updatedDate": "2023-08-29 17:38:37",
        "subscription": {
            "subscriptionId": 8015
        }
    }
}
Expand
titleApplication Data Subscription (8020)
Code Block
languagejson
{
    "subscription": {
        "id": 8020,
        "notificationEmailAddress": "tts-slate-team@elists.tufts.edu",
        "expirationDate": "2025-08-29",
        "createdBy": "TuftsUni",
        "updatedBy": "TuftsUni",
        "userLevel": "institution",
        "disabled": false,
        "createdDate": "2023-08-30 14:03:57",
        "updatedDate": "2023-08-30 14:03:57",
        "subscriptionDetails": [
            {
                "id": 48245,
                "event": "application.program.received",
                "responseType": "fullResponse",
                "responseLevel": "program",
                "responseOptions": "expand=all,includeNulls=true,contentType=text/csv,columnSeparator=COMMA,csvHeaderTruncationSize=4,csvShortName=question",
                "destinationType": "SFTP",
                "createdBy": "TuftsUni",
                "updatedBy": "TuftsUni",
                "apiVersion": "v2",
                "disabled": false,
                "createdDate": "2023-08-30 14:03:57",
                "updatedDate": "2023-08-30 14:03:57",
                "sftpDestination": {
                    "id": 12079,
                    "sftpHost": "ft.technolutions.net",
                    "sftpPort": 22,
                    "sftpBaseDirectory": "/incoming/liaison/PTCAS/data",
                    "sftpPathTemplate": "PTCAS-app-s-<instanceId>_<organizationId>_<programId>_<applicationId>_<casApplicantId>.csv",
                    "sftpUser": "liaison_service@tusmgp.admissions.tufts.edu",
                    "sftpPassword": "2717fef375e24a1ab89a376a86cbe358",
                    "createdBy": "TuftsUni",
                    "updatedBy": "TuftsUni",
                    "createdDate": "2023-08-30 14:03:57",
                    "updatedDate": "2023-08-30 14:03:57"
                }
            },
            {
                "id": 48246,
                "event": "application.program.completed",
                "responseType": "fullResponse",
                "responseLevel": "program",
                "responseOptions": "expand=all,includeNulls=true,contentType=text/csv,columnSeparator=COMMA,csvHeaderTruncationSize=4,csvShortName=question",
                "destinationType": "SFTP",
                "createdBy": "TuftsUni",
                "updatedBy": "TuftsUni",
                "apiVersion": "v2",
                "disabled": false,
                "createdDate": "2023-08-30 14:03:57",
                "updatedDate": "2023-08-30 14:03:57",
                "sftpDestination": {
                    "id": 12080,
                    "sftpHost": "ft.technolutions.net",
                    "sftpPort": 22,
                    "sftpBaseDirectory": "/incoming/liaison/PTCAS/data",
                    "sftpPathTemplate": "PTCAS-app-s-<instanceId>_<organizationId>_<programId>_<applicationId>_<casApplicantId>.csv",
                    "sftpUser": "liaison_service@tusmgp.admissions.tufts.edu",
                    "sftpPassword": "2717fef375e24a1ab89a376a86cbe358",
                    "createdBy": "TuftsUni",
                    "updatedBy": "TuftsUni",
                    "createdDate": "2023-08-30 14:03:57",
                    "updatedDate": "2023-08-30 14:03:57"
                }
            },
            {
                "id": 48247,
                "event": "application.program.verified",
                "responseType": "fullResponse",
                "responseLevel": "program",
                "responseOptions": "expand=all,includeNulls=true,contentType=text/csv,columnSeparator=COMMA,csvHeaderTruncationSize=4,csvShortName=question",
                "destinationType": "SFTP",
                "createdBy": "TuftsUni",
                "updatedBy": "TuftsUni",
                "apiVersion": "v2",
                "disabled": false,
                "createdDate": "2023-08-30 14:03:57",
                "updatedDate": "2023-08-30 14:03:57",
                "sftpDestination": {
                    "id": 12081,
                    "sftpHost": "ft.technolutions.net",
                    "sftpPort": 22,
                    "sftpBaseDirectory": "/incoming/liaison/PTCAS/data",
                    "sftpPathTemplate": "PTCAS-app-s-<instanceId>_<organizationId>_<programId>_<applicationId>_<casApplicantId>.csv",
                    "sftpUser": "liaison_service@tusmgp.admissions.tufts.edu",
                    "sftpPassword": "2717fef375e24a1ab89a376a86cbe358",
                    "createdBy": "TuftsUni",
                    "updatedBy": "TuftsUni",
                    "createdDate": "2023-08-30 14:03:57",
                    "updatedDate": "2023-08-30 14:03:57"
                }
            }
        ]
    }
}
Expand
titleApplication Data Replay
Code Block
 Expand
titleDocument Subscription (8026)
 Code Block
{
    "subscription": {
        "id": 8026,
        "notificationEmailAddress": "tts-slate-team@elists.tufts.edu",
        "expirationDate": "2025-08-29",
        "createdBy": "TuftsUni",
        "updatedBy": "TuftsUni",
        "userLevel": "institution",
        "disabled": false,
        "createdDate": "2023-08-30 16:44:11",
        "updatedDate": "2023-08-30 16:44:11",
        "subscriptionDetails": [
            {
                "id": 48268,
                "event": "file.attachment.updated",
                "responseType": "fullResponse",
                "responseLevel": "organization",
                "destinationType": "SFTP",
                "createdBy": "TuftsUni",
                "updatedBy": "TuftsUni",
                "dataHold": "InProgress",
                "apiVersion": "v1",
                "disabled": false,
                "createdDate": "2023-08-30 16:44:11",
                "updatedDate": "2023-08-30 16:44:11",
                "sftpDestination": {
                    "id": 12100,
                    "sftpHost": "ft.technolutions.net",
                    "sftpPort": 22,
                    "sftpBaseDirectory": "/incoming/liaison/",
                    "sftpPathTemplate": "PTCAS_pers_<casApplicantId>__<documentSubType>__<fileId>!<deliveredDate>.pdf",
                    "sftpUser": "liaison_service@tusmgp.admissions.tufts.edu",
                    "sftpPassword": "2717fef375e24a1ab89a376a86cbe358",
                    "createdBy": "TuftsUni",
                    "updatedBy": "TuftsUni",
                    "createdDate": "2023-08-30 16:44:11",
                    "updatedDate": "2023-08-30 16:44:11"
                }
            },
            {
                "id": 48269,
                "event": "file.supplementalAttachment.updated",
                "responseType": "fullResponse",
                "responseLevel": "program",
                "destinationType": "SFTP",
                "createdBy": "TuftsUni",
                "updatedBy": "TuftsUni",
                "dataHold": "InProgress",
                "apiVersion": "v1",
                "disabled": false,
                "createdDate": "2023-08-30 16:44:11",
                "updatedDate": "2023-08-30 16:44:11",
                "sftpDestination": {
                    "id": 12101,
                    "sftpHost": "ft.technolutions.net",
                    "sftpPort": 22,
                    "sftpBaseDirectory": "/incoming/liaison/",
                    "sftpPathTemplate": "PTCAS_app_<casApplicantId>_<programId>_<documentSubType>__<fileId>!<deliveredDate>.pdf",
                    "sftpUser": "liaison_service@tusmgp.admissions.tufts.edu",
                    "sftpPassword": "2717fef375e24a1ab89a376a86cbe358",
                    "createdBy": "TuftsUni",
                    "updatedBy": "TuftsUni",
                    "createdDate": "2023-08-30 16:44:11",
                    "updatedDate": "2023-08-30 16:44:11"
                }
            },
            {
                "id": 48270,
                "event": "file.evaluation.updated",
                "responseType": "fullResponse",
                "responseLevel": "program",
                "destinationType": "SFTP",
                "createdBy": "TuftsUni",
                "updatedBy": "TuftsUni",
                "dataHold": "InProgress",
                "apiVersion": "v1",
                "disabled": false,
                "createdDate": "2023-08-30 16:44:11",
                "updatedDate": "2023-08-30 16:44:11",
                "sftpDestination": {
                    "id": 12102,
                    "sftpHost": "ft.technolutions.net",
                    "sftpPort": 22,
                    "sftpBaseDirectory": "/incoming/liaison/",
                    "sftpPathTemplate": "PTCAS_app_<casApplicantId>_<programId>_<docType>__<fileId>!<deliveredDate>.pdf",
                    "sftpUser": "liaison_service@tusmgp.admissions.tufts.edu",
                    "sftpPassword": "2717fef375e24a1ab89a376a86cbe358",
                    "createdBy": "TuftsUni",
                    "updatedBy": "TuftsUni",
                    "createdDate": "2023-08-30 16:44:11",
                    "updatedDate": "2023-08-30 16:44:11"
                }
            },
            {
                "id": 48271,
                "event": "file.transcript.updated",
                "responseType": "fullResponse",
                "responseLevel": "organization",
                "destinationType": "SFTP",
                "createdBy": "TuftsUni",
                "updatedBy": "TuftsUni",
                "dataHold": "InProgress",
                "apiVersion": "v1",
                "disabled": false,
                "createdDate": "2023-08-30 16:44:11",
                "updatedDate": "2023-08-30 16:44:11",
                "sftpDestination": {
                    "id": 12103,
                    "sftpHost": "ft.technolutions.net",
                    "sftpPort": 22,
                    "sftpBaseDirectory": "/incoming/liaison/",
                    "sftpPathTemplate": "PTCAS_pers_<casApplicantId>__<docType><transcriptType>_<collegeAttendedId>_<fileId>!<deliveredDate>.pdf",
                    "sftpUser": "liaison_service@tusmgp.admissions.tufts.edu",
                    "sftpPassword": "2717fef375e24a1ab89a376a86cbe358",
                    "createdBy": "TuftsUni",
                    "updatedBy": "TuftsUni",
                    "createdDate": "2023-08-30 16:44:11",
                    "updatedDate": "2023-08-30 16:44:11"
                }
            },
            {
                "id": 48272,
                "event": "file.vendorTranscriptEval.updated",
                "responseType": "fullResponse",
                "responseLevel": "organization",
                "destinationType": "SFTP",
                "createdBy": "TuftsUni",
                "updatedBy": "TuftsUni",
                "dataHold": "InProgress",
                "apiVersion": "v1",
                "disabled": false,
                "createdDate": "2023-08-30 16:44:11",
                "updatedDate": "2023-08-30 16:44:11",
                "sftpDestination": {
                    "id": 12104,
                    "sftpHost": "ft.technolutions.net",
                    "sftpPort": 22,
                    "sftpBaseDirectory": "/incoming/liaison/",
                    "sftpPathTemplate": "PTCAS_pers_<casApplicantId>__<docType>_<collegeAttendedId>_<fileId>!<deliveredDate>.pdf",
                    "sftpUser": "liaison_service@tusmgp.admissions.tufts.edu",
                    "sftpPassword": "2717fef375e24a1ab89a376a86cbe358",
                    "createdBy": "TuftsUni",
                    "updatedBy": "TuftsUni",
                    "createdDate": "2023-08-30 16:44:11",
                    "updatedDate": "2023-08-30 16:44:11"
                }
            }
        ]
    }
}
 Expand
titleDocument Replay
 Code Block
{
    "replay": {
        "id": 8251,
        "status": "PENDING",
        "fromDate": "2023-08-25 00:00:01",
        "toDate": "2023-08-30 23:59:59",
        "createdDate": "2023-08-30 16:44:39",
        "updatedDate": "2023-08-30 16:44:39",
        "subscription": {
            "subscriptionId": 8026
        }
    }
}
DPT-BOS
 Expand
titleIn Progress Subscription (8016)
 Code Block
{
    "subscription": {
        "id": 8016,
        "notificationEmailAddress": "tts-slate-team@elist.tufts.edu",
        "expirationDate": "2025-08-28",
        "createdBy": "TuftsUni",
        "updatedBy": "TuftsUni",
        "userLevel": "institution",
        "disabled": false,
        "createdDate": "2023-08-29 17:40:24",
        "updatedDate": "2023-08-29 17:40:24",
        "subscriptionDetails": [
            {
                "id": 48217,
                "event": "application.program.selected",
                "responseType": "fullResponse",
                "responseLevel": "program",
                "responseOptions": "expand=all,includeNulls=true,contentType=text/csv,columnSeparator=COMMA,csvHeaderTruncationSize=4,csvShortName=question",
                "destinationType": "SFTP",
                "createdBy": "TuftsUni",
                "updatedBy": "TuftsUni",
                "apiVersion": "v2",
                "disabled": false,
                "createdDate": "2023-08-29 17:40:24",
                "updatedDate": "2023-08-29 17:40:24",
                "sftpDestination": {
                    "id": 12075,
                    "sftpHost": "ft.technolutions.net",
                    "sftpPort": 22,
                    "sftpBaseDirectory": "/incoming/liaison/PTCAS/data/",
                    "sftpPathTemplate": "PTCAS-app-started_<instanceId>_<organizationId>_<programId>_<applicationId>_<casApplicantId>.csv",
                    "sftpUser": "liaison_service@tusmgp.admissions.tufts.edu",
                    "sftpPassword": "2717fef375e24a1ab89a376a86cbe358",
                    "createdBy": "TuftsUni",
                    "updatedBy": "TuftsUni",
                    "createdDate": "2023-08-29 17:40:24",
                    "updatedDate": "2023-08-29 17:40:24"
                }
            }
        ]
    }
}
 Expand
titleIn Progress Replay
 Code Block
{
    "replay": {
        "id": 8234,
        "status": "PENDING",
        "fromDate": "2023-08-25 17:45:00",
        "toDate": "2023-08-29 17:00:00",
        "createdDate": "2023-08-29 17:40:37",
        "updatedDate": "2023-08-29 17:40:37",
        "subscription": {
            "subscriptionId": 8016
        }
    }
}
 Expand
titleApplication Data Subscription (8022)
 Code Block
{
    "subscription": {
        "id": 8022,
        "notificationEmailAddress": "tts-slate-team@elists.tufts.edu",
        "expirationDate": "2025-08-29",
        "createdBy": "TuftsUni",
        "updatedBy": "TuftsUni",
        "userLevel": "institution",
        "disabled": false,
        "createdDate": "2023-08-30 14:49:22",
        "updatedDate": "2023-08-30 14:49:22",
        "subscriptionDetails": [
            {
                "id": 48250,
                "event": "application.program.received",
                "responseType": "fullResponse",
                "responseLevel": "program",
                "responseOptions": "expand=all,includeNulls=true,contentType=text/csv,columnSeparator=COMMA,csvHeaderTruncationSize=4,csvShortName=question",
                "destinationType": "SFTP",
                "createdBy": "TuftsUni",
                "updatedBy": "TuftsUni",
                "apiVersion": "v2",
                "disabled": false,
                "createdDate": "2023-08-30 14:49:22",
                "updatedDate": "2023-08-30 14:49:22",
                "sftpDestination": {
                    "id": 12082,
                    "sftpHost": "ft.technolutions.net",
                    "sftpPort": 22,
                    "sftpBaseDirectory": "/incoming/liaison/PTCAS/data",
                    "sftpPathTemplate": "PTCAS-app-s-<instanceId>_<organizationId>_<programId>_<applicationId>_<casApplicantId>.csv",
                    "sftpUser": "liaison_service@tusmgp.admissions.tufts.edu",
                    "sftpPassword": "2717fef375e24a1ab89a376a86cbe358",
                    "createdBy": "TuftsUni",
                    "updatedBy": "TuftsUni",
                    "createdDate": "2023-08-30 14:49:22",
                    "updatedDate": "2023-08-30 14:49:22"
                }
            },
            {
                "id": 48251,
                "event": "application.program.completed",
                "responseType": "fullResponse",
                "responseLevel": "program",
                "responseOptions": "expand=all,includeNulls=true,contentType=text/csv,columnSeparator=COMMA,csvHeaderTruncationSize=4,csvShortName=question",
                "destinationType": "SFTP",
                "createdBy": "TuftsUni",
                "updatedBy": "TuftsUni",
                "apiVersion": "v2",
                "disabled": false,
                "createdDate": "2023-08-30 14:49:22",
                "updatedDate": "2023-08-30 14:49:22",
                "sftpDestination": {
                    "id": 12083,
                    "sftpHost": "ft.technolutions.net",
                    "sftpPort": 22,
                    "sftpBaseDirectory": "/incoming/liaison/PTCAS/data",
                    "sftpPathTemplate": "PTCAS-app-s-<instanceId>_<organizationId>_<programId>_<applicationId>_<casApplicantId>.csv",
                    "sftpUser": "liaison_service@tusmgp.admissions.tufts.edu",
                    "sftpPassword": "2717fef375e24a1ab89a376a86cbe358",
                    "createdBy": "TuftsUni",
                    "updatedBy": "TuftsUni",
                    "createdDate": "2023-08-30 14:49:22",
                    "updatedDate": "2023-08-30 14:49:22"
                }
            },
            {
                "id": 48252,
                "event": "application.program.verified",
                "responseType": "fullResponse",
                "responseLevel": "program",
                "responseOptions": "expand=all,includeNulls=true,contentType=text/csv,columnSeparator=COMMA,csvHeaderTruncationSize=4,csvShortName=question",
                "destinationType": "SFTP",
                "createdBy": "TuftsUni",
                "updatedBy": "TuftsUni",
                "apiVersion": "v2",
                "disabled": false,
                "createdDate": "2023-08-30 14:49:22",
                "updatedDate": "2023-08-30 14:49:22",
                "sftpDestination": {
                    "id": 12084,
                    "sftpHost": "ft.technolutions.net",
                    "sftpPort": 22,
                    "sftpBaseDirectory": "/incoming/liaison/PTCAS/data",
                    "sftpPathTemplate": "PTCAS-app-s-<instanceId>_<organizationId>_<programId>_<applicationId>_<casApplicantId>.csv",
                    "sftpUser": "liaison_service@tusmgp.admissions.tufts.edu",
                    "sftpPassword": "2717fef375e24a1ab89a376a86cbe358",
                    "createdBy": "TuftsUni",
                    "updatedBy": "TuftsUni",
                    "createdDate": "2023-08-30 14:49:22",
                    "updatedDate": "2023-08-30 14:49:22"
                }
            }
        ]
    }
}
 Expand
titleApplication Data Replay
 Code Block
{
    "replay": {
        "id": 8242,
        "status": "PENDING",
        "fromDate": "2023-08-25 00:00:01",
        "toDate": "2023-08-25 23:59:59",
        "createdDate": "2023-08-30 14:50:10",
        "updatedDate": "2023-08-30 14:50:10",
        "subscription": {
            "subscriptionId": 8022
        }
    }
}

{
    "replay": {
        "id": 8243,
        "status": "PENDING",
        "fromDate": "2023-08-26 00:00:01",
        "toDate": "2023-08-26 23:59:59",
        "createdDate": "2023-08-30 15:32:31",
        "updatedDate": "2023-08-30 15:32:31",
        "subscription": {
            "subscriptionId": 8022
        }
    }
}
{
    "replay": {
        "id": 8244,
        "status": "PENDING",
        "fromDate": "2023-08-27 00:00:01",
        "toDate": "2023-08-27 23:59:59",
        "createdDate": "2023-08-30 15:38:25",
        "updatedDate": "2023-08-30 15:38:25",
        "subscription": {
            "subscriptionId": 8022
        }
    }
}

{
    "replay": {
        "id": 8245,
        "status": "PENDING",
        "fromDate": "2023-08-28 00:00:01",
        "toDate": "2023-08-28 23:59:59",
        "createdDate": "2023-08-30 15:51:18",
        "updatedDate": "2023-08-30 15:51:18",
        "subscription": {
            "subscriptionId": 8022
        }
    }
}

{
    "replay": {
        "id": 8246,
        "status": "PENDING",
        "fromDate": "2023-08-29 00:00:01",
        "toDate": "2023-08-29 23:59:59",
        "createdDate": "2023-08-30 15:59:47",
        "updatedDate": "2023-08-30 15:59:47",
        "subscription": {
            "subscriptionId": 8022
        }
    }
}

{
    "replay": {
        "id": 8247,
        "status": "PENDING",
        "fromDate": "2023-08-30 00:00:01",
        "toDate": "2023-08-30 23:59:59",
        "createdDate": "2023-08-30 16:13:07",
        "updatedDate": "2023-08-30 16:13:07",
        "subscription": {
            "subscriptionId": 8022
        }
    }
}

 Expand
titleDocument Subscription (8025)
 Code Block
{
    "subscription": {
        "id": 8025,
        "notificationEmailAddress": "tts-slate-team@elists.tufts.edu",
        "expirationDate": "2025-08-29",
        "createdBy": "TuftsUni",
        "updatedBy": "TuftsUni",
        "userLevel": "institution",
        "disabled": false,
        "createdDate": "2023-08-30 16:42:40",
        "updatedDate": "2023-08-30 16:42:40",
        "subscriptionDetails": [
            {
                "id": 48263,
                "event": "file.attachment.updated",
                "responseType": "fullResponse",
                "responseLevel": "organization",
                "destinationType": "SFTP",
                "createdBy": "TuftsUni",
                "updatedBy": "TuftsUni",
                "dataHold": "InProgress",
                "apiVersion": "v1",
                "disabled": false,
                "createdDate": "2023-08-30 16:42:40",
                "updatedDate": "2023-08-30 16:42:40",
                "sftpDestination": {
                    "id": 12095,
                    "sftpHost": "ft.technolutions.net",
                    "sftpPort": 22,
                    "sftpBaseDirectory": "/incoming/liaison/",
                    "sftpPathTemplate": "PTCAS_pers_<casApplicantId>__<documentSubType>__<fileId>!<deliveredDate>.pdf",
                    "sftpUser": "liaison_service@tusmgp.admissions.tufts.edu",
                    "sftpPassword": "2717fef375e24a1ab89a376a86cbe358",
                    "createdBy": "TuftsUni",
                    "updatedBy": "TuftsUni",
                    "createdDate": "2023-08-30 16:42:40",
                    "updatedDate": "2023-08-30 16:42:40"
                }
            },
            {
                "id": 48264,
                "event": "file.supplementalAttachment.updated",
                "responseType": "fullResponse",
                "responseLevel": "program",
                "destinationType": "SFTP",
                "createdBy": "TuftsUni",
                "updatedBy": "TuftsUni",
                "dataHold": "InProgress",
                "apiVersion": "v1",
                "disabled": false,
                "createdDate": "2023-08-30 16:42:40",
                "updatedDate": "2023-08-30 16:42:40",
                "sftpDestination": {
                    "id": 12096,
                    "sftpHost": "ft.technolutions.net",
                    "sftpPort": 22,
                    "sftpBaseDirectory": "/incoming/liaison/",
                    "sftpPathTemplate": "PTCAS_app_<casApplicantId>_<programId>_<documentSubType>__<fileId>!<deliveredDate>.pdf",
                    "sftpUser": "liaison_service@tusmgp.admissions.tufts.edu",
                    "sftpPassword": "2717fef375e24a1ab89a376a86cbe358",
                    "createdBy": "TuftsUni",
                    "updatedBy": "TuftsUni",
                    "createdDate": "2023-08-30 16:42:40",
                    "updatedDate": "2023-08-30 16:42:40"
                }
            },
            {
                "id": 48265,
                "event": "file.evaluation.updated",
                "subscriptionresponseType": { "fullResponse",
                "subscriptionIdresponseLevel": 8014
  "program",
     }     } }
DPT-PHX
 Expand
titleIn Progress Subscription
 Code Block
{     "subscriptiondestinationType": {
 "SFTP",
      "id": 8015,         "notificationEmailAddresscreatedBy": "tts-slate-team@elist.tufts.edu",TuftsUni",
                "expirationDateupdatedBy": "2025-08-28TuftsUni",
                "createdBydataHold": "TuftsUniInProgress",
        "updatedBy        "apiVersion": "TuftsUniv1",
                "userLeveldisabled": "institution"false,

       "disabled": false,           "createdDate": "2023-08-2930 1716:3842:2440",
                "updatedDate": "2023-08-2930 1716:3842:2440",

       "subscriptionDetails": [        "sftpDestination": {
   {                 "id": 4821612097,
                    "eventsftpHost": "applicationft.program.selected",technolutions.net",
                    "sftpPort": 22,
                    "responseTypesftpBaseDirectory": "fullResponse/incoming/liaison/",
                      "sftpPathTemplate": "PTCAS_app_<casApplicantId>_<programId>_<docType>__<fileId>!<deliveredDate>.pdf",
  "responseLevel": "program",                 "responseOptionssftpUser": "expand=all,includeNulls=true,contentType=text/csv,columnSeparator=COMMA,csvHeaderTruncationSize=4,csvShortName=question",liaison_service@tusmgp.admissions.tufts.edu",
                    "destinationTypesftpPassword": "SFTP2717fef375e24a1ab89a376a86cbe358",
                    "createdBy": "TuftsUni",
                    "updatedBy": "TuftsUni",
                    "apiVersioncreatedDate": "v22023-08-30 16:42:40",
                    "disabledupdatedDate": false, "2023-08-30 16:42:40"
                }
    "createdDate": "2023-08-29 17:38:24",      },
          "updatedDate": "2023-08-29 17:38:24", {
                "sftpDestinationid": {
   48266,
                "idevent": 12074,
   "file.transcript.updated",
                "sftpHostresponseType": "ft.technolutions.netfullResponse",
   
                "sftpPortresponseLevel": 22,
   "organization",
                "sftpBaseDirectorydestinationType": "/incoming/liaison/PTCAS/data/SFTP",
   
                "sftpPathTemplatecreatedBy": "PTCAS-app-started_<instanceId>_<organizationId>_<programId>_<applicationId>_<casApplicantId>.csv",
   TuftsUni",
                "sftpUserupdatedBy": "liaison_service@tusmgp.admissions.tufts.eduTuftsUni",
   
                "sftpPassworddataHold": "2717fef375e24a1ab89a376a86cbe358",
   InProgress",
                "createdByapiVersion": "TuftsUniv1",
   
                "updatedBydisabled": "TuftsUni",
   false,
                "createdDate": "2023-08-2930 1716:3842:2440",
   
                "updatedDate": "2023-08-2930 1716:3842:2440",
                }
      "sftpDestination": {
     }         ]     } }
 Expand
titleIn Progress Replay
 Code Block
{
    "replay": {"id": 12098,
          "id": 8233,         "statussftpHost": "PENDINGft.technolutions.net",
        "fromDate": "2023-08-25 17:45:00",         "toDate": "2023-08-29 17:00:00",sftpPort": 22,
         "createdDate": "2023-08-29 17:38:37",         "updatedDatesftpBaseDirectory": "2023-08-29 17:38:37/incoming/liaison/",
        "subscription": {             "subscriptionId": 8015"sftpPathTemplate": "PTCAS_pers_<casApplicantId>__<docType><transcriptType>_<collegeAttendedId>_<fileId>!<deliveredDate>.pdf",
         }     } }
DPT-BOS
 Expand
titleIn Progress Subscription
 Code Block
{     "subscriptionsftpUser": {"liaison_service@tusmgp.admissions.tufts.edu",
          "id": 8016,         "notificationEmailAddresssftpPassword": "tts-slate-team@elist.tufts.edu2717fef375e24a1ab89a376a86cbe358",
        "expirationDate": "2025-08-28",            "createdBy": "TuftsUni",
          "updatedBy": "TuftsUni",         "userLevelupdatedBy": "institutionTuftsUni",
          "disabled": false,         "createdDate": "2023-08-2930 1716:42:40:24",
                    "updatedDate": "2023-08-2930 1716:42:40:24",
          "subscriptionDetails": [     }
       {     },
           "id": 48217, {
                "eventid": "application.program.selected"48267,
                "responseTypeevent": "fullResponsefile.vendorTranscriptEval.updated",
                "responseLevelresponseType": "programfullResponse",
                "responseOptionsresponseLevel": "expand=all,includeNulls=true,contentType=text/csv,columnSeparator=COMMA,csvHeaderTruncationSize=4,csvShortName=question"organization",
                "destinationType": "SFTP",
                "createdBy": "TuftsUni",
                "updatedBy": "TuftsUni",
                "dataHold": "InProgress",
                "apiVersion": "v2v1",
                "disabled": false,
                "createdDate": "2023-08-2930 1716:42:40:24",
                "updatedDate": "2023-08-2930 1716:42:40:24",
                "sftpDestination": {
                    "id": 1207512099,
                    "sftpHost": "ft.technolutions.net",
                    "sftpPort": 22,
                    "sftpBaseDirectory": "/incoming/liaison/PTCAS/data/",
                    "sftpPathTemplate": "PTCAS-app-started_<instanceId>_<organizationId>_<programId>_<applicationId>_<casApplicantId>.csv_pers_<casApplicantId>__<docType>_<collegeAttendedId>_<fileId>!<deliveredDate>.pdf",
                    "sftpUser": "liaison_service@tusmgp.admissions.tufts.edu",
                    "sftpPassword": "2717fef375e24a1ab89a376a86cbe358",
                    "createdBy": "TuftsUni",
                    "updatedBy": "TuftsUni",
                    "createdDate": "2023-08-2930 1716:42:40:24",
                    "updatedDate": "2023-08-2930 1716:42:40:24"
                }
            }
        ]
    }
}
 Expand
titleIn Progress Document Replay
 Code Block
{
    "replay": {
        "id": 82348250,
        "status": "PENDING",
        "fromDate": "2023-08-25 1700:4500:0001",
        "toDate": "2023-08-2930 1723:0059:0059",
        "createdDate": "2023-08-2930 1716:4043:3714",
        "updatedDate": "2023-08-2930 1716:4043:3714",
        "subscription": {
            "subscriptionId": 80168025
        }
    }
}
Applications in SOPHAS but not in Slate:
 
2716721476
Megan
Hasenfratz
 
NOT IN SLATE
Complete
Submitted 8/28 and Completed 8/28 but program added 6/21 -- possibly no IP app?
5636806312
Gianna
Buckley
 
NOT IN SLATE
Verified
 
7681966544
Paige
Luong
 
NOT IN SLATE
Verified
 
1494492140
Shannon
McKean
 
NOT IN SLATE
Verified
 
5015004038
Katherine
Snow
 
NOT IN SLATE
Verified
 
 
Applications in Slate with incorrect CAS Status:
 
Person CAS/Liaison Person ID
Application CAS/Liaison Application ID
SOPHAS App Status
Application CAS/Liaison Application Status
Application Status
Created Date
Application Start Term/Year
8811325641
8811325641-349019
Verified
Complete
Awaiting Materials
07/05/2023
Summer 2024
6165511055
6165511055-349019
Received
In Progress
Awaiting Submission
06/16/2023
Summer 2024
1632638824
1632638824-349019
Verified
In Progress
Awaiting Submission
06/25/2023
Summer 2024
3467889319
3467889319-349019
Verified
In Progress
Awaiting Submission
06/17/2023
Summer 2024
3305359106
3305359106-349019
Verified
In Progress
Awaiting Submission
07/12/2023
Summer 2024
9251391771
9251391771-349019
Verified
In Progress
Awaiting Submission
07/27/2023
Summer 2024
2242019818
2242019818-349019
Complete
In Progress
Awaiting Submission
06/28/2023
Summer 2024
 
8811325641
Kevin
O'Neil
 
Complete
Verified
2242019818
Riley
Hayden
 
In Progress
Complete
6165511055
Angela
Yang
 
In Progress
Received
3305359106
Andrea
Jaeger
 
In Progress
Verified
9251391771
Evan
Kalminov
 
In Progress
Verified
3467889319
Rachel
Zhang
 
In Progress
Verified
1632638824
Amanda
Zygmont
 
In Progress
Verified