- Created by Helen Williams , last modified on Aug 31, 2023
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 5 Next »
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.
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.
Re-created subscriptions for In Progress (program selected) applications first, immediately ran a replay for each. This was necessary because if a record came over in a subsequent subscription data file before it came through the In Progress file, an application record would not exist in Slate and it would not update properly. The In Progress data subscription is what creates the application for the record.
DPT-SEA
In Progress Subscription (8014)
{
"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"
}
}
]
}
}
In Progress Replay
{
"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
}
}
}
Application Data Subscription (8017)
{
"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"
}
}
]
}
}
Application Data Replay
{
"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
}
}
}
Document Data Subscription (8027)
{
"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"
}
}
]
}
}
Document Data Replay
{
"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
In Progress Subscription (8015)
{
"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"
}
}
]
}
}
In Progress Replay
{
"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
}
}
}
Application Data Subscription (8020)
{
"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"
}
}
]
}
}
Application Data Replay
Document Subscription (8026)
{
"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"
}
}
]
}
}
Document Replay
{
"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
In Progress Subscription (8016)
{
"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"
}
}
]
}
}
In Progress Replay
{
"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
}
}
}
Application Data Subscription (8022)
{
"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"
}
}
]
}
}
Application Data Replay
{
"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
}
}
}
Document Subscription (8025)
{
"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",
"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": 12097,
"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:42:40",
"updatedDate": "2023-08-30 16:42:40"
}
},
{
"id": 48266,
"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:42:40",
"updatedDate": "2023-08-30 16:42:40",
"sftpDestination": {
"id": 12098,
"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:42:40",
"updatedDate": "2023-08-30 16:42:40"
}
},
{
"id": 48267,
"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:42:40",
"updatedDate": "2023-08-30 16:42:40",
"sftpDestination": {
"id": 12099,
"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:42:40",
"updatedDate": "2023-08-30 16:42:40"
}
}
]
}
}
Document Replay
{
"replay": {
"id": 8250,
"status": "PENDING",
"fromDate": "2023-08-25 00:00:01",
"toDate": "2023-08-30 23:59:59",
"createdDate": "2023-08-30 16:43:14",
"updatedDate": "2023-08-30 16:43:14",
"subscription": {
"subscriptionId": 8025
}
}
}
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 |
- No labels
Add Comment